To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82543
User fst changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Fri Oct 12 10:09:03 +0000
2007 -------
Hi,
thanks a lot for the files.
Had a short look on the ODS file. I will use I29 on the second sheet as an
example.
First of all, this is not a bug of Calc. You try to calculate with text values
which is not possible with Calc.
I29 divides G29 and E29. G29 refers to F18 on the first sheet which contains
'67.5 making it a textvalue. E29 refers to D18 on the first sheet which contains
'134.9 making it also a text value. Text values have the value zero in Calc. So
you have a Division by Zero in your calculation which is correctly reflected by
the error message.
To convert the text values on the first sheet to numbers use the following
steps :
- Select A1 on the first Sheet
- Type CTRL+F (Find and replace dialog opens)
- Into the Find field type .*
- Into the replace field type &
- Click on the more button and select regular expression
- Click on Replace all
This sequence takes the cell content and replaces it with itself, making the
former text values a number by removing the apostrophe in front of the value.
We have an easy to use feature to determine if a cell is a text, a number or a
formula result. Press CTRL+F8 to enable the Value Highlighting Feature. Green
are formula results, black is text and blue are numbers.
Frank
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
