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
FRED
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
FRED
Please reopen this question, as it’s not outdated. Colors are still changed when opening files with LibreCalc 5.2.
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.