Ask Your Question

Cell format not applied after file reload in Calc

asked 2017-01-04 16:26:09 +0200

williepabon gravatar image

Hi: I created a particular numeric format in my file, which I called TwoDig (see below)

The format worked as expected, as you see below.

The problem shows when I save my file and open it again. I looks like the format disappeared!

When I check the format cells menu to see if my TwoDig format shows, this is what I get:

The question mark character was removed from the format! Is this a problem with the software or I'm doing something wrong? Please, help. Thanks.

edit retag flag offensive close merge delete


In what format are you saving your spreadsheet? If you are not using the native .ods you may lose formatting.

robleyd gravatar imagerobleyd ( 2017-01-05 03:33:02 +0200 )edit

I'm using native .ods

williepabon gravatar imagewilliepabon ( 2017-01-07 21:24:45 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-01-08 17:52:04 +0200

williepabon gravatar image

Hi: This problem is solved if I save the file in .xlsx format instead of .ods. Strange!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-04 16:26:09 +0200

Seen: 31 times

Last updated: Jan 08 '17