[Solved] Spreadsheet opens in read only

Discuss the spreadsheet application

[Solved] Spreadsheet opens in read only

Postby CapnBill » Tue Dec 11, 2018 2:44 pm

Hi, I have a spreadsheet for my accounts and opened it this morning to see what I now think is a page offering me to choose a theme (it's covered in different types of arrow graphic).

I finally discovered that clicking the Edit File button would make my spreadsheet reappear. Now, however, it is in 'read only' mode. I've tried creating a new spreadsheet (to copy the data into) but I just get offered the theme page again. In the past creating a new spreadsheet would bring up, well, a blank spreadsheet.

Does anybody know how I can either get out of read only mode or start a new spreadsheet to copy the data into? This is rather frustrating and as a non-specialist I dont even know where to begin. Thanks in advance.
Last edited by CapnBill on Tue Dec 11, 2018 3:34 pm, edited 1 time in total.
MacBook Pro (13-inch, Early 2011), High Sierra 10.13.6, OpenOffice 4.1.5
CapnBill
 
Posts: 2
Joined: Tue Dec 11, 2018 2:13 pm

Re: Spreadsheet opens in read only

Postby RoryOF » Tue Dec 11, 2018 3:02 pm

/Tools /Gallery should kill the display of arrows; you then may have no need to click the Edit button.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28566
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Spreadsheet opens in read only

Postby FJCC » Tue Dec 11, 2018 3:03 pm

I think what your are seeing is the Gallery. Select the menu Tools -> Gallery to hide it. Whether the Gallery is visible or not should not affect your ability to edit the document. If you just close and reopen the document, is it still read-only?
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: 7090
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Spreadsheet opens in read only

Postby CapnBill » Tue Dec 11, 2018 3:32 pm

Thank you very much for those astonishingly quick replies! It was indeed the Gallery on display and it has now gone, everything is back to normal!

It may seem trivial to experts but for me this was next to unsolvable. If you don't have the correct vocabulary it's impossible to find by googling or trying to search the forum, so thanks again.
MacBook Pro (13-inch, Early 2011), High Sierra 10.13.6, OpenOffice 4.1.5
CapnBill
 
Posts: 2
Joined: Tue Dec 11, 2018 2:13 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 29 guests