search

MathNya / umya-spreadsheet

A pure rust library for reading and writing spreadsheet files
MIT License
239 stars 41 forks source link

[feature request] support for executing excel formuals #148

Open agentjill opened 7 months ago

agentjill commented 7 months ago

This feature request is requesting the following and the direction this project is expected is left for discussion.

  1. Detect whether a cell has a formula in it. Which I feel is easier to
  2. Inject custom formula in a cell by the user. At present this can be done by writing it as a string itself, which when opened by spreadsheet software then executes.
  3. Support can be provided for simpler excel formulas. so that the xml making up the spreadsheet containing cells with formula can be properly updated. For this I feel this option should be upto the user to decide if they want this to happen given the memory penalty.

Be kind enough to consider having discussion on this feature request so that an appropriate PR can be made for the same.

MathNya commented 7 months ago

@agentjill Thanks for the very exciting suggestion. I have been wanting to implement this feature someday.

Yes, it seems like it would be good to leave the recalculation of formulas to the user's discretion. I will consider the specific specifications as well.

agentjill commented 7 months ago

@MathNya can you add milestone for each of the points mentioned in original issue

MathNya commented 7 months ago

@agentjill Milestones created. Please point out any areas that are different from what you expected. https://github.com/MathNya/umya-spreadsheet/milestone/1