question: write_formula Inserts Incorrect Table References

jmcnamara / XlsxWriter

A Python module for creating Excel XLSX files.

https://xlsxwriter.readthedocs.io

BSD 2-Clause "Simplified" License

3.61k stars 629 forks source link

question: write_formula Inserts Incorrect Table References #1080

Closed areqq closed 2 months ago

areqq commented 2 months ago

Question

When using write_formula to insert a formula with table references, the formula "=THours[client]" is being changed to =THours[@client] in the Excel file. I need the formula to remain as =THours[client] because I want to reference the entire column in another sheet. What I did wrong? If I manually edit the file and remove the @ from the formula, it works correctly and references the entire column as intended.

jmcnamara commented 2 months ago

Closing this as a Question. Can you open a Bug Report and fill in the required data and reproducible sample.