Page 1 of 1

Display leading zeros ODS

PostPosted: Mon May 12, 2014 4:38 pm
by Florent
Hello,

Does someone know how it is possible to display the leadings zeros when creating a ods aeroo report ?

Example : 0606060606 is displayed 606060606

I tried to format column as text, return a string, use ' ... nothing worked at this time.

Thanks for your help

Re: Display leading zeros ODS

PostPosted: Wed Sep 24, 2014 4:49 pm
by Florent
No one can help ?

Re: Display leading zeros ODS

PostPosted: Wed Oct 29, 2014 10:26 am
by martin
I have the same problem, but I still didn't find the answer... If I set field format to text, loffice ignores it. If I put single quote before hyperlink, zeroes are visible, but so is the quote...

Re: Display leading zeros ODS

PostPosted: Fri Oct 31, 2014 5:50 pm
by sraps
Hello,
I can not confirm this. Leading zero's are being displayed fine. Please write down the code you are writing in the fields...

Re: Display leading zeros ODS

PostPosted: Wed Nov 05, 2014 11:26 am
by martin
I tried to attach small example, but get error 'Could not upload attachment'...

Code in ODS hyperlinks is
Code: Select all
python://obj.code or ''

for browsing object, or
Code: Select all
python://norm.get('code', '')

for dictionary from parser. If value contains only numbers, it will be displayed as number, regardless of field format in ODS. And if value has leading zeroes, they will be ignored.

Versions:
Debian Wheezy
Libre Office 3.5.4.2
OpenERP 6.1.1
aeroolib 1.0.0.RC4