Am Mi., 8. Dez. 2021 um 13:38ÂUhr schrieb martin dawson <u1356770@gmail.com>:
> First of all, there is a simple HTML reference to each function
Thanks for the links.
Unfortunately this html link isn't separatedÂout into a separateÂpage. so we can't do an API request to it because it would contain the other function data below it. Google sheets separatesÂinto separateÂpages like so:Âhttps://support.google.com/docs/answer/3093669?hl=en-GB
This allows them to do API requests to each function page and display it in their sidebar for google sheets like so:
However, we would still need a machine readable format (XML or JSON etc) because we also need to generate the helper below each cell like this:
Which we cannot do with just API calls to a web page.
> When I look into the content.xml of the ODT, I do not see any RDF metadata, but some tagging by ODF style names like Value_20_Type, see below
Sorry I cannot find this `content.xml` file. Could you please send me the link for it?
But yes I can absolutely generate JSON from XML if the data is there in the XML.
> What do others use as separated function documentations? Could you share some links?Â
I think Microsoft Excel & Google Sheets generate the documentation from their built in functions into a JSON file:
https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-json-autogeneration
https://developers.google.com/apps-script/guides/sheets/functions
Not sure about other spreadsheets.On Wed, Dec 8, 2021 at 12:08 PM Svante Schubert <svante.schubert@gmail.com> wrote:Hello Martin,the best place to state such a question would be the office-comment list, but as you have already written us and I do like your idea and others might have the same problem, I put the ODF TC list on CC (and fixed two outdated emails).There will be an ODF TC editors call later today, where I bring this topic up, to see what we have.First of all, there is a simple HTML reference to each function:When I look into the content.xml of the ODT, I do not see any RDF metadata, but some tagging by ODF style names like Value_20_Type, see below<text:p text:style-name="Text_20_body"><text:span text:style-name="Label">Returns:</text:span><text:span text:style-name="Value_20_Type"> Number</text:span></text:p>Perhaps some JSON might be generated from this? If you like to give it a try, you might base your work on ODFDOM of the ODF Toolkit:Âhttps://tdf.github.io/odftoolkit/What do others use as separated function documentations? Could you share some links?Â(You might not write to the official ODF TC list, but my reply would be seen there).Hope I could be of help,SvanteAm Mi., 8. Dez. 2021 um 12:54ÂUhr schrieb martin dawson <u1356770@gmail.com>:Hello,Sorry to tag multiple people in this email but I am reading this Oasis document here about the specifications for formulas:Âhttps://docs.oasis-open.org/office/OpenDocument/v1.3/OpenDocument-v1.3-part4-formula
Is it possible to get each of the separateÂdocumented functions such as `SUM()` in a machine readable format such as an XML or JSON file that contains theÂSummary, Syntax, Notes etc?
I'm looking to add documentation to my spreadsheet formulas on my website (like Excel & Google Sheets has) and would like to use the same descriptions as in this document.I found this link which is for XML files:Âhttps://docs.oasis-open.org/office/OpenDocument/v1.3/os/schemas/But I can't seem to find any functions documentation metadata in here.Also, I think the copyright allows me to do this as long as I creditÂOpen Oasis with the copyright notice for each function documentation?
Thanks
