Format PDF Form Fields: Display Integers Without Decimals
Question details
The user wants to format a calculated PDF form field so that integer results appear as whole numbers without trailing zeros, while fractional results display exactly two decimal places.
- Product
- PDF Editors
- Device & OS
- not provided
- Scenario
- Designing or editing a fillable PDF form with calculated fields that require intelligent number formatting for cleaner presentation.
- Observed behavior
- Standard PDF number formatting applies a fixed number of decimal places to all values, resulting in whole numbers inappropriately displaying decimals (e.g., 100.00 instead of 100).
Ensure you are using a PDF editor that supports form creation and custom JavaScript execution, and that your document contains the target form fields.
Use a Custom Format Script with util.printf
Apply a custom JavaScript snippet to the form field's formatting properties to check if the value is an integer and format it conditionally.
This approach uses the built-in JavaScript function Number.isInteger to detect if the calculated result is a whole number. If it is not, it uses Acrobat's util.printf function to append exactly two decimal places.
Enter the form editing mode in your PDF editor, right-click the target text field, and select 'Properties'.
In the Properties dialog box, click on the 'Format' tab to access formatting options.
Click the 'Select Format Category' dropdown menu and choose 'Custom' from the list.
In the Custom Format Script text box, enter the following code: if (!Number.isInteger(event.value)) event.value = util.printf("%.2f", event.value);
Click 'Close' to save the properties, exit form editing mode, and enter different numbers to test the conditional formatting.
Apply Math.round for Custom Calculations
If you prefer handling the decimals during the calculation phase rather than formatting, you can use JavaScript's Math.round method.
Manage Interactive PDF Forms with WPS Office
WPS Office offers a comprehensive PDF toolkit that makes editing forms, managing calculations, and reviewing complex documents effortless across all your devices.
- 1. Open your PDF form: Launch WPS Office and open your PDF document containing the calculated fields.
- 2. Access PDF tools: Navigate to the PDF toolset to interact with form fields and test your scripts.
- 3. Save your document: Once formatting is complete, save your customized interactive PDF to share.
Frequently Asked Questions
Why do my whole numbers show .00 at the end in PDF forms?
This occurs when the field's Format category is set to 'Number' with exactly two decimal places. This default setting blindly applies decimals to all inputs, including integers. Using a Custom Format script resolves this issue.
Does the util.printf function work in all PDF readers?
The util.printf function is a standard Acrobat JavaScript method. It is supported by the majority of modern, advanced PDF readers that process JavaScript form calculations, ensuring consistent behavior for most users.
Can I apply this custom script to multiple fields simultaneously?
Yes. In your PDF editor's form mode, you can select multiple fields at once, right-click to open their combined Properties, and paste the Custom Format script. It will instantly apply to all selected fields.
