Ask Your Question

how do i stop calc from changing the cell colors [closed]

asked 2013-09-20 16:43:53 +0200

fvicary gravatar image

when i open my excel spreadsheet the colors have all been changed. this is inconvenient as each color has a meaning. how can i stop this from happening. regards


edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-09 09:32:27.908120


Please reopen this question, as it's not outdated. Colors are still changed when opening files with LibreCalc 5.2.

dandv gravatar imagedandv ( 2016-08-24 09:43:45 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-09-21 22:53:32 +0200

Esprit gravatar image

Save the file as an .ods instead of .xls or .xlsx Unfortunately you will have to re-correct the colours when you do this but if you use the .ods format consistently in LibreOffice then you won't have to worry about the colours changing.

.xls and .xlsx files are proprietary formats for Excel. LibreOffice has to reverse engineer the files to make them compatible with the software, so some things are not yet perfect in transition. New versions of MS Office support .ods and other Open document formats, so it's better just to use .ods for your spreadsheets.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-09-20 16:43:53 +0200

Seen: 502 times

Last updated: Sep 21 '13