Apache OpenOffice (AOO) Bugzilla – Issue 103364
The position of the "show note" in an ods file should be behaved the same as in an xls file
Last modified: 2012-09-03 08:30:33 UTC
When we click "Show Note" on a cell to make the note shown and save as an ods file, the position of the "show note" will be deviated from what we expect. However, if we save as an xls file, the position will be kept as what we expect -- even we do some change ( e.g. insert some rows ) and resave the file. Please check to see what make the difference and make the position of the "show note" in an ods file behaved the same as in an xls file, because we cannot set the password for an xls file. Thank you.
Created attachment 63405 [details] an xls file with some notes shown and the positon of the notes can be kept even we do some change to the file and save the change.
Created attachment 63406 [details] an ods file with some notes shown and the positon of the notes cannot be kept if we do some change to the file and save the change.
One more disadvantage brought by the randomly deviation of the position of the "show note", some blank pages may be added below the data pages that we cannot print directly by clicking the print button if we don't want to printout the unnecessary blank pages. Thank you.
Created attachment 63483 [details] an xls file with some notes shown and all the data is hold in one page.
Created attachment 63484 [details] an ods file with some notes shown and an extra blank page is added due to a note ( show or hide does not matter ).
Created attachment 63485 [details] an pdf output file of an xls file with some notes shown and all the data in one page.
Created attachment 63486 [details] a pdf output file of an ods file with some notes shown and an extra blank page is added due to a note ( show or hide does not matter ).
Created attachment 63496 [details] a pdf output file of an ods file with some hidden notes and an extra blank page is added due to a hidden note.
Although this issue is not related to great technical improvement, it does greatly affect daily usage unless we do not use "note" to memorize something for later use. Please help to recheck this issue and give some tips to handle this issue. Thank you.
It is seemed this issue is fixed in OOo 3.2. Thank you for your hard working !!
Verified on Aoo_Trunk_20120829.1800, it can not repro, it is fixed. so close it.