Display leading zeros ODS

[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

[Florent]

No one can help ?

[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...

[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...

[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