--- Patrick Shanahan
* Stephen W
[05-13-04 20:05]: When I hide columns in OO spreadsheet the data/formulas are lost when I show them again.
Is there a way to keep the data?
How are you hiding the columns? AIUI, the proper maner is to set the column width to zero. If you reset the column width to > zero the data will reappear. I just tested it on my 9.0 system, OpenOffice_org-1.1-43, and it works correctly.
I used the drop down menu under format>columns>hide (or show as the case might be). I will try the "zero" option. Thanks ===== Stephen W Sarasota, FL "A merry heart doeth good like a medicine ..." Proverbs __________________________________ Do you Yahoo!? Yahoo! Movies - Buy advance tickets for 'Shrek 2' http://movies.yahoo.com/showtimes/movie?mid=1808405861