Re: [O] Table refuses to forget cell formula which once overrode a column formula
Thanks for your reply. I now understand and I also agree it is a good solution. Best, Ruy On Nov 15, 2017 19:54, "Nicolas Goaziou"wrote: > Ruy Exel writes: > > > Thanks very much. Just out of curiosity I'd be interested in > understanding > > how did you do it. My (non expert) impression is that using properties > to > > override column formulas isn't a good idea. > > The property is here to prevent evaluation of a column formula on > a given field. It doesn't override anything. > > > It seems to me it would be more natural to apply cell formulas AFTER > > all column formulas were applied, so that each cell would be simply > > the output of the formula defining it. > > This is what happens already. The property prevents useless > computations. > > Regards, >
Re: [O] Table refuses to forget cell formula which once overrode a column formula
Ruy Exelwrites: > Thanks very much. Just out of curiosity I'd be interested in understanding > how did you do it. My (non expert) impression is that using properties to > override column formulas isn't a good idea. The property is here to prevent evaluation of a column formula on a given field. It doesn't override anything. > It seems to me it would be more natural to apply cell formulas AFTER > all column formulas were applied, so that each cell would be simply > the output of the formula defining it. This is what happens already. The property prevents useless computations. Regards,
Re: [O] Table refuses to forget cell formula which once overrode a column formula
Ruy Exelwrites: > Hi Nicolas, > > Thanks very much. Just out of curiosity I'd be interested in understanding > how did you do it. My (non > expert) impression is that using properties to override column formulas isn't > a good idea. It seems to > me it would be more natural to apply cell formulas AFTER all column formulas > were applied, so that each > cell would be simply the output of the formula defining it. > Here's what I do in such cases (I'm assuming that the change exists in master, either because it was applied there in the first place, or after a merge with maint): - update my git repo: git checkout master; git remote update; git rebase - check recent history: git log -20 --oneline - find the commit of interest - in this case 6059c3a05 org-table: Clean left-over `:org-untouchable' property - show the commit: git show 6059c3a05 HTH. > > On Nov 15, 2017 14:42, "Nicolas Goaziou" wrote: > > Hello, > > Ruy Exel writes: > > > The following is very simple org-mode spreadsheet in which the cells in > the > > second column show the triple of the corresponding cell in the first > column > > due to the "column formula" in its TBLFM row $2=3*$1;N. However the > third > > row (actually row @4) is an exception because of the "cell formula" > > @4$2=string("Exception") which expectedly overrides the above column > > formula. > > > > |+---| > > | Number | Triple | > > |+---| > > | 1 | 3 | > > | 2 | 6 | > > | 3 | Exception | > > | 4 | 12 | > > |+---| > > > > #+TBLFM: $2=3*$1::@4$2=string("Exception") > > > > So all is well. Below you will find a copy of the above table, except > that, > > after copying, I have deleted the exceptional formula affecting cell > @4$2. > > > > |+---| > > | Number | Triple | > > |+---| > > | 1 | 3 | > > | 2 | 6 | > > | 3 | Exception | > > | 4 | 12 | > > |+---| > > > > #+TBLFM: $2=3*$1 > > > > One would expect that, after updating this table with C-u C-c *, or C-c > C-c > > in the TBLFM line, the exceptional value in cell @4$2 would revert to > the > > triple of '3', but instead the string "Exception" stays put. > > Fixed. Thank you. > > Regards, > > -- > Nicolas Goaziou > -- Nick
Re: [O] Table refuses to forget cell formula which once overrode a column formula
Hi Nicolas, Thanks very much. Just out of curiosity I'd be interested in understanding how did you do it. My (non expert) impression is that using properties to override column formulas isn't a good idea. It seems to me it would be more natural to apply cell formulas AFTER all column formulas were applied, so that each cell would be simply the output of the formula defining it. Best, Ruy On Nov 15, 2017 14:42, "Nicolas Goaziou"wrote: Hello, Ruy Exel writes: > The following is very simple org-mode spreadsheet in which the cells in the > second column show the triple of the corresponding cell in the first column > due to the "column formula" in its TBLFM row $2=3*$1;N. However the third > row (actually row @4) is an exception because of the "cell formula" > @4$2=string("Exception") which expectedly overrides the above column > formula. > > |+---| > | Number |Triple | > |+---| > | 1 | 3 | > | 2 | 6 | > | 3 | Exception | > | 4 |12 | > |+---| > > #+TBLFM: $2=3*$1::@4$2=string("Exception") > > So all is well. Below you will find a copy of the above table, except that, > after copying, I have deleted the exceptional formula affecting cell @4$2. > > |+---| > | Number |Triple | > |+---| > | 1 | 3 | > | 2 | 6 | > | 3 | Exception | > | 4 |12 | > |+---| > > #+TBLFM: $2=3*$1 > > One would expect that, after updating this table with C-u C-c *, or C-c C-c > in the TBLFM line, the exceptional value in cell @4$2 would revert to the > triple of '3', but instead the string "Exception" stays put. Fixed. Thank you. Regards, -- Nicolas Goaziou
Re: [O] Table refuses to forget cell formula which once overrode a column formula
Hello, Ruy Exelwrites: > The following is very simple org-mode spreadsheet in which the cells in the > second column show the triple of the corresponding cell in the first column > due to the "column formula" in its TBLFM row $2=3*$1;N. However the third > row (actually row @4) is an exception because of the "cell formula" > @4$2=string("Exception") which expectedly overrides the above column > formula. > > |+---| > | Number |Triple | > |+---| > | 1 | 3 | > | 2 | 6 | > | 3 | Exception | > | 4 |12 | > |+---| > > #+TBLFM: $2=3*$1::@4$2=string("Exception") > > So all is well. Below you will find a copy of the above table, except that, > after copying, I have deleted the exceptional formula affecting cell @4$2. > > |+---| > | Number |Triple | > |+---| > | 1 | 3 | > | 2 | 6 | > | 3 | Exception | > | 4 |12 | > |+---| > > #+TBLFM: $2=3*$1 > > One would expect that, after updating this table with C-u C-c *, or C-c C-c > in the TBLFM line, the exceptional value in cell @4$2 would revert to the > triple of '3', but instead the string "Exception" stays put. Fixed. Thank you. Regards, -- Nicolas Goaziou