[Libreoffice-bugs] [Bug 99859] [Calc] Font color not correct in DOCUMENT VIEW; transparency in charts garbles PRINT PREVIEW.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=99859

--- Comment #13 from kurt.pfeifle at gmail.com ---
Re. comment #4 and comment #5:

Sorry for wrongly assuming that ODF people/developers who think they are
knowledgeable enough to evaluate bug reports which concern LibreOffice features
would know how one of its nicest features (creating and handling its own
non-standard invention, "Hybrid PDFs") works...

My bad, mea culpa.  :-(   Please forgive me.

I created this file as a Hybrid PDF, because it has the following advantages:

1. It directly shows the different look of the printouts and PDFs.
2. It embeds in the same file the original ODS document which demonstrates the
bug.
3. You can extract the original ODS document to reproduce the bug itself.

----

Ok, here is a step-by-step recipe to extract the original ODS file from the
hybrid PDF:

1. Open the PDF with a text editor -- but please use one which does handle
binary
   files gracefully. Use `vim -b`, for example. When using VIm, switch on the
line 
   numbering by typing `:set numbers` in VIm's command mode.

2. Jump to the very end of the file. (Type ":6708" if you are using VIm to jump
to
   line 6708.)

3. You should see the following PDF trailer code in lines 6702 - 6710:

       trailer
       <</Size 488/Root 486 0 R
       /Info 487 0 R
       /ID [ <BD60A3189BDF9102C9822623D7BA3CEF>
       <BD60A3189BDF9102C9822623D7BA3CEF> ]
       /DocChecksum /63B562B0B0FD347C6E1B587CE587A9BF
       /AdditionalStreams
[/application#2Fvnd#2Eoasis#2Eopendocument#2Espreadsheet 461 0 R
       ]
       >>

4. Line 6708 tells us that the ODS document is embedded into the PDF as object 
   number 461.

5. Go to object number 461 (search for the string "461 0 obj" with the help of
   your text editor).

6. Locate this string on line 5359.

7. Locate the keyword "stream" two lines below, on line 5361.

8. Delete all the lines before and including line 5361. What remains is the
line
   starting with the two letters "PK", and all the lines until the rest of the
   file.

9. Now search for the string "462 0 obj". You should find it on the (now new)
   line number 433. (You  H A V E  deleted the lines from the beginning of the
   file up to and including line 5361, have you?)

10. Locate the keyword "endstream" on (now new) line number 430.

11. Delete all the lines from 430 through to the very end of the file.

12. Save this file under a new name, say "original.ods".

Voila!, you now have extracted the original ODS file from the Hybrid PDF
created 
by LibreOffice.

I repeat: it is very important to use a text editor which is able to handle
binary 
files! Otherwise this will not work as described.

----

Another thing:

   1. If you download the Hybrid PDF file, make sure you get the original
version. 
      Check that the file size is 299.252 Bytes.

   2. Should you open it in, say Chrome's previewer and save it from there,
then
      the file size may be ca. 130 kByte smaller. This is due to the fact, that
      OO/LO did not implement its "Hybrid PDF" by using the standard method to
      embed other files into a PDF, but invented its own "proprietary" method
      which Chrome/PDFium does not seem to be able to handle...

P.S.: You may also want to look at bug95328 with comments (esp. after
https://bugs.documentfoundation.org/show_bug.cgi?id=95328#c3)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171022/d443a0e9/attachment.html>