Nick Dokos <ndo...@gmail.com> writes: > Jarmo Hurri <jarmo.hu...@iki.fi> writes: >> This solution seems to change the contents of a cell, not only its >> formatting. So the following, where I try to increase the value of "C" >> by one, leads to an error: >> >> ``` >> | quantity | value | >> |----------+--------| >> | A | 1 | >> | B | 3 | >> |----------+--------| >> | *C* | *0.33* | >> | D | #ERROR | >> >> #+TBLFM: @4$2=@-2/@-1; *%.2f*::@5$2=@-1+1 >> ``` >> >> I wonder if there is a way around this effect? > > The error here is that `*0.33*' is no longer a string that can be > converted to a number, so the calculator barfs.
Yes, that is obvious. The underlying question is whether it is possible to cleanly separate presentation from contents. Here they are mixed. All the best, Jarmo
