Ask Your Question

Revision history [back]

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.