Bug 143062 - FILEOPEN XLSX FORMATTING wrong colour in cell
Summary: FILEOPEN XLSX FORMATTING wrong colour in cell
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.4.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-06-25 08:34 UTC by Ludwig.Neumeyer
Modified: 2021-06-25 09:45 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
A simple Excel-file with numbers in different colours (18.35 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-06-25 08:34 UTC, Ludwig.Neumeyer
Details
Screenshoot LibreOffice vs Excel (88.97 KB, image/png)
2021-06-25 09:02 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
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.