[Libreoffice-bugs] [Bug 120012] New: FILESAVE: Formatting and/or data validation, positioned after last non-empty cell, is lost when saving to XLS or XLSX

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 120012
           Summary: FILESAVE: Formatting and/or data validation,
                    positioned after last non-empty cell, is lost when
                    saving to XLS or XLSX
           Product: LibreOffice
           Version: 6.2.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: major
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kelemeng at ubuntu.com
                CC: baron at caesar.elte.hu, cno at nouenoff.nl,
                    dericlima at gmail.com, gang65 at poczta.onet.pl,
                    kelemeng at ubuntu.com,
                    libreoffice-bugs at lists.freedesktop.org,
                    llsubscr at zudiewiener.com, lukebenes at hotmail.com,
                    nemeth at numbertext.org, roberg at iafrica.com,
                    ssanders at bookmasters.com, tdf at mspacek.mm.st,
                    todventtu at suomi24.fi
        Depends on: 41425
            Blocks: 108897, 108988, 109072

Created attachment 145070
  --> https://bugs.documentfoundation.org/attachment.cgi?id=145070&action=edit
Example ods file with 2000 rows of validation

+++ This bug was initially created as a clone of Bug #41425 +++

Hi. I have a file with lots of data validation, I open it in LibreOffice, and I
do nothing else but save it as either XLS or XLSX.

The resulting XLS or XLSX now have no data validation.

---
This bug is here as a reminder to find a proper solution to saving formatting
and data validation to XLSX format. The workaround for Bug #41425 works for the
next 1000 rows after the last one, which should cover most user needs. 

However we should not settle for a workaround, but support this for all and
every single rows.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=41425
[Bug 41425] FILESAVE: Formatting and/or data validation, positioned after last
non-empty cell, is lost when saving to XLS or XLSX
https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
https://bugs.documentfoundation.org/show_bug.cgi?id=108988
[Bug 108988] [META] Validity-related bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=109072
[Bug 109072] [META] XLS (binary) format bug tracker
-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180920/931e980a/attachment-0001.html>