Document workflow using LibreOffice Calc to process the generated CSV file

[gitname]

Here's my workflow for using LibreOffice Calc to process the CSV file generated by this script (i.e. dupeguru-post-processor):

1. Open the CSV file in LibreOffice Calc
2. Create an empty column between the "File" and "Folder" columns (i.e. between columns A and B, respectively)
   • Right-click the B letter label area above the topmost cell in the "Folder" column and select Insert Columns Before
3. In the newly-inserted column (i.e. the new column B), populate the first cell (i.e. cell B1) with the text: Link
4. In that same column, populate the second cell (i.e. cell B2) with the formula: =HYPERLINK(C2, "🔗")
   • This will create a hyperlink to the folder containing the file to which this row refers
5. Apply an analogous formula to the remaining cells in that column
   • Select the existing hyperlink (i.e. cell B2)
   • New: Double-click on the small, resizing dot at the bottom right of the cell selector; as doing so will apply an analogous formula to each cell below it (it will do so on all rows where the previous column is not empty)
   • Old: Press Ctrl+Shift+End to select the lowest/rightest populated cell on the sheet
   • Press Shift+⬅️(Left arrow) repeatedly (e.g. 3 times) until only the Link column is selected
   • Press Ctrl+D to "Duplicate" the formula (i.e. apply an analogous formula) to all selected cells
6. Ctrl+click any hyperlink to follow it (i.e. to open that folder in the OS file manager; e.g. Windows Explorer)

I'm creating this ticket to represent the task of adding this documentation to the project, itself. I don't yet know how I will do that (e.g. add it to the main README.md file vs. add it elsewhere).

[gitname]

I just learned that, if the value of a cell has the format, file://{file_path} (or file:///{file_path}), LibreOffice Calc will automatically treat it like a link (i.e. it will open it if the user Ctrl+clicks it).

I am considering updating the Python script to include a column that has the folder in that format. That would make most of the steps listed above, unnecessary.

Edit: This file:// approach does not seem to work when the path contains whitespace (e.g. C:\Temp\One Two\Three) or underscores. 😞