Ask Your Question

Column line wrapping

asked 2017-03-23 00:30:19 +0200

SeaSea gravatar image

updated 2017-03-23 00:56:22 +0200

EasyTrieve gravatar image

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?

edit retag flag offensive close merge delete


@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?

EasyTrieve gravatar imageEasyTrieve ( 2017-03-23 00:54:09 +0200 )edit

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

SeaSea gravatar imageSeaSea ( 2017-03-23 08:50:41 +0200 )edit

2 Answers

Sort by ยป oldest newest most voted

answered 2017-03-23 05:49:34 +0200

Mike Kaganski gravatar image

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.

edit flag offensive delete link more

answered 2017-03-23 09:24:09 +0200

EasyTrieve gravatar image

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.

edit flag offensive delete link more


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 ๐Ÿ˜€๐Ÿ˜€๐Ÿ˜€

SeaSea gravatar imageSeaSea ( 2017-03-23 10:58:24 +0200 )edit
Login/Signup to Answer

Question Tools



Asked: 2017-03-23 00:30:19 +0200

Seen: 93 times

Last updated: Mar 23 '17