ASF Bugzilla – Attachment 22170 Details for
Bug 45260
Excel file unreadable due to applyFont()
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
Remember
[x]
|
Forgot Password
Login:
[x]
My code for initialising fonts and styles
initStyles.txt (text/plain), 7.01 KB, created by
Werner Schindling
on 2008-06-25 00:40:48 UTC
(
hide
)
Description:
My code for initialising fonts and styles
Filename:
MIME Type:
Creator:
Werner Schindling
Created:
2008-06-25 00:40:48 UTC
Size:
7.01 KB
patch
obsolete
>FONT = workbook.createFont(); >FONT.setFontName("Arial"); >FONT.setFontHeightInPoints((short) 10); >FONT_STRIKE = workbook.createFont(); >FONT_STRIKE.setFontName("Arial"); >FONT_STRIKE.setFontHeightInPoints((short) 10); >FONT_STRIKE.setStrikeout(true); > >FONT_ITALIC = workbook.createFont(); >FONT_ITALIC.setFontName("Arial"); >FONT_ITALIC.setFontHeightInPoints((short) 10); >FONT_ITALIC.setItalic(true); >FONT_ITALIC_STRIKE = workbook.createFont(); >FONT_ITALIC_STRIKE.setFontName("Arial"); >FONT_ITALIC_STRIKE.setFontHeightInPoints((short) 10); >FONT_ITALIC_STRIKE.setStrikeout(true); >FONT_ITALIC_STRIKE.setItalic(true); > >FONT_CELL_HEADER = workbook.createFont(); >FONT_CELL_HEADER.setFontName(FONT.getFontName()); >FONT_CELL_HEADER.setFontHeightInPoints((short) 10); >FONT_CELL_HEADER.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); >FONT_CELL_HEADER_STRIKE = workbook.createFont(); >FONT_CELL_HEADER_STRIKE.setFontName(FONT.getFontName()); >FONT_CELL_HEADER_STRIKE.setFontHeightInPoints((short) 10); >FONT_CELL_HEADER_STRIKE.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); >FONT_CELL_HEADER_STRIKE.setStrikeout(true); > >FONT_CELL_HEADER_BLUE = workbook.createFont(); >FONT_CELL_HEADER_BLUE.setFontName(FONT.getFontName()); >FONT_CELL_HEADER_BLUE.setFontHeightInPoints((short) 10); >FONT_CELL_HEADER_BLUE.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); >FONT_CELL_HEADER_BLUE.setColor(HSSFColor.BLUE.index); >FONT_CELL_HEADER_BLUE_STRIKE = workbook.createFont(); >FONT_CELL_HEADER_BLUE_STRIKE.setFontName(FONT.getFontName()); >FONT_CELL_HEADER_BLUE_STRIKE.setFontHeightInPoints((short) 10); >FONT_CELL_HEADER_BLUE_STRIKE.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); >FONT_CELL_HEADER_BLUE_STRIKE.setStrikeout(true); >FONT_CELL_HEADER_BLUE_STRIKE.setColor(HSSFColor.BLUE.index); > >FONT_HISTORY_HEADER = workbook.createFont(); >FONT_HISTORY_HEADER.setFontName(FONT.getFontName()); >FONT_HISTORY_HEADER.setFontHeightInPoints((short) 8); >FONT_HISTORY_HEADER.setItalic(true); >FONT_HISTORY_HEADER.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); >FONT_HISTORY_HEADER_STRIKE = workbook.createFont(); >FONT_HISTORY_HEADER_STRIKE.setFontName(FONT.getFontName()); >FONT_HISTORY_HEADER_STRIKE.setFontHeightInPoints((short) 8); >FONT_HISTORY_HEADER_STRIKE.setItalic(true); >FONT_HISTORY_HEADER_STRIKE.setStrikeout(true); >FONT_HISTORY_HEADER_STRIKE.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); > >FONT_HISTORY_SPECIAL = workbook.createFont(); >FONT_HISTORY_SPECIAL.setFontName(FONT.getFontName()); >FONT_HISTORY_SPECIAL.setFontHeightInPoints((short) 8); >FONT_HISTORY_SPECIAL.setItalic(true); >FONT_HISTORY_SPECIAL_STRIKE = workbook.createFont(); >FONT_HISTORY_SPECIAL_STRIKE.setFontName(FONT.getFontName()); >FONT_HISTORY_SPECIAL_STRIKE.setFontHeightInPoints((short) 8); >FONT_HISTORY_SPECIAL_STRIKE.setItalic(true); >FONT_HISTORY_SPECIAL_STRIKE.setStrikeout(true); > >FONT_LEGAL_STATUS = workbook.createFont(); >FONT_LEGAL_STATUS.setFontName(FONT.getFontName()); >FONT_LEGAL_STATUS.setFontHeightInPoints((short) 8); >FONT_LEGAL_STATUS.setColor(HSSFFont.COLOR_RED); >FONT_LEGAL_STATUS.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); >FONT_LEGAL_STATUS_STRIKE = workbook.createFont(); >FONT_LEGAL_STATUS_STRIKE.setFontName(FONT.getFontName()); >FONT_LEGAL_STATUS_STRIKE.setFontHeightInPoints((short) 8); >FONT_LEGAL_STATUS_STRIKE.setColor(HSSFFont.COLOR_RED); >FONT_LEGAL_STATUS_STRIKE.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); >FONT_LEGAL_STATUS_STRIKE.setStrikeout(true); >FONT_HISTORY_SPECIAL_RED = workbook.createFont(); >FONT_HISTORY_SPECIAL_RED.setFontName(FONT.getFontName()); >FONT_HISTORY_SPECIAL_RED.setFontHeightInPoints((short) 8); >FONT_HISTORY_SPECIAL_RED.setColor(HSSFFont.COLOR_RED); >FONT_HISTORY_SPECIAL_RED.setItalic(true); >FONT_HISTORY_SPECIAL_RED_STRIKE = workbook.createFont(); >FONT_HISTORY_SPECIAL_RED_STRIKE.setFontName(FONT.getFontName()); >FONT_HISTORY_SPECIAL_RED_STRIKE.setFontHeightInPoints((short) 8); >FONT_HISTORY_SPECIAL_RED_STRIKE.setColor(HSSFFont.COLOR_RED); >FONT_HISTORY_SPECIAL_RED_STRIKE.setItalic(true); >FONT_HISTORY_SPECIAL_RED_STRIKE.setStrikeout(true); > >FONT_SMALL = workbook.createFont(); >FONT_SMALL.setFontName(FONT.getFontName()); >FONT_SMALL.setFontHeightInPoints((short) 8); >FONT_SMALL_STRIKE = workbook.createFont(); >FONT_SMALL_STRIKE.setFontName(FONT.getFontName()); >FONT_SMALL_STRIKE.setFontHeightInPoints((short) 8); >FONT_SMALL_STRIKE.setStrikeout(true); >FONT_SMALL_BOLD = workbook.createFont(); >FONT_SMALL_BOLD.setFontName(FONT.getFontName()); >FONT_SMALL_BOLD.setFontHeightInPoints((short) 8); >FONT_SMALL_BOLD.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); >FONT_SMALL_BOLD_STRIKE = workbook.createFont(); >FONT_SMALL_BOLD_STRIKE.setFontName(FONT.getFontName()); >FONT_SMALL_BOLD_STRIKE.setFontHeightInPoints((short) 8); >FONT_SMALL_BOLD_STRIKE.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); >FONT_SMALL_BOLD_STRIKE.setStrikeout(true); > >FONT_WINGDINGS = workbook.createFont(); >FONT_WINGDINGS.setFontName("Wingdings"); >FONT_WINGDINGS.setFontHeightInPoints((short) 10); >FONT_WINGDINGS_STRIKE = workbook.createFont(); >FONT_WINGDINGS_STRIKE.setFontName("Wingdings"); >FONT_WINGDINGS_STRIKE.setFontHeightInPoints((short) 10); >FONT_WINGDINGS_STRIKE.setStrikeout(true); > >FONT_WINGDINGS2 = workbook.createFont(); >FONT_WINGDINGS2.setFontName("Wingdings 2"); >FONT_WINGDINGS2.setFontHeightInPoints((short) 10); >FONT_WINGDINGS2_STRIKE = workbook.createFont(); >FONT_WINGDINGS2_STRIKE.setFontName("Wingdings 2"); >FONT_WINGDINGS2_STRIKE.setFontHeightInPoints((short) 10); >FONT_WINGDINGS2_STRIKE.setStrikeout(true); > >FONT_WINGDINGS_SMALL = workbook.createFont(); >FONT_WINGDINGS_SMALL.setFontName("Wingdings"); >FONT_WINGDINGS_SMALL.setFontHeightInPoints((short) 8); >FONT_WINGDINGS_SMALL_STRIKE = workbook.createFont(); >FONT_WINGDINGS_SMALL_STRIKE.setFontName("Wingdings"); >FONT_WINGDINGS_SMALL_STRIKE.setFontHeightInPoints((short) 8); >FONT_WINGDINGS_SMALL_STRIKE.setStrikeout(true); > >FONT_WINGDINGS2_SMALL = workbook.createFont(); >FONT_WINGDINGS2_SMALL.setFontName("Wingdings 2"); >FONT_WINGDINGS2_SMALL.setFontHeightInPoints((short) 8); >FONT_WINGDINGS2_SMALL_STRIKE = workbook.createFont(); >FONT_WINGDINGS2_SMALL_STRIKE.setFontName("Wingdings 2"); >FONT_WINGDINGS2_SMALL_STRIKE.setFontHeightInPoints((short) 8); >FONT_WINGDINGS2_SMALL_STRIKE.setStrikeout(true); > >STYLE_HEADER = workbook.createCellStyle(); >STYLE_HEADER.setAlignment(HSSFCellStyle.ALIGN_CENTER); >STYLE_HEADER.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); >STYLE_HEADER.setRotation((short) 80); >STYLE_HEADER.setWrapText(true); >STYLE_HEADER.setBorderBottom(HSSFCellStyle.BORDER_THIN); >STYLE_HEADER.setBorderLeft(HSSFCellStyle.BORDER_THIN); >STYLE_HEADER.setBorderRight(HSSFCellStyle.BORDER_THIN); >STYLE_HEADER.setBorderTop(HSSFCellStyle.BORDER_THIN); >STYLE_HEADER.setFont(FONT_CELL_HEADER); > >STYLE = workbook.createCellStyle(); > >STYLE.setWrapText(true); >STYLE.setBorderBottom(HSSFCellStyle.BORDER_THIN); >STYLE.setBorderLeft(HSSFCellStyle.BORDER_THIN); >STYLE.setBorderRight(HSSFCellStyle.BORDER_THIN); >STYLE.setBorderTop(HSSFCellStyle.BORDER_THIN); >STYLE.setVerticalAlignment(HSSFCellStyle.VERTICAL_TOP); >STYLE.setAlignment(HSSFCellStyle.ALIGN_LEFT); >STYLE.setFont(FONT);
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 45260
: 22170 |
23312