I’d like to maintain the same header and footer test sizes across multiple sheets, and have the text in the print range shrink as necessary to fit on a single page.
It that possible in Calc? (The application is creating lyric sheets.)
In Excel this can be done with an option to scale, or in my use case not scale, the header and footer with the document. Is there an equivalent in Calc or another method?
Reduce the lyrics text size and columns width.
As a workaround, you can set the cell formatting to [x] Shrink to fit cell size, and change the column width in the print preview. But you will get different text sizes.
It is better to work with Writer (and columns, or tables) for that.
Many thanks for your response, but that’s what I’m trying to avoid.
My standard text font for the lyrics is Verdana 18pt and they sit centered in 40pt high rows. I can reduce the height of blank rows in between verses and/or choruses and bridges to give a bit of sense to the song’s structure.
And if there are a lot of lyrics I can move some of them to a second column, but position them to vertically align (for example) the 3rd verse in the 2nd column with the 2nd verse in the first column.
Most of my experience is in spreadsheets, so I admit I’m biased, but I find this much easier in a spreadsheet than in a word processor.
I’ll try to upload a couple of examples if the forum allows me as a new user.
Again, many thanks for your input.
As you attach only some .pdf to show what you want to achieve, I’m lost again with the question for what you Insist on using Calc instead of Writer.
Writer allows for well formatted headers and footers while in Calc only exists something with the same name, but much less functionality.
Also I suppose you derived the .pdf from some primary document. Why didn’t you attach that, too?
Accepting a few retrictions you can also give shape to a Writer page using a TextTable…
If the original “data source” is a spreadsheet, you can even embed it as an OLE object …
Many thanks for your reply.
Basically I’m trying to replicate what I do in Excel (and I’m using the 2007 version, I think, in Win10) and I’d love to move all my Excel work into Calc, so even if new work in Writer is an option, the large body of existing work needs to remain in a spreadsheet.
I’ll try to check out your two suggestions.
Edit: The two pdfs that I attached were exports from two Excel files which both contain a much larger number of lyric sheets. They were only intended as examples of the format want to preserve.
Please upload examples of your Excel files in Excel format (.xlsx).
This xlxs file has the Excel worksheets from which the two pdfs were created.
(pdfs were created using pdfFactory.)
LO example 250505.xlsx (20.5 KB)
tdf#57202 : FORMATTING: Make Header/footer font size independent from scaling of the sheets.
You can “vote” to increase the priority of consideration of this “bug” by the developers by adding yourself to the CC List (I did this).
Thank you for the link to that “bug” report.
I read through the discussion and found the CC list, but could you tell me how I can add myself to the list?
CC List: Add me to CC list
Do you have an account at the site?
Are you logged in?