[Libreoffice-bugs] [Bug 128038] New: FILESAVE MSExcel 2007-365 conditional format selected style is lost after closing and reopening on libreoffice-6.3.2.2-snap1

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Oct 9 07:41:54 UTC 2019


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

            Bug ID: 128038
           Summary: FILESAVE MSExcel 2007-365 conditional format selected
                    style is lost after closing and reopening on
                    libreoffice-6.3.2.2-snap1
           Product: LibreOffice
           Version: 6.3.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: stdedos at gmail.com

Description:
Apply the following Conditional Format to a cell:
FormulaIs: AND(MOD(NOW(),1)>MOD(A1,1),MOD(NOW(),1)-MOD(A1+TIME(0,15,0),1)<0)
Style: Anything that's "noticable and different" than the rest of the cells

Write the quarter of the current time, rounded down (e.g. 10:39 >> 10:30)

Save the file as 'MSExcel 2007-365' format, close and re-open.

Expected result: File opens as-is
  Actual result: Conditional format has "reverted" to the default. It may have
also remove the style from "Styles

===================

The feature was never perfect, even on the stock Ubuntu 16.04 libreoffice
(that's my earliest).
The replication and behavior are "more consistent" now though

Actual Results:
1.
2.
3.

Expected Results:
1.
2.
3.


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
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/20191009/2d14d50b/attachment.html>


More information about the Libreoffice-bugs mailing list