I am trying to print a spreadsheet with 66 columns. I would like to wrap each row to print so row 1 would be 6 lines of 10 cells. Is this possible?
@SeaSea, Could you please edit your question again, because it doesn’t seem to make sense. I get that your spreadsheet has 66 columns and that you want to wrap it, to possibly fit on one page. But when you say, “so row 1 would be 6 lines of 10 cells”, what do you mean by that? Do you mean wrapping row1 to 6 lines tall?
Yes thank you, late and tired I was struggling to explain. I have tried to fit to 1 page width but it just makes the cells tiny
OP wants that each row (consisting of 66 cells) be output as a “string” of those 66 cells which (line) is wrapped by breaking between cells (yes, there’s also arithmetic error like 66 = 6x10). This is impossible using LO Calc, unless you somehow restructure the cells to actually consist of say 10 columns, e.g. by a macro creating a new sheet with output formatted for print.
You can create a 2nd sheet used just for printing, that points to (gets its data from) the first sheet as follows:
original → new
a1 → a1
a2 → a2
a3 → a3
a4 → a4
a5 → a5
a6 → a6
a7 → b1
a8 → b2 etc
…
b1 → f1
b2 → f2 …
For a small limited number of rows this could be done by hand, but am guessing a macro is where it’s at for this job.
Thanks that might work with a macro as I have 300 rows to do and I could save it as a template for future use 