Recent

Author Topic: Excel stuff  (Read 1329 times)

0 Members and 1 Guest are viewing this topic.

Offline Joe

  • Master of Nothing
  • Administrator
  • Ninja Warlord
  • *****
  • Posts: 36956
  • Gender: Male
    • B4Print.com
Excel stuff
« 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/
Mac OS 10.14.6 Mojave | Prinergy 8.2 | Adobe Creative Cloud 2019 | Two Luscher XPose 160 CTP units

Prepress: One who does precision guess work based on unreliable data provided by those of questionable knowledge.

Offline DigiCorn

  • Terrorizing humans since 1971
  • Supreme Ninja
  • ***
  • Posts: 15030
  • Gender: Male
  • There is no Dana, only Zul!
    • Clerks.
Re: Excel stuff
« Reply #1 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
"Selling my soul would be a lot easier if I could just find it."
– Nikki Sixx

“Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut.”
― Ernest Hemingway

Offline DigiCorn

  • Terrorizing humans since 1971
  • Supreme Ninja
  • ***
  • Posts: 15030
  • Gender: Male
  • There is no Dana, only Zul!
    • Clerks.
Re: Excel stuff
« Reply #2 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.
« Last Edit: November 06, 2019, 04:37:48 PM by DigiCorn »
"Selling my soul would be a lot easier if I could just find it."
– Nikki Sixx

“Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut.”
― Ernest Hemingway

Offline Tracy

  • Ninja Master
  • **
  • Posts: 7722
  • Gender: Female
Re: Excel stuff
« Reply #3 on: November 07, 2019, 11:27:51 AM »
under view select normal
and under page setup select fit to 1 page

Offline DigiCorn

  • Terrorizing humans since 1971
  • Supreme Ninja
  • ***
  • Posts: 15030
  • Gender: Male
  • There is no Dana, only Zul!
    • Clerks.
Re: Excel stuff
« Reply #4 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".
"Selling my soul would be a lot easier if I could just find it."
– Nikki Sixx

“Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut.”
― Ernest Hemingway

Offline Tracy

  • Ninja Master
  • **
  • Posts: 7722
  • Gender: Female
Re: Excel stuff
« Reply #5 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!!

Offline DigiCorn

  • Terrorizing humans since 1971
  • Supreme Ninja
  • ***
  • Posts: 15030
  • Gender: Male
  • There is no Dana, only Zul!
    • Clerks.
Re: Excel stuff
« Reply #6 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.
"Selling my soul would be a lot easier if I could just find it."
– Nikki Sixx

“Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut.”
― Ernest Hemingway