Lay My Hat home page Lay My Hat Forum
The forum for holiday rental owners


 
  FAQFAQ    SearchSearch    MemberlistMemberlist   UsergroupsUsergroups    RegisterRegister  
  ProfileProfile    Log in to check your private messagesLog in to check your private messages    Log inLog in 

Converting excel to pdf

 
Post new topic   Reply to topic    Lay My Hat Forum Index -> The Workshop
View previous topic :: View next topic  
Author Message
annedab



Joined: 18 Oct 2005
Posts: 761
Location: Midi Pyrenees

PostPosted: Wed Nov 11, 2015 12:10 pm    Post subject: Converting excel to pdf Reply with quote

We have always shown our availability on our PMP site by using a clickable link that opens a pdf of the calendar(s). Always very simple and straightforward. I am just doing the 2016 calendars and they look fine in excel, but as soon as I convert them to PDF they look nothing like the excel spreadsheet Shocked Never had this before, can anyone tell me what I (or my laptop) am doing wrong or how I can fix it?

TIA
_________________
Regards

Anne

If there's no such thing as co-incidence, then why is there a word for it?
Back to top
View user's profile Send private message
kevsboredagain



Joined: 20 Jan 2007
Posts: 3209
Location: France

PostPosted: Wed Nov 11, 2015 5:50 pm    Post subject: Reply with quote

Without knowing the version of Excel and what features you have in your spreadsheet, it's difficult, if not impossible to know what your problem is.

Forgive me for stating the obvious question but why not simply embed a visible calendar into your PMP like all the other users of PMP? You have to really read the instructions carefully on your site to find where you've hidden the calendar, something which many people will simply miss.
_________________
www.samoensalpineholiday.com
www.websiteproud.com
Back to top
View user's profile Send private message Visit poster's website
CSE



Joined: 06 Nov 2006
Posts: 4292
Location: Galicia

PostPosted: Wed Nov 11, 2015 6:06 pm    Post subject: Reply with quote

loads of ways detailed on line.
http://www.wikihow.com/Convert-Excel-to-PDF
https://online2pdf.com/convert-excel-to-pdf
http://www.zamzar.com/convert/xls-to-pdf/
_________________
Never try to out-stubborn your guests.
Back to top
View user's profile Send private message
kevsboredagain



Joined: 20 Jan 2007
Posts: 3209
Location: France

PostPosted: Wed Nov 11, 2015 6:16 pm    Post subject: Reply with quote

casasantoestevo wrote:
loads of ways detailed on line.
http://www.wikihow.com/Convert-Excel-to-PDF
https://online2pdf.com/convert-excel-to-pdf
http://www.zamzar.com/convert/xls-to-pdf/


The recent versions require no 3rd party applications. It's just a "save as" and chose PDF.
_________________
www.samoensalpineholiday.com
www.websiteproud.com
Back to top
View user's profile Send private message Visit poster's website
e-richard



Joined: 17 Oct 2004
Posts: 5009
Location: Algarve, Portugal

PostPosted: Wed Nov 11, 2015 6:22 pm    Post subject: Reply with quote

kevsboredagain wrote:
The recent versions require no 3rd party applications. It's just a "save as" and chose PDF.

And just to confuse us all, when you reach Windows 10, its changed to File > Export > Create PDF Confused

Of course, this still does not help Annedab, but helps illustrate why more info is needed before we can assist.
_________________
** Richard
PIMS: Holiday Rental Management system
They say we learn from our mistakes. That makes me a genius !
Back to top
View user's profile Send private message Visit poster's website
CSE



Joined: 06 Nov 2006
Posts: 4292
Location: Galicia

PostPosted: Thu Nov 12, 2015 12:11 am    Post subject: Reply with quote

Quote:
The recent versions

How recent?. Asking out of curiosity as we do not use Windoze products other than operating system.
_________________
Never try to out-stubborn your guests.
Back to top
View user's profile Send private message
annedab



Joined: 18 Oct 2005
Posts: 761
Location: Midi Pyrenees

PostPosted: Thu Nov 12, 2015 7:45 am    Post subject: Reply with quote

Thanks everyone - I just needed a short term fix for yesterday while I am looking at the embedded calendar options. It seems to be my laptop that is the problem - everything worked as normal using OH's - go figure!!

Kev, the reason I did it the clunky roundabout way in the first place is that we have 2 gites and 2 B&B rooms so I need to display more than one lot of availability. Are there any calendars out there that will easily display three individual lines of availability rather than having three calendars? Bear in mind that anything technical starts to sound like gobbledegook to me after the first two words Laughing
_________________
Regards

Anne

If there's no such thing as co-incidence, then why is there a word for it?
Back to top
View user's profile Send private message
annedab



Joined: 18 Oct 2005
Posts: 761
Location: Midi Pyrenees

PostPosted: Thu Nov 12, 2015 10:01 am    Post subject: Reply with quote

All sorted - have managed to add a calendar that shows all our availability at once Cool Still don't know why my PDFs aren't displaying properly, but as I don't need them now, that problem can go back down the list.
_________________
Regards

Anne

If there's no such thing as co-incidence, then why is there a word for it?
Back to top
View user's profile Send private message
kevsboredagain



Joined: 20 Jan 2007
Posts: 3209
Location: France

PostPosted: Thu Nov 12, 2015 1:09 pm    Post subject: Reply with quote

casasantoestevo wrote:
Quote:
The recent versions

How recent?. Asking out of curiosity as we do not use Windoze products other than operating system.


Since 2010 I think. Before that it used a PDF print service so you printed the document and chose the PDF service.
_________________
www.samoensalpineholiday.com
www.websiteproud.com
Back to top
View user's profile Send private message Visit poster's website
CSE



Joined: 06 Nov 2006
Posts: 4292
Location: Galicia

PostPosted: Thu Nov 12, 2015 5:01 pm    Post subject: Reply with quote

That long ago recent. Embarassed
Thanks for the info.
_________________
Never try to out-stubborn your guests.
Back to top
View user's profile Send private message
kevsboredagain



Joined: 20 Jan 2007
Posts: 3209
Location: France

PostPosted: Thu Nov 12, 2015 6:56 pm    Post subject: Reply with quote

annedab wrote:


Kev, the reason I did it the clunky roundabout way in the first place is that we have 2 gites and 2 B&B rooms so I need to display more than one lot of availability. Are there any calendars out there that will easily display three individual lines of availability rather than having three calendars? Bear in mind that anything technical starts to sound like gobbledegook to me after the first two words Laughing


I see you've already found Dateblocker, which is one I used to use. You need to ask a fellow PMP how to embed this as an iframe so that it appears on your own web page, instead of jumping away from your site.
_________________
www.samoensalpineholiday.com
www.websiteproud.com
Back to top
View user's profile Send private message Visit poster's website
Hells Bells



Joined: 30 Apr 2005
Posts: 13182
Location: French Alps

PostPosted: Thu Nov 12, 2015 10:06 pm    Post subject: Reply with quote

go to the 'edit website content' page and choose the page where you wish to display the calendar. From the Tools menu select 'Insert HTML snippet'. Copy the 'Embedded iframe' code from Dateblocker and paste into the box, then click OK. Finally, click 'Save' to put it onto the page.
Back to top
View user's profile Send private message Visit poster's website
annedab



Joined: 18 Oct 2005
Posts: 761
Location: Midi Pyrenees

PostPosted: Fri Nov 13, 2015 8:30 am    Post subject: Reply with quote

Thanks Kev Smile I wasn't sure which option was the best - I'll change it over today. Got too excited abut blocking off dates for when we are on holiday Cool
_________________
Regards

Anne

If there's no such thing as co-incidence, then why is there a word for it?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Lay My Hat Forum Index -> The Workshop All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group