Ask Your Question

I want to compare sheets for differencese

asked 2016-09-01 19:52:26 +0200

Budd gravatar image

I have two copies of the same information, somewhere there is an inconsistency, how can I compare them and highlight the item or items on both sheets so I can determine which is correct?

Thank you for helping me, I hope.. Budd

edit retag flag offensive close merge delete



2 answers concern Calc (spreadsheet module) because you mention sheets. But you have tagged Impress. Is it this ?


pierre-yves samyn gravatar imagepierre-yves samyn ( 2016-09-03 08:27:26 +0200 )edit

Hi it should have been Calc, Sorry! Budd

Budd gravatar imageBudd ( 2016-09-12 19:22:05 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2016-09-01 21:40:42 +0200

erAck gravatar image

Copy each sheet to a new document (context menu on sheet tab, "Move or Copy Sheet ...", Action Copy, Location To document, new document) and save each new document, e.g. name1.ods and name2.ods

In name2.ods menu Edit - Compare Document... pick name1.ods and you're presented with a list of changes, you can travel around with the dialog and accept or reject each change. Note that changes are "from 1 to 2" if you proceed in this order.

When done you can copy the data over to the original sheet via clipboard. To copy or move the entire sheet like in the steps before you first have to go to menu Edit - Track Changes and disable Record Changes because otherwise the Copy/Move sheet option is disabled.

edit flag offensive delete link more


Hi it should have been Calc, this is my first time using help. I was finally able to accomplish my comparison, but my sheets had passwords and I saw somewhere else to try removing the password and rename the name 2 sheet, I did and after completing my project saved that sheet to its original name and used the same password. worked great.. Budd Thanks

Budd gravatar imageBudd ( 2016-09-12 19:21:25 +0200 )edit

answered 2016-09-03 03:26:32 +0200

mark_t gravatar image

You can use conditional formatting to highlight cells that are not identical between the two sheets.

Select cell range on the first sheet. Then Format, Conditional Formatting, Condition... Cell value is, not equal to, and in the empty box select the first cell of the range on the other sheet. Remove the $ from the cell reference of the other sheet in the box. Choose New Style from the drop down box and set a highlight color for cell background.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-09-01 19:52:26 +0200

Seen: 8,332 times

Last updated: Sep 03 '16