>>> "ESF" == Eric S Fraga <e.fr...@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