From: Daniele Nicolodi <daniele@grinta.net> To: emacs-orgmode@gnu.org Subject: Re: [PATCH] org-table: Add mode flag to enable Calc units simplification mode Date: Tue, 20 Oct 2020 16:32:16 +0200 Message-ID: <b5f1933a-3a7f-be80-04a2-916427dda169@grinta.net> (raw) In-Reply-To: <87lfg1ught.fsf@disroot.org> On 20/10/2020 16:19, Eric S Fraga wrote: > Hello again, > > Following up on myself. I'm seeing some strange behaviour although unit > calculations are working nicely. For instance, this table: > > #+begin_src org > | stream | a | b | c | total | x_a | x_b | x_c | > | | <l> | <l> | <l> | <l> | <r> | <r> | <r> | > |----------+--------------+--------------+--------------+--------------+-------+-------+-------| > | feed | 1.05 mol/s | 1.05 mol/s | | 2.10 mol / s | 0.500 | 0.500 | 0 | > | effluent | 0.74 mol / s | 0.74 mol / s | 0.32 mol / s | 1.80 mol / s | 0.411 | 0.411 | 0.178 | > ,#+TBLFM: $5=vsum($2..$4);uf2::$6=$2/$5;uf3::$7=$3/$5;uf3::$8=$4/$5;uf3::@4$2=(1-0.3)*@-1;uf2::@4$3=(1-0.3)*@-1;uf2::@4$4=@-1+0.3*@-1$-1;uf2 > #+end_src > > does not seem to pay attention to the f3 mode in the last column, first > data row. It is something related to how Calc computes the result. The f2 mode specifies the formatting for floating point values, however it seems that Calc treats the zero (from the missing value in the fourth column) divided by a float (from the value in the fifth column) as an integer and not as a float. This may be because the org substitutes a "0" for the missing value, thus an integer. Still, I am not sure dividing an integer by a float should result in an integer (I guess zero is special cased here). If you change the formula for that field to: #+TBLFM: $8=$4*1.0/$5;uf3 to force the $4 field to be evaluated as a float (there are other ways to get the same effect) you get the expected result (I think). > I've also seen some (difficult to replicate) problem with column widths > where the columns are much wider than the expected. I'll keep playing > to see if I can isolate the column width behaviour. I haven't touched any code dealing with columns width (I believe). Cheers, Dan
next prev parent reply other threads:[~2020-10-20 14:33 UTC|newest] Thread overview: 26+ messages / expand[flat|nested] mbox.gz Atom feed top 2020-10-19 15:38 Bug in org-table--set-calc-mode? Daniele Nicolodi 2020-10-20 13:30 ` [PATCH] org-table: Add mode flag to enable Calc units simplification mode Daniele Nicolodi 2020-10-20 13:44 ` Eric S Fraga 2020-10-20 14:00 ` Daniele Nicolodi 2020-10-20 14:22 ` Eric S Fraga 2020-10-20 14:19 ` Eric S Fraga 2020-10-20 14:32 ` Daniele Nicolodi [this message] 2020-10-20 14:53 ` Daniele Nicolodi 2020-10-20 15:35 ` Eric S Fraga 2020-10-20 15:35 ` Eric S Fraga 2020-10-21 15:57 ` Daniele Nicolodi 2020-10-24 15:33 Daniele Nicolodi 2020-11-07 14:03 ` Daniele Nicolodi 2020-11-19 5:58 ` Kyle Meyer 2020-11-19 20:02 ` Daniele Nicolodi 2020-11-23 3:14 ` Kyle Meyer 2020-11-23 10:22 ` Daniele Nicolodi 2020-11-23 22:27 ` Kyle Meyer 2020-11-24 0:03 ` Daniele Nicolodi 2020-11-24 5:35 ` Kyle Meyer 2020-11-24 8:05 ` Daniele Nicolodi 2020-11-25 2:07 ` Kyle Meyer 2020-11-25 7:41 ` Christian Moe 2020-11-23 10:25 ` Daniele Nicolodi 2020-11-23 22:25 ` Kyle Meyer 2020-11-23 23:01 ` Daniele Nicolodi
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style List information: https://orgmode.org * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --in-reply-to=b5f1933a-3a7f-be80-04a2-916427dda169@grinta.net \ --to=daniele@grinta.net \ --cc=emacs-orgmode@gnu.org \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
Org-mode mailing list This inbox may be cloned and mirrored by anyone: git clone --mirror https://orgmode.org/list/0 list/git/0.git # If you have public-inbox 1.1+ installed, you may # initialize and index your mirror using the following commands: public-inbox-init -V2 list list/ https://orgmode.org/list \ emacs-orgmode@gnu.org public-inbox-index list Example config snippet for mirrors. Newsgroups are available over NNTP: nntp://news.yhetil.org/yhetil.emacs.orgmode nntp://news.gmane.io/gmane.emacs.orgmode AGPL code for this site: git clone https://public-inbox.org/public-inbox.git