LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 08-31-2017, 04:23 AM   #1
joboy
Member
 
Registered: Jul 2009
Distribution: Debian, Ubuntu, Puppy, Mint
Posts: 494

Rep: Reputation: 7
Problem converting Excel to PDF in Libreoffice


Hi there,

I am running Linux Mint Debian, I want to convert Excel files into PDF with Libreoffice, it worked but always messed up the cell grid lines. Some lines are missing or thinness changed, I don't see problem on the Excel file but after converted into PDF, any fix to it ?
 
Old 08-31-2017, 04:38 AM   #2
jlinkels
LQ Guru
 
Registered: Oct 2003
Location: Bonaire, Leeuwarden
Distribution: Debian /Jessie/Stretch/Sid, Linux Mint DE
Posts: 5,195

Rep: Reputation: 1042Reputation: 1042Reputation: 1042Reputation: 1042Reputation: 1042Reputation: 1042Reputation: 1042Reputation: 1042
Have you enlarged the PDF? There is often a problem with (grid) lines which are too thin. When the PDF scaling is insufficient they are not shown although they are there. If you enlarge the PDF to 400% every line should be there.

If this is the case, it is probably caused by the very thin default grid lines in Calc. If you make them a bit thicker this problem should disappear. Although for certain line thicknesses you might see lines of different thickness in you PDF. And again, at higher zoom level they are equal in thickness.

jlinkels
 
Old 09-02-2017, 01:45 AM   #3
joboy
Member
 
Registered: Jul 2009
Distribution: Debian, Ubuntu, Puppy, Mint
Posts: 494

Original Poster
Rep: Reputation: 7
I created a worksheet with Librecalc in XLS and export to PDF, the worksheet itself looked fine, I used the same grid line the whole sheet, but on the PDF there are very obvious thickness difference and some lines are missing. On the otherhand, Librecalc is problematic in grid line, unlike Excel that I can draw and erase individual lines, fine tunning in Librecalc is very hard to do, that's why I need to save as Excel format simply for fixing the grid lines !
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Libreoffice Calc vs Excel speed question redart Linux - Software 17 11-15-2015 07:25 PM
Problem converting chm file to pdf rng Linux - General 1 01-24-2014 01:24 AM
Emailing LibreOffice Spreadsheet As Excel roger2143 Linux - Newbie 3 09-05-2012 07:30 PM
If you have any idea for converting PDF to Excel,come in and help me belly.A Linux - Software 3 09-07-2011 03:06 PM
converting PDF to Excel newbiesforever General 4 11-04-2010 08:31 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:29 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration