Ask Your Question
0

Calc formula [closed]

asked 2013-01-23 13:41:10 +0100

richdell gravatar image

updated 2015-10-24 02:44:18 +0100

Alex Kemp gravatar image

Wstrong text*strong text*


When I open a spreadsheet created in Open Office (Windows XP) the formulas stop working part way down the page, and the output changes to #value! the rest of the way down. The formulas look right.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-24 02:44:49.480151

Comments

I decided that since Open Office Calc works, I simply install it in place of Libre. All is well now! Thanks for your help.

richdell gravatar imagerichdell ( 2013-01-25 01:12:59 +0100 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2013-02-25 06:21:47 +0100

qubit gravatar image

@richdell writes:

I decided that since Open Office Calc works, I simply install it in place of Libre. All is well now! Thanks for your help.

Looks like there might be an undiagnosed bug here. If anyone else runs across this problem, please first test against the latest release, and if doesn't seem to fix the problem, file a bug. It would be really helpful to have an example file attached to the bug report to help us diagnose the problem.

edit flag offensive delete link more
0

answered 2013-01-24 05:03:22 +0100

ROSt52 gravatar image

Eward's comment point in the right direction. I recommend to use additionally the Detective Toolbar to verify if all cells with links to your formula are correct.

View/Toolbar/Detective

read additionally in Help what comes up using

Help/Indexes/traces

edit flag offensive delete link more
0

answered 2013-01-23 22:07:19 +0100

Edward gravatar image

I had a similar scenario/problem, which turned out to be a space appearing in what should have been an empty cell (that was referenced by the formula reporting #value). Unfortunately I didn't find a quick/easy fix (I eventually found the offending cell), but at least you have a possible source for the error. Per LO's User Guides:

"#VALUE Instead of displaying Err:519. The value for one of the arguments is not the type that the argument requires. The value may be entered incorrectly; for example, double-quotation marks may be missing around the value. At other times, a cell or range used may have the wrong format, such as text instead of numbers."

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-01-23 13:41:10 +0100

Seen: 412 times

Last updated: Feb 25 '13