(in OO and until LO 3.3.4 the following described problem didn't occur)
#WERT! (German language) is shown in a cell containing a formula in the following cases:
- if a formula in a cell refers to another empty cell. Putting a '0' (zero) into the empty cell makes the #WERT! disappear and the calculation result is shown
- if a formula in a cell refers to another cell in which double quotation marks (" ") are used in order to cause showing an empty cell
Created attachment 51027 [details]
two speadsheet visualize the described problem
Without a sample document it's difficult, but I am pretty sure that this one is a DUP of "Bug 37860 - Formula returns #VALUE in 3.4RC2 but works as expected in 3.3"
Please feel free to reopen this Bug if you find evidence that we have an independent issue here.
Workarounds you can find here: <http://email@example.com/msg06637.html>
May be you can test <http://wiki.documentfoundation.org/BugReport_Details> for submitting bug reports?
Please file Bug reports with status UNCONFIRMED if your are not absolutely sure that you contributed all required background information, that the problem will be reproducible with information you can provide or that your enhancement request will be accepted!
*** This bug has been marked as a duplicate of bug 37860 ***