Open it in excel and do a file save as an OpenDoc spreadsheet. (*.ods) If this is a publicly accessible spreadsheet with no private data in it just email me the URL and I'll send it back.
There might also be online xls to ods converters as well Ted -----Original Message----- From: PLUG <plug-boun...@lists.pdxlinux.org> On Behalf Of Rich Shepard Sent: Saturday, May 4, 2024 8:26 AM To: plug@lists.pdxlinux.org Subject: [PLUG] Password protected .xlsx; cannot save as .ods A state agency provides a Microsoft .xlsx spreadsheet on a web site page. It's available to the public. When I tried to save it as a LO Calc spreadsheet (.ods) it told me it was password protected; a dialog box asks me to re-enter my (non-existent) password. It also will not allow me to export it as an .xls file. This is the first password-protected spreadsheet I've encountered. I don't understand why it's protected but the data should be in a database, not a spreadsheet, but this is another very common example of "if the only tool you have is Excel, everything looks like a spreadsheet." Any ideas on how to proceed? TIA, Rich
