search

fernandreu / office-ribbonx-editor

An overhauled fork of the original Custom UI Editor for Microsoft Office, built with WPF
MIT License
516 stars 100 forks source link

password protected spreadsheet #158

Open PeterS1957 opened 3 years ago

PeterS1957 commented 3 years ago

Hi, Office RibbonX Editor is a great tool. Does it also somehow support password protected spreadsheets ? When I try to open a password protected excel it get an error message "error opening office document" What I want to achieve is a password protected excel with very limited backstage menu (e.g. no Tabinfo which would allow to change password setting). Can I provide the password to OfficeRibbonXEditor to open it ?

fernandreu commented 3 years ago

Hi PeterS1957, unfortunately not. In theory, it should be possible to support this, since the cryptography structure used by Office is publicly documented by Microsoft here. However, it's a rather complex structure, and there doesn't seem to be any readily available .NET library to work with it. This means I would need to implement this on my own, which would take me a considerable amount of time, given I am not familiar with cryptography at the level that this would require.

Due to that, so far I have preferred to work on other features instead. If there was a working C# library for this, I would give this a much higher priority. Obviously, if somebody wants to contribute to this project by adding this functionality themselves, I would be happy to review / accept the changes.

There are a few more details about this topic in #150.

PeterS1957 commented 3 years ago

Hi Fernando, i understand, thank you for explaining Peter

Von: Fernando Andreu @.> Gesendet: Dienstag, 04. Mai 2021 22:29 An: fernandreu/office-ribbonx-editor @.> Cc: PeterS1957 @.>; Author @.> Betreff: Re: [fernandreu/office-ribbonx-editor] password protected spreadsheet (#158)

Hi PeterS1957, unfortunately not. In theory, it should be possible to support this, since the cryptography structure used by Office is publicly documented by Microsoft https://docs.microsoft.com/en-us/openspecs/office_file_formats/ms-offcrypto/3c34d72a-1a61-4b52-a893-196f9157f083 here. However, it's a rather complex structure, and there doesn't seem to be any readily available .NET library to work with it. This means I would need to implement this on my own, which would take me a considerable amount of time, given I am not familiar with cryptography at the level that this would require. Due to that, so far I have preferred to work on other features instead. If there was a working C# library for this, I would give this a much higher priority. Obviously, if somebody wants to contribute to this project by adding this functionality themselves, I would be happy to review / accept the changes. There are a few more details about this topic in #150 https://github.com/fernandreu/office-ribbonx-editor/issues/150 . — You are receiving this because you authored the thread. Reply to this email directly, https://github.com/fernandreu/office-ribbonx-editor/issues/158#issuecomment-832221979 view it on GitHub, or https://github.com/notifications/unsubscribe-auth/AT6JCRZE63J36L73LMXLXADTMBKH3ANCNFSM44DAAPLQ unsubscribe. https://github.com/notifications/beacon/AT6JCRZMPA47IVFUYQQVDJ3TMBKH3A5CNFSM44DAAPL2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOGGNLGGY.gif