On Sat, 4 May 2024, King Beowulf wrote:
From one of the many Libreofice help forums (edited for details and clarity):
Ed,
I hadn't yet gone to LO to see if there was a solution.
To save-as xlsx to ods, and the "retype" password box pops up with "Hash
incompatible" message:
Open Excel spreadsheet in Calc, Then File -> Save As to save as a new ods
file. When the "retype" window pops up, for each protected sheet do:
click on “retype”
clear “New password must match the original password” checkbox
type anything, e.g., “a” as both password and confirm
(Note: remove password from from this protected item does not work)
The ods is now saved with new sheet password ("a" in above example). Now, in
the newly saved and open ods file, for each protected sheet (padlock next to
sheet name), right-click and choose “protect”, enter the password (“a” in the
above example). Your sheets are now not protected and you can carry on as
normal.
Now I don't need to. :-)
Many thanks,
Rich
