[Libreoffice-bugs] [Bug 127822] New: CALC FILEOPEN, FILESAVE: Excel Import/Export changes cell contents for Boolean cells

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 127822
           Summary: CALC FILEOPEN, FILESAVE: Excel Import/Export changes
                    cell contents for Boolean cells
           Product: LibreOffice
           Version: 6.3.1.2 release
          Hardware: All
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: axel at dua3.com

Description:
Boolean values are changed when opening and saving excel workbooks.

I have attached sample workbooks that I created using Excel. In the first cell
I typed in "TRUE", in the cell below "=TRUE". Both display as "TRUE" in Excel
(see screenshot). When opened in LibreOffice, both display as "1". When saving
as "savedInLibreOffice" to xls format from wihtin libreoffice again, the cell
contents are changed as can be seen on the screenshot.

This is an issue since we encountered this when programmatically processing
excel documents and values from boolean cells could not be evaluated after
making changes in LibreOffice even though the sheet containing the boolean
values had not been altered (only the text of a single cell on another sheet
had been changed).

description of screenshot:

top: document "savedInExcel" opened in Excel (left) vs LibreOffice (right)
bottom: document "savedInLibreOffice" opened in Excel (left) vs LibreOffice
(right)

LibreOffice version: LibreOffice Version: 6.3.2.2 (same issue with 6.3.1.2)
Excel version: Microsoft Excel for Mac Version 16.29.1


Steps to Reproduce:
1. Open attached workbook "savedInExcel.xlsx" in Calc
2. Save again in xlsx format
3. Compare with original (preferrably in Excel if available)

Actual Results:
Cell A1 content changed from "TRUE" (no '=') to "=TRUE()" (added '=' and '()')
Cell A2 content changed from "=TRUE" to "=1"

Expected Results:
cells contents should not change


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: StartModule
[Information guessed from browser]
OS: Mac OS X (All)
OS is 64bit: no

-- 
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/20190927/1b5d7623/attachment.html>