A
A
Andrey Akimov2018-02-28 12:08:23
HTML
Andrey Akimov, 2018-02-28 12:08:23

Is there a markup language for web pages in the form of calculation tables?

The HTML markup language was originally created as a means of displaying structured and formatted text on websites. With the release of HTML5, the possibilities have expanded significantly, but still, the essence remains the same - an html page is still a "sheet" of formatted text. There is an analogy with applied computer programs for typographic text editing, for example, MS Word.
Does "MS Excel" exist for the Internet? I do not mean just the ability to insert a table into a web document, and the once-unpopular tabular layout of pages. It also does not include modern means of presenting data such as CSS Grid. The essence of the idea is that a web page can be a document at the root with a tabular structure, with an unlimited number of cells in width and length. The contents of the cells can be determined by formulas that calculate values ​​based on data from other cells in this document, from the cells of another document (accessible via a data transfer protocol), or other sources.
I tried to find an existing web page markup language in the form of calculation tables, but did not find it. Perhaps such technology simply does not exist, as unnecessary? I assume that something similar can be implemented using the XML syntax. In this case, you need to do a lot of work: firstly, you need to develop the markup language for computing web tables, and secondly, you need to write a browser capable of displaying documents of this type. Or when the idea becomes a standard, then modern browsers will implement support for documents of this type.
Addition! Task example.
Create a text file in the calculation table markup language, which, when opened in a browser, shows the multiplication table. Moreover, the values ​​of the first row and the first column (numbers 1..9) are explicitly set, and the values ​​of the intersection cells are calculated on the fly. That is, initially in the markup file, the result of the calculations is not set, but only the formula is set. How would you implement this idea, for example, in XML?

Answer the question

In order to leave comments, you need to log in

4 answer(s)
O
Oleg, 2018-02-28
@402d

look inside xlsx there xml .
Browsers are already eating gigs of RAM.
if a spreadsheet calculator is screwed in there ;(
but the main thing is where the browser will save the edited document?
poi.apache.org - the best in this topic

S
Saboteur, 2018-02-28
@saboteur_kiev

google documents already does this. But this is not just a colossal work, it is a little more.
You kind of have to understand that formula support is NOT a markup language, it's already a programming language.
And how would you need to write a browser capable of displaying documents of this type, if ALREADY there is a program (excel, openoffice tables) that can display documents of this type? You must understand that this will not take off.

A
Andrey Akimov, 2018-02-28
@Ostan

Somehow people respond and comment. The answers are as follows:
The correct answers to my question could be:
The correct answer is 2. Everything!

V
Varlam, 2018-03-01
Erofeich @warsand

Andrey Akimov , if you take a toy like Blockly more seriously , then the tabular version will not be so relevant. They are even somewhat similar, and since I feel sorry for the children of my childhood to spoil with Anglicisms, I consider it more acceptable to teach them logic in their native language. The block version can also be improved for adults. Remove the extra thickness of the blocks, increase their functionality, and you won’t have to strain your memory to open / close tags. At one time I forgot about this resource, but thanks to you - I remembered.
- Thank you!.. Of course, it is necessary to invent something new; experiment, make mistakes, remake, make mistakes again, all this is the way to self-improvement... (!)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question