DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21027>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21027 [PATCH]Cloning Sheets: Formula Problems ------- Additional Comments From [EMAIL PROTECTED] 2003-06-25 22:51 ------- I probably should have given a better description of the problems this caused. Because these classes were not cloning the ptgClass attribute, when the spreadsheet is opened in Excel the cells with the affected functions have #VALUE! errors. I have also just uploaded another patch, which has all the original changes plus the following changes to the FunctionRecord class: 1) data_value is not being copied in FunctionRecord.clone(). This causes a problem when the result is a "Empty" cell - openning the file in Excel causes a message "File Error: data may have been lost" to be displayed. In actual fact Nothing had been lost and saving the file sorted this out - doesn't look good to the users though. 2) When the calculated value of a Formula is not a number the FormulaRecord.toString() just shows "NaN" - however the 8 bytes contain important information. When I used biffviewer, it took me a long time to work out the above problem because I couldn't see it. I have changed the toString() to display a hex dump if its not a number. I was just typing this in when you said your going to apply them - thanks much appreciated. Niall --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
