1. 

   bushraj, Member

   Hey,

   I want to export my report in Excel and I don't want the large data columns text to be wrapped. How can I do it in Excel export?

   Thanks.
2. 

   myDBR Team, Key Master

   Do you have wrapping set on for the columns in the report?

   --
   myDBR Team
3. 

   bushraj, Member

   I have set the style [white-space: wrap;] on those columns ? Will it work?
   I want all the columns in my excel sheet with NO wrapping
4. 

   myDBR Team, Key Master

   While myDBR converts some of the CSS commands into Excel, all CSS commands simply do not apply in Excel.

   To make sure no wrapping is done please make sure you do not have linefeeds in your data as Excel will use linefeeds within the cell.

   --
   myDBR Team
5. 

   bushraj, Member

   How can i remove thousand separator when exporting the report in excel.. I have successfully it from HTML report but when i m exporting it in excel it shows the number as 1,098 ? How can i remove it like 1098?
6. 

   myDBR Team, Key Master

   The thousad separator has a server (Environment settings) and user preference (Preferences).

   This will affect the normal report display and PDF exports. Excel thousand separator formatting is determined by Excel itself.

   --
   myDBR Team
7. 

   bushraj, Member

   So there is no way to remove it?
8. 

   myDBR Team, Key Master

   Run the updater to get the latest build. If will format Excel numbers wihtout thousand separator if no separator is defined in settings.

   --
   myDBR Team
9. 

   bushraj, Member

   Yea done thanks a lot!

Reply

You must log in to post.