Problem with cell borders - Excel 2010

This Forum is for the use of End Users requiring help and assistance for Tracker Software's OFFice2PDF and MS Office Addin Applications - supplied with PDF-XChange.

Moderators: TrackerSupp-Daniel, Tracker Support, Vasyl-Tracker Dev Team, Sean - Tracker, Chris - Tracker Supp, Tracker Supp-Stefan

Post Reply
BobM
User
Posts: 91
Joined: Thu Feb 14, 2008 11:28 am

Problem with cell borders - Excel 2010

Post by BobM » Wed Dec 14, 2011 9:45 am

When using the "Convert to PDF" ribbon bar option in Excel 2010, for cells that have borders with thin lines, these lines are not correctly converted. Instead, some borders are displayed as thick short dashes, whilst others are similar but also include the (correct) thin line.
Printing using the PDFX4 driver produces the correct output.
See attachments for examples.
Attachments
spreadsheet_lines.7z
(1.99 KiB) Downloaded 191 times

User avatar
Tracker Supp-Stefan
Site Admin
Posts: 13430
Joined: Mon Jan 12, 2009 8:07 am
Location: London
Contact:

Re: Problem with cell borders - Excel 2010

Post by Tracker Supp-Stefan » Wed Dec 14, 2011 10:18 am

Hello Bob,

Can you please also include the excel file - so that I can try and reproduce this at my end?

Thanks,
Stefan

BobM
User
Posts: 91
Joined: Thu Feb 14, 2008 11:28 am

Re: Problem with cell borders - Excel 2010

Post by BobM » Wed Dec 14, 2011 3:58 pm

Spreadsheet attached as requested.
Attachments
spreadsheet_lines.7z
(6.88 KiB) Downloaded 186 times

User avatar
Tracker Supp-Stefan
Site Admin
Posts: 13430
Joined: Mon Jan 12, 2009 8:07 am
Location: London
Contact:

Re: Problem with cell borders - Excel 2010

Post by Tracker Supp-Stefan » Wed Dec 14, 2011 4:11 pm

Thanks for the sample Bob,

I managed to reproduce your problem. When using the office add-in button - dashed line instead of a single continuous one, and when printed via File -> Print - the expected thin line.

However both in the main excel window, and in the print preview - Excel is displaying this dashed line, so I presume it's something else that excel is doing at print time that causes this difference (check the attached files).

I will now discuss this with my colleagues to see if we can give any further advise.

Best,
Stefan
Attachments
excel.zip
(139.49 KiB) Downloaded 190 times

User avatar
Tracker Supp-Stefan
Site Admin
Posts: 13430
Joined: Mon Jan 12, 2009 8:07 am
Location: London
Contact:

Re: Problem with cell borders - Excel 2010

Post by Tracker Supp-Stefan » Wed Dec 14, 2011 4:45 pm

Hello Bob,

After discussing this further - it turns out to be a DPI issue. When the add-in is working inside Excel - it only has access to what excel has already rendered - and for displaying purposes excel uses just 96 DPI - so when the add-in converts your line - it uses the 96 DPI resolution and the "dotted" line excel uses in substitution of the expected thin one. There is no way to make excel increase that - so for this kind of file you will need to use the File -> Print I am afraid.

Best,
Stefan

BobM
User
Posts: 91
Joined: Thu Feb 14, 2008 11:28 am

Re: Problem with cell borders - Excel 2010

Post by BobM » Wed Jan 04, 2012 9:43 am

Thanks for identifying the cause.

It appears there is a similar issue with MSWord 10. I copied the Excel table from the previous spreadsheet to Word then minimised the internal linewidths, see attachment.

The differences between pdfs produced via the PDFX options and the Word "Create a PDF/XPS" are also shown.
FTR although the PDFX print driver output came close, it wasn't quite as good as the Word generated pdf.
Attachments
subject.7z
(96.62 KiB) Downloaded 167 times

Jamie - Tracker Supp
User
Posts: 207
Joined: Thu Jun 02, 2011 3:23 pm

Re: Problem with cell borders - Excel 2010

Post by Jamie - Tracker Supp » Wed Jan 04, 2012 4:50 pm

:)

John - Tracker Supp
Site Admin
Posts: 8202
Joined: Tue Jun 29, 2004 10:34 am
Location: Vancouver Island - Canada
Contact:

Re: Problem with cell borders - Excel 2010

Post by John - Tracker Supp » Thu Jan 05, 2012 1:16 am

Hi,

I think maybe Jamie missed the point of your final comment and sample ...

The PDF-XChange drivers are in the process of complete rewrite/revision and these will be released in late March/April - once released I believe you will see major positive changes in many area's to the conversion process including the example you provide - perhaps when released you can test again and advise if this as expected.

Many thanks.
If posting files to this forum - you must archive the files to a ZIP, RAR or 7z file or they will not be uploaded - thank you.

Best regards
Tracker Support
http://www.tracker-software.com

BobM
User
Posts: 91
Joined: Thu Feb 14, 2008 11:28 am

Re: Problem with cell borders - Excel 2010

Post by BobM » Thu Jan 05, 2012 7:46 am

That's good to know - thanks John.

John - Tracker Supp
Site Admin
Posts: 8202
Joined: Tue Jun 29, 2004 10:34 am
Location: Vancouver Island - Canada
Contact:

Re: Problem with cell borders - Excel 2010

Post by John - Tracker Supp » Thu Jan 05, 2012 5:13 pm

Pleasure Bob :)
If posting files to this forum - you must archive the files to a ZIP, RAR or 7z file or they will not be uploaded - thank you.

Best regards
Tracker Support
http://www.tracker-software.com

Post Reply