source code https://github.com/AntonSikidin/global_settingsTime-to-time constants appear in your code. Some time constants are less constant. They have different types for example date of feature start, rfc_dest to other system, and number of paralle...
As an external developer Iām involved in many projects. We usually connect to the client system using various combinations of Remote Desktop. For security reasons, the clipboard between Remote Desktop and the work computer is disabled. Also, we usual...
Macros is a powerful tool that increase boilerplate writing speed. Unfortunately, exploitation of macros is forbidden in many projects because macros cannot be debugged.
Zmacros is my development to generate a boilerplate in few clicks.
Source: ht...
Inspired by interest and comments on my previous article (Best way to generate Microsoft word docx from ABAP), I decided to create similar solution for Microsoft EXCEL.
First of all, I checked these projects on the same topic:
XLSX Workbench
Xm...
There are several ways to generate Microsoft Word docx documents using ABAP + UPDATES
All of them have a number of disadvantages:
some require a lot of manual actions and saving structures in the ABAP Dictionary
some require the Microsoft Offic...
Hello @Olaf2 it is not possible. this solution does not use Microsoft Word to generate docx.what is your case for using macro? maybe there is another way. I do not have enough experience to see why macro needs.
yes. you can do that. For example you have next template.Ctrl+a, repeating control name it if you want each doc from new page then insert "page break" inside
it is possible to calculate formula. but it is hard. You must know where the formula was in template. then calculate added rows. rewrite formula.
you can calculate the answer in the program and write it in [total] cell instead.
There is solution
ZCL_EXCEL_FILL_TEMPLATE FILL_SHEET
METHOD fill_sheet.
DATA
: lo_worksheet TYPE REF TO zcl_excel_worksheet
, lv_title TYPE zexcel_sheet_title
.
FIELD-SYMBOLS
: <any_data> TYPE any
.
lv_title = zcl_excel_common=>unescape_string(...