Bug 143062

Summary: FILEOPEN XLSX FORMATTING wrong colour in cell
Product: LibreOffice Reporter: Ludwig.Neumeyer
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: enhancement CC: miguelangelrv
Priority: medium    
Version: 7.1.4.2 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: A simple Excel-file with numbers in different colours
Screenshoot LibreOffice vs Excel

Description Ludwig.Neumeyer 2021-06-25 08:34:24 UTC
Created attachment 173192 [details]
A simple Excel-file with numbers in different colours

Opening a XLSX-file, the font colour attribute in some cells is ignored.
In the attached file the numbers in row 4 and 6 should be of red colour.
Comment 1 m_a_riosv 2021-06-25 09:02:13 UTC
Created attachment 173195 [details]
Screenshoot LibreOffice vs Excel

I can't see any difference opening with LibreOffice or excel.
Comment 2 [REDACTED] 2021-06-25 09:11:12 UTC
No repro

Version: 7.1.4.2 / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

No repro

Version: 7.1.4.2 (x64) / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 1; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
Locale: en-US (en_DE); UI: de-DE
Calc: threaded
Comment 3 [REDACTED] 2021-06-25 09:17:34 UTC
Could you please try to open the the test file while running in LibreOffice's "Safe Mode" (to start into safe mode use "Help -> Restart in Safe Mode", confirm the restart and click button "Continue in Safe Mode" and use "File -> Open" to open the test file). 

If it works you should try to reset your LibreOffice user profile (https://wiki.documentfoundation.org/UserProfile)
Comment 4 Ludwig.Neumeyer 2021-06-25 09:33:19 UTC
(In reply to Uwe Auer from comment #3)
> Could you please try to open the the test file while running in
> LibreOffice's "Safe Mode" (to start into safe mode use "Help -> Restart in
> Safe Mode", confirm the restart and click button "Continue in Safe Mode" and
> use "File -> Open" to open the test file). 
> 
> If it works you should try to reset your LibreOffice user profile
> (https://wiki.documentfoundation.org/UserProfile)

Thanks, that was it.
I renamed "%APPDATA%\libreoffice\4\user" and now it works.
Comment 5 m_a_riosv 2021-06-25 09:45:16 UTC
Fixed it's not fine here, no changes in the program was done.