search

ggreen86 / XLSX-Workbook-Class

VFP Class to Create an XLSX Workbook without Excel Automation or Installed
46 stars 16 forks source link

Protection #49

Closed lscheffler closed 3 years ago

lscheffler commented 3 years ago

There are methods to protect / unprotect objects (workbook / sheet.
This sets a bunch of props, I see stuff like AlgorithmName Does this encrypt / decrypt or is this just a setting for Excel to not touch the cells? IOW, cann I alter the cells ignoring the protection?

ggreen86 commented 3 years ago

There is not actually any encryption going on to the cell values. This class actually bypasses any that Excel would enforce since you have direct access to the cells via the methods. The formatting of the cells is what controls the protection setting; the sheet setting controls whether it is enforced by Excel (the class ignores the setting). If you reassign the cell formatting, it could alter the protection setting of the cell. The password is what is encrypted into the workbook; not the actual cell values.

From: Lutz Scheffler @.> Sent: Friday, May 14, 2021 12:17 PM To: ggreen86/XLSX-Workbook-Class @.> Cc: Subscribed @.***> Subject: [ggreen86/XLSX-Workbook-Class] Protection (#49)

There are methods to protect / unprotect objects (workbook / sheet. This sets a bunch of props, I see stuff like AlgorithmName Does this encrypt / decrypt or is this just a setting for Excel to not touch the cells? IOW, cann I alter the cells ignoring the protection?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/49, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33KIU427WI7ZZHOB7CLTNVEIRANCNFSM444WP4YQ.

lscheffler commented 3 years ago

ok. So I can just ignore this. It's just about gathering some data from those cells (I'm in my general manager and there is a unprotect step.)