Jump to content
Changes to the Jaspersoft community edition download ×

Field separator when exporting to EXcel

2004 IR Help

Recommended Posts

By: marco mistroni - mmarcom

Field separator when exporting to EXcel

2005-12-30 03:45

hello all,

i am having problems with my reports.

I am exportng my reports in Excel format, and i have users from both UK and Denmark.

The problem that i am experiencing is how to set the field delimiter when exporting to Excel..

In UK, field separator is ',' which is understood by Excel so it outputs proper columns.

In denmark, the field separator should be ';'

for some reasons, when exporting my report hte field separator is always the same, ',', so report will looks fine in UK but it won't be undrstood by excel in Denmark.

Can anyone tell me how can i set the field separator dependign on the Locale?


thanks in advance and regards


Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...