Cloud Computing Insider Awards 2022: Vote for ONLYOFFICE
Vote for ONLYOFFICE

Formula or Function

I want to know how to implement this Google Sheets formula in Onlyoffice

=ArrayFormula( TRIM( SUBSTITUTE( SUBSTITUTE( SPLIT( CONCATENATE( REPT( ImportHTML(“https://www.finviz.com/quote.ashx?t="SPY,"table”,9) & CHAR( 9 ) , ISNUMBER( MATCH( ( {1,2,3,4,5,6,7,8,9,10,11,12} + ( 12 * {0;1;2;3;4;5;6;7;8;9;10;11} ) ) , { 24;36;48;60;72;132;140;144} , 0 ) ) ) ) , CHAR( 9 ) ) , “*” , “” ) , “%” , “” ) ) + 0 )

Hello @caymann
As far as I understand, you are using ImportHTML feature in your formula. ONLYOFFICE doesn’t have this feature at the moment. But we are working on it already (internal suggestion number - 56900). I have added your request and I will notify you when we have something to share about this feature.
Meanwhile, you can take a look at this import mechanism Get data from TXT/CSV file - ONLYOFFICE
I’m not sure that it can help you with your scenario, but probably it will be useful.

Sorry for inconvenience.

Thank you. I am seeking replacement of google docs/sheets with onlyoffice. Without a direct formula or functions equivalency, onlyoffice is not much use. The Get data from TXT/CSV is not much help. We are looking to acquire dynamic data. The TXT and CSV idea is not fit here

I understand your desired scenario, I will update this post when we get any news about ImportHTML feature release.
Sorry for inconvenience.