B4Print.com

Applications => The Rest... => Topic started by: Joe on March 16, 2018, 09:21:35 AM

Title: Excel stuff
Post by: Joe on March 16, 2018, 09:21:35 AM
This site looks like a good place for Excel info should you need it.

https://chandoo.org/wp/
Title: Re: Excel stuff
Post by: DigiCorn on November 06, 2019, 02:02:56 PM
Where the fuck does the damned PDF go when you print to PDF? Can't find it anywhere and save to PDF doesn't work - file is all FUBAR

on Mac OS
Title: Re: Excel stuff
Post by: DigiCorn on November 06, 2019, 02:34:48 PM
figured out a work around. that was stressful - had a guy waiting on it and nothing else was working for what he wanted other than the print to pdf. I did all the same procedures, but instead of print to pdf, i hit preview in preview, and then exported the pdf from there. it got what we wanted. save as pdf was making weird page breaks and not doing what was intended.
Title: Re: Excel stuff
Post by: Tracy on November 07, 2019, 11:27:51 AM
under view select normal
and under page setup select fit to 1 page
Title: Re: Excel stuff
Post by: DigiCorn on November 07, 2019, 11:43:17 AM
yeah - unfortunately for this project, that was not working. Even zamzar messed it up... I got an 11" wide x 1000" long document, 1 single page. It was a long-ass spreadsheet that was supposed to be 118 pages, 11" x 8.5".
Title: Re: Excel stuff
Post by: Tracy on November 07, 2019, 12:01:07 PM
Ah! well that doesn't work then
did you try to change under view?

excel is something I have to fight too sometimes!!
Title: Re: Excel stuff
Post by: DigiCorn on November 07, 2019, 01:55:13 PM
The document had "defined" page breaks, for whatever that is worth, and I selected and defined the print area, but it kept redefining and splitting up the document, so instead of 118 pages, I'd get like 600+ pages or something. The only way it would run 118 pages as defined was printing as a pdf... then it would write a file 118 pages long, but I don't know where the file ends up. That's why I clicked preview in preview and then exported from there.