Jarmo Hurri <jarmo.hu...@iki.fi> writes:
> Greetings Norwid.
>
> Norwid Behrnd <nbeh...@yahoo.com> writes:
>
>> try extending the format of the table formula with asterisks, i.e.
>>
>> ```
>> | quantity | value |
>> |----------+--------|
>> | A | 1 |
>> | B | 3 |
>> |----------+--------|
>> | *C* | *0.33* |
>>
>> #+TBLFM: @4$2=@-2/@-1; *%.2f*
>> ```
>>
>> Subsequently, issue the call ```C-c *``` for an update while the
>> cursor is within the table. This approach works well enough for me
>> (equally for emphasis with enclosing forward slashes, or underscores)
>> in Emacs' native display (backed by elpa-org 9.4.0) as well as for a
>> subsequent export into .html and display (e.g., in Firefox), or .tex.
>
> Excellent, this is a working solution for the basic case. Much
> appreciated!
>
> 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.
TUrn on formula debugging with `C-c {' and try evaluating it.
--
Nick
"There are only two hard problems in computer science: cache
invalidation, naming things, and off-by-one errors." -Martin Fowler
