Re: how to use complex excel formula in org

[Uwe Brauer]

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

smime.p7s
Description: S/MIME cryptographic signature