I have two large spreadsheets with similar data and structure but with small and undetermined differences.
Is there a ready function in Calc or some other tool which will locate and show these differences.
I have found one answer that takes care of the field values (which is what I wanted).
I converted the files to CSV format and used WinMerge to compare the two.
I would be interested to know if there are alternatives within the LibreOffice family.
WinMerge doesn’t have any special function for CSV files, though, it just shows them as plain text, right?