 |
Forums |
Admin  Start New Thread
By: Daniel Berger
 RE: Support for Cell comments [ reply ]
2008-01-26 18:34
|
I think the best thing to do would be to post your code so we can take a look.
Debugging this library is extremely difficult because it mainly deals with specific hex values, and the original Perl code has almost no tests.
Also keep in mind that this is the Excel 95 version. The current Perl module uses the Excel 97 format, so a straight port may not work if you took the code from that version.
Regards,
Dan
|
By: Raja Venkataraman
RE: Support for Cell comments [ reply ]
2008-01-26 18:34
|
Ok, after a few tweaks, I have the comment box showing up now but the contents are empty. I have been checking this with OpenOffice but that probably doesnt matter.
My question still is, how does one debug these as to why something doesnt work as expected? Is there some kind of hex editor that could help?
|
By: Raja Venkataraman
Support for Cell comments [ reply ]
2008-01-26 18:11
|
I have a need to add cell comments for each cell. I have ported the changes from Spreadsheet::WriteExcel Perl Library to the Ruby version. Currently, I have code thats free of errors but I dont see any cell comments even after adding this new code.
My question is how do you debug such a thing? I couldnt find specifications for cell comments in the BIFF Excel library (I got the spec from openoffice.org). Im completely lost and have no clue where to start debugging. Any pointers would help.
FWIW, this is the code that I ported from Perl
write_comment(row,col,comment) and the store_comments method that goes with it.
Thanks
Raja
|
|
|
