Issue 67622 - notes are not exported to pdf when pagerange is exported
Summary: notes are not exported to pdf when pagerange is exported
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2006-07-20 18:21 UTC by andreschnabel
Modified: 2013-08-07 15:13 UTC (History)
3 users (show)

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

Calc file with notes (7.79 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-08-08 18:38 UTC, andreschnabel
no flags Details
PDF - all notes exported (15.36 KB, application/pdf)
2006-08-08 18:38 UTC, andreschnabel
no flags Details
PDF - notes missing (only page 2) (14.29 KB, application/pdf)
2006-08-08 18:39 UTC, andreschnabel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description andreschnabel 2006-07-20 18:21:40 UTC
If only a page range (1st page not included) of a calc document is exported to
PDF, notes are not exported, although the option is enabled.

To reproduce:
- Create a calc document with some content, so that it has more than one page
for printing
- put a note somwhere on the second page
- export to pdf, export page 2 only, enable "Export Notes"

-> the note will not be exported

This works fine, if all pages are exported.

I filed the issue for calc, as this problem does not occure in Writer.
Comment 1 andreschnabel 2006-07-20 22:25:02 UTC
this seems related to Issue 44282, 59745, 45493, 40354 
Comment 2 frank 2006-08-08 13:12:28 UTC

as it never worked that way, it's an enhancement. On the other hand you may say
it's the correct way because you decided to just export the second page and the
Notes are always another page so the pdf must contain 2 pages.

So I assign this to requirements for decission finding.

Comment 3 andreschnabel 2006-08-08 18:37:13 UTC
set back to DEFECT, as I think  you are talking about a different thing here.

If notes would be exported using format - page, sheet - print notes enabled I
would agree, that notes would not be exported, as they are on a different page.

But with "export notes" enabled in PDF export, notes should be embedded in the
PDF document, right there where they are. That it "never worked that way" is no
argument to change this defect to enhancement.
See . Export of
Notes is explained in 6.5 ... Calc notes are supposed to behave the same way as
writer notes do.
Comment 4 andreschnabel 2006-08-08 18:38:10 UTC
Created attachment 38347 [details]
Calc file with notes
Comment 5 andreschnabel 2006-08-08 18:38:46 UTC
Created attachment 38348 [details]
PDF - all notes exported
Comment 6 andreschnabel 2006-08-08 18:39:11 UTC
Created attachment 38349 [details]
PDF - notes missing (only page 2)
Comment 7 andreschnabel 2006-08-08 18:39:38 UTC
reassign do default owner again
Comment 8 frank 2006-08-09 13:01:22 UTC
Hi Niklas,

one for you I think. I did not know that there is a specification and that Calc
should export the notes to PDF as an embedded tag. As far as I can see, Print
Notes mus tbe enabled under Format-Page-Sheet in addition to the export Notes
checkbox in the PDF Export dialog. According to the Specification only the
checkbox in the Export dialog should be necessary to export notes.

Comment 9 niklas.nebel 2006-09-01 15:09:52 UTC
NN->SJ: PDFExport::ExportSelection calls PDFExtOutDevData::SetCurrentPageNumber
with the document page number (including non-selected pages), but when used in
PDFExtOutDevData::CreateNote etc, it's interpreted as page number within the PDF

Writer calculates its own page numbers, but Impress has the same problem (with

I suppose this can just be changed in PDFExport::ExportSelection.
Comment 10 Martin Hollmichel 2007-11-09 16:52:08 UTC
change target from 2.x to 3.x according to