Ask Your Question

Formats not being retrieved with saved files

asked 2020-11-22 06:43:42 +0100

stub gravatar image

I've spend a lot of time formatting the appearance of my spreadsheets, but they are no longer being retrieved with my saved files. How to fix this problem.

edit retag flag offensive close merge delete


Are you saving in .ods or a different file format? Formatting doesn't always survive conversion to and from other file formats. Always saving in native format should fix the problem, unless it is something else.... Cheers, Al

Earnest Al gravatar imageEarnest Al ( 2020-11-22 07:46:15 +0100 )edit

I was saving in .cvs format

Have you got the default Save format as .csv? Go to Tools > Options > Load/Save > General, under Document type, select Spreadsheet, in the next field down, Always Save As it should say ODF spreadsheet (*.ods).

When you save it as ODS, under Save as type you should select ODF spreadsheet (*.ods). If you just rename the .csv to .ods there will be no extra information saved.

Earnest Al gravatar imageEarnest Al ( 2020-11-22 10:14:44 +0100 )edit

That solved the problem. It took several (about 3 or 4 attempts), before it would save/load with the formatting. But now I'm good to go. Thank you.

stub gravatar imagestub ( 2020-11-22 11:28:52 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-11-22 08:30:08 +0100

stub gravatar image

It was part of the problem. I was saving in .cvs format which I knew didn't save the formats. So I saved them in .ods format instead. But the problem exits it .ods format as well.

edit flag offensive delete link more


This is not a solution to your problem; please click on the More link in the non-answer and convert it to a comment.

robleyd gravatar imagerobleyd ( 2020-11-22 09:17:36 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-11-22 06:43:42 +0100

Seen: 33 times

Last updated: Nov 22 '20