axlsx icon indicating copy to clipboard operation
axlsx copied to clipboard
verified publisher icon randym

formula1 dont work on add_data_validation

Open paulomcnally opened this issue 5 years ago • 1 comments

Screen Shot 2020-03-03 at 19 41 50

I create formula on Excel UI and work. But use formula1: '=INDIRECT(INDIRECT("C"&MID(CELL("address"),4,1))&"!A$2:A$30")' and dont work. The excel file generated is corrupted.

Screen Shot 2020-03-03 at 19 43 38

Any idea?

=INDIRECT(INDIRECT("C"&MID(CELL("address"),4,1))&"!A$2:A$30")

paulomcnally avatar Mar 04 '20 01:03 paulomcnally

Hola Paulo, lograste agregar la formula en formula1 ?

vsolari avatar Jun 24 '22 21:06 vsolari