Sorry...first timer, not sure how... -----Original Message----- From: MSB [mailto:[email protected]] Sent: Tuesday, May 04, 2010 2:57 AM To: [email protected] Subject: RE: Help with Freeze Pane problem
Jason Do not hijack someone else's thread please. It would be far better if you created a new thread yourself asking how to accomplish this task. I opened the thread this morning thinking it was about Japanese character encoding! Yours Mark B Goris, Jason wrote: > > Sorry, I was mistaken... it STILL DOES NOT WORK. Please help. This is > very frustrating. Some values passed to the method seem to allow it to > work, but others (e.g. the ones I want/need!) do not. > > -----Original Message----- > From: Goris, Jason [mailto:[email protected]] > Sent: Monday, May 03, 2010 2:39 PM > To: 'POI Users List' > Subject: RE: Help with Freeze Pane problem > > Nevermind, I believe I figured out the issue. > > If I do the createFreezePane(2,1,2,1), I get the strange behavior in > Excel. > However, if I do something like createFreezePane(2,1,3,2), it works ok. > Probably something that you could never do in Excel itself, but POI allows > you to do this, so you get the strange behavior. > > Sorry for the bandwidth waste... > > Jason > > -----Original Message----- > From: Goris, Jason [mailto:[email protected]] > Sent: Monday, May 03, 2010 1:43 PM > To: 'POI Users List' > Subject: Help with Freeze Pane problem > > Hello, I am trying to get the createFreezePane() method working, but when > I open the resulting Excel (2007) document (xlsx) and try to use the mouse > scroll-wheel, the screen gets all garbled. Also, a couple of the rows > appear to be missing when first opening the document until I cursor down > once. I've tried setting the active cell, etc., but no dice on that > either. > > I wrote a simple piece of code below that creates some rows and columns in > a workbook/sheet and writes a file. When I open the file, the above issue > happens. If anyone can see what I'm doing wrong, I'd appreciate it. I'm > using the POI 3.6 (latest stable release) version in Java JDK 1.6.0_13. > > Sample code snippet: > > final Workbook wb2 = new XSSFWorkbook(); > final Sheet sheet2 = wb2.createSheet(); > sheet2.createFreezePane(2, 1, 2, 1); // 1=header row > final Row dataRow20 = sheet2.createRow(0); > final Cell dataCell200 = dataRow20.createCell(0); > dataCell200.setCellValue("200"); > final Cell dataCell201 = dataRow20.createCell(1); > dataCell201.setCellValue(10.12); > final Cell dataCell202 = dataRow20.createCell(2); > dataCell202.setCellValue("TEST 200"); > final Cell dataCell203 = dataRow20.createCell(3); > dataCell203.setCellValue(new Date()); > > final Row dataRow21 = sheet2.createRow(1); > final Cell dataCell210 = dataRow21.createCell(0); > dataCell210.setCellValue("210"); > final Cell dataCell211 = dataRow21.createCell(1); > dataCell211.setCellValue(11.13); > final Cell dataCell212 = dataRow21.createCell(2); > dataCell212.setCellValue("TEST 210"); > final Cell dataCell213 = dataRow21.createCell(3); > dataCell213.setCellValue(new Date()); > > final Row dataRow22 = sheet2.createRow(2); > final Cell dataCell220 = dataRow22.createCell(0); > dataCell220.setCellValue("220"); > final Cell dataCell221 = dataRow22.createCell(1); > dataCell221.setCellValue(12.14); > final Cell dataCell222 = dataRow22.createCell(2); > dataCell222.setCellValue("TEST 220"); > final Cell dataCell223 = dataRow22.createCell(3); > dataCell223.setCellValue(new Date()); > > final Row dataRow23 = sheet2.createRow(3); > final Cell dataCell230 = dataRow23.createCell(0); > dataCell230.setCellValue("230"); > final Cell dataCell231 = dataRow23.createCell(1); > dataCell231.setCellValue(13.15); > final Cell dataCell232 = dataRow23.createCell(2); > dataCell232.setCellValue("TEST 230"); > final Cell dataCell233 = dataRow23.createCell(3); > dataCell233.setCellValue(new Date()); > > final Row dataRow24 = sheet2.createRow(4); > final Cell dataCell240 = dataRow24.createCell(0); > dataCell240.setCellValue("240"); > final Cell dataCell241 = dataRow24.createCell(1); > dataCell241.setCellValue(14.16); > final Cell dataCell242 = dataRow24.createCell(2); > dataCell242.setCellValue("TEST 240"); > final Cell dataCell243 = dataRow24.createCell(3); > dataCell243.setCellValue(new Date()); > > final FileOutputStream fileOut = new > FileOutputStream("myworkbook.xlsx"); > wb2.write(fileOut); > fileOut.close(); > > > Thanks, > > Jason > > > This email may contain confidential or privileged material. Use or > disclosure of it by anyone other than the recipient is unauthorized. If > you are not an intended recipient, please delete this email. > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > > This email may contain confidential or privileged material. Use or > disclosure of it by anyone other than the recipient is unauthorized. If > you are not an intended recipient, please delete this email. > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > > This email may contain confidential or privileged material. Use or > disclosure of it by anyone other than the recipient is unauthorized. If > you are not an intended recipient, please delete this email. > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://old.nabble.com/Parsing-Japanese-characters-in-excel-using-POI-tp28437673p28443733.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] This email may contain confidential or privileged material. Use or disclosure of it by anyone other than the recipient is unauthorized. If you are not an intended recipient, please delete this email. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
