https://bugs.documentfoundation.org/show_bug.cgi?id=158356
Bug ID: 158356
Summary: FORMATTING: cell format "Status" from xlsx are not
transferred correctly to Calc
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 191020
--> https://bugs.documentfoundation.org/attachment.cgi?id=191020&action=edit
screenshots of the described steps
The predefined cell formats "status" (good, neutral, bad) from Excel are not
transferred correctly into the corresponding Calc-Status Formats.
This has two eetcs:
- The status "good" form xslx appears as "Excel built-in good" in Calc
- Using the "Excel built-in" formats in Excel switches the content-Status to
"standard" (from date, time, etc.)
Used versions: Excel 2016 and LibreOffice 7.5.7.1
same behaviour with Excel 2019 and with LibreOffice 7.6.3.2
How to repoduce:
create an Excel sheet, fill some cells with date, time, number
format cells with the status formats "good", "neutral", "bad"
save (xslx) and close
open the file in Calc
the format status are displayed as "excel built-in ..."
add comment, save and close
open in Excel
the "excel built in ..." formats are displayed
add comment, save ans close
open the file in Calc
additional versions of the "excel built in ..." status formats are displayed
add comment, save ans close
open again with Calc
the additional versions of the "excel built in ..." status formats are not
displayed anymore
open with Excel
use the "excel built-in …" formats for new or existing values
=> the cell format switches to "Standard"
--
You are receiving this mail because:
You are the assignee for the bug.
