Hello Team,
I'm submitting this request on behalf of our customer Hays
Conditional logic / hidden cells
- Their excel sheet shows or hides follow-up questions based on an answer (e.g., pick “Yes” → new rows appear right under it).
- This is usually built with VBA/macros, grouping/outlines, filters, or formulas that reference other cells.
- Our mapping tool read the sheet as raw data only. They don’t execute macros, respect grouping, or “expand” hidden rows. Result: those conditional questions never appear to the importer, so the logic seems “lost.”
Content control (protected cells) / developer / macros not recognized
- Content controls (Developer tab), protected/locked cells, and macros (VBA) are Excel UI features, not plain data.
- Importers typically ignore or block them for security and compatibility. Macros aren’t executed; locked cells can prevent reads/writes; content controls aren’t parsed as fields.
Thank you!
Sathish
