randym / axlsx

xlsx generation with charts, images, automated column width, customizable styles and full schema validation. Axlsx excels at helping you generate beautiful Office Open XML Spreadsheet documents without having to understand the entire ECMA specification. Check out the README for some examples of how easy it is. Best of all, you can validate your xlsx file before serialization so you know for sure that anything generated is going to load on your client's machine.
MIT License
2.62k stars 695 forks source link

Some formulas do not work in Axlsx #641

Open AlexCs389 opened 5 years ago

AlexCs389 commented 5 years ago

I am adding this formula to my .xlsx:

=BUSCARV(G2, 'Categorias'!A$2:C$3, 3, 0)

I add it this way to my worksheet:

sheet.add_row ["=BUSCARV(G2, 'Categorias'!A$2:C$3, 3, 0)"]

when I check my .xlsx in the cell I have this error #NOMBRE? and in the entry line I have this =buscarv(F3,B2:C2,2,0)

I understand that this error #NOMBRE? is because the formula is misspelled but I cannot understand why the formula changes when you added it to the cell

How could I solve this?