1. 

   elb98rm, Member

   There's a bug when exporting to excel:

   It looks like there's a problem when you export special/reserved chars to excel.

   I have a column where the data can come up as something like:

   Multi Sports coach [<21]

   When you export to excel, this gets truncated to:

   Multi Sports coach [<

   I can make a work around for now, but the column name is correct: it should be <21.

   Cheers
   Rick
2. 

   myDBR Team, Key Master

   We'll take a look at it. Thanks for reporting the issue.

   --
   myDBR Team
3. 

   myDBR Team, Key Master

   You can run the updater to get the latest build.

   If you wish to use "Multi Sports coach [<21]" as a column title use dbr.column.title-command.

   --
   myDBR Team
4. 

   elb98rm, Member

   It's a returned value I'm afraid. :(
5. 

   myDBR Team, Key Master

   You can use dbr.column.title-command, even if the column title comes from the data:

   select 'dbr.column.title', 'titlecolumn', value
   from mydata;

   --
   myDBR Team
6. 

   elb98rm, Member

   Hi, apologies for the late response: Was working on other aspects of the projects.

   I think there's some misunderstanding here:

   "Multi Sports coach [<21]" is a returned value, not a header. By this I mean the column in question is:

   Role
   ----
   Play leader
   Multi Sports coach [<21]
   Multi Sports coach [21+]
   ...

   So, the DATA is .. [<21], so I don't think I can affect that with the header function. If I can - please let me know how.

   Cheers
7. 

   myDBR Team, Key Master

   This should work in latest builds.

   --
   myDBR Team

Reply

You must log in to post.