Ask Your Question

4.0 Calc cell format problem - clean install on XP Pro [closed]

asked 2013-02-08 14:21:51 +0200

catwizud gravatar image

updated 2015-10-21 15:51:40 +0200

Alex Kemp gravatar image

4.0 is looking good, thanks for the hard work.

One small problem though, reading a file last saved in shows negative numbers in black font when they where formatted red.

New cells are correct and will highlight in red.

This is important to me so will need to re-install if it cannot be solved.



P.S. If a cell within the formatted area is altered or deleted then formatted cells highlight red font. If saved and re-opened negative numbers are back to a black font.

New sheets in 4.0 act normally. I just tried a cut'n'paste from old to a new 4.0 sheet and when re-opened negative numbers are still back to a black font.

P.S.S. Seems to be the same problem as mariosv, so I have added my findings/comments to existing bug report.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-21 15:51:48.062732

2 Answers

Sort by » oldest newest most voted

answered 2013-02-09 00:04:02 +0200

m.a.riosv gravatar image

A bug Formatting: Appears to have no effect on numbers about same problem, what I have just confirmed.

A hard calculate (Crtl+Shif+F9) solve the issue.

edit flag offensive delete link more




manj_k gravatar imagemanj_k ( 2014-07-08 18:56:04 +0200 )edit

answered 2013-02-08 23:45:19 +0200

qubit gravatar image

Hi @catwizud,

This problem sounds like a bug. Please file a bug about this in the bugtracker and explain exactly what you said here. The QA team will be happy to help you track down what's going on here.


edit flag offensive delete link more



I apologise for the delay in replying.

catwizud gravatar imagecatwizud ( 2013-02-10 23:29:52 +0200 )edit

@catwizud, No worries! :-) Hmm... doesn't look like you'll get karma if I upvote your comment, but I can upvote your question instead. Looks like you commented on the bug report as well. Thanks for helping us out!

qubit gravatar imagequbit ( 2013-02-10 23:35:57 +0200 )edit

Question Tools


Asked: 2013-02-08 14:21:51 +0200

Seen: 1,375 times

Last updated: Feb 10 '13