Re: BigGridDemo for a RichText

2016-10-03 Thread Ratna
Could you please specify the XML format for each cell,as mine is not working http://schemas.openxmlformats.org/spreadsheetml/2006/main";> Title% ChangeRatioExpensesDate Blue Widget VK My requirement is like in one cell "Blue Widget" with murltiple tesxt style,remaining three cells with

Re: Problem opening Excel files

2016-10-03 Thread Fende
Thank you for your comment but it is not a problem of format. I have a number about fourteen million, and we use the default format. If you check the value of the cell when is open in a bad way you only can see the first digit, i.e. "1". The format string of the cell is something similar to #.

Rich text string implementation in Biggriddemo

2016-10-03 Thread Ratna
Could you please specify the XML format for each cell,as mine is not working http://schemas.openxmlformats.org/spreadsheetml/2006/main";> Title% ChangeRatioExpensesDate Blue Widget VK My requirement is like in one cell "Blue Widget" with murltiple tesxt style,remaining three cells with

Re: BigGridDemo for a RichText

2016-10-03 Thread Nick Burch
On Sun, 2 Oct 2016, Ratna wrote: Could you please specify the XML format for each cell,as mine is not working Don't use BigGridDemo any more! You should use SXSSF instead Nick - To unsubscribe, e-mail: user-unsubscr...@poi.ap

Re: BigGridDemo for a RichText

2016-10-03 Thread Ratna
As RICH text string wont work it out in SXSSF,i came back to biggriddemo,do u have any sample xml,please attach it for rich textstring -- View this message in context: http://apache-poi.1045710.n5.nabble.com/BigGridDemo-for-a-RichText-tp3412641p5724967.html Sent from the POI - User mailing list

Re: BigGridDemo for a RichText

2016-10-03 Thread Ratna
Hi Nick, I will explain the issue i faced,kindly take a look and suggest me. We need an java export for nearly 1lakh records,in which in one cell in the worksheet needs a multiple styling text(Say for example - "BLUE WIDGET"- Blue in bold and Red color,widget in green color). As i implemented S