microsoft / advanced-formula-environment

Create, edit, and reuse formulas in Excel
https://aka.ms/get-afe
MIT License
109 stars 11 forks source link

Please release the syntax highlighting for VS Code #76

Open santiago-afonso opened 4 months ago

santiago-afonso commented 4 months ago

Hello. First of all, congratulations on the work, it's a great leap forward for Excel.

However, for a large library I'd be better to work full screen in VS Code with all the bonuses it provides. And it seems that you're already working on enabling version control software (https://github.com/microsoft/advanced-formula-environment/issues/53). Given that the AFE is extremely similar to VS Code, it seems like it would represent a small effort for you to release a VS Code extension for writing Excel formulas.

Thanks!

santiago-afonso commented 1 month ago

(The purpose of this would be to edit Excel formula modules in VS Code, synced with a Github gist.)

santiago-afonso commented 2 weeks ago

Another possibility would be to outright add an "edit in VSCode" button, which would allow us to leverage Copilot or similar LLM-based aids.

jack-williams commented 2 weeks ago

Thanks for the feedback. We have had a couple of requests to provide the formula editing mode as a VS Code plugin.

I did start looking into it - I think it is slightly more work to release and publish than we can budget right now based on the frequency of requests. For now I'll mark this is as enhancement and revisit if we start working on it.

santiago-afonso commented 2 weeks ago

Thank you for taking the time to reply. Hope you get the resources to do this.