search

ONLYOFFICE / DesktopEditors

An office suite that combines text, spreadsheet and presentation editors allowing to create, view and edit local documents
https://www.onlyoffice.com
Other
2.64k stars 311 forks source link

Add new formulas for the Spreadsheet Editor #1582

Closed eSkry closed 4 weeks ago

eSkry commented 4 weeks ago

This issue is unique.

Your idea.

I suggest adding important functions for the table editor like:

  1. WEBSERVICE - The function allows you to make HTTP requests and receive the contents of the response;
  2. FILTERXML - Allows you to get values from XML by specifying xpath;
  3. FILTERJSON - Similar to FILTERXML for JSON only.
rsnegirev commented 4 weeks ago

Hi @eSkry

Can you please create separate issues for FILTERXML and FILTERJSON?

And about last one formula (FILTERJSON). Where did you find it? I don't see any MS or Google documentation about it.

eSkry commented 4 weeks ago

Hi @rsnegirev

Sure, I will create separate issues.

About FILTERJSON: There is no FILTERJSON formula in MS Excel. However, many APIs now return JSON rather than XML. It would be good to support JSON as well.

eSkry commented 4 weeks ago

Links: WEBSERVICE FILTERXML FILTERJSON

rsnegirev commented 4 weeks ago

Great thanks. I'll discuss about that with devs and text in every issue.

Rita-Bubnova commented 4 weeks ago

I close this issue. Feel free to comment or reopen it if you got further questions.