I am new to the list.
I am also having a problem with this. I am using this Java code in an
attempt to set Color but it does not work.
/**
* Creates a cell and aligns it a certain way.
*
* @param wb the workbook
* @param row the row to create the cell in
* @param i the column number to create the cell in
* @param halign the horizontal alignment for the cell.
*/
private void createCell(Workbook wb, Row row, int i, short halign,
short
valign, int value) {
CreationHelper ch = wb.getCreationHelper();
DataFormat format = wb.createDataFormat();
Cell cell = row.createCell(i);
cell.setCellValue(value);
CellStyle cellStyle = wb.createCellStyle();
cellStyle.setDataFormat(format.getFormat("###0"));
cellStyle.setFillBackgroundColor(IndexedColors.DARK_BLUE.getIndex());
cellStyle.setFillForegroundColor(IndexedColors.DARK_BLUE.getIndex());
cellStyle.setAlignment(halign);
cellStyle.setVerticalAlignment(valign);
cell.setCellStyle(cellStyle);
}
Christopher Schene
Field Engineer, Solution Delivery
41ST PARAMETER
A part of Experian
www.the41st.com
[email protected]
+1 602.290.9792 mobile
On 4/15/15, 7:09 AM, "Dominik Stadler" <[email protected]> wrote:
>Hi,
>
>Glad that it works, seems multiple people stumbled over this recently,
>the fix will be included in the next released binaries, either
>3.12-beta2 or 3.12 final, whichever comes first, we have not decided
>yet.
>
>The fixes were done as part of Bug 56295, SVN changes can be seen at
>https://svn.apache.org/viewvc?view=rev&rev=1666736
>
>Thanks... Dominik.
>
>On Wed, Apr 15, 2015 at 11:16 AM, Pankaj <[email protected]> wrote:
>>
>> Hi,
>>
>> Thanks a ton for your response. Results looks good with test file I was
>> working with. Do you know which stable release would have this
>>particular
>> fix ? And can I know the bug ID to look at the code fix/snippet of the
>>fix.
>>
>> Thanks,
>> Pankaj
>>
>>
>>
>> --
>> View this message in context:
>>http://apache-poi.1045710.n5.nabble.com/Background-Color-for-XLSX-Files-w
>>hen-usinng-Indexed-Automatic-tp5718484p5718490.html
>> Sent from the POI - User mailing list archive at Nabble.com.
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [email protected]
>For additional commands, e-mail: [email protected]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
