[Bug 157834] Add simple arithmetic to pdf forms
https://bugs.documentfoundation.org/show_bug.cgi?id=157834 --- Comment #13 from Mike Sapsard --- I obviously was not clear, and apologise. I was looking for a method to add JavaScript to pdf exports from LO. Currently, I create forms in LO and then export to pdf. To add the JavaScript, I open the pdf file in Scribus and add the JavaScript. Scribus has two forms of textbox - 'ordinary' and 'pdf'. The pdf textboxes have a component editor that allows formatting of basic functions - sum, product, etc, without coding. Results can be checked in FireFox and Chromium. Some of the Scribus screens are shown in the third attachment above. The only problem may be that the ODT spec does not allow embedding of the additional functionality in the source file. Mike Sapsard -- You are receiving this mail because: You are the assignee for the bug.
[Bug 157834] Add simple arithmetic to pdf forms
https://bugs.documentfoundation.org/show_bug.cgi?id=157834 --- Comment #12 from Mike Sapsard --- Created attachment 194678 --> https://bugs.documentfoundation.org/attachment.cgi?id=194678&action=edit Screenshoots from Scribus showing Javascript insertion for pdf textbox -- You are receiving this mail because: You are the assignee for the bug.
[Bug 157834] Add simple arithmetic to pdf forms
https://bugs.documentfoundation.org/show_bug.cgi?id=157834 --- Comment #11 from Mike Kaganski --- (In reply to Mike Sapsard from comment #10) > The responses that I received seemed to think that I wanted to pirate and > abuse other people's forms, rather than do everything in LO. No. E.g., my responses were about what I think about this request as (1) requiring LibreOffice to implement a translation of arbitrary programs from one scripting language and one object model to another language and model, which is currently not possible even for advanced AI; and (2) introducing a security risk. Your phrase here looks very odd. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 157834] Add simple arithmetic to pdf forms
https://bugs.documentfoundation.org/show_bug.cgi?id=157834 --- Comment #10 from Mike Sapsard --- This was a feature request, to introduce scripting using JavaScript into pdf forms. I gave examples, that used LO Writer to create the basic form layout and export it to a pdf. The pdf was then imported into Scribus, where Javascript was added to automate addition of various fields. The file was then exported to pdf again, so that a fully functional form existed. The layout facilities for forms are much better in LO than Scribus for occasional users. The responses that I received seemed to think that I wanted to pirate and abuse other people's forms, rather than do everything in LO. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 157834] Add simple arithmetic to pdf forms
https://bugs.documentfoundation.org/show_bug.cgi?id=157834 QA Administrators changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|--- |INSUFFICIENTDATA -- You are receiving this mail because: You are the assignee for the bug.
[Bug 157834] Add simple arithmetic to pdf forms
https://bugs.documentfoundation.org/show_bug.cgi?id=157834 --- Comment #9 from QA Administrators --- Dear Mike Sapsard, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp -- You are receiving this mail because: You are the assignee for the bug.
[Bug 157834] Add simple arithmetic to pdf forms
https://bugs.documentfoundation.org/show_bug.cgi?id=157834 --- Comment #8 from QA Administrators --- Dear Mike Sapsard, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157834] Add simple arithmetic to pdf forms
https://bugs.documentfoundation.org/show_bug.cgi?id=157834 --- Comment #7 from Mike Kaganski --- IMO: 1. There is no built-in means to do calculations in form fields in LibreOffice, other than writing own macros. LibreOffice *must not* put into PDFs anything absent in the source document itself, so any document with simple form fields (but without macros) must never obtain any scripting capability on export - because LibreOffice is not a PDF authoring tool, but its PDF export is designed to just store the document in another format, as is. 2. Even if there is a macro in the document, it is not a LibreOffice task to serve as a AI to convert *programs* from one programming language (say, Basic) and one document model (namely, LibreOffice/UNO document model) into another language (JavaScript) and another document model (PDF API). Not only the two document models are completely different; not only the correct automatic translation of this kind is yet impossible even for most sophisticated AI available currently. It is also a new security risk, which mitigation would be put on TDF. And then, it would still rely on an implementation of this API in other PDF viewers, giving raise to bugs like "your PDF doesn't calculate in Reader X"... WONTFIX IMO. Ref: https://opensource.adobe.com/dc-acrobat-sdk-docs/acrobatsdk/pdfs/acrobatsdk_jsapiref.pdf https://helpx.adobe.com/acrobat/using/javascripts-pdfs-security-risk.html -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157834] Add simple arithmetic to pdf forms
https://bugs.documentfoundation.org/show_bug.cgi?id=157834 Stéphane Guillou (stragu) changed: What|Removed |Added CC||stephane.guillou@libreoffic ||e.org URL||https://ask.libreoffice.org ||/t/dynamic-pdf-fields/96101 ||/4 See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=10 ||6475 Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #6 from Stéphane Guillou (stragu) --- This has been brought up on ask.LO before: - https://ask.libreoffice.org/t/dynamic-pdf-fields/96101/4 - https://ask.libreoffice.org/t/math-calculations-in-pdf-forms/12208/4 I understand comment 4 to be the current workaround "recipe" to use a layout created in LibreOffice, export as PDF, open it in Scribus to then add the calculated fields (which uses JavaScript) and export again to PDF. Adobe Acrobat (Pro and Sign as far as I can tell) also allows creating those too. So I guess the enhancement request is twofold: - support calculated fields in a form created with Writer document (is there anything in ODF for that?) - support their export as PDF (In reply to Mike Sapsard from comment #4) > Although LO can do arithmetic in Base and Calc forms, this cannot be > exported to pdf for a standalone fillable form. Any chance you could also attach an example Calc file that has such form controls? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157834] Add simple arithmetic to pdf forms
https://bugs.documentfoundation.org/show_bug.cgi?id=157834 --- Comment #5 from Mike Sapsard --- Created attachment 190333 --> https://bugs.documentfoundation.org/attachment.cgi?id=190333&action=edit Scribus interface for arithmetic This is a screenshot of the Scribus interface for adding the capabilty. I believe that it must use javascript underneath. Unfortunately, it does not allow anything more than addition or multiplication of fields. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157834] Add simple arithmetic to pdf forms
https://bugs.documentfoundation.org/show_bug.cgi?id=157834 --- Comment #4 from Mike Sapsard --- Although LO can do arithmetic in Base and Calc forms, this cannot be exported to pdf for a standalone fillable form. I would like to be able to create a fillable pdf form with arithmetic, in Write, that can be sent out to other people to fill in. In the files that I sent, LO exported Demo_Arithmetic.pdf from Demo_Arithmetic.odt. Scribus then imported Demo_Arithmetic.pdf and translated it to its own format - Demo_Arithmetic.sla. I was then able to add the arithmetic using a simple window with click to select functions to add the arithmetic. The file was then exported again as Demo_Arithmetic_from_Scribus.pdf. So, the first pdf file contains no arithmetic, and the second one does. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157834] Add simple arithmetic to pdf forms
https://bugs.documentfoundation.org/show_bug.cgi?id=157834 --- Comment #3 from Mike Kaganski --- (In reply to Mike Sapsard from comment #2) The ODT in your file does not do any arithmetics. So are you asking for "translate to PDF what is already working in ODT", or are you asking for something else? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157834] Add simple arithmetic to pdf forms
https://bugs.documentfoundation.org/show_bug.cgi?id=157834 Mike Sapsard changed: What|Removed |Added CC||mike.saps...@gmail.com --- Comment #2 from Mike Sapsard --- Created attachment 190326 --> https://bugs.documentfoundation.org/attachment.cgi?id=190326&action=edit Files to produce working fillable pdf form. Open zip file, which contains the route to create a working fillable pdf with addition and multiplication. Scribus cannot do subtraction and multiplication, without user generated javascript. I suspect that there is embedded javascript in the fully working pdf. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157834] Add simple arithmetic to pdf forms
https://bugs.documentfoundation.org/show_bug.cgi?id=157834 --- Comment #1 from Mike Kaganski --- Can you please provide a Scribus-made form doing simple arithmetics without javascript? -- You are receiving this mail because: You are the assignee for the bug.
