Advanced Portfolio problems
John Ralls
jralls at ceridwen.us
Sun Jul 19 23:13:18 EDT 2015
> On Jul 19, 2015, at 12:18 PM, Wm... <tcnw81 at tarrcity.demon.co.uk> wrote:
>
> Wed, 15 Jul 2015 20:24:08 <CAF1oafdw1hvQF=n1VbhbV7w7Kicx=t4JBZfE4Fb9Hd8JN86pPg at mail.gmail.com>
> dunbrokin <dunbrokin at gmail.com> wrote...
>
>> On a another matter. When I cut and paste the Advanced Portfolio
>> information into a Calc sheet in LibreOffice, the money amounts i.e.
>> NZ$1000 becomes text and I cannot work out how to make it a number so that
>> I can add up various parts of various columns. I have to go thorough the
>> spreadsheet and change them all manually to make them a number...there must
>> be a better way of doing this?
>
> Works fine here with a pound symbol.
>
> Does your LO know what you would like it to think is a currency symbol? <-- beyond this list's scope, I suggest
Not necessarily. One can customize currency symbols in the security editor. The catch with multi-currency is coming up with a scheme that the spreadsheet can understand while keeping the human from getting confused.
Regards,
John Ralls
More information about the gnucash-user
mailing list