[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: how to concatenate string to spreadsheet formula
From: |
Fraga, Eric |
Subject: |
Re: how to concatenate string to spreadsheet formula |
Date: |
Mon, 15 Aug 2022 14:40:15 +0000 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) |
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 numbers are integers, integer division is
used so I multiply one of the arguments by 1.0 to ensure floating point
numbers.
HTH,
eric
--
: Eric S Fraga, with org release_9.5.4-720-g4db67d in Emacs 29.0.50