You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by Avik Sengupta <av...@itellix.com> on 2003/02/07 13:23:24 UTC

Re: Setting Background Color for Entire Row

Well, it is possible... if someone gets down to it. 

(Moving to dev list)
In ROWRECORD

set 8th bit of option flags (byte offset 16 - grbit) to 1
and set the index of an XF record in at byte offset 18-20 (ixfe)

On Fri, 2003-02-07 at 07:04, Calvin Cheung wrote:
> I would like to know if there is a way to set the background color for an entire row?
> 
> Is it possible to add such method to the HSSFRow object?
> 
> If there is currently no way to accomplish such task, is this feature planned in future releases?
> 
> Calvin



Re: [OT] Html Excel Generation

Posted by Avik Sengupta <av...@apache.org>.
All i can think of is to check in your server (access) logs which url is
actually getting called (and how many times). Other than that,
absolutely no clue :)

On Sun, 2003-02-09 at 03:38, Danny Mui wrote:
> Hey fellow excel report people!
> 
> I have a question for veterans of  HTML->Excel generation (for those 
> unfortunately not able to use poi :( ).
> 
> When building mult-sheet workbooks, I keep getting "Some of the files in 
> this Web page aren't in the expected location" prompt.  
> 
> workbook url:
> 
> /ReportServlet/workbook.html?REPORT_PAGE=/report.jsp
> 
> worksheets:
> 
> /ReportServlet/sheet.html;jsessionid=3222232?REPORT_PAGE=/sheet1.jsp
> /ReportServlet/sheet2.html;jsessionid=3222232?REPORT_PAGE=/sheet2.jsp
> 
> Anybody have any pointers, googling yields scant information.
> 
> Sharing is caring.
> 
> danny
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 




[OT] Html Excel Generation

Posted by Danny Mui <da...@muibros.com>.
Hey fellow excel report people!

I have a question for veterans of  HTML->Excel generation (for those 
unfortunately not able to use poi :( ).

When building mult-sheet workbooks, I keep getting "Some of the files in 
this Web page aren't in the expected location" prompt.  

workbook url:

/ReportServlet/workbook.html?REPORT_PAGE=/report.jsp

worksheets:

/ReportServlet/sheet.html;jsessionid=3222232?REPORT_PAGE=/sheet1.jsp
/ReportServlet/sheet2.html;jsessionid=3222232?REPORT_PAGE=/sheet2.jsp

Anybody have any pointers, googling yields scant information.

Sharing is caring.

danny


Re: Setting Background Color for Entire Row

Posted by "Andrew C. Oliver" <ac...@apache.org>.
I love hearing people talk like that! :-)
Isn't this fun?

Calvin, put in an RFE and vote for it.  I'm sure we'll get to it at some 
point.  We're all a little taxed right now.

-andy

Avik Sengupta wrote:
> Well, it is possible... if someone gets down to it. 
> 
> (Moving to dev list)
> In ROWRECORD
> 
> set 8th bit of option flags (byte offset 16 - grbit) to 1
> and set the index of an XF record in at byte offset 18-20 (ixfe)
> 
> On Fri, 2003-02-07 at 07:04, Calvin Cheung wrote:
> 
>>I would like to know if there is a way to set the background color for an entire row?
>>
>>Is it possible to add such method to the HSSFRow object?
>>
>>If there is currently no way to accomplish such task, is this feature planned in future releases?
>>
>>Calvin
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 
>