how to use complex excel formula in org

how to use complex excel formula in org

[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 

Re: how to use complex excel formula in org

[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 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" <oub@mat.ucm.es> 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

Re: how to use complex excel formula in org

[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
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

<row r="1" ...><c r="A1"...<f>FF</f><v>XX</v></c>...</row>

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

[Uwe Brauer]

[-- Attachment #1: Type: text/plain, Size: 1156 bytes --]

>>> "ESF" == Eric S Fraga <e.fraga@ucl.ac.uk> 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

> <row r="1" ...><c r="A1"...<f>FF</f><v>XX</v></c>...</row>

> 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.

[-- Attachment #2: smime.p7s --]
[-- Type: application/pkcs7-signature, Size: 5673 bytes --]