From time to time when I need to do some complex replacements in Excel, I work with the unzipped Excel file on the sheet and workbook XML files (Excel doesn’t support regex replacement).
The usual process is to rename the XLSX file, unpack it, edit, pack it and rename it again.
It would be nice, if I could use the context menu of DOpus to unzip the file and zip it again with the XLSX extension. So I added the extension to the ZIP file list … which achieved what I wanted to do BUT when I now double click the file, it automatically opens the archive.
Is there a way to avoid this and get the behaviour that DOpus recognises the XLSX files as archives but also allows that a double-click is still handled by Excel?
Create a new file type for XLSX extension and set Commands/Events/Left Double-Click to use Excel.
Then XLSX will both belong to Archives group and will exist as separate (individual) file type.
What is set for the latter has priority over that what is set for former.
You can create a hard link with a .zip extension pointing to the .xl* file, then double-click to open and edit the contained files. Once finished, delete the hard link.
sorry for the long delay … thanks for your suggestion. It works like a charm
Btw, the XLSX file type was already registered and the proper command to launch Excel with the file on a double click is
"C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" {filepath$}
I ran into the same Excel issue and fixed it by customizing the double-click action under File Types in Directory Opus—set it to open Excel directly, then let the zip treatment be just for right-click or viewer-specific actions. I was working with a set of Excel templates and needed quick access without breaking the file association every time. This tweak kept things smooth.
