poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MSB <markbrd...@tiscali.co.uk>
Subject RE: Help with Freeze Pane problem
Date Tue, 04 May 2010 06:56:40 GMT

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:Jason.Goris@crowncastle.com] 
> 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:Jason.Goris@crowncastle.com] 
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
> 
> 
> 
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
> 
> 
> 
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
> 
> 
> 

-- 
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message