Adding white spaces in imported data.

Discuss the database features

Adding white spaces in imported data.

Postby clausisme » Wed Oct 02, 2019 11:30 am

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.
OpenOffice 4.01 on Windows 7
clausisme
 
Posts: 24
Joined: Fri Mar 28, 2014 3:23 pm

Re: Adding white spaces in imported data.

Postby UnklDonald418 » Thu Oct 03, 2019 8:53 pm

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.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.8 & LibreOffice 6.4.7.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1362
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Adding white spaces in imported data.

Postby clausisme » Fri Oct 04, 2019 8:46 am

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.
OpenOffice 4.01 on Windows 7
clausisme
 
Posts: 24
Joined: Fri Mar 28, 2014 3:23 pm

Re: Adding white spaces in imported data.

Postby Villeroy » Fri Oct 04, 2019 12:30 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28851
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Base

Who is online

Users browsing this forum: No registered users and 6 guests