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@lists.freedesktop.org
Reporter: kelem...@ubuntu.com
CC: ba...@caesar.elte.hu, c...@nouenoff.nl,
dericl...@gmail.com, gan...@poczta.onet.pl,
kelem...@ubuntu.com,
libreoffice-bugs@lists.freedesktop.org,
llsub...@zudiewiener.com, lukebe...@hotmail.com,
nem...@numbertext.org, rob...@iafrica.com,
ssand...@bookmasters.com, t...@mspacek.mm.st,
todven...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs