Hello,
Please see this bug at Fedora:
https://bugzilla.redhat.com/show_bug.cgi?id=419181
as an example for a frequent situation in Calc:
If a numeric-only string in some cell arrives to be treated as text (have an
apostrophe in front of it), it won't participate in totals, formulas,
calculations, etc.
OpenOffice.org 2.3.1 issues no warning about that, leading to situations in
which totals are mathematically wrong. This may be a serious issue. IMHO, OOo
should issue a warning when some formula tries to use in mathematical
calculations a cell that is formatted as text.
As far as I know, there is no easy way to automatically remove the apostrophes
for a range of cells (at least I didn't managed to find any solution in the
docs). This is important when the range is large and/or the user has no skill in
writing regular expressions for searching/replacing apostrophes... ;-)
This situation is very frequent with spreasheets imported from Microsoft Excel -
Microsoft Excel 2003 silently corrects this situation.
Particularily, this leads to the user impression that Microsoft Excel
„calculates correctly” and OOo „is wrong”.
If a solution aleady exist, please add some piece of docs - I think this should
be a FAQ.
Regards,
Răzvan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
