SCIENTIFIC-LINUX-USERS Archives

October 2011

SCIENTIFIC-LINUX-USERS@LISTSERV.FNAL.GOV
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Major bug in libreOffice 3.43
From:
Larry Linder <[log in to unmask]>
Reply To:
Larry Linder <[log in to unmask]>
Date:
Fri, 7 Oct 2011 16:12:04 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (23 lines) 
There is a major problem with the spread sheet and how it error checks 
calculations.

The example is:

Spread Sheet 

cell K7 = K6+D7-H7-I7-J7      The displayed value   is #value

All cells are formatted as Dollars two decimal places.
Tried to add $0.00 to all empty cells - did not change anything.

If I remove the K6 cell from the calculation it now works but answere is now 
worthless.

Tried to look up #value in help but it was not found.

Good thing I didn't retire OpenOffice 3.3.2 on all systems in shop.
Friday and a nice weekend and I may be stuck here removing libreoffice 3.4.3 
from all machines in shop.

Larry Linder

ATOM RSS1 RSS2