[libreoffice-users] Re: Percentage with bracket as negative

Am 07.10.2015 um 19:49 schrieb Yudi Wijaya:
> Hi,
> I want to use feature Insert - Sheet from file and i have file.txt that
> contains like this:
> |     1|03/10/2015|14-1403837|SARIPAH                  |  24 |Rp
> 130,000,000 |Rp     3,799,530|Rp        0|Rp     1,600,000|
>  0.0%|Rp   36,296,000|Rp    6,929,000|Rp   130,000,000|Rp             0| 0
>      0| (24.86 % )|Arr|    JAMES BOND |Y     |
> |     1|02/10/2015|17-2202200|MAKMUR                   |  24 |Rp
>  25,060,000 |Rp       828,800|Rp        0|Rp     1,600,000|
>  0.0%|Rp    6,452,000|Rp    1,313,000|Rp    25,060,000|Rp             0| 0
>      0| (25.24 % )|Adv|       ALEXANDER |Y     |
>
> How to make LibreOffice can detect these (24.86 % ) and (25.24 % ) as
> negative percentage value?
>
> I already try many way, but still can not make it read as negative
> percentage value.
>
> Please help.. thanks!
>
>
> Best Regards,
> Yudi Wijaya

Always turn on "special numbers" option. This will also import correct
dates.


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted