| Summary: | FORMATTING: cell format "Status" from xlsx are not transferred correctly to Calc | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Elisabeth Dapper <eda-lo> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | UNCONFIRMED --- | ||
| Severity: | normal | CC: | armlopez, ilmari.lauhakangas |
| Priority: | medium | ||
| Version: | unspecified | ||
| Hardware: | All | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
screenshots of the described steps
File with formatted cells, straight from Excel |
||
(In reply to Elisabeth Dapper from comment #0) > 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 Please attach such a file that is coming straight from Excel and has never been saved in Calc. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document. Created attachment 191563 [details]
File with formatted cells, straight from Excel
As requested, a sheet with the formatted fields that has never been saved with Calc.
I was unable to recreate the same behavior in Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: a2265e8faa099d9652efd12392c2877c2df1d1eb CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded or Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded |
Created attachment 191020 [details] 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"