We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calculate total from fillable form [closed]

asked 2018-12-20 12:51:06 +0200

valentinas gravatar image

updated 2021-06-02 15:22:03 +0200

Alex Kemp gravatar image


I'm creating a fillable form in LibreOffice but I need a field that gives me the total of other fields (numbered format) but I can't find the right format for that field so it calculates the total (see the image below).

image description

I'd appreciate your help! Thank you!

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-07 03:10:46.272674

2 Answers

Sort by » oldest newest most voted

answered 2019-07-24 01:54:52 +0200

lazarus477 gravatar image

updated 2019-08-06 08:23:43 +0200

Short answer: NO. JavaScript in a PDF document is apparently a proprietary extension to the specification, source, Wikipedia:

PDF 1.7, the sixth edition of the PDF specification that became ISO 32000-1, includes some proprietary technologies defined only by Adobe, such as Adobe XML Forms Architecture (XFA) and JavaScript extension for Acrobat, which are referenced by ISO 32000-1 as normative and indispensable for the full implementation of the ISO 32000-1 specification. These proprietary technologies are not standardized and their specification is published only on Adobe’s website.[8][9][10][11][12] Many of them are also not supported by popular third-party implementations of PDF.

On July 28, 2017, ISO 32000-2:2017 (PDF 2.0) was published.[13] ISO 32000-2 does not include any proprietary technologies as normative references.[14]

What this means is that you need to use Adobe's own software in order to produce a PDF form which acts like a spreadsheet.

edit flag offensive delete link more

answered 2018-12-20 18:31:09 +0200

erAck gravatar image

Assuming your 6 values are in the cell ranges A2:A4 and C2:C4 then the formula in E4 would be =SUM(A2:A4;C2:C4)

edit flag offensive delete link more


I think the question here is how to produce a PDF form that acts as a spreadsheet and can thus produce a sum in one of the form fields. As far as I know this would require scripting. PDF as a format does support embedded JavaScript.

lazarus477 gravatar imagelazarus477 ( 2019-07-24 01:08:35 +0200 )edit

The question didn't mention PDF, but if that was meant then, yes, there's no such thing in a PDF export.

erAck gravatar imageerAck ( 2019-08-01 12:44:54 +0200 )edit

Question Tools

1 follower


Asked: 2018-12-20 12:51:06 +0200

Seen: 944 times

Last updated: Aug 06 '19