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

how to use complex excel formula in org

2021-07-01 Thread Uwe Brauer
Hi I currently have to collaborate with an excel file that contains quite a bit of complex formula. I cannot simply import the file via xlsx-->csv-->org Since csv does no know about excel formulas. Does anybody know about a tool a trick to use that excel formula. Regards Uwe Brauer