[GH-ISSUE #334] Assign the result of a formula to a variable #270

New issue

Closed

opened 2026-05-05 12:03:48 -06:00 by gitea-mirror · 2 comments

gitea-mirror commented

2026-05-05 12:03:48 -06:00

Owner

Originally created by @sapomuyverde on GitHub (May 20, 2021).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/334

Originally assigned to: @jmcnamara on GitHub.

It is possible to assign the result of a formula to a variable and then use that variable, for example: I do something like this:

worksheet_write_formula(worksheet, lin, 8, "=SUM(I5:I10), numberRightTotal) --> (total sales, to say)
Then make use of the "variable", without repeating the formula, something like this:
worksheet_write_number(worksheet, lin+10, 8, total sales, numberRight )

Any idea how to solve in this way.

Regards,
Javier

Originally created by @sapomuyverde on GitHub (May 20, 2021). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/334 Originally assigned to: @jmcnamara on GitHub. It is possible to assign the result of a formula to a variable and then use that variable, for example: I do something like this: worksheet_write_formula(worksheet, lin, 8, "=SUM(I5:I10), numberRightTotal) --> (total sales, to say) Then make use of the "variable", without repeating the formula, something like this: worksheet_write_number(worksheet, lin+10, 8, total sales, numberRight ) Any idea how to solve in this way. Regards, Javier

gitea-mirror closed this issue

2026-05-05 12:03:50 -06:00

gitea-mirror commented

2026-05-05 12:03:51 -06:00

Author

Owner

@jmcnamara commented on GitHub (May 20, 2021):

Unfortunately that isn't possible. Libxlsxwriter doesn't evaluate the formula in any way so there isn't any results to return/store.

@jmcnamara commented on GitHub (May 20, 2021): Unfortunately that isn't possible. Libxlsxwriter doesn't evaluate the formula in any way so there isn't any results to return/store.

gitea-mirror commented

2026-05-05 12:03:53 -06:00

Author

Owner

@sapomuyverde commented on GitHub (May 21, 2021):

Thank you for your answer and for your time.

@sapomuyverde commented on GitHub (May 21, 2021): Thank you for your answer and for your time.