Create XLSX with controls from developer mode #2826

New Issue

bekverdyan · 2022-11-13T21:34:55Z

bekverdyan commented

2022-11-13 21:34:55 +00:00

Is it possible to create an excell file with some Form Controlls and ActiveX Controls inside?
Can I lock cells? (found an #2518)
Is one of this features are available in Pro version?

Is it possible to create an excell file with some `Form Controlls` and `ActiveX Controls` inside? Can I lock cells? (found an #2518) Is one of this features are available in `Pro` version?

sheetjs commented

2022-11-13 22:00:40 +00:00

Info current as of today (2022-11-13).

Currently supported in the Community Edition:

Creating files with ActiveX controls

Currently supported in "Pro Basic":

Locking cells

Currently supported in "Pro Image":

Form controls

.

The featureset breaks down like this:

"ActiveX Controls" are stored in the VBA blob, so it is possible to create a file with ActiveX controls, capture the VBA blob, and add it to new files. https://docs.sheetjs.com/docs/csf/features/#round-tripping-macro-enabled-files discusses in more detail.

"Locking cells" is a cell styling property. We do plan on introducing cell styles at some point, but the current focus is data interchange and related features like number formatting.

"Form controls" are different. They have a separate XML representation.

Info current as of today (2022-11-13). Currently supported in the Community Edition: - Creating files with ActiveX controls Currently supported in "Pro Basic": - Locking cells Currently supported in "Pro Image": - Form controls . The featureset breaks down like this: "ActiveX Controls" are stored in the VBA blob, so it is possible to create a file with ActiveX controls, capture the VBA blob, and add it to new files. https://docs.sheetjs.com/docs/csf/features/#round-tripping-macro-enabled-files discusses in more detail. "Locking cells" is a cell styling property. We do plan on introducing cell styles at some point, but the current focus is data interchange and related features like number formatting. "Form controls" are different. They have a separate XML representation.

🎉 1

sheetjs closed this issue

2022-11-13 22:00:40 +00:00

Sign in to join this conversation.