emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* how to use complex excel formula in org
@ 2021-07-01 16:28 Uwe Brauer
  2021-07-01 17:02 ` Jonathan McHugh
  2021-07-02  8:15 ` Eric S Fraga
  0 siblings, 2 replies; 4+ messages in thread
From: Uwe Brauer @ 2021-07-01 16:28 UTC (permalink / raw)
  To: emacs-orgmode



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 



^ permalink raw reply	[flat|nested] 4+ messages in thread

* Re: how to use complex excel formula in org
  2021-07-01 16:28 how to use complex excel formula in org Uwe Brauer
@ 2021-07-01 17:02 ` Jonathan McHugh
  2021-07-02  8:15 ` Eric S Fraga
  1 sibling, 0 replies; 4+ messages in thread
From: Jonathan McHugh @ 2021-07-01 17:02 UTC (permalink / raw)
  To: Uwe Brauer, emacs-orgmode

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


^ permalink raw reply	[flat|nested] 4+ messages in thread

* Re: how to use complex excel formula in org
  2021-07-01 16:28 how to use complex excel formula in org Uwe Brauer
  2021-07-01 17:02 ` Jonathan McHugh
@ 2021-07-02  8:15 ` Eric S Fraga
  2021-07-02  8:40   ` Uwe Brauer
  1 sibling, 1 reply; 4+ messages in thread
From: Eric S Fraga @ 2021-07-02  8:15 UTC (permalink / raw)
  To: emacs-orgmode

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


^ permalink raw reply	[flat|nested] 4+ messages in thread

* Re: how to use complex excel formula in org
  2021-07-02  8:15 ` Eric S Fraga
@ 2021-07-02  8:40   ` Uwe Brauer
  0 siblings, 0 replies; 4+ messages in thread
From: Uwe Brauer @ 2021-07-02  8:40 UTC (permalink / raw)
  To: emacs-orgmode

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

^ permalink raw reply	[flat|nested] 4+ messages in thread

end of thread, other threads:[~2021-07-02  8:41 UTC | newest]

Thread overview: 4+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2021-07-01 16:28 how to use complex excel formula in org Uwe Brauer
2021-07-01 17:02 ` Jonathan McHugh
2021-07-02  8:15 ` Eric S Fraga
2021-07-02  8:40   ` Uwe Brauer

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).