On 01/05/2010 04:29 PM, NoOp wrote: > On 01/04/2010 07:35 PM, [email protected] wrote: >> >> >> Hi all, >> >> I opened an Excel document that had cell comments, in Open Office >> Calc. When I closed the file in Calc I saved it as an Excel file. >> >> However when I reopened the file in Excel, the cell comments are >> visible onscreen but will not print. >> >> The cell comments can be moved and edited in Excel, however they are >> not visible on the print preview. This is despite ensuring all >> settings are ok for printing cell comments as-displayed. >> >> I have tried resaving from Calc as different excel versions, tried >> different printers to no avail. Hope someone can help or advise. > > I cannot completely reproduce. > > o Created spreadsheet in Calc 3.2.0 (linux) w/cell value & comments > o Saved as Excel97/etc > o Opened a VirtualBox Win2kPro machine & opened the file in both Calc > 3.2.0 (Windows) and Excel 97. In both I was able to print (to a virtual > PDF printer (PDFCreator & Adobe Acrobat 6.0) w/comments. > > In Excel: File|Page Setup|Sheet|Comments: At end of sheet > > However, I found that using 'As Displayed on Sheet' does indeed have > problems as you mentioned. You might want to check to see if there has > been a bug alread filed regarding this, if not file one.
Sorry; to be clear - file the bug with Microsoft as OOo prints 'As Displayed on Sheet' w/o issue, even when an comment has been added in excel to the sheet. Also should have mentioned that I also tested with a sheet created in excel. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
