[Libreoffice-bugs] [Bug 125414] New: FILESAVE XLSX Ellipses of the “Mark invalid data” function shouldn't be exported when saving XLSX

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 125414
           Summary: FILESAVE XLSX Ellipses of the “Mark invalid data”
                    function shouldn't be exported when saving XLSX
           Product: LibreOffice
           Version: 3.5.0 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu

Description:
The Mark invalid data function (Tools > Detective > Mark invalid data) can be
used to mark invalid data in a validated cell with a red ellipse. This function
also exists in Microsoft Excel, but Excel turns this function off automatically
when saving the spreadsheet as XLSX. Calc on the other hand saves it as a
regular, non-functioning ellipse shape in XLSX. It would probably make more
sense to drop it entirely when saving the spreadsheet as XLSX, similarly how
Excel turns this function off when saving.

Steps to Reproduce:
    1. Create a new spreadsheet.
    2. Fill the A1:A3 cells with the following numbers: 1, 5, 15 and the B1:B3
cells with the following numbers: 12, 8, 16.
    3. Select the A1:B3 cells and click on Data > Validity.
    4. In the “Validity” window set the following criteria: “Allow: Whole
numbers”, “Data: less than”, “Maximum: 10” and click on OK.
    5. Turn on the “Mark invalid data” function by clicking on Tools >
Detective > Mark invalid data – the A3, B1 and B3 cells should have red
ellipses around them.
    6. Save the file as XLSX and reload it by clicking on File > Reload.

Actual Results:
The ellipse around the B3 cell is converted to a regular, non-functioning
ellipse shape in XLSX, while the ellipses that were around the A3 and B1 cells
are lost – presumably because parts of those shapes were outside the sheets
boundary. If the same XLSX is opened in Microsoft Excel 2013 all three red
ellipses are visible.

Expected Results:
Ellipses shouldn't be exported when saving the spreadsheet as XLSX.


Reproducible: Always


User Profile Reset: No



Additional Info:
LibreOffice details:
Version: 6.3.0.0.alpha1+ (x64)
Build ID: c3245cfd54f391111afb424867ab483096d9de5e
CPU threads: 4; OS: Windows 6.3; UI render: GL; VCL: win; 
TinderBox: Win-x86_64 at 42, Branch:master, Time: 2019-05-19_22:59:06
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: threaded

Already happens in: 
LibreOffice 3.5.0rc3 
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735

-- 
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/20190521/dad80d38/attachment-0001.html>