Re: how to use complex excel formula in org
>>> "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. Collaboration with people using MS based tools is > challenging (being polite here). Xlsx-->org would be enough for the moment. >> I cannot simply import the file via xlsx-->csv-->org > xlsx is XML based so you could, in principle, read the information > directly from the xl/worksheets/sheetN.xml component in the file (the > xlsx file itself should be a zip archive). The format will consist of > entries such as > FFXX... > where FF would be the formula (and XX the value of that formula) for > entry in A1. Lots of detail omitted in the above, mind you. Right, this is basically what I am trying to do now. A manual approach of sorts. I just realized that there are operations I am not sure how to do them in org. I'll send a different post about it. smime.p7s Description: S/MIME cryptographic signature
Re: how to use complex excel formula in org
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 challenging (being polite here). > I cannot simply import the file via xlsx-->csv-->org xlsx is XML based so you could, in principle, read the information directly from the xl/worksheets/sheetN.xml component in the file (the xlsx file itself should be a zip archive). The format will consist of entries such as FFXX... where FF would be the formula (and XX the value of that formula) for entry in A1. Lots of detail omitted in the above, mind you. -- : Eric S Fraga via Emacs 28.0.50, Org release_9.4.6-577-gf76d4d : Latest paper written in org: https://arxiv.org/abs/2106.05096
Re: how to use complex excel formula in org
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 but Awk can be quite satisfying a tool. Im sure somebody is sitting on a more correct approach however. Jonathan McHugh indieterminacy@libre.brussels July 1, 2021 6:31 PM, "Uwe Brauer" wrote: > 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
how to use complex excel formula in org
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