Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 16 Apr 2020 14:46:54 +0200Concatenate currency input with number and treat as currencyhttps://ask.libreoffice.org/en/question/238728/concatenate-currency-input-with-number-and-treat-as-currency/Is it possible to concatenate currency input with number that is the result of a formula without relying on a intermediary cell? Example: cells have the format e.g. "$55 (26)" which means $55 due in 26 days. I just want to enter "55" and it should have the prefix `$` and ideally be treated as a currency so I can sum up the dollar amounts of the cells. 26 days is the result of a formula returning a number.
What I'm looking for is `$<user-input to be treated as currency> (<number output of formula>)`. I can have one column for the dollar amount and another column for number of dates, but grouping them in this context is more intuitive for me. Also just curious if this can be done.Thu, 16 Apr 2020 03:31:14 +0200https://ask.libreoffice.org/en/question/238728/concatenate-currency-input-with-number-and-treat-as-currency/Answer by Opaque for <p>Is it possible to concatenate currency input with number that is the result of a formula without relying on a intermediary cell? Example: cells have the format e.g. "$55 (26)" which means $55 due in 26 days. I just want to enter "55" and it should have the prefix <code>$</code> and ideally be treated as a currency so I can sum up the dollar amounts of the cells. 26 days is the result of a formula returning a number.</p>
<p>What I'm looking for is <code>$<user-input to be treated as currency> (<number output of formula>)</code>. I can have one column for the dollar amount and another column for number of dates, but grouping them in this context is more intuitive for me. Also just curious if this can be done.</p>
https://ask.libreoffice.org/en/question/238728/concatenate-currency-input-with-number-and-treat-as-currency/?answer=238798#post-id-238798Hello,
AFAIK you can't do that since you got no control on the input interpretation algorithm (and by the way: I'd consider your *more intuitive* approach as poor spreadsheet design). Have a separate column for currency, have an additional column for "due in" days and you may - for your personal preference - have a column showing everything in the way you want (using something like `="$" & A2 & " (" & B2 & ")"` assuming that cell `A2` contains the currency value and cell `B2` contains the due-in-days value; `B2` may be replaced by the calculation of due-in-days itself and this way saving extra column `B`).
Thu, 16 Apr 2020 11:32:05 +0200https://ask.libreoffice.org/en/question/238728/concatenate-currency-input-with-number-and-treat-as-currency/?answer=238798#post-id-238798Comment by Mike Kaganski for <p>Hello,</p>
<p>AFAIK you can't do that since you got no control on the input interpretation algorithm (and by the way: I'd consider your <em>more intuitive</em> approach as poor spreadsheet design). Have a separate column for currency, have an additional column for "due in" days and you may - for your personal preference - have a column showing everything in the way you want (using something like <code>="$" & A2 & " (" & B2 & ")"</code> assuming that cell <code>A2</code> contains the currency value and cell <code>B2</code> contains the due-in-days value; <code>B2</code> may be replaced by the calculation of due-in-days itself and this way saving extra column <code>B</code>).</p>
https://ask.libreoffice.org/en/question/238728/concatenate-currency-input-with-number-and-treat-as-currency/?comment=238820#post-id-238820... and the two adjacent cells might *together* look like what OP wants:
A B
$55 (26)Thu, 16 Apr 2020 14:46:54 +0200https://ask.libreoffice.org/en/question/238728/concatenate-currency-input-with-number-and-treat-as-currency/?comment=238820#post-id-238820