My text KeenWrite supports R Markdown. I wrote a simple function to convert CSV data into a Markdown table[1] along with a tutorial demonstrating usage[2]. This allows users to keep the data separate from the document.
Having the ability to apply spreadsheet functions as per EqualTo is brilliant.
Feel free to reach out (email in my profile) if you'd like to discuss how Sheet Markdown could be added to KeenWrite. Assuming you're displaying the preview using some sort of modern HTML render with canvas support, it should be pretty easy to do.
KeenWrite uses the Java-based FlyingSaucer library for rendering HTML in the preview. Moreover, KeenWrite exports Markdown as XHTML, which ConTeXt imports for typesetting into PDF. While Sheet Markdown would be a fun integration, it would have to execute prior to displaying (i.e., not use JavaScript for in-browser rendering, but use Java to preprocess the Markdown tables before inserting into the XHTML).
Thanks for the explanation. I think integrating Sheet Markup with that process would be challenging, since (as I understand it) XHTML doesn't support canvas.
As far as I know, there are no other editors or word processors that offer interpolated variables at a keystroke[1], the primary reason I developed the software. A similar editor to KeenWrite is Jupyter Notebooks, which looks like it has an Emacs extension[2]. I think of KeenWrite as being meant for long-form prose with a little math and stats thrown in (e.g., sci-fi novels); Jupyter Notebooks is meant for math and stats with short-form prose thrown in.
Having the ability to apply spreadsheet functions as per EqualTo is brilliant.
[1]: https://github.com/DaveJarvis/KeenWrite/blob/main/R/csv.R
[2]: https://youtu.be/XSbTF3E5p7Q?list=PLB-WIt1cZYLm1MMx2FBG9KWzP...