umya-spreadsheet icon indicating copy to clipboard operation
umya-spreadsheet copied to clipboard
verified publisher icon MathNya

[feature request] support for executing excel formuals

Open agentjill opened this issue 2 years ago • 3 comments

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.

agentjill avatar Nov 25 '23 20:11 agentjill

@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.

MathNya avatar Nov 28 '23 00:11 MathNya

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

agentjill avatar Nov 28 '23 01:11 agentjill

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

MathNya avatar Nov 28 '23 08:11 MathNya