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, Chris - Tracker Supp, Sean - Tracker, Tracker Supp-Stefan

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

Problem with cell borders - Excel 2010

Post by BobM »

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 272 times
User avatar
Tracker Supp-Stefan
Site Admin
Posts: 17820
Joined: Mon Jan 12, 2009 8:07 am
Location: London
Contact:

Re: Problem with cell borders - Excel 2010

Post by Tracker Supp-Stefan »

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: 102
Joined: Thu Feb 14, 2008 11:28 am

Re: Problem with cell borders - Excel 2010

Post by BobM »

Spreadsheet attached as requested.
Attachments
spreadsheet_lines.7z
(6.88 KiB) Downloaded 275 times
User avatar
Tracker Supp-Stefan
Site Admin
Posts: 17820
Joined: Mon Jan 12, 2009 8:07 am
Location: London
Contact:

Re: Problem with cell borders - Excel 2010

Post by Tracker Supp-Stefan »

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 277 times
User avatar
Tracker Supp-Stefan
Site Admin
Posts: 17820
Joined: Mon Jan 12, 2009 8:07 am
Location: London
Contact:

Re: Problem with cell borders - Excel 2010

Post by Tracker Supp-Stefan »

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: 102
Joined: Thu Feb 14, 2008 11:28 am

Re: Problem with cell borders - Excel 2010

Post by BobM »

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 256 times
Jamie - Tracker Supp
User
Posts: 191
Joined: Thu Jun 02, 2011 3:23 pm

Re: Problem with cell borders - Excel 2010

Post by Jamie - Tracker Supp »

:)
User avatar
John - Tracker Supp
Site Admin
Posts: 5219
Joined: Tue Jun 29, 2004 10:34 am
Location: United Kingdom
Contact:

Re: Problem with cell borders - Excel 2010

Post by John - Tracker Supp »

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: 102
Joined: Thu Feb 14, 2008 11:28 am

Re: Problem with cell borders - Excel 2010

Post by BobM »

That's good to know - thanks John.
User avatar
John - Tracker Supp
Site Admin
Posts: 5219
Joined: Tue Jun 29, 2004 10:34 am
Location: United Kingdom
Contact:

Re: Problem with cell borders - Excel 2010

Post by John - Tracker Supp »

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