By: Fred M
Checkbox in XLSX
I need to check/uncheck checkboxes (Form Control) in some XLSX templates I received from providers (I can't change them to ActiveX Control then).
Is there a way to do this ?
Re: Checkbox in XLSX
There is no OpenTBS feature that can do it automatically. But since you understand how are stored Form Controls in an XLSX, you can manage it with code.
In XLSX, the properties of the Form Controls are stored in sub-files such as « xl/ctrlProps/ctrlProp1.xml ».
There is one sub-file for each control in the workbook.
The checked state is done with the attribute « checked="Checked" ».
So your have to load the sub-file corresponding to your checkbox and edit this attribute.