Description: Column label text not readable on Excel xlsx file Steps to Reproduce: 1. Open xlsx file in Microsoft Excel can see Column header https://www.cleanenergyregulator.gov.au/DocumentAssets/Documents/Postcode%20data%20for%20small-scale%20installations%20-%20all%20data.xlsx 2. Open xlsx file in LibreOffice Column header became wavy lines ~~~ not readable Actual Results: Column label text not readable on Excel xlsx file Expected Results: Column label text readable. Reproducible: Always User Profile Reset: No Additional Info: LibreOffice Build https://git.libreoffice.org/core/+log/da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1
It would help to attach the xlsx file to this report. In addition, a screenshot of the file when it is opened in Excel would also help. When the xlsx file is opened by Calc, worksheet "SGU-Solar". 1. Select row 4 (entirely). 2. [CTRL]+[1] (equivalent to Format cell). 3. "Font Effects" tab. 4. "Font Color" > Change from "None" to "Automatic". IDK how the xlsx file was created, or how this "Font Color" attribute should had been parsed. IDK whether the Font Color is incorrectly imported, or instead it is just incorrectly displayed. Having said that, in order to say whether something is incorrect at all, we should know how it is done by Excel. In addition to the screenshot (when the file is opened by Excel), please provide the version of Excel you are using and the OS (from Calc menu Help > About, use the icon to copy to the clipboard and paste it in your next comment.
Created attachment 192919 [details] Excell screenshot
Created attachment 192920 [details] Excel file
Font color automatic fixed this. Thanks for the suggestion. It would have helped if it is the default so I won't need to submit this ticket.
Hunch: this is about Excel table formatting. The "waves" are just the underline originated by the Automatic Spell Checking tool in Calc. The real issue is about table format. The Summary should be modified accordingly. If table formatting is indeed the problem, then this is probably a duplicate report of some enhancement request.
Font is white as per screenshot but the background color is not rendered correctly in Libreoffice, so is this still a bug ?
(In reply to ktopyes from comment #6) > Font is white as per screenshot but the background color is not rendered > correctly in Libreoffice, so is this still a bug ? Indeed... this is actually a missing feature in LibreOffice. We still do not support Table Format (see bug 66377). If you create any table in Excel and use the "Format as Table" to apply formatting, it won't be imported into LibreOffice.
(In reply to Rafael Lima from comment #7) > Indeed... this is actually a missing feature in LibreOffice. We still do not > support Table Format (see bug 66377). Let's mark as duplicate. *** This bug has been marked as a duplicate of bug 66377 ***