Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
Photo

Issue with Open Office spreadsheet


  • Please log in to reply

#1
gismeu

gismeu

    Member

  • Member
  • PipPip
  • 53 posts

Hello,

 

I have been using Open Office for years and recently something changed on their spreadsheets.

I assume it was me, who did something unknowingly.

 

Suddenly some of the boxes on my spreadsheets have a red border and changing the content does not always work.

I have attached a pic.

 

And if I move the cursor over one of these boxes, a new box appears telling me in what way I changed that box recently.

 

If anybody could help me to get rid of these red lines and everything that is attached to that, I would be very grateful and happy.

 

Thanks, gis

Attached Thumbnails

  • temp open office2.png

  • 0

Advertisements


#2
phillpower2

phillpower2

    Mechanised Mod

  • Global Moderator
  • 24,941 posts

Hello gismeu,

 

I don`t use Open Office so not familiar with how it works but when you have problems with an application the best and quickest fix most often is to back up your docs, uninstall and then clean install the problem app.


  • 0

#3
gismeu

gismeu

    Member

  • Topic Starter
  • Member
  • PipPip
  • 53 posts

Hmm,

 

I have so many Open Office docs in a huge number of files, so not sure to back them up would be an easy thing to do.

Or would I keep those docs and only need the back-up if  something goes wrong with the new installation?

 

Thanks, gis


  • 0

#4
phillpower2

phillpower2

    Mechanised Mod

  • Global Moderator
  • 24,941 posts

Your documents should all be stored somewhere else, in a folder called Open Office docs for example and if of real importance backed up to somewhere like the Cloud.

 

At the moment what you have is an irritant that you are putting up with because O/O is still working but what if this is just the start of something more serious and something that renders the app useless, best to back the info up, check that all of the info is safe and only then uninstall and then clean install the problem app.


  • 0

#5
gismeu

gismeu

    Member

  • Topic Starter
  • Member
  • PipPip
  • 53 posts

Okay, thanks, will do.

 

gis


  • 0

#6
phillpower2

phillpower2

    Mechanised Mod

  • Global Moderator
  • 24,941 posts

You are welcome  :)


  • 0

#7
SleepyDude

SleepyDude

    Trusted Helper

  • Malware Removal
  • 4,985 posts

Hi,

 

I use LibreOffice but it have something similar to track document changes.

 

On Open Office Check Edit > Changes > Record option you probably have to stop the Record.


  • 0

#8
gismeu

gismeu

    Member

  • Topic Starter
  • Member
  • PipPip
  • 53 posts

Hi,

 

I use LibreOffice but it have something similar to track document changes.

 

On Open Office Check Edit > Changes > Record option you probably have to stop the Record.

You da man, SleepyDude!

 

That did the trick  :)

 

Thank you ever so much, gis


  • 0

#9
SleepyDude

SleepyDude

    Trusted Helper

  • Malware Removal
  • 4,985 posts

:thumbsup: 


  • 0

#10
phillpower2

phillpower2

    Mechanised Mod

  • Global Moderator
  • 24,941 posts

Glad you got it sorted and thanks for providing the solution SleepyDude  :thumbsup:


  • 0

#11
alexmurphy2020

alexmurphy2020

    New Member

  • Member
  • Pip
  • 4 posts

:thumbsup:

Thank you for your answer, the same problem was happening to me and I was searching for the answer in the internet and I got the answer here. I followed your words and my Open Office spreadsheet was solved. I am very happy that I could not stop myself from answering.


  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP