Re: how to use complex excel formula in org

2021-07-02 Thread Uwe Brauer
>>> "ESF" == Eric S Fraga writes: > On Thursday, 1 Jul 2021 at 18:28, Uwe Brauer wrote: >> I currently have to collaborate with an excel file that contains quite a >> bit of complex formula. > Do you need bi-directional collaboration? If you do, I doubt there's a > solution out there. Collab

Re: how to use complex excel formula in org

2021-07-02 Thread Eric S Fraga
On Thursday, 1 Jul 2021 at 18:28, Uwe Brauer wrote: > I currently have to collaborate with an excel file that contains quite a > bit of complex formula. Do you need bi-directional collaboration? If you do, I doubt there's a solution out there. Collaboration with people using MS based tools is

Re: how to use complex excel formula in org

2021-07-01 Thread Jonathan McHugh
Just an idea (especially given I havent touched Excel formulae for a v. long time): Have you considered using (G)awk? It could be possible to build up a list of arrays containing data and formulae and then perform as result in the end block. It could get onerous to do and may be hackish/bespoke