[Libreoffice-bugs] [Bug 143896] New: FILESAVE XLSX 1001+ rows are lost after saving new file

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=143896

            Bug ID: 143896
           Summary: FILESAVE XLSX 1001+ rows are lost after saving new
                    file
           Product: LibreOffice
           Version: 7.2.0.0 alpha1+
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: bibisected, bisected, dataLoss, filter:xlsx,
                    regression
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nemeth at numbertext.org, szucs.attila3 at nisz.hu,
                    varga.balazs3 at nisz.hu
            Blocks: 108815

Created attachment 174308
  --> https://bugs.documentfoundation.org/attachment.cgi?id=174308&action=edit
Sample data as plain text

When a new file is created with more than 1001 rows and saved as XLSX the rows
over 1001 are lost on save.

Steps to reproduce:
    1. Open the attached text file, it contains numbers 1-1500 in rows
    2. Paste all of this as unformatted text into a new Calc file
    3. Save as XLSX, reload in Calc or Excel

Actual results:
Row 1001 is the last one still having contents.

Expected results:
All rows retained.

LibreOffice details:
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 5aac78e5fb241050a86714687e9ff8804588ae3c
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: CL

Additional Information:
Bibisected using bibisect-win64-7.2 to:
URL:
https://cgit.freedesktop.org/libreoffice/core/commit/?id=2bf3e0d00e3bccb5b250642ee0d3fdbe6cae8ecc 

author   Attila Szűcs <szucs.attila3 at nisz.hu>   2021-01-27 17:43:43 +0100
committer       László Németh <nemeth at numbertext.org>   2021-02-09 16:37:51
+0100
commit  2bf3e0d00e3bccb5b250642ee0d3fdbe6cae8ecc (patch)

tdf#104502 sc: skip hidden columns at printing pages

Adding CC to: Attila Szűcs

Note: this might be related to the fix added to bug 41425 which introduced an
1000 row limit to save rows with formatting but without contents to xlsx. 
See also bug 46738 for lifting this limit and properly save any number of rows
with formatting but without contents to xlsx.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108815
[Bug 108815] [META] Print range/area bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210816/3225c301/attachment.htm>