Ask Your Question

Bug or Misoperation in Calc [closed]

asked 2013-03-19 23:22:39 +0200

Huskey gravatar image

updated 2020-07-21 21:08:56 +0200

Alex Kemp gravatar image

Hi. I'm not sure if the following is a bug or if I do something wrong. After inserting a forumula in Calc, negative numbers turn red as they are supposed to according to my preferences set in Format Cell/Numbers until I close the file. But when I open this file again at a later stage, all negative numbers are black as the positive numbers. Many thanks for your help.

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-27 03:42:41.731263

2 Answers

Sort by » oldest newest most voted

answered 2013-03-20 01:40:04 +0200

m.a.riosv gravatar image

It is a know bug (, as I remember a hard recalc restore the format Ctrl+Shift+F9

edit flag offensive delete link more



fdo#60215 · Status: RESOLVED FIXED

manj_k gravatar imagemanj_k ( 2014-08-01 21:25:42 +0200 )edit

Thanks @manj_k for pointing.

m.a.riosv gravatar imagem.a.riosv ( 2014-08-01 22:54:07 +0200 )edit

answered 2013-03-20 02:44:14 +0200

horst gravatar image

You can also set the recalculation options in Tools->LibreOffice Calc-> Formula to "Always recalculate". I believe it is set to "Never recalculate" by default.

edit flag offensive delete link more

Question Tools


Asked: 2013-03-19 23:22:39 +0200

Seen: 179 times

Last updated: Mar 20 '13