Ask Your Question

Calc spreadsheet does not keep definitions

asked 2018-12-06 18:13:32 +0100

Motim gravatar image

Hello, In "LibreOffice" I have prepared a saving accout followup spread sheet. Defined content of each column (text, currency, date, color and so on), defined font type and size, named it and saved it. Started to make entries, but each time I open it to make a new entrie, have again to select the row and select font type and size. Same goes for the entries in the columns. When done, I save it. On the next time all over again. Why does it not keep the definitions ? I made all definitions when started "LibreOffice" the first time. OS win 10 pro 64bit, 1709. Answers will be appreciated. Thanks Motim

edit retag flag offensive close merge delete


What file type are you using when saving your spreadsheet? Is that CSV?

Mike Kaganski gravatar imageMike Kaganski ( 2018-12-06 18:34:19 +0100 )edit

Hello, 1.Saved spreadsheet file in "xlsx" format. 2.Previous lines keep the definitions, only the new added lines have to re-define. Thanks Motim

Motim gravatar imageMotim ( 2018-12-07 16:38:17 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-12-07 08:36:42 +0100

Motim gravatar image

Hello, Thank you Mike for the answer. Saving my spreadsheet in "xlsx" format. Is it wrong ? Thanks. Motim

edit flag offensive delete link more


I didn't "answer", I commented. Please do the same when not answering the original question. You may either use comments, or edit your original question when adding information essential to the matter of the question. Please edit your question to add the file type there, and delete this "answer".

As to XLSX. Well - the file format, though foreign to LibreOffice, should keep the font type and so on. But it's unclear from your question, if all the formatting is lost from all the data already present, or if you speak about new rows that you wish to add when editing.

If that's existing data formatting that is lost, then please add a sample file, and mention specific steps to reproduce the problem, like "1. Put cursor to cell XXX; 2. Right-click and choose "Cell Formatting"; 3. Go to tab YYY; 4. Enter 123 to box ABC; ..., N ...(more)

Mike Kaganski gravatar imageMike Kaganski ( 2018-12-07 08:54:33 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-06 18:13:32 +0100

Seen: 26 times

Last updated: Dec 07 '18