On 2007.12.13. 13:55, Răzvan Sandu wrote:
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... ;-)
well, the problem is annoying, but luckily there's a solution floating
around :
http://www.ambience.sk/open-office-text-number-format-conversion
1. Use search and replace.
2. Click More options and check regular expressions.
3. Set the search string to '.*' (without the quotes) and replace string
to '&' (again, without the quotes).
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
--
Rich
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
