Ask Your Question

How do I compare two spreadsheet files? [closed]

asked 2016-08-01 17:16:49 +0100

gnuarm1 gravatar image

updated 2020-08-02 11:29:20 +0100

Alex Kemp gravatar image

I have a series of files which are essentially forms. Each one has different info entered while some of it remains the same. I'd like to be able to compare any two of these files to see what info or formulas are different.

I found the "Compare Document..." item in the Edit menu, but doesn't seem to work. I select a file to compare the current spreadsheet to and it brings up a dialog box, "Accept or Reject Changes" which is empty. I tried turning on "Changes, Record", make changes and repeat the "Compare Document..." function and it warns me that it is leaving recording mode. If I say ok it brings up the same empty "Accept or Reject Changes" dialog box. How is this command supposed to work?

Is there an easier way to see the changes from one copy of this form to another?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-02 11:29:38.338443


Need an answer for this...

Ricky Lall gravatar imageRicky Lall ( 2017-02-15 06:39:35 +0100 )edit

Don't know why this was closed. The "answer" says it works, but it doesn't work for me. I guess there's no one here to help figure out why.

gnuarm1 gravatar imagegnuarm1 ( 2020-09-27 19:27:08 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-06-12 16:10:04 +0100

MostlyCalc gravatar image

When I have used this function, the dialog box contains a list of differences with a basic description of their cell location and the differing values. Clicking an entry in the list highlights the cell in the spreadsheet where the difference occurred.

To use it:

  • Open Document B
  • Click Edit > Compare Document
  • Choose Document A
  • The resulting dialog should list the differences
edit flag offensive delete link more


This works too easy (LO 5.4)

khrysRo gravatar imagekhrysRo ( 2018-06-13 20:12:20 +0100 )edit

Question Tools

1 follower


Asked: 2016-08-01 17:16:49 +0100

Seen: 12,410 times

Last updated: Jun 12 '18