Ask Your Question
0

Missing table content when converting XLSX to PDF [closed]

asked 2016-12-08 15:17:50 +0200

fagner gravatar image

updated 2016-12-08 16:12:35 +0200

I'm using soffice.exe to convert a XLSX file to PDF but the converted PDF file is missing content: only one row is being converted in one of the spreadsheet tables.

My setup:

  • Windows 8.1
  • LibreOffice portable (version 5.2.3.3)

Command executed: soffice.exe -norestore -nofirststartwizard -headless -convert-to pdf "report-1481124262741.xlsx"

EDIT 1: I tried to export my spreadsheet to PDF in LibreOffice Calc and the result was the same. Here are two images, one in Calc and another in the exported PDF: http://imgur.com/a/zKwCK. Rows are missing and I don't know why.

EDIT 2: I think I know what is happening. I'm using EPPlus and the page break is not being redefined after the table is being generated. As soon as I confirm this is the issue I will close this issue.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by fagner
close date 2016-12-08 23:07:48.144955

Comments

Without access to a file with the issue, it's really difficult for someone to help.

m.a.riosv gravatar imagem.a.riosv ( 2016-12-08 22:58:28 +0200 )edit

Hello @m.a.riosv. Unfortunately there is confidential data that I cannot disclose here. However, like I said in my last edit in the thread, there were page breaks removing some of the spreadsheet content. As soon as I defined the page breaks in my C# code correctly using EPPlus the issue was resolved. In any case, thank you for being willing to help.

fagner gravatar imagefagner ( 2016-12-08 23:06:21 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2016-12-08 23:07:18 +0200

fagner gravatar image

There were page breaks removing some of the spreadsheet content. As soon as I defined the page breaks in my C# code correctly using EPPlus the issue was resolved.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2016-12-08 15:17:50 +0200

Seen: 187 times

Last updated: Dec 08 '16