Page margins

users
#1

In Libre 4.2.2.1 Mac version.
I have a five sheet Calc document and when I set the page margins to print
one sheet, the margins for the other sheets are also altered.
Should I list this as a bug?

Tink.

#2

Hi Tinkerer,

Tinkerer wrote (02-04-14 11:54)

In Libre 4.2.2.1 Mac version.
I have a five sheet Calc document and when I set the page margins to print
one sheet, the margins for the other sheets are also altered.
Should I list this as a bug?

No, it is common behaviour.
You can apply different page styles for different sheets. Pls see F11
and the Help for more info :slight_smile:

Cheers,

#3

This might be something to add to the list of differences between MSO and LO. This one drives me nuts frequently! As much as we all think LO is obviously the superior product, we do need to remember that most people will be coming to it from MSO and will want to know what to be watching out for.

Dave

#4

Are you quite sure that you can easily print different pages of the same sheet of a spreadsheet document with different page layouts (margins, orientation, etc.) in Microsoft Excel? If so, please tell us exactly how to do this. If not, you are apparently being weirdly "driven nuts" by a non-existent difference.

Perhaps you are confusing this with either printing different sheets of the same spreadsheet or printing different pages from the same text document in different layouts - both of which you can do very easily in LibreOffice.

Unless I've got this completely wrong, do please take care not to advertise a prejudice as if it were a genuine fault with the application which is the topic of this list.

Brian Barker

#5

Cor

I need to make frequent changes to the Page Format on the three Sheets that
I print from.
I cannot predetermine every change, so a change in the margins is the
simplest way out, or it would be if it remains with that sheet only.

BTW. Re. CT2N. Using Libre version 3, I was not able to add your suggestion
for the £ prefix as the Macro was in the Libre Macros. In version 4, the
macro is in "My Macros", so I was able to alter it.
It works great.
Many thanks.

Tink.

#6

I don't think the OP was talking about printing "different pages of the same sheet". He referred to changing margins of one "sheet" and having the margins for the other sheets be affected as well. In Excel I can change margins for only one sheet (or tab) just by going to |File|Page Setup>Margins>.

In Calc, I had to hunt to find where I'd done the same thing. It first appeared that I cold go to |File|Page Preview|Format Page|, and then select the |Organizer| tab and change the Style Name to something unique, then go to the |Page| tab and change my margins the way I want them. However, THAT FAILED because it just changed the name of the style that was already listed there.

SOLUTION:
Actually, once on the sheet you want to change, hit [F11] (or go to

Format>Styles and Formatting|) and then click the second icon (Page

Styles). The active Page style was highlighted (white text on a gray background). Then click on the next-to-last icon (New Style From Selection) and enter a new Style name, which adds that name to the list. Next, double-click on the new name to make it the style for the sheet you are on, then right-click on the new name and select |Modify|, which brings up the Page Style box. Make the changes you desire and click |OK|. Now, that sheet has a unique page style which will not affect any other sheets.

I hope this helps.

-- Tim

#7

Many thanks Tim, I'll try that later.

Tink.

#8

Hi Tinker,

Tinkerer wrote (02-04-14 20:15)

I need to make frequent changes to the Page Format on the three Sheets that
I print from.
I cannot predetermine every change, so a change in the margins is the
simplest way out, or it would be if it remains with that sheet only.

I would suggest to add more page-styles (right-click on the name in the
window Style and Formatting and choose New), and apply a different style
to each sheet (double click on the name with the desired sheet active).

BTW. Re. CT2N. Using Libre version 3, I was not able to add your suggestion
for the £ prefix as the Macro was in the Libre Macros. In version 4, the
macro is in "My Macros", so I was able to alter it.
It works great.
Many thanks.

Thanks for the compliments and happy to read that it helps. (there's a
list of wishes to implement in CT2N that I'm not able to work on for
some time already - alas).

Regards,
Cor

#9

Thank you Cor.
Your suggestion sounds a lot simpler.
Re CT2N. Let me know when you update it.

Best regards, Tink.