Forum

Notifications
Clear all

Formatting of Reports - lost when emailed.

3 Posts
3 Users
0 Reactions
143 Views
(@mareepiksters-com)
Posts: 19
Eminent Member
Topic starter
 

Hello!

I'm having trouble with excel reports I've made holding their formatting when sending to others in the office via email.

They are getting #### in columns or titles are moving to the next line, when from my perspective what I'm viewing and saving it looks correct? How can you hold the formatting so that it looks the same when they open it - besides sending a PDF?My-view.PNGDeans-view.PNG

In this example the column width I have is 9.27 (109 pixels) whereas when opened on my colleagues computer it is only 9.14?

I've been using excel for many years and this is the first time I've been faced with this problem... I'm feeling like a rookie!

Any advice will be much appreciated?

Thank you

Maree

Screen shot example attached (the 'y' and 'g' are going on the next line)

 
Posted : 19/08/2019 10:25 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Maree,

It could be lots of factors contributing to the resizing e.g. screen resolution, zoom level etc. which are out of your control. I would just take a screenshot and paste it as an image if you don't want it resized.

Mynda

 
Posted : 20/08/2019 1:21 am
Anders Sehlstedt
(@sehlsan)
Posts: 971
Prominent Member
 

Hello,

First I want to share a link to a page that describes how column width is determined in Excel.

Now some questions.

1) What file format is used? The old .xls or the new .xlsx format?

I have seen similar posts where this issue occurs with .xls format but not with .xlsx.

2) Does all users have the same font library? In case a non-standard font is used.

3) If none above makes any difference and in regards to font issues, do test with changing the default printer.

 
Posted : 20/08/2019 1:27 am
Share: