× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



The first thing I **notice** that's wrong about your message (besides the
fact that POI is not "Scott's") is that you do not have a return value on:
hssf_merge( hssfsheet : mergerf : mergecf : mergert : mergect );

That return value would be something that you need to pass in to your "set
cell style" routines. There are a number of parameter-passing issues in
your code, so my suggestion would be to go back and gain better
understanding at the fundamental level of what's going on here.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"If you look like your passport photo, you're too ill to travel."
-- Will Kommen

I am using Scotts POI. Im would like to create a merged area with
borders.
The following code is not producing a border around merged area. Any
suggestions?



mergerf = row#;

mergecf = 0;

mergert = row#;

mergect = 11;

hssf_merge( hssfsheet : mergerf : mergecf : mergert : mergect );

head1style = HSSFWorkbook_createCellStyle( HSSFWorkbook);

numfmt = 22;

currentFont = HSSFWorkbook_createFont( HSSFWorkbook);

HSSFCellStyle_setBorderBottom( head1style :border_thin);

HSSFCellStyle_setBordertop( head1style :border_thin);

HSSFCellStyle_setBorderleft( head1style :border_thin);

HSSFCellStyle_setBorderright( head1style :border_thin);

HSSFCellStyle_setVerticalAlignment( head1style : ALIGN_fill );

HSSFCellStyle_setFillForegroundColor(head1style: numfmt);

HSSFCellStyle_setFillPattern(head1style: PATTERN_1);

HSSFCellStyle_setAlignment( head1style :ALIGN_center);

HSSFCellStyle_setFont(head1Style:currentFont);

HSSFFont_setBoldweight(currentfont:BOLDWEIGHT_BOLD);

HSSFRow = HSSFSheet_createRow(hssfSheet:Row#);

HSSFRow_setHeight( HSSFRow : 410);

hssf_text( HSSFRow : 0 : 'Client heading' : head1style);

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.