[Libreoffice-bugs] [Bug 115349] Conditional Formatting is completely lost on save to XLS format FILESAVE FILEOPEN FORMATTING
https://bugs.documentfoundation.org/show_bug.cgi?id=115349 --- Comment #9 from Aron Budea --- The XLSX part could probably be worth a bug report, though. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115349] Conditional Formatting is completely lost on save to XLS format FILESAVE FILEOPEN FORMATTING
https://bugs.documentfoundation.org/show_bug.cgi?id=115349 Yousuf Philips (jay) changed: What|Removed |Added Blocks|109072, 113782 |88174 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=88174 [Bug 88174] [META] Binary XLS format limitations https://bugs.documentfoundation.org/show_bug.cgi?id=109072 [Bug 109072] [META] XLS (binary) format bug tracker https://bugs.documentfoundation.org/show_bug.cgi?id=113782 [Bug 113782] [META] XLSX (OOXML) conditional formatting bug tracker -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115349] Conditional Formatting is completely lost on save to XLS format FILESAVE FILEOPEN FORMATTING
https://bugs.documentfoundation.org/show_bug.cgi?id=115349 Aron Budea changed: What|Removed |Added Attachment #139487|application/octet-stream|application/vnd.oasis.opend mime type||ocument.spreadsheet -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115349] Conditional Formatting is completely lost on save to XLS format FILESAVE FILEOPEN FORMATTING
https://bugs.documentfoundation.org/show_bug.cgi?id=115349 Aron Budea changed: What|Removed |Added Keywords|bibisectRequest |bibisected, bisected Status|NEW |RESOLVED Resolution|--- |NOTABUG --- Comment #8 from Aron Budea --- Bibisected to the following commit using repo bibisect-linux-64-5.4. It appears to be a limitation of XLS format, see the following link: https://msdn.microsoft.com/en-us/library/03AE6098-BDC2-475B-BA2C-B8AEF7882174 Closing as NOTABUG. The solution is the reduce the conditional formatting applied to any range to 3 or less. https://cgit.freedesktop.org/libreoffice/core/commit/?id=7ceda09f6780c954fedc49764d5457aa2616b39a author Tor Lillqvist2017-03-07 22:40:55 +0200 committer Tor Lillqvist2017-03-08 00:44:01 +0200 A 'CondFmt' record can have a maximum of three CF records following (eek) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115349] Conditional Formatting is completely lost on save to XLS format FILESAVE FILEOPEN FORMATTING
https://bugs.documentfoundation.org/show_bug.cgi?id=115349 --- Comment #7 from C Hemingway --- For reference, the files generated from LibreOffice Still Portable 4.4.7.2 with conditional formatting are being opened on Mac Office 2004 (maybe 2008). That is why I have to use xls format instead of xlsx. The xlsx format is opens, but is not editable according to the staff. It may even be a PPC Mac. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115349] Conditional Formatting is completely lost on save to XLS format FILESAVE FILEOPEN FORMATTING
https://bugs.documentfoundation.org/show_bug.cgi?id=115349 --- Comment #6 from C Hemingway --- Thank you for your prompt attention in this matter. If you need any further testing, I'll be happy to do so for you. Just let me know when the change is committed. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115349] Conditional Formatting is completely lost on save to XLS format FILESAVE FILEOPEN FORMATTING
https://bugs.documentfoundation.org/show_bug.cgi?id=115349 Aron Budea changed: What|Removed |Added Keywords||bibisectRequest Status|UNCONFIRMED |NEW Version|6.0.0.3 release |5.4.0.3 release Blocks||113782, 109072, 87351 Ever confirmed|0 |1 --- Comment #5 from Aron Budea --- Thanks for the sample. The conditions are quite complicated. I wouldn't say it used to be perfect in 4.4, but until 5.3.0.3 some kind of conditional formatting was saved, and starting with 5.4.0.3 none of that is saved. At least that change could be bibisected. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=87351 [Bug 87351] [META] Conditional formatting bugs and enhancements https://bugs.documentfoundation.org/show_bug.cgi?id=109072 [Bug 109072] [META] XLS (binary) format bug tracker https://bugs.documentfoundation.org/show_bug.cgi?id=113782 [Bug 113782] [META] XLSX (OOXML) conditional formatting bug tracker -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115349] Conditional Formatting is completely lost on save to XLS format FILESAVE FILEOPEN FORMATTING
https://bugs.documentfoundation.org/show_bug.cgi?id=115349 Aron Budea changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115349] Conditional Formatting is completely lost on save to XLS format FILESAVE FILEOPEN FORMATTING
https://bugs.documentfoundation.org/show_bug.cgi?id=115349 --- Comment #4 from C Hemingway --- Created attachment 139489 --> https://bugs.documentfoundation.org/attachment.cgi?id=139489&action=edit Spreadsheet as XLSX; Conditional Formatting partial corruption (ODS to XLSX) Also note! There is a Bug in LO that - when a spreadsheet is saved to XLS/XLSX, the column format of the BOOLEAN VALUE column to custom format TRUE;TRUE;FALSE As noted in my other bug, this breaks the ISLOGICAL function, which factors heavily in my conditional formatting functions. Workaround - select all of Column S2 and convert back to BOOLEAN type. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115349] Conditional Formatting is completely lost on save to XLS format FILESAVE FILEOPEN FORMATTING
https://bugs.documentfoundation.org/show_bug.cgi?id=115349 --- Comment #3 from C Hemingway --- Created attachment 139488 --> https://bugs.documentfoundation.org/attachment.cgi?id=139488&action=edit Spreadsheet as XLS; Conditional Formatting as beenlost (just used save-as to XLS) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115349] Conditional Formatting is completely lost on save to XLS format FILESAVE FILEOPEN FORMATTING
https://bugs.documentfoundation.org/show_bug.cgi?id=115349 --- Comment #2 from C Hemingway --- Created attachment 139487 --> https://bugs.documentfoundation.org/attachment.cgi?id=139487&action=edit Spreadsheet as ODS with Conditional Formatting (prior to save as XLS) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115349] Conditional Formatting is completely lost on save to XLS format FILESAVE FILEOPEN FORMATTING
https://bugs.documentfoundation.org/show_bug.cgi?id=115349 Aron Budea changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||ba...@caesar.elte.hu Ever confirmed|0 |1 --- Comment #1 from Aron Budea --- Can you please upload a sample ODT which loses conditional formatting when saved as XLS? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs