Re: Oasis Open Formula Document Metadata

[Svante Schubert <svante.schubert@gmail.com>]

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:

https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#BITXOR

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,

Svante

Am 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