export to excel with checkbox
I have a file that uses several check boxes. When I export it to Excel it renders as 'true' and 'false'.
Is there a way to use checkboxes that is Number and Excel friendly?
I have a file that uses several check boxes. When I export it to Excel it renders as 'true' and 'false'.
Is there a way to use checkboxes that is Number and Excel friendly?
Checkboxes don't export. Simple as that. If you want to do something more export-robust, ask the user to type an X to indicate a selection, or ask for a Y/N response. Then test for these characters in your expression.
Jerry
export to excel with checkbox