Re: how to concatenate string to spreadsheet formula

2022-08-16 Thread edgar
On 2022-08-15 14:40, Fraga, Eric wrote: Hi Edgar, I did not quite understand what you actually were calculating but maybe consider the following expression for table formulas: #+TBLFM: $3='(format "%s\\textwidth" (/ (* 1.0 $2) $1));N If you specify ";N", the entries are treated as numbers. Th

Re: how to concatenate string to spreadsheet formula

2022-08-15 Thread Fraga, Eric
Hi Edgar, I did not quite understand what you actually were calculating but maybe consider the following expression for table formulas: #+TBLFM: $3='(format "%s\\textwidth" (/ (* 1.0 $2) $1));N If you specify ";N", the entries are treated as numbers. The problem with division is that if both nu