SAP/abap2xlsx
1
0
Fork 0
mirror of https://github.com/abap2xlsx/abap2xlsx.git synced 2025-05-04 20:28:22 +08:00
Code Issues Actions Packages Projects Releases Wiki Activity
894 Commits 9 Branches 7 Tags 35 MiB
sandraros/clone-worksheet
Commit Graph

894 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
sandraros
11ab392189 new version of PR 1015 (sz3lbi:clone) 
Fixes for:
- tables
- named ranges
- total functions
- autofilter
- graphs
- not all worksheet properties cloned
 2022-05-08 18:24:53 +00:00
Tom Schmelzer
d2a1301329
docs: add missing full stop (#1023) 2022-04-28 11:27:24 +02:00
Gregor Wolf
177f30326c
replace pass by value with pass by reference (#1022) 2022-04-27 11:56:37 +02:00
Gregor Wolf
7b7984373c
Fix #1011 exception ZCX_EXCEL is not caught (#1016) 
* Fix #1011 exception ZCX_EXCEL is not caught

* fix uncaught exception in test class

* activate uncaught_exception check

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>
 2022-04-23 13:33:56 +02:00
Abo
46e234cd94
finish moving demo-related files (delete from old) (#1009) 2022-04-20 20:32:34 +02:00
Abo
f9b3a5b555
remove leftover int8 declaration (#1008) 2022-03-26 09:41:59 +01:00
sandraros
efbac83915
Note about the demos repository (#1005) 2022-03-26 08:59:21 +01:00
Abo
ac8f4a701e
Update abapGit-installation.md (#1001) 
* Update abapGit-installation.md

naming suggestions for demos package and explanation

* Update abapGit-installation.md

fixed typo

* Update abapGit-installation.md

* Update abapGit-installation.md

recommend that demos be created as local package

Co-authored-by: Lars Hvam <larshp@hotmail.com>
 2022-03-12 15:53:19 +01:00
sandraros
bea794926b
Delete objects moved to abap2xlsx/demos repository (#998) 
* Delete objects moved to abap2xlsx/demos repository

* remove unused zexcel_export_dir

* + procedure for the demo programs

Co-authored-by: sandraros <sandra.rossi@gmail.com>
 2022-03-06 20:54:20 +01:00
sandraros
e97169a0c3
Reader: custom paper height and width (#984) 
Fix #396

Co-authored-by: sandraros <sandra.rossi@gmail.com>
Co-authored-by: Abo <andrea@borgia.bo.it>
 2022-02-23 23:00:24 +01:00
sandraros
211cf550e6
SET_CELL_FORMULA sets formula in wrong cell (#961) 
Co-authored-by: sandraros <sandra.rossi@gmail.com>
Co-authored-by: Abo <andrea@borgia.bo.it>
 2022-02-19 16:29:33 +01:00
sandraros
f2dd72e76e
SET_CELL use output length for conversion exits (#982) 
* SET_CELL use output length for conversion exits

* bind_table: field catalog + demo

Co-authored-by: sandraros <sandra.rossi@gmail.com>
Co-authored-by: Abo <andrea@borgia.bo.it>
 2022-02-19 15:59:22 +01:00
sandraros
2973d66594
Refactor headings logic in BIND_TABLE (#960) 
* Refactor headings logic in BIND_TABLE

to help proposing a change for #764

Co-authored-by: sandraros <sandra.rossi@gmail.com>
Co-authored-by: Lars Hvam <larshp@hotmail.com>
Co-authored-by: Abo <andrea@borgia.bo.it>
 2022-02-07 16:37:06 +01:00
sandraros
c80da26920
move folders to archive repository (#991) 
fix #908
 2022-02-06 18:08:45 +01:00
sandraros
07340621a2
zdemo_excel29 demo file from Web Repository (#989) 
Fix #988

* zdemo_excel29 demo file from Web Repository

* Delete TestMacro.xlsm

* Remove comment about ZDEMO_EXCEL29/TestMacro.xlsm

Co-authored-by: sandraros <sandra.rossi@gmail.com>
 2022-02-06 10:43:35 +01:00
sandraros
77afa4480d
Fix FAQ link to TestMacro.xlsm (#987) 2022-02-05 10:11:51 +01:00
sandraros
5bb343a3e4
Fix set_cell overflow big value type int8 (#979) 
Fix #977

Co-authored-by: sandraros <sandra.rossi@gmail.com>
 2022-01-29 18:08:54 +01:00
Abo
bffb01c7b9
comments support in reader, initial version (#976) 
* comments support in reader, initial version

* fixes formatting for unmodified section

* remove spurious cast

hopefully fixes linter complaint

* handle raw text comments

* removed raw text handling (unused)
 2022-01-23 16:41:47 +01:00
sandraros
66ed127cb8
apack manifest 7.15.0 (#975) 
Co-authored-by: sandraros <sandra.rossi@gmail.com>
 2022-01-22 18:47:45 +01:00
Arno
76f14105db
zcl_excel_converter_salv_table exception handling (#974) 
Fixes shortdump in ZDEMO_EXCEL32 and custom programs if the ALV bind functionality is being used.
The dumps are caused by the missing handling of the exception CX_SALV_BS_SC_RUNTIME_INFO.
 2022-01-22 15:07:49 +01:00
sandraros
c3204b5c7b
Reader called twice loses formatting (#965) 
Co-authored-by: sandraros <sandra.rossi@gmail.com>
Co-authored-by: Abo <andrea@borgia.bo.it>
 2022-01-15 19:39:47 +01:00
sandraros
79d0df4dc3
BIND_TABLE incorrect table overlap check (#964) 
* draft, not finished

* Final commit

Co-authored-by: sandraros <sandra.rossi@gmail.com>
Co-authored-by: Abo <andrea@borgia.bo.it>
 2022-01-15 19:19:14 +01:00
sandraros
c3481d5d90
GET_TABLE skip bottom empty rows (#959) 
Fix #787

Co-authored-by: sandraros <sandra.rossi@gmail.com>
Co-authored-by: Abo <andrea@borgia.bo.it>
 2022-01-15 18:32:56 +01:00
sandraros
cc291983d7
Fix demo programs 3 and 33 (#956) 
* Fix demo programs 3 and 33

* updated reader reference files

( affected by #935 )

Co-authored-by: sandraros <sandra.rossi@gmail.com>
Co-authored-by: Lars Hvam <larshp@hotmail.com>
Co-authored-by: Abo <andrea@borgia.bo.it>
 2022-01-15 17:38:30 +01:00
sandraros
6a32480e5d
Read XLSX from third-party providers (namespaces) (#935) 
* theme namespace

* XLSM and rename namespace default to main

Co-authored-by: sandraros <sandra.rossi@gmail.com>
Co-authored-by: Abo <andrea@borgia.bo.it>
 2022-01-15 17:05:38 +01:00
Abo
a09229a130
remove CONDENSE from formulas (#968) 2022-01-15 14:56:12 +01:00
sandraros
206e9199c8
Update new-online-abap2xlsx.png (#967) 
screenshot with new URL of abap2xlsx project

Co-authored-by: Lars Hvam <larshp@hotmail.com>
Co-authored-by: Abo <andrea@borgia.bo.it>
 2022-01-15 12:23:20 +01:00
sandraros
165a580b34
Handle exceptions in demo programs (#962) 
* Handle exceptions in demo programs

Fix #955

Co-authored-by: sandraros <sandra.rossi@gmail.com>
Co-authored-by: Lars Hvam <larshp@hotmail.com>
Co-authored-by: Abo <andrea@borgia.bo.it>
 2022-01-15 12:17:53 +01:00
sandraros
4662dc85f4
release7.15.0 (#957) 
* release7.15.0

* Update changelog.txt

(Check demo regressions)

* abap2xlsx version made public to be used in APACK

Co-authored-by: Abo <andrea@borgia.bo.it>
 2022-01-14 20:32:56 +01:00
sandraros
7fa137bc94
ip_style TYPE any + add_new_style( io_clone_of = ) (#929) 
* ip_style TYPE any + add_new_style( io_clone_of = )

* zdemo_excel2 instead of zdemo_excel1

* Update zcl_excel_worksheet.clas.abap

* Unit tests added + fix demo 2

Co-authored-by: sandraros <sandra.rossi@gmail.com>
Co-authored-by: Abo <andrea@borgia.bo.it>
 2022-01-09 13:07:22 +01:00
sandraros
8f630081ed
zdemo_excel20 shows old abap2xlsx URL (#963) 2022-01-09 07:15:02 +01:00
Lars Hvam
5e1ca6255f
change REFRESH to CLEAR (#954) 
* change REFRESH to CLEAR

and remve REFRESH if the variable is always empty

* more refresh

* enable REFRESH obsolete rule

* another

* last two

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>
 2022-01-07 09:25:03 +01:00
sandraros
c5eb18acdc
prevent row height zero (#950) 
Fix #944

Co-authored-by: sandraros <sandra.rossi@gmail.com>
Co-authored-by: Abo <andrea@borgia.bo.it>
 2022-01-06 10:32:24 +01:00
sandraros
6fcbc5c8a8
ip_columnrow in SET_CELL and other methods (#930) 
* get_cell, set_cell, set_area, set_merge

* Test classes + Fixes

* demo simple set_cell in zdemo_excel1

* rename the "normalize" methods + cleanup

* Demonstration programs and few fixes

* added "raising cx_static_check"

* zdemo_excel40 call methods with only IP_RANGE

Co-authored-by: sandraros <sandra.rossi@gmail.com>
Co-authored-by: Lars Hvam <larshp@hotmail.com>
Co-authored-by: Abo <andrea@borgia.bo.it>
 2022-01-06 09:44:09 +01:00
Lars Hvam
87b8291ea2
remove use of DTEL SYLANGU and DTEL GUID_16 (#953) 
* remove use of DTEL SYLANGU

* and GUID_16

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>
 2022-01-05 21:39:55 +01:00
Lars Hvam
8d63df6ba6
refactor CONVERT_COLUMN2INT (#952) 
Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>
 2022-01-05 21:29:37 +01:00
Lars Hvam
38160bc781
move converter classes to not_cloud package (#951) 
* move converter classes to not_cloud package

* STRINGVAL to STRING

* fix whitespace

* fix SYBATCH

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>
 2022-01-05 21:19:14 +01:00
sandraros
3ef605e74a
Sandraros/check demo regressions 2 (#940) 
* remove sy-datum/sy-uzeit from demo programs

* Fixed data for all demo programs

Co-authored-by: sandraros <sandra.rossi@gmail.com>
Co-authored-by: Abo <andrea@borgia.bo.it>
 2022-01-05 10:31:48 +01:00
Lars Hvam
9d0c970682
change FLOAT to F (#949) 
* change FLOAT to F

* fix whitespace

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>
 2022-01-03 21:50:43 +01:00
Lars Hvam
8d072439da
remove TYPE-POOLS statements (#948) 
* remove TYPE-POOLS statements

* fix whitespace

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>
 2022-01-03 21:42:10 +01:00
Lars Hvam
496b51e531
change SYTABIX to I (#947) 
* change SYTABIX to I

* another
 2022-01-03 21:33:18 +01:00
sandraros
3a4270c11e
Delete code instead of commenting it (#946) 
* Detect commented code

* Update abaplint.json

Co-authored-by: Lars Hvam <larshp@hotmail.com>

* first batch of modifications

* Last batch of modifications

* Last batch of modifications (again)

Co-authored-by: Lars Hvam <larshp@hotmail.com>
Co-authored-by: sandraros <sandra.rossi@gmail.com>
 2022-01-03 08:54:52 +01:00
Gregor Wolf
a5e4bb9c77
add column for photographer, improve formatting (#943) 
* add column for photographer, improve formatting

* Update src/demos/zdemo_calendar.prog.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

* Update src/demos/zdemo_calendar.prog.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>
 2022-01-02 12:05:16 +01:00
sandraros
9ee01464fc
keyword_case upper (#942) 
* keyword to upper case (using class builder)

(methods in zcl_excel_style_changer were automatically reordered)

* keyword upper case of local implementations

* Update src/zcl_excel_style_changer.clas.abap

Co-authored-by: sandraros <sandra.rossi@gmail.com>
Co-authored-by: Abo <andrea@borgia.bo.it>
 2022-01-02 08:23:57 +01:00
Lars Hvam
98d67652a9
refactor to use new collection classes (#937) 
* refactor to use new collection classes

closes #880

* Update src/zcl_excel.clas.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

* Update src/zcl_excel_comments.clas.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

* Update src/zcl_excel_data_validations.clas.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

* Update src/zcl_excel_drawings.clas.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

* Update src/zcl_excel_worksheets.clas.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

* Update src/zcl_excel_writer_csv.clas.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

* Update src/zcl_excel_writer_huge_file.clas.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

* Update src/zcl_excel_writer_xlsm.clas.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

* Update src/zcl_excel_writer_2007.clas.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

* Update src/zcl_excel_columns.clas.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

* Update src/zcl_excel_fill_template.clas.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

* Update src/zcl_excel_worksheet.clas.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

* Update src/zcl_excel_ranges.clas.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

* Update src/zcl_excel_reader_2007.clas.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

* Update src/zcl_excel_rows.clas.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

* Update src/zcl_excel_styles.clas.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

* Update src/zcl_excel_styles_cond.clas.abap

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>
 2022-01-01 12:46:10 +01:00
sandraros
f16a3cc9b2
Allow more than 255 sheets per workbook (#934) 
Fix #530

Co-authored-by: sandraros <sandra.rossi@gmail.com>
Co-authored-by: Lars Hvam <larshp@hotmail.com>
 2021-12-29 05:42:09 +01:00
Gregor Wolf
2818544c9a
Domain for ZEXCEL_SHEET_TITLE (#936) 2021-12-28 23:35:01 +01:00
sandraros
9e90a307c1
Demo WebDynpro: ICF, button text, MIME type (#928) 
* * add ICF Service to demo webdynpro

* WDA MIME application/vnd.openxmlformats-officed...

* * empty button text -> text "download"

* Custom "download" OTR text for Demo WDA

* Demo WDA button text Download dynamically (no OTR)

(to overcome issue https://github.com/abapGit/abapGit/issues/5232)

Co-authored-by: sandraros <sandra.rossi@gmail.com>
Co-authored-by: Abo <andrea@borgia.bo.it>
 2021-12-27 21:54:21 +01:00
Lars Hvam
26a42d8bdb
ddic, fix UUID and GUID_16 (#924) 
* ddic, fix DOMA UUID

* fix DTEL GUID_16

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>
 2021-12-25 21:22:49 +01:00
Abo
c55cf528fd
fix typo: hasehd -> hashed (#927) 
* fix typo: hasehd -> hashed

* make "hasehd" types private

Co-authored-by: sandraros <34005250+sandraros@users.noreply.github.com>
 2021-12-24 19:20:40 +01:00