cescript / markdownformula

Use Excel-like formulas in markdown tables

Hey there 👋

I'm Bahri ABACI, a computer vision enthusiast and Ph.D. student.

📖 My research is all about making computers understand the world like we do, specifically on biometric verification, target tracking and object detection.

👨‍💻 I speak the language of computers fluently, specifically in C, C++, Python and Matlab.

📝 I also share my knowledge and experiences in the field on my blog, imlab.

🚀 I organized most of my public repositories under different organizations. Check out my organizations to see what I code!

📌 If you're into computer vision or just want to know more about it, give my blog a read and follow me!

markdownformula's Issues

Integers are being rounded

With default precision formatting (4) integers are being rounded as well:

I got this:

| Label | 2587408  |  [2587400](#B1) |       

I set precision to large number and it then worked for ints, however decimals have long decimal points now :).

Add formula in markdown narative

It would be fantastic if I could add formula outside of table such as:

The summation is [](#table1!C3)

<!-- table1 -->
| name           | formula         | values                 |
| -------------- | --------------- | ---------------------- |
| three          | -               | 3                      |
| eight          | -               | 8                      |
| summation      | #SUM(C1:C2)     | [11](#SUM(C1:C2))      |

This currently doesn't work for 2 reasons:

1. Reference need to be defined prior to the formula
2. Its outside of the table.

Allow separators in numbers

It would be great to allow specifying separators in numbers via comment directives:

<!-- table1 number_separator:,-->

Item	Number	Total
1	2,587,408.12
2	2,587,402
#SUM(B)		#ERROR!

Any option to fill down formulas?

Firstly, thanks a lot for this plugin, it's awesome. It has finally brought to life my dream of doing calculations inside markdown. Incredible!

Is there an option to fill down formulas? Or any tips on how to automate that?

Feature Request: automatic recalculations in table mode

Hi @cescript ,
thank you for your useful extension! I would like to have an extra feature, that is automatic formula calculations when table gets modified while in table mode. Do you think it's possible?

Enable formula calulation just for specific markdowns

Current formula syntax is unfortunate because [](#anchor) is used regularly in normal markdown documents. I was confused to see my configuration markdown of service I work on evaluated:

I propose one of the following:

1. Enable automatic formulas for markdown via markdown comment such as <-- markdown formula -->.
2. Use different syntax: [](#=...)

I think option 2 would be better as it will just work and = isn't something you have in anchor in general and it furthermore is Excel like and conveys specific meaning.

I know I can disable Calculate and update formulas on save but I don't want to, as I will certainly forget to update formulas here and there, while I can't forget to save.