Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
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

  • Moderator
  • 23,784 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

  • Moderator
  • 23,784 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

  • Moderator
  • 23,784 posts

You are welcome  :)


  • 0

#7
SleepyDude

SleepyDude

    Trusted Helper

  • Malware Removal
  • 4,854 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,854 posts

:thumbsup: 


  • 0

#10
phillpower2

phillpower2

    Mechanised Mod

  • Moderator
  • 23,784 posts

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


  • 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