Ask Your Question

How do I compare two spreadsheet files?

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

gnuarm1 gravatar image

updated 2017-12-10 17:14:07 +0200

erAck 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 close merge delete


Need an answer for this...

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

1 Answer

Sort by » oldest newest most voted

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

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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 1,961 times

Last updated: Jun 12