Modern spreadsheet editor, does it exist?

Question

Spreadsheets

I really want to find the right tool for my work, but I haven’t found it yet.
The specifics of my work is as follows:
Each of my projects is essentially two objects:
1. Data - the data.xls file (design data, technological data, program scripts, ...)
The file contains about 25 sheets, the format of all cells is text, some cells contain the code of various programs (large multiline).
Here are a couple of screenshots for an example:
2. Data handler - JS script (several files)
It first reads data.xls, forms an object model based on it and fills it with its own data.
Then, based on this object model, the following are created:
1. Program sources for PLC (Industrial logic controller)
2. Program sources for HMI SCADA
3. Operator's manual. (tex format for Latex)
So, actually, what I would like from a modern spreadsheet editor:
1. Normal human integration with some modern PL. After you know the power of the same JS, sitting down to VBA is just some kind of psychological trauma.
2. Save the file in a normal readable format, and not zipped xml with gibberish, so that you can normally screw up the GIT version control system.
3. So that you can create a tree of sheets, and not just a long tape, with a large number of sheets, it is not convenient.
4. Multiline cells.
5. Work offline. (often you have to work where there is no Internet)
I found a spreadsheet calculator for Linux.
Control interface like in VIM - it's just super! Lightweight - class!.
Save the file in a readable format - bravissimo!.
But unfortunately he can't use Russian letters and multi-line cells - sadness.
Of course, I understand that it’s probably impossible to find such a spreadsheet editor that would be able to do all four points I have indicated, but if there is one that can do points 2, 4, 5, I would be happy to the core!

Answer 1

spreadsheet.new , right?

Answer 2

The most interesting thing is that all 5 points are supported by your Excel
1 - As far as I know, excel above 2017 supports, in addition to VBA, also JS and something else. Although your distrust of the same VBA is most likely from his ignorance and inability to use it. For desktop and under windows, the thing is, you can connect anything.
2 - GIT will be able to easily change versions of your xls. Agreed differences will not show.
3 - you can generate a tree of sheets on a separate sheet. Well, yes, it will be necessary to work and write some code, and maybe a whole add-on.
4 - ... not clear what you mean?
5 is already offline.

Answer 3

Maybe this is already a "bell" to some own program that will link and store program sources and data for them in different ways (from paragraph 1) + generate in the form of TeX reports
. Then the rest of the points will practically disappear ...
It is clear that It also requires some mental breakdown, but...

Answer 4

Very narrow, extremely specific requirements. Either "eat a cactus" using Excel, LO Calc (or their analogues from other offices), or write it yourself :) Or go to the database :)

Answer 5

Are these narrow and specific requirements?
After all, any self-respecting product has a project tree, why is this inconvenient ribbon at the bottom in all modern spreadsheet editors?
Any self-respecting product allows normal use of GIT.
Again, in modern spreadsheet editors, these are some kind of terrible crutches, especially for those who want to track not only the tabular data themselves, but also built-in scripts.
These are normal, I would even say natural, human desires in 2018.
Why add or change a cell in an existing xls using the JS API, it's just a hell of an ambush!!!