How can I remove duplicate table rows in Writer, without going through Calc and losing formatting as a result?
Use case: preparing a file that contains strings extracted from CMS that will be sent to a translator for cost estimation. The CMS export contains lots of duplicates. Reasons why deduplication cannot be handled at an earlier step are numerous, serious, valid, and out of this question’s scope.
A handmade workaround: split a column (A) and add a serial number, copy the table data to Calc, in Calc add a new column (B) and copy the serial number of A, “go through Calc”, delete the serial numbers for duplicate rows in the column B, sort by A, copy B, paste in Writer in column A, delete rows without serial number (here a macro could help), delete column A.
Add Answer is reserved for solutions. Please, click edit below your question if you want to add more information.