Ask Your Question

calc files are using dates or times for all cells

asked 2019-01-11 17:27:53 +0200

hackenberg gravatar image

updated 2019-01-13 01:19:52 +0200

calc files are using dates or times for all cells even when the cell has been assigned to money or numbers. Even new files are doing this. I was hoping in the updates it would be fixed, but it's not. I reuse files and even when the cell has had a number in it before it puts a date or time format in the cell instead. I want this to stop. How can I do so?

auto-format is not as assigned.C:\fakepath\example file for libreforum.ods

edit retag flag offensive close merge delete


Can you edit your question and attach an example .ods file?

BigRAl gravatar imageBigRAl ( 2019-01-12 13:54:43 +0200 )edit

BigRAI - I have

hackenberg gravatar imagehackenberg ( 2019-01-13 01:20:41 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-01-14 17:33:39 +0200

erAck gravatar image

The entire sheet is formatted as H:MM time format, except cell range A3:A13 which is formatted as D-MMM.

edit flag offensive delete link more


Yes, but it does that even when I change it back to what it's supposed to be (date or money). It doesn't matter that I've tried to correct this problem. Also, I can change the format for the whole column, go down to where I want to put in the new information (or see the old information corrected) and it won't change.

hackenberg gravatar imagehackenberg ( 2019-01-15 03:31:51 +0200 )edit

The Default style has that number format set. Hit F11 or go to Style -> Manage Style, right click Default, go to tab Numbers, select Number General format, hit OK. See all your values change to raw numeric values in cells that don't have an explicit number format assigned. Apply number formats as needed or create styles derived from Default and apply those.

erAck gravatar imageerAck ( 2019-01-15 13:51:22 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-11 17:27:53 +0200

Seen: 29 times

Last updated: Jan 14