Ben --
This is something that people know about. I have seen it discussed about
before in the forums. I don't know if it is being fixed or not, but it
can be a problem for sure, especially if you aren't watching for it. If
you would like you can file an issue for it.
The best way to have problems such as this evaluated is to file an
issue. Issued are used to both report defects in the software and to
propose that new features be added. For instructions on how to file an
issue please see:
<http://openoffice.peschtra.com/tips/ooott_web_iz_file_issue.html>
Thanks for bringing this to our attention. It is important that you file
the issue to ensure reproducibility with your examples.
HTH,
Peter
Ben Wong wrote:
Hi,
Recently I had a problem to solve which involve using a spreadsheet
originally created in MS Excel but my user now have to use OO Calc
after changing to Fedora.
It seem that in MS Excel, cells that contain non-numeric data can
can be used for computation in formulas. While in OO Calc the same
spreadsheet will produce a different result due to mixing numeric and
non-numeric.
I think OO Calc has followed the basic arithmetic rule that only
numeric can be correctly computed. While in MS Excel it assume
the non-numeric data into valid numerics.
Just want to hear what you all think about this problem especially
when troubleshooting for errors.
Best regards,
Ben
p.s. pls checkout the attached Excel file.
------------------------------------------------------------------------
---------------------------------------------------------------------
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]
