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

how to concatenate string to spreadsheet formula

2022-08-15 Thread edgar
Dear everyone, At the moment, I am using an Org spreadsheet to concatenate a string to the ratio between 2 numbers. One of numbers is the [[sum-of-column][sum of a column]]. The other number would correspond to [[each-row-col1][each of the rows of another column]] ([[ratio-to-0.95][multip