Every password in Excel can be removed by this. So its the person who needs to be carefull 😉īy the way do you know the macro, that can unlock every password-protected file? Try it. Yes they must, but they should not expect, that the sotware will do everything itself. In today’s world, people must take security seriously. Its understandable that some functions are different and sometimes you must learn how to do things. Its a free open open source for people who dont want (or need) to have payed version to create documents, tables and presentations. I guess that’s a valid opinion if LO never expects to be taken seriously as a business or enterprise tool. The other side of my question is that in the overall hierarchy of file attributes, why does the Excel spreadsheet file structure allow this security attribute to be changed without similar user action in another vendor’s spreadsheet program? For many users, the integrity of the file security setting is kind of a biggie.

My question is why can LO Calc, apparently by default, remove this attribute and allow an otherwise previously encrypted file to be saved as an un-encrypted file without my overtly removing that attribute? However as a user, I should be able to assume that if I have assigned a spreadsheet file the security-related attribute of “password protected”, then my action of later editing and saving the changed original with a different name would mean that the new file inherits the original file’s security attribute and will remain encrypted until I make an overt act to remove that attribute.

I agree if I were saving an unprotected spreadsheet in either Excel or Calc.

Libreoffice xls