I have this document I exported from a spreadsheet. It appears to be all double spaced.
But none of the fixes I found would fix it.
When I finally looked at the formatting marks it appears what’s going on is the lines are too long… and they wrap around to make a next line. There’s just arrows, you know? pointing to the right…?
How do I fix that/
Better describe your problem, maybe with a screenshot. Don’t forget to mention your OS and LO version.
Arrows in formatting marks stand for Tab characters. If you copied/pasted/imported from a spreadsheet, this is a representation of empty columns.
If you don’t use this information to align data at some position, have you tried Find & Replace
in Regular expressions mode? \t
, i.e. reverse solidus + letter “t”, is an encoding for Tab
Hmm. Maybe I made a mistake in the orginal export from the spreadsheet then.
I haven’t tried find and replace. I’ll look into it. Bit sudden. I didn’t expect a response tonight.
I fixed it.
Well not really. I went back and did a proper export from the spreadsheet and that avoided it.
The text spanned numerous columns and I defined the print area across all those columns.
But of course that was wrong.
I needed to simply expand the column with the ‘long text’ to where it included all the text and then define that print area.
I did put up a screenshot but I’ve removed it because really it was personal data.
I’ll nominate it answered. Because you did provide the answer - it was all those un-needed columns.
thanks. now finished for the day. well done.