search

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

Problem with formular converted to downcase and returning #NAME? #623

Closed gnumarcelo closed 5 years ago

gnumarcelo commented 5 years ago

Hi guys,

I am adding a row with a formula in it like: sheet.add_row ['name', "=VLOOKUP(G2,$sheet2.A:B,2,0)"]

However, when I open the document either in Excel or Libre Office, it shows the text #NAME? and formula content with the following content: =VLOOKUP(G2,$sheet2.a:b,2,0)

Notice that A:B in the formula changed to downcase a:b and this is causing my formula to not work. Is this a bug or I am missing something when adding a row?

Thank you!

gnumarcelo commented 5 years ago

Just discovered what happend, wrong formula syntax:

=VLOOKUP(G2,sheet2!A:B,2,0) <-- notice the !

I'll close this ticket.