OK, after working on this more, I found 2 things. First, I was able to
switch between the sheets using the Navigator (I double-clicked where it
showed the number of sheets on bottom left of file window). Then I
noticed that the scroll bar had been expanded to the entire width of the
window, hiding the sheet tabs. I simply clicked the left edge of the
bottom scroll bar and dragged to the right to uncover the tabs. Not
sure how that happened, but it's working now. Whew!
Thanks,
Carl
On 3/13/13 1:07 PM, Carl Paulsen wrote:
LibreOffice 3.5.6.2
Mac OS 10.6.8
I have a spreadsheet with 4 sheets. File has been taking a long time
to save (10 seconds or so for a 650kb file). Auto-filter is currently
on for at least one sheet. This morning I closed the file because
after saving, the display of the grid was wrong. Auto-filter pop-up
arrows and column headings were mixed up and wouldn't revert to the
proper display.
After closing with a save, when I re-opened, the last sheet I worked
on opens, file says there are 4 sheets, but I can't access the sheet
tabs to navigate to the other tabs. I've opened Calc options/prefs
and made sure it was set to display sheet tabs in the window. No luck.
I've spent 8-10 hours on this file with some complicated vlookups,
formulas, etc. (most of which have been converted to data by now), and
I need to complete it today or tomorrow and am a bit panicked. Can't
think of anything else that would cause this, nor how to access the
other sheets. Help please!
Thanks!
Carl
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
