Le 08/04/2009 à 20:00, JOE Conner a écrit : > Cor Nouws wrote: > > Hi Alain, > > > > Alain Baeckeroot wrote (8-4-2009 16:19) > >> I would like to display all the notes and if possible > >> to put them in a table, or at least print it : note.sheet1.A1 = > >> "foo" note.sheet3.D7 = "bar" > >> > >> for the names of variables i know (thanks to [email protected]) its: > >> Insert > name > insert > all > >> > >> but i find nothing about notes > > > > There is no (AFAIK) way to show all notes. > > Writing a macro for that, would be a fine extension ;-) > > > > Regards, > > Cor > > > You can choose to show individual notes. > > *Tools - Options - OpenOffice.org Calc - View must have a check in NOTE > INDICATOR box. > In the context menu for notes there is INSERT NOTE, DELETE NOTE, and > SHOW NOTE. If > SHOW NOTE is selected it will remain visible. I know of no universal > setting to show all notes. > * Thanks, i'll verify with this.
I managed to get the content of all notes: - i opened the xls in gnumeric, there a special characters appears in cell with note. It seems to be \n\n (unix line return twice) in one cell : text of note \n\n visible text - i said find \n\n (copied with mouse) replace by @@@ and then exported to csv :-) it messed up a little with cells where there were 2 line return, but roughtly it worked. Alain. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
