[Libreoffice-bugs] [Bug 116591] New: Negative Date shows as ### when opening xlsx file

Fri Mar 23 19:56:20 UTC 2018

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

            Bug ID: 116591
           Summary: Negative Date shows as ### when opening xlsx file
           Product: LibreOffice
           Version: 5.4.6.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: martin.troiber at gmail.com

Description:
When opening a .xlsx file the cells (Format: [H]:MM) that contain the formula
"=CELL1-CELL2" sometimes show "###" when the result is negative. When opening
the file and saving to .xls or .ods the newly created file does not come with
the same error. However saving the working file as .xlsx brings back the
problem.

Steps to Reproduce:
1.Open a certain .xlsx file. For privacy reasons only available upon request.
2.Have a look at the cells "Vormonat" and "Akt. Stand" from sheet "November17"
to "März18".
3.

Actual Results:  
Some cells (Format: [H]:MM) that contain the formula "=CELL1-CELL2" show "###"
when the result is negative.

Expected Results:
The cells (Format: [H]:MM) that contain the formula "=CELL1-CELL2" show "###"
should have shown the result even when the result is negative.

Reproducible: Always

User Profile Reset: Yes

Additional Info:
Version: 5.4.6.2 (x64)
Build-ID: 4014ce260a04f1026ba855d3b8d91541c224eab8
CPU-Threads: 4; BS: Windows 6.19; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc: group

User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101
Firefox/59.0

-- 
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/20180323/acd0f65b/attachment.html>