To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85328
------- Additional comments from [EMAIL PROTECTED] Sat Nov 8 00:20:55 +0000 2008 ------- OK, I think you are changing the issue slightly. Perhaps we are iterating towards a better description. I don't think the problem (and I can see more of a problem now) is to do with formulas, it's to do with the format of the cells in column A, which seem to be inconsistent. The problem can be resolved in various ways, but with some difficulty (eg changing the format of column A globally to 'all' doesn't work). I'm guessing that something in the XML file must be wrong, but although I can see the XML via Winzip, working out what is wrong is beyond my technical knowledge. However, I agree it would be better if Calc did not end up in this muddle, however badly the original file was written. Suggest we change the description to 'Calc fails to recognise and resolve inconsistent cell formats'. With that description, I'd be happy to mark the issue as 'new'. --------------------------------------------------------------------- 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]