Advanced Portfolio problems

[John Ralls]

> 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