Form controls: numerical field loses number format on .pdf export

[heimdall]

LibreOffice 7.3.7.2
OS: Fedora Linux 36 Workstation

I’ve created a form in LibreOffice Draw, and have placed a few numeric field form controls on it.
Control Properties I’ve set are:

• Strict format: Yes
• Value min: 0.00
• Decimal accuracy: 2
• Thousands separator: Yes
• Alignment: Right

The objective is for a given number, entered in any format, to be formatted as #,##0.00
So: 5 → 5.00
123456 → 123,456.00
etc.

All goes well, until I export the form as a pdf.
Then the default values in all fields have “0” instead of “0.00”
And any numbers I enter stay in the entry format, thus:
5 → 5
123456 → 123456
123,456.00 → 123,456.00
etc.

What am I doing wrong, please?
It seems to be behaving as if the input is text, not numerical, eg, no way should I be able to input a thousands separator.
I have a feeling it’s something super-simple, but so far a solution has escaped me.

PS: Brilliant piece of kit, guys. I use LO all the time, wouldn’t be without it.

[Zizi64]

Please upload the ODF and the PDF version of your sample file.

[heimdall]

Thank you so much for your help on this.
Don’t mind saying, it’s got me tearing my hair out.

st-vincent-vat-form-003-2007.odg (37.2 KB)
st-vincent-vat-form-003-2007.pdf (63.1 KB)

[Hrbrgr]

What settings did you use?

[heimdall]

Exactly like this:

[Hrbrgr]

I can see values in the PDF reader.

---

Version: 7.5.2.2 (X86_64) / LibreOffice Community
Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL threaded

[heimdall]

Hm. Your .pdf looks perfect, not at all like the one I’m generating.

I note you’re on Windows, with a newer version of LO (7.5.2.2) than mine (7.3.7.2).
I suppose thing-to-do-next is to upgrade Fedora to 38; that would bring in LO 7.5.2.2-1.fc38, which /may/ solve the problem. I will check back in when I’ve done that.

Please could you upload the .pdf you’ve generated? I’d like to see how the number formatting behaves on input.

[Hrbrgr]

90258 st-vincent-vat-form-003-2007.pdf (112,4 KB)

done.

[heimdall]

Curioser and curioser.

@Hrbrgr, what pdf reader are you using?

I upgraded to Fedora WS 37, because 38 is out in a couple more weeks, and I may as well wait for it to be moved to stable. That brought in LO 7.4.6.2.

1. I opened your file in Chrome (see pic).
   On Load, fields show only “0”, not “0.00” (set as default value)
   On Edit, numeric input is rejected 1st time; but accepted on 2nd try. Numeric format is enforced;chars are disallowed, with incorrect input discarded.
   

   

2. Evince pdf reader:
   On load, fields show only “0”, not “0.00” (set as default value)
   On edit, no numerical formatting is applied: I can enter literally any chars, eg see lines 260 and 270, “the cat sat on the mat”.
   

   

3. Firefox:
   On load, fields show only “0”, not “0.00” (set as default value)
   On Edit, it worked perfectly: numeric format is enforced; non-numeric chars are ignored (yay, FF!).

4. I installed Okular to see if that helped.
   On load, fields show only “0”, not “0.00” (set as default value)
   On Edit, numerical format is enforced; non-numeric chars result in “NaN”. Oh well.

5. On MacOS Darwin 22.3.0 Darwin Kernel Version 22.3.0 with Preview 11.0:
   On Load, all fields are empty, with no clue as to where the fields are.
   On Edit, a “0” shows up; numeric format is not enforced; any char input is accepted.

6. On MacOS again, with Safari 16.3
   As for No.5 above.

7. On MacOS again, with Chrome 111.0.5563.146:
   On Load, fields show only “0”, not “0.00” (set as default value)
   On Edit, numeric format is not enforced; any char input is accepted.

8. On MacOS Ventura 13.2.1 with pdfExpert 3.0.37:
   On Load, fields show “0.00”, ie the default value
   On Edit, numerical format is very well enforced.

9. I’ve sent the file to a Windows user, will update this when I hear back from him.

[EarnestAl]

On Windows 11:

• Exported from LibreOfice 7.3.7.2 I get single 0.
• Exported from LibreOffice 7.5.1.2 I get 0.00.

Both viewed in Adobe Reader 23.001.20093.0