Issue 73466 - Tables with a SUM formula doesn't get exported properly to PDF
Summary: Tables with a SUM formula doesn't get exported properly to PDF
Alias: None
Product: Writer
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.1
Hardware: Other Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: h.ilter
QA Contact: issues@sw
Keywords: oooqa
Depends on:
Reported: 2007-01-14 20:42 UTC by bastb
Modified: 2007-01-16 13:31 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

OpenOffice Document containing the error (10.10 KB, application/vnd.oasis.opendocument.text)
2007-01-14 21:04 UTC, bastb
no flags Details
See bottom right corner. (86.50 KB, image/png)
2007-01-16 12:08 UTC, kpalagin
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description bastb 2007-01-14 20:42:10 UTC
A document created with 2.1 (dutch version) has a lot of tables 
in it, and 1 of the tables contains a formula. The formula is a sum formula 
(=sum(<A3:G3>)). The table itself is repeated 6 more times and the layout and 
formula is the same for each of the tables.

When this entire document gets exported to a PDF-document and the resulting PDF 
document is viewed using the Foxit PDF reader, the value of the cell containing 
this formula doesn't contain the expected value, but this error: "** Foutieve 
expressie **" (which can be translated to something like "invalid expression"). 
There is no error when the document is read using 2.1.
Comment 1 kpalagin 2007-01-14 20:53:56 UTC
please provide the document.
Comment 2 bastb 2007-01-14 21:04:07 UTC
Created attachment 42151 [details]
OpenOffice Document containing the error
Comment 3 Rainer Bielefeld 2007-01-15 07:13:01 UTC
... and your PDF-export, please.
Comment 4 michael.ruess 2007-01-15 08:08:01 UTC
Already tracked as issue 34863.

*** This issue has been marked as a duplicate of 34863 ***
Comment 5 michael.ruess 2007-01-15 08:46:37 UTC
Closing duplicate.
Comment 6 michael.ruess 2007-01-15 10:28:44 UTC
My fault. It is PDF export, not WinWord export... reopened issue.
Comment 7 michael.ruess 2007-01-15 10:29:21 UTC
Reassigned to HI.
Comment 8 h.ilter 2007-01-15 13:13:47 UTC
The error is already present by opened document at the last table below.
Set to WFM
Comment 9 h.ilter 2007-01-16 10:16:34 UTC
I've corrected the error at the bugdoc and did a pdf export. It looks like
expected, No error!
Comment 10 bastb 2007-01-16 10:35:31 UTC
I'm probably not clear enough on this, but what is the error in the document? 
The formula seems ok. Is it? If it is, then it should be possible to 
automaticly `execute' the formula prior to the PDF export.
Comment 11 Rainer Bielefeld 2007-01-16 11:42:24 UTC
Hm, I can't see any relation to PDF export. When I open your document
'openoffice-export-pdf.odt', I read "** Foutieve expressie ** in the last cell
of the last table, and that is just the same as in PDF. 

When I did a change in 'openoffice-export-pdf.odt', the error message has been
changed to German (as expected). So the question seems to be what input caused
the error message in the OOo document. 

@bastb: any idea how to get the error message in an own new document?
Comment 12 kpalagin 2007-01-16 12:07:12 UTC
I am getting error when opening the file. Please see screenshot attached.
Comment 13 kpalagin 2007-01-16 12:08:26 UTC
Created attachment 42193 [details]
See bottom right corner.
Comment 14 bastb 2007-01-16 12:39:50 UTC
I can see the error in the original document -- I forgot to add a closing 
brace ")" to the formula in the cell. This was not the problem in the original 
document, however I don't want to attach this document to the bug report as I 
don't want this document to be available to the world.

What triggers the execution of a formula is not clear to me: I created a table 
to reproduce this bug and noticed that when I set a value to a cell which was 
empty and is part of the formula in another cell, the new value gets calculated 
right away. When I change a value and click below the table, the result of the 
formula is not changed. The new value is calculated right away when I change 
the value and use the tab key to jump to another cell.
Comment 15 Rainer Bielefeld 2007-01-16 13:31:36 UTC
@bastb, please feel free to reopen this issue if you can
- contribute a test kit with an error free OOo source document and a PDF export 
  showing the complained problem.