Page 1 of 1

Adding white spaces in imported data.

PostPosted: Wed Oct 02, 2019 11:30 am
by clausisme
I import some addresses from a open office calc spreadsheet. And sometimes I want to add a space or two so they get a nicer alignment in the final rapport. But adding mare spaces in the spreadsheet doesn't produce more spaces in the rapport.
I tried Insert>Formatting Mark>Non break space , no luck.

Re: Adding white spaces in imported data.

PostPosted: Thu Oct 03, 2019 8:53 pm
by UnklDonald418
It isn't clear from your question what you are using to generate the report.
If you are using the standard report writer built into OO Base then I would recommend installing the Oracle Report Builder extension. It provides much better control.
https://extensions.openoffice.org/en/project/oracle-report-builder
Several years ago Libre Office replaced the old report writer with ORB as the default report writer.
Have you tried printing directly from the spreadsheet? Sometimes that works even better than the ORB.

Re: Adding white spaces in imported data.

PostPosted: Fri Oct 04, 2019 8:46 am
by clausisme
Yes I have oracle report builder
I just want the double spaces that I have in my spreadsheet present in my report fields.
I don't know why it only shows a maximum of one space.
"Andrew,[space][space]Nr.24" becomes "Andrew,[space]Nr.24" no mater what I do.

Re: Adding white spaces in imported data.

PostPosted: Fri Oct 04, 2019 12:30 pm
by Villeroy
I tried to add a double space by means of a sheet formula, a query and calculated report field. It seems that the report engine corrects double spaces automatically and intentionally. If this is a matter of readability, you should play with different fonts and spacing. Open the report for editing, get the text box properties and click the ellipsis button next to the font.