Sheet starts at Row 135? also protection

Discuss the spreadsheet application

Sheet starts at Row 135? also protection

Postby eleanorb » Sat Jan 18, 2020 6:52 pm

On an old Calc document of mine, Sheet 1 begins with row 135, Sheet 2 at row 1. Any way I can see (get back?) whatever was once in rows 1-134? How could this happen?
Second question: I'd like to freeze an old document in time, so a won't inadvertently make changes. I've tried various forms of Protect, but I seem to still be able to change cells. Have I misunderstood the concept of protection? I tried selecting the whole sheet and turning on protection with a password, and I tried Save with Password. Then I reopen the sheet and try to change a cell, and in both cases nothing stopped me from doing that. — Eleanor
eleanorb
 
Posts: 77
Joined: Mon Dec 28, 2009 11:59 pm
Location: Queens, NY — MacOS 10.15.3

Re: Sheet starts at Row 135? also protection

Postby FJCC » Sat Jan 18, 2020 7:35 pm

There is a box just above the column A header that shows what cells are selected. In that box enter A1:A134 (be sure to hit Enter after typing) then go to the menu Format -> Row -> Show
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7752
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Sheet starts at Row 135? also protection

Postby RoryOF » Sat Jan 18, 2020 7:40 pm

A crude but effective way to stop a document being altered is to mark it read-only at system level.
Apache OpenOffice 4.1.7 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31451
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Sheet starts at Row 135? also protection

Postby eleanorb » Sun Jan 19, 2020 2:35 am

To FJCC: I did that, and A1:A134 appeared in the large entry box to the right, I pressed return , nothing happened. I pressed return again, and I found myself at row 474, where "A1:A134" appeared in cell D! Not sure what, if anything happened. If it matters, I'm using OO 4.1.7. Eleanor

To RoryOF: Thanks for the tip about locking the file in the Finder! Works a treat! and simple, I just never thought of that... Eleanor
AOO 4.1.7 on MacOS 10.15.3
eleanorb
 
Posts: 77
Joined: Mon Dec 28, 2009 11:59 pm
Location: Queens, NY — MacOS 10.15.3

Re: Sheet starts at Row 135? also protection

Postby FJCC » Sun Jan 19, 2020 3:06 am

Did you go to Format -> Row -> Show?
In that box enter A1:A134 (be sure to hit Enter after typing) then go to the menu Format -> Row -> Show
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7752
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Sheet starts at Row 135? also protection

Postby RusselB » Sun Jan 19, 2020 3:14 am

This may be overkill for getting the rows to show, but since FJCC's suggestion didn't work, right click on the "cell" located at the top of the row numbers and to the left of the column letters.
This will highlight your entire spreadsheet.
Next right click on one of the rows and select Show.
This will make all rows that are currently hidden visible again.
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6123
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

Users browsing this forum: No registered users and 31 guests