DO NOT REPLY [Bug 21571] - [NEEDS-INFO]EXCEL application error appears when closing and not saving a POI generated xls spreadsheet

2003-07-28 Thread bugzilla 
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21571

[NEEDS-INFO]EXCEL application error appears when closing and not saving a POI 
generated xls spreadsheet





--- Additional Comments From [EMAIL PROTECTED]  2003-07-29 06:31 ---
Good morning Andy,

I think I may have found a problem. I wrote a small test application that 
generates a Excel workbook. During my testing/debugging I found that the 
minute I add a 3rd sheet to the workbook I experience the above mentioned 
problem/error. Working with less than 3 sheet work 100% :) Please advise?

Kind Regards
Fred

/*
 * POI.java
 *
 * 2003/07/28
 *
 * 1.0
 *
 * Copyright (c) 1999 - 2003 Tiscali (Pty) Ltd. All rights reserved.
 */
package com.wol.reporting;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.Region;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;


/**
 * @author Fred Barnes
 * @version 1.0
 */
public class POI
{
private HSSFCellStyle style;
private HSSFCellStyle style2;
private HSSFCellStyle style3;

public POI()
{
//Create a work book.
HSSFWorkbook wb = new HSSFWorkbook();

//Create a font.
HSSFFont font = wb.createFont();
font.setFontHeightInPoints((short) 16);
font.setFontName("Arial");
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);

//Create style.
style = wb.createCellStyle();
style.setFont(font);

//Create 2nd font.
HSSFFont font2 = wb.createFont();
font2.setFontHeightInPoints((short) 14);
font2.setFontName("Arial");
font2.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);

style2 = wb.createCellStyle();
style2.setFont(font2);

//Create 3rd font.
HSSFFont font3 = wb.createFont();
font3.setFontHeightInPoints((short) 10);
font3.setFontName("Arial");
font3.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);

style3 = wb.createCellStyle();
style3.setFont(font3);

createSheet(wb);
createSheet(wb);
createSheet(wb);

FileOutputStream fileOut = null;

try
{
fileOut = new FileOutputStream("c:/test.xls");
wb.write(fileOut);
fileOut.close();
}
catch (FileNotFoundException e)
{
if (fileOut != null)
{
try
{
fileOut.close();
}
catch (IOException ioe)
{
}

fileOut = null;
}
}
catch (IOException e)
{
if (fileOut != null)
{
try
{
fileOut.close();
}
catch (IOException ioe)
{
}

fileOut = null;
}
}
}

private void createSheet(HSSFWorkbook wb)
{
//  Create a sheet.
HSSFSheet sheet = wb.createSheet("Test sheet");

//Set zoom to 80%.
sheet.setZoom(4, 5);

//Merge columns.
sheet.addMergedRegion(new Region(0, (short) 0, 0, (short) 3));

//Create row1.
HSSFRow row = sheet.createRow(0);
HSSFCell row0Cell0 = row.createCell((short) 0);
row0Cell0.setCellStyle(style);
row0Cell0.setCellValue("Row 1");

//Create row2.
HSSFRow row1 = sheet.createRow(1);
HSSFCell row1Cell0 = row1.createCell((short) 0);
row1Cell0.setCellStyle(style2);
row1Cell0.setCellValue("Row 2");

//Create row3.
HSSFRow row2 = sheet.createRow(2);
HSSFCell row2Cell0 = row2.createCell((short) 0);
row2Cell0.setCellStyle(style3);
row2Cell0.setCellValue("Row 3");

//Insert a long value.
long aLong = 123;
HSSFRow row3 = sheet.createRow(3);
HSSFCell row3Cell0 = row3.createCell((short) 0);
row3Cell0.setCellStyle(style3);
row3Cell0.setCellValue(aLong);

//Insert a double value.
double aDouble = 456;
HSSFRow row4 = sheet.createRow(4);
HSSFCell row4Cell0 = row4.createCell((short) 0);
row4Cell0.setCellStyle(style3);
row4Cell0.setCellValue(aDouble);

//Insert data.
for (int i = 5; i < 1005; i++)
{
HSSFRow rowX = sheet.createRow(i);

for (

DO NOT REPLY [Bug 21444] - [PATCH] Macro functions

2003-07-28 Thread bugzilla 
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21444

[PATCH] Macro functions





--- Additional Comments From [EMAIL PROTECTED]  2003-07-28 23:04 ---
I finally finished reconfiguring my workspace, so here is the patch against the 
release 2 branch.  This patch is completely automatic, and all the test cases 
pass, so it should be safe to apply it as is.

Procedure for this patch:
1. Install 7495 as src/testcases/org/apache/poi/hssf/data/SquareMacro.xls.
2. Patch 7555 against REL_2_BRANCH.
3. Build, Test, and Commit.

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

DO NOT REPLY [Bug 21444] - [PATCH] Macro functions

2003-07-28 Thread bugzilla 
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21444

[PATCH] Macro functions





--- Additional Comments From [EMAIL PROTECTED]  2003-07-28 23:00 ---
Created an attachment (id=7555)
patch against REL_2_BRANCH

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Release notes (ALL COMMITTERS PLEASE READ)

2003-07-28 Thread Andrew C. Oliver 
Hey guys I put up the pre3 release but I'm having trouble putting together
the release notes, can you reply to this email with a short list of what
fixes/additions you've checked in to REL_2 branch since pre2?

Thanks,

Andy
-- 
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI

http://jakarta.apache.org/poi
For Java and Excel, Got POI?


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

DO NOT REPLY [Bug 21646] - Cannot open large spreadsheet created by POI. Sheet briefly flashes.

2003-07-28 Thread bugzilla 
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21646

Cannot open large spreadsheet created by POI. Sheet briefly flashes.





--- Additional Comments From [EMAIL PROTECTED]  2003-07-28 20:10 ---
Hello 
 I have a similiar problem while populating the excel sheet. if the rows are
more then 3000(Apprx 640kb). then i am not able to open the excel file. It just
flash. 
Else it is ok. Iam populating the excel sheet from database. 
I can see the size of the downloaded file eg: 900kb.

Let me know if you have any resolution for this. Or any planned fix for the bug.

Do you think the size may be the problem.

thanks
Sanjay

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

cvs commit: jakarta-poi build.xml

2003-07-28 Thread acoliver 
acoliver2003/07/28 11:45:15

  Modified:.Tag: REL_2_BRANCH build.xml
  Log:
  this is the pre3 release...
  
  Revision  ChangesPath
  No   revision
  
  
  No   revision
  
  
  1.41.2.5  +1 -1  jakarta-poi/build.xml
  
  Index: build.xml
  ===
  RCS file: /home/cvs/jakarta-poi/build.xml,v
  retrieving revision 1.41.2.4
  retrieving revision 1.41.2.5
  diff -u -r1.41.2.4 -r1.41.2.5
  --- build.xml 23 Jul 2003 01:28:26 -  1.41.2.4
  +++ build.xml 28 Jul 2003 18:45:14 -  1.41.2.5
  @@ -83,7 +83,7 @@
   
   
   
  -
  +
   
   
   
  
  
  

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [VOTE] ATTENTION!! "POI/Poi naming issue"

2003-07-28 Thread Danny Mui 

ISSUE #1:  "POI to be known as Poi in the future?"

[ ] +1   Applause!! I *do* love the "Poi" naming rather than "POI".
[ ] +0.5 Cool! Go forward to it!
[ ] +-0  No Idea / Having both co-exist might be preferable
[ ] -0.5 *Boo* ... I have objections for this naming, "Poi".
[X] -1   A couple of *Boo*s ... I *do* love "POI" abbr rather than "Poi"
# Other fraction expressions are also welcomed. (with your comments!)

Your Status:   poi committer / poi developer / poi adviser
Your Comments: []
 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: Re: Release imminent

2003-07-28 Thread Avik Sengupta 
Yep, works for me... thanks. 

   ---Original Message---
   > From: Rainer Klute <[EMAIL PROTECTED]>
   > Subject: Re: Release imminent
   > Sent: 28 Jul 2003 21:47:06
   >
   >  >> I'll be reverting Rainer's changes into the 2.0 branch and doing a
   >  >> release.
   >  >
   >  >Just wait until I am home and able to fix it! It is a matter of not more
   >  >than a few hours. I want that bug to be fixed in the release. Reverting my
   >  >changes won't do it. Thanks!
   >  
   >  Should work now.
   >  
   >  Best regards
   >  Rainer Klute
   >  
   > Rainer Klute IT-Consulting GmbH
   >Dipl.-Inform.
   >Rainer Klute E-Mail:  [EMAIL PROTECTED]
   >Körner Grund 24  Telefon: +49 172 2324824
   >  D-44143 Dortmund   Telefax: +49 231 5349423
   >  
   >  
   >  
   >  -
   >  To unsubscribe, e-mail: [EMAIL PROTECTED]
   >  For additional commands, e-mail: [EMAIL PROTECTED]
   ---Original Message---

cvs commit: jakarta-poi/src/testcases/org/apache/poi/hpsf/basic Util.java

2003-07-28 Thread klute 
klute   2003/07/28 10:01:03

  Modified:src/testcases/org/apache/poi/hpsf/basic Util.java
  Log:
  
  
  Revision  ChangesPath
  1.5   +14 -1 jakarta-poi/src/testcases/org/apache/poi/hpsf/basic/Util.java
  
  Index: Util.java
  ===
  RCS file: /home/cvs/jakarta-poi/src/testcases/org/apache/poi/hpsf/basic/Util.java,v
  retrieving revision 1.4
  retrieving revision 1.5
  diff -u -r1.4 -r1.5
  --- Util.java 26 Jul 2003 06:57:33 -  1.4
  +++ Util.java 28 Jul 2003 17:01:03 -  1.5
  @@ -90,7 +90,10 @@
* output stream until end of file is encountered.
*
* @param in the input stream to read from
  + * 
* @param out the output stream to write to
  + * 
  + * @exception IOException if an I/O exception occurs
*/
   public static void copy(final InputStream in, final OutputStream out)
   throws IOException
  @@ -129,6 +132,11 @@
*
* @return The POI files. The elements are ordered in the same way
* as the files in the POI filesystem.
  + * 
  + * @exception FileNotFoundException if the file containing the POI 
  + * filesystem does not exist
  + * 
  + * @exception IOException if an I/O exception occurs
*/
   public static POIFile[] readPOIFiles(final File poiFs)
   throws FileNotFoundException, IOException
  @@ -151,6 +159,11 @@
*
* @return The POI files. The elements are ordered in the same way
* as the files in the POI filesystem.
  + * 
  + * @exception FileNotFoundException if the file containing the POI 
  + * filesystem does not exist
  + * 
  + * @exception IOException if an I/O exception occurs
*/
   public static POIFile[] readPOIFiles(final File poiFs,
final String[] poiFiles)
  
  
  

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

cvs commit: jakarta-poi/src/contrib/src/org/apache/poi/contrib/poibrowser Codec.java TreeReaderListener.java

2003-07-28 Thread klute 
klute   2003/07/28 09:56:46

  Modified:src/contrib/src/org/apache/poi/contrib/poibrowser Codec.java
TreeReaderListener.java
  Log:
  
  
  Revision  ChangesPath
  1.4   +5 -3  
jakarta-poi/src/contrib/src/org/apache/poi/contrib/poibrowser/Codec.java
  
  Index: Codec.java
  ===
  RCS file: 
/home/cvs/jakarta-poi/src/contrib/src/org/apache/poi/contrib/poibrowser/Codec.java,v
  retrieving revision 1.3
  retrieving revision 1.4
  diff -u -r1.3 -r1.4
  --- Codec.java22 Feb 2003 13:39:24 -  1.3
  +++ Codec.java28 Jul 2003 16:56:45 -  1.4
  @@ -58,8 +58,10 @@
   
   package org.apache.poi.contrib.poibrowser;
   
  -import java.io.*;
  -import java.util.*;
  +import java.io.BufferedReader;
  +import java.io.IOException;
  +import java.io.InputStreamReader;
  +
   import org.apache.poi.hpsf.ClassID;
   
   
  
  
  
  1.3   +1 -10 
jakarta-poi/src/contrib/src/org/apache/poi/contrib/poibrowser/TreeReaderListener.java
  
  Index: TreeReaderListener.java
  ===
  RCS file: 
/home/cvs/jakarta-poi/src/contrib/src/org/apache/poi/contrib/poibrowser/TreeReaderListener.java,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- TreeReaderListener.java   22 Feb 2002 04:27:18 -  1.2
  +++ TreeReaderListener.java   28 Jul 2003 16:56:45 -  1.3
  @@ -265,13 +265,4 @@
   }
   }
   
  -
  -private String s(final Object o)
  -{
  -if (o == null)
  -return "null";
  -else
  -return o.getClass().getName() + '@' + o.hashCode();
  -}
  -
   }
  
  
  

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: Release imminent

2003-07-28 Thread Rainer Klute 
>> I'll be reverting Rainer's changes into the 2.0 branch and doing a
>> release.
>
>Just wait until I am home and able to fix it! It is a matter of not more
>than a few hours. I want that bug to be fixed in the release. Reverting my
>changes won't do it. Thanks!

Should work now.

Best regards
Rainer Klute

   Rainer Klute IT-Consulting GmbH
  Dipl.-Inform.
  Rainer Klute E-Mail:  [EMAIL PROTECTED]
  Körner Grund 24  Telefon: +49 172 2324824
D-44143 Dortmund   Telefax: +49 231 5349423



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

cvs commit: jakarta-poi/src/testcases/org/apache/poi/hpsf/basic TestEmptyProperties.java

2003-07-28 Thread klute 
klute   2003/07/28 09:45:39

  Modified:src/testcases/org/apache/poi/hpsf/basic Tag: REL_2_BRANCH
TestEmptyProperties.java
  Log:
  Test case fixed.
  
  Revision  ChangesPath
  No   revision
  
  
  No   revision
  
  
  1.1.2.3   +30 -8 
jakarta-poi/src/testcases/org/apache/poi/hpsf/basic/TestEmptyProperties.java
  
  Index: TestEmptyProperties.java
  ===
  RCS file: 
/home/cvs/jakarta-poi/src/testcases/org/apache/poi/hpsf/basic/TestEmptyProperties.java,v
  retrieving revision 1.1.2.2
  retrieving revision 1.1.2.3
  diff -u -r1.1.2.2 -r1.1.2.3
  --- TestEmptyProperties.java  28 Jul 2003 10:18:13 -  1.1.2.2
  +++ TestEmptyProperties.java  28 Jul 2003 16:45:39 -  1.1.2.3
  @@ -37,13 +37,20 @@
   
   static final String[] POI_FILES = new String[]
   {
  -"SlideShow",
  +"PerfectOffice_MAIN",
   "\005SummaryInformation",
  -"PerfectOffice_MAIN"
  +"Main"
   };
   
   POIFile[] poiFiles;
   
  +
  +
  +/**
  + * Constructor
  + * 
  + * @param name The name of the test case
  + */
   public TestEmptyProperties(final String name)
   {
   super(name);
  @@ -53,6 +60,10 @@
   
   /**
* Read a the test file from the "data" directory.
  + *
  + * @exception FileNotFoundException if the file containing the test data
  + * does not exist
  + * @exception IOException if an I/O exception occurs
*/
   public void setUp() throws FileNotFoundException, IOException
   {
  @@ -68,6 +79,8 @@
   /**
* Checks the names of the files in the POI filesystem. They
* are expected to be in a certain order.
  + * 
  + * @exception IOException if an I/O exception occurs
*/
   public void testReadFiles() throws IOException
   {
  @@ -86,9 +99,11 @@
* property sets. In the latter cases a [EMAIL PROTECTED]
* NoPropertySetStreamException} will be thrown when trying to
* create a [EMAIL PROTECTED] PropertySet}.
  + * 
  + * @exception IOException if an I/O exception occurs
*/
   public void testCreatePropertySets() throws IOException
  -{
  +{ 
   Class[] expected = new Class[]
   {
   NoPropertySetStreamException.class,
  @@ -126,10 +141,13 @@
* Tests the [EMAIL PROTECTED] PropertySet} methods. The test file has two
* property sets: the first one is a [EMAIL PROTECTED] SummaryInformation},
* the second one is a [EMAIL PROTECTED] DocumentSummaryInformation}.
  + * 
  + * @exception IOException if an I/O exception occurs
  + * @exception HPSFException if an HPSF operation fails
*/
   public void testPropertySetMethods() throws IOException, HPSFException
   {
  -byte[] b = poiFiles[2].getBytes();
  +byte[] b = poiFiles[1].getBytes();
   PropertySet ps =
   PropertySetFactory.create(new ByteArrayInputStream(b));
   SummaryInformation s = (SummaryInformation) ps;
  @@ -145,9 +163,9 @@
   assertNull(s.getLastPrinted());
   assertNull(s.getCreateDateTime());
   assertNull(s.getLastSaveDateTime());
  -assertEquals(s.getPageCount(),0);
  -assertEquals(s.getWordCount(),0);
  -assertEquals(s.getCharCount(),0);
  +assertEquals(s.getPageCount(), 0);
  +assertEquals(s.getWordCount(), 0);
  +assertEquals(s.getCharCount(), 0);
   assertNull(s.getThumbnail());
   assertNull(s.getApplicationName());
   }
  @@ -156,6 +174,10 @@
   
   /**
* Runs the test cases stand-alone.
  + * 
  + * @param args the command-line arguments (unused)
  + * 
  + * @exception Throwable if any exception or error occurs
*/
   public static void main(final String[] args) throws Throwable
   {
  
  
  

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

DO NOT REPLY [Bug 21923] - [PATCH] Modify HSSFWorkbook, FormulaParser and SheetReferences to support 3DRefs

2003-07-28 Thread bugzilla 
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21923

[PATCH] Modify HSSFWorkbook, FormulaParser and SheetReferences to support 3DRefs





--- Additional Comments From [EMAIL PROTECTED]  2003-07-28 15:56 ---
Right, there is no need for dirty hacks in 3.0.  Play with the scaffolding a bit.  Try 
to fix the frame a 
bit.

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

DO NOT REPLY [Bug 21923] - [PATCH] Modify HSSFWorkbook, FormulaParser and SheetReferences to support 3DRefs

2003-07-28 Thread bugzilla 
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21923

[PATCH] Modify HSSFWorkbook, FormulaParser and SheetReferences to support 3DRefs





--- Additional Comments From [EMAIL PROTECTED]  2003-07-28 15:45 ---
Ok, ok.. I'll poke around with JUnit.. :)

As for the assertTrue, I was just following the previous examlpe in
TestSheetReferehces.

Regardless of how it's refactored, somehow, the FormulaParser needs information
out of the workbook, or access to the workbook to resolve 3DRefs.  Getting a
copy of the SheetReferences seemed like less of a hack than exposing the
internal workbook to the outside world.  At least it can't be used in reverse to
mess up the workbook.  Admittedly, it's still a hack, though.

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: Release imminent

2003-07-28 Thread rainer . klute 
> I'll be reverting Rainer's changes into the 2.0 branch and doing a
> release.

Just wait until I am home and able to fix it! It is a matter of not more
than a few hours. I want that bug to be fixed in the release. Reverting my
changes won't do it. Thanks!

Best regards
Rainer Klute

-- 
  RAINER KLUTE IT-CONSULTING GMBH
Dipl.-Inform.
Rainer Klute  [EMAIL PROTECTED]
Körner Grund 24   Telefon: +49 172 2324824
D-44143 Dortmund  Telefax: +49 231 5349423

+++ GMX - Mail, Messaging & more  http://www.gmx.net +++

Jetzt ein- oder umsteigen und USB-Speicheruhr als Prämie sichern!


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Release imminent

2003-07-28 Thread Shawn Laubach 
Do we want to mark is/setGridsPrinted in 2.0?

Shawn

-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 9:24 AM
To: POI Developers List
Subject: Release imminent 


Unless you're Rainer fixing your shit, please do not check anything in.
I'll be reverting Rainer's changes into the 2.0 branch and doing a release.
It's my first one in ages so watch for falling rocks...  Lets hope I get
this right :-)

-Andy  
-- 
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI

http://jakarta.apache.org/poi
For Java and Excel, Got POI?


-
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]

Release imminent

2003-07-28 Thread Andrew C. Oliver 
Unless you're Rainer fixing your shit, please do not check anything in.
I'll be reverting Rainer's changes into the 2.0 branch and doing a release.
It's my first one in ages so watch for falling rocks...  Lets hope I get
this right :-)

-Andy  
-- 
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI

http://jakarta.apache.org/poi
For Java and Excel, Got POI?


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[GUMP] Build Failure - jakarta-poi-3

2003-07-28 Thread Gump \[HEAD\] :-\( 

This email is autogenerated from the output from:



Buildfile: build.xml

check-jars:

fetch-jars:

init:

compile-main:

-test-main-check:

test-main:
[junit] Running org.apache.poi.hpsf.basic.TestBasic
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.676 sec

[junit] Running org.apache.poi.hpsf.basic.TestEmptyProperties
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.419 sec

[junit] Running org.apache.poi.hpsf.basic.TestUnicode
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.259 sec

[junit] Running org.apache.poi.hssf.eventmodel.TestEventRecordFactory
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.983 sec

[junit] Running org.apache.poi.hssf.eventmodel.TestModelFactory
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 1.188 sec

[junit] Running org.apache.poi.hssf.model.TestFormulaParser
[junit] Tests run: 15, Failures: 0, Errors: 0, Time elapsed: 0.456 sec

[junit] Running org.apache.poi.hssf.record.aggregates.TestFormulaRecordAggregate
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.058 sec

[junit] Running org.apache.poi.hssf.record.aggregates.TestRowRecordsAggregate
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.029 sec

[junit] Running org.apache.poi.hssf.record.aggregates.TestValueRecordsAggregate
[junit] Tests run: 1, Failures: 1, Errors: 0, Time elapsed: 0.08 sec


BUILD FAILED
/home/rubys/jakarta/jakarta-poi-3/build.xml:230: Test 
org.apache.poi.hssf.record.aggregates.TestValueRecordsAggregate failed

Total time: 11 seconds

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[GUMP] Build Failure - jakarta-poi

2003-07-28 Thread Gump \[REL_2_BRANCH\] :-\( 

This email is autogenerated from the output from:



Buildfile: build.xml

check-jars:

fetch-jars:
  [get] Getting: 
http://www.ibiblio.org/maven/commons-logging/jars/commons-logging-1.0.1.jar
  [get] Getting: http://www.ibiblio.org/maven/log4j/jars/log4j-1.2.8.jar
  [get] Getting: 
http://www.ibiblio.org/maven/commons-beanutils/jars/commons-beanutils-1.6.jar
  [get] Getting: 
http://www.ibiblio.org/maven/commons-collections/jars/commons-collections-2.1.jar
  [get] Getting: 
http://www.ibiblio.org/maven/commons-lang/jars/commons-lang-1.0-b1.jar
  [get] Getting: http://www.ibiblio.org/maven/junit/jars/junit-3.8.1.jar

init:
[mkdir] Created dir: /home/rubys/jakarta/jakarta-poi/build
[mkdir] Created dir: /home/rubys/jakarta/jakarta-poi/build/classes
[mkdir] Created dir: /home/rubys/jakarta/jakarta-poi/build/contrib-classes
[mkdir] Created dir: /home/rubys/jakarta/jakarta-poi/build/scratchpad-classes
[mkdir] Created dir: /home/rubys/jakarta/jakarta-poi/build/test-classes
[mkdir] Created dir: /home/rubys/jakarta/jakarta-poi/build/contrib-test-classes
[mkdir] Created dir: /home/rubys/jakarta/jakarta-poi/build/scratchpad-test-classes
[mkdir] Created dir: /home/rubys/jakarta/jakarta-poi/build/test-results
[mkdir] Created dir: /home/rubys/jakarta/jakarta-poi/build/scratchpad-test-results
[mkdir] Created dir: /home/rubys/jakarta/jakarta-poi/build/contrib-test-results
[mkdir] Created dir: 
/home/rubys/jakarta/jakarta-poi/build/tmp/site/build/site/junit
[mkdir] Created dir: 
/home/rubys/jakarta/jakarta-poi/build/tmp/site/build/site/jdepend
[mkdir] Created dir: 
/home/rubys/jakarta/jakarta-poi/build/tmp/site/src/documentation/content/jdepend
[mkdir] Created dir: 
/home/rubys/jakarta/jakarta-poi/build/tmp/site/build/site/apidocs
[mkdir] Created dir: /home/rubys/jakarta/jakarta-poi/build/dist
 [copy] Copying 176 files to 
/home/rubys/jakarta/jakarta-poi/build/tmp/site/src/documentation
 [copy] Copying 1 file to /home/rubys/jakarta/jakarta-poi/build/tmp/site

compile-main:
[javac] Compiling 308 source files to /home/rubys/jakarta/jakarta-poi/build/classes
[javac] Compiling 130 source files to 
/home/rubys/jakarta/jakarta-poi/build/test-classes
[javac] 
/home/rubys/jakarta/jakarta-poi/src/testcases/org/apache/poi/hpsf/basic/TestEmptyProperties.java:148:
 cannot resolve symbol
[javac] symbol  : method assertEquals (int)
[javac] location: class org.apache.poi.hpsf.basic.TestEmptyProperties
[javac] assertEquals(s.getPageCount());
[javac] ^
[javac] 
/home/rubys/jakarta/jakarta-poi/src/testcases/org/apache/poi/hpsf/basic/TestEmptyProperties.java:149:
 cannot resolve symbol
[javac] symbol  : method assertNull (int)
[javac] location: class org.apache.poi.hpsf.basic.TestEmptyProperties
[javac] assertNull(s.getWordCount());
[javac] ^
[javac] 
/home/rubys/jakarta/jakarta-poi/src/testcases/org/apache/poi/hpsf/basic/TestEmptyProperties.java:150:
 cannot resolve symbol
[javac] symbol  : method assertNull (int)
[javac] location: class org.apache.poi.hpsf.basic.TestEmptyProperties
[javac] assertNull(s.getCharCount());
[javac] ^
[javac] Note: 
/home/rubys/jakarta/jakarta-poi/src/testcases/org/apache/poi/hssf/record/TestRecordFactory.java
 uses or overrides a deprecated API.
[javac] Note: Recompile with -deprecation for details.
[javac] 3 errors

BUILD FAILED
/home/rubys/jakarta/jakarta-poi/build.xml:176: Compile failed; see the compiler error 
output for details.

Total time: 34 seconds

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

DO NOT REPLY [Bug 21571] - [NEEDS-INFO]EXCEL application error appears when closing and not saving a POI generated xls spreadsheet

2003-07-28 Thread bugzilla 
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21571

[NEEDS-INFO]EXCEL application error appears when closing and not saving a POI 
generated xls spreadsheet





--- Additional Comments From [EMAIL PROTECTED]  2003-07-28 14:11 ---
doh, for some reason I thought I saw you newing one up.  Can you create instead a 
simple 
program that just reproduces this in a main function?  The simplest piece of code 
which replicates 
the problem and depends on nothing else.

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

DO NOT REPLY [Bug 21571] - [NEEDS-INFO]EXCEL application error appears when closing and not saving a POI generated xls spreadsheet

2003-07-28 Thread bugzilla 
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21571

[NEEDS-INFO]EXCEL application error appears when closing and not saving a POI 
generated xls spreadsheet





--- Additional Comments From [EMAIL PROTECTED]  2003-07-28 13:03 ---
Hi Andy,

Thank you for your reply. I had a look at your font creation example versus 
mine and I can not see any differences. Please advise?

Mine:

//Create company name font.
HSSFFont companyFont = wb.createFont();
companyFont.setFontHeightInPoints((short) 16);
companyFont.setFontName("Arial");
companyFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
companyStyle = wb.createCellStyle();
companyStyle.setFont(companyFont);

//Create heading font.
HSSFFont headingFont = wb.createFont();
headingFont.setFontHeightInPoints((short) 14);
headingFont.setFontName("Arial");
headingFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
headingStyle = wb.createCellStyle();
headingStyle.setFont(headingFont);

//Create column heading font.
HSSFFont columnHeadingFont = wb.createFont();
columnHeadingFont.setFontHeightInPoints((short) 10);
columnHeadingFont.setFontName("Arial");
columnHeadingFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
columnHeadingStyle = wb.createCellStyle();
columnHeadingStyle.setFont(columnHeadingFont);

Your example:

// Create a new font and alter it.
HSSFFont font = wb.createFont();
font.setFontHeightInPoints((short)24);
font.setFontName("Courier New");
font.setItalic(true);
font.setStrikeout(true);

// Fonts are set into a style so create a new one to use.
HSSFCellStyle style = wb.createCellStyle();
style.setFont(font);

Kind Regards
Fred

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

DO NOT REPLY [Bug 21571] - [NEEDS-INFO]EXCEL application error appears when closing and not saving a POI generated xls spreadsheet

2003-07-28 Thread bugzilla 
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21571

[NEEDS-INFO]EXCEL application error appears when closing and not saving a POI 
generated xls spreadsheet

[EMAIL PROTECTED] changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution||INVALID



--- Additional Comments From [EMAIL PROTECTED]  2003-07-28 12:42 ---
You're doign it wrong: 
http://jakarta.apache.org/poi/hssf/quick-guide.html#WorkingWithFonts

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

DO NOT REPLY [Bug 21884] - [RFE] Functions to hide gridlines of excel sheet using HSSF package not working

2003-07-28 Thread bugzilla 
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21884

[RFE] Functions to hide gridlines of excel sheet using HSSF package not working

[EMAIL PROTECTED] changed:

   What|Removed |Added

Version|unspecified |2.0-pre2



--- Additional Comments From [EMAIL PROTECTED]  2003-07-28 12:37 ---
Either in the CVS REL_2_0 branch (check it out and build it) or wait a few days for 
the 2.0-pre3 
release.

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

cvs commit: jakarta-poi/src/documentation/content/xdocs/trans/es who.xml

2003-07-28 Thread tetsuya 
tetsuya 2003/07/28 05:24:08

  Modified:src/documentation/content/xdocs/trans/es who.xml
  Log:
  Who.xml: Updated Committers/Emeritus Committer
  
  Revision  ChangesPath
  1.3   +26 -12jakarta-poi/src/documentation/content/xdocs/trans/es/who.xml
  
  Index: who.xml
  ===
  RCS file: /home/cvs/jakarta-poi/src/documentation/content/xdocs/trans/es/who.xml,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- who.xml   24 Apr 2003 00:53:31 -  1.2
  +++ who.xml   28 Jul 2003 12:24:08 -  1.3
  @@ -1,23 +1,21 @@
   
   
  -
   

  -  Who we are
  +  Jakarta Poi - Who we are
 
  -   
  -   
  +   
  

   

   
  - Who we are
  + Jakarta Poi - Who we are
 
   The Poi Project operates on a meritocracy: the more you do, the more
   responsibility you will obtain. This page lists all of the people who have
   gone the extra mile and are Committers. If you would like to get involved,
  -the first step is to join the mailing lists.
  +the first step is to join the http://jakarta.apache.org/site/mail2.html#poi";>mailing lists.
 
   
 
  @@ -33,24 +31,40 @@
   
 Advisors
   
  -   http://jakarta.apache.org/avalon/authors/stefano.html";>Stefano Mazzocchi 
(stefano at apache dot org)
  +   http://www.betaversion.org/~stefano/";>Stefano 
Mazzocchi (stefano at apache dot org)
  
   
 
   
  +  Emeritus Committers
  +
  +  Nicola Ken Barozzi (barozzi at nicolaken dot com)
  +
  +  
  +
 Committers
   
  -  http://trilug.org/~acoliver";>Andrew C. Oliver 
(acoliver at apache dot org)
  -  http://www.marcj.com";>Marc Johnson (mjohnson at apache 
dot org)
  -  Glen Stampoultzis (glens at apache.org)
  +  http://cvs.apache.org/~acoliver/";>Andrew C. Oliver 
(acoliver at apache dot org)
  +  http://www.marcj.com/";>Marc Johnson (mjohnson at 
apache dot org)
  +  http://members.iinet.net.au/~gstamp/glen/";>Glen 
Stampoultzis (glens at apache.org)
 http://www.rainer-klute.de/";>Rainer Klute (klute at 
apache dot org)
  -  Nicola Ken Barozzi (barozzi at nicolaken dot com)
 Ryan Ackley (sackley at apache dot org)
 Avik Sengupta (avik at apache dot org)
  +  Shawn Laubach (slaubach at apache dot org)
  +  Danny Mui (dmui at apache dot org)
  +  Jason Height (jheight at apache dot org)
  +  http://www.apache.org/~tetsuya/";>Tetsuya Kitahata 
(tetsuya at apache dot org)
   
 
 Developers
  -
  +
  +  Agustín Martín (agusmba at terra dot es)
  +
  +  
  +  Translators
  +
  +  (Please add your name here!!)
  +
 

   
  
  
  

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

cvs commit: jakarta-poi/src/documentation/content/xdocs who.xml

2003-07-28 Thread tetsuya 
tetsuya 2003/07/28 05:16:53

  Modified:src/documentation/content/xdocs who.xml
  Log:
  Who.xml: Updated Committers/Emeritus Committer
  
  Revision  ChangesPath
  1.8   +1 -1  jakarta-poi/src/documentation/content/xdocs/who.xml
  
  Index: who.xml
  ===
  RCS file: /home/cvs/jakarta-poi/src/documentation/content/xdocs/who.xml,v
  retrieving revision 1.7
  retrieving revision 1.8
  diff -u -r1.7 -r1.8
  --- who.xml   28 Jul 2003 12:14:54 -  1.7
  +++ who.xml   28 Jul 2003 12:16:52 -  1.8
  @@ -16,7 +16,7 @@
   The Poi Project operates on a meritocracy: the more you do, the more
   responsibility you will obtain. This page lists all of the people who have
   gone the extra mile and are Committers. If you would like to get involved,
  -the first step is to join the http://jakarta.apache.org/mail2.html#poi";>mailing lists.
  +the first step is to join the http://jakarta.apache.org/site/mail2.html#poi";>mailing lists.
 
   
 
  
  
  

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

cvs commit: jakarta-poi/src/documentation/content/xdocs who.xml

2003-07-28 Thread tetsuya 
tetsuya 2003/07/28 05:14:54

  Modified:src/documentation/content/xdocs who.xml
  Log:
  Who.xml: Updated Committers/Emeritus Committer
  
  Revision  ChangesPath
  1.7   +4 -3  jakarta-poi/src/documentation/content/xdocs/who.xml
  
  Index: who.xml
  ===
  RCS file: /home/cvs/jakarta-poi/src/documentation/content/xdocs/who.xml,v
  retrieving revision 1.6
  retrieving revision 1.7
  diff -u -r1.6 -r1.7
  --- who.xml   24 Jul 2003 16:36:40 -  1.6
  +++ who.xml   28 Jul 2003 12:14:54 -  1.7
  @@ -16,7 +16,7 @@
   The Poi Project operates on a meritocracy: the more you do, the more
   responsibility you will obtain. This page lists all of the people who have
   gone the extra mile and are Committers. If you would like to get involved,
  -the first step is to join the mailing lists.
  +the first step is to join the http://jakarta.apache.org/mail2.html#poi";>mailing lists.
 
   
 
  @@ -37,7 +37,7 @@
   
 
   
  -  Honorary Committers
  +  Emeritus Committers
   
 Nicola Ken Barozzi (barozzi at nicolaken dot com)
   
  @@ -52,12 +52,13 @@
 Ryan Ackley (sackley at apache dot org)
 Avik Sengupta (avik at apache dot org)
 Shawn Laubach (slaubach at apache dot org)
  +  Danny Mui (dmui at apache dot org)
  +  Jason Height (jheight at apache dot org)
 http://www.apache.org/~tetsuya/";>Tetsuya Kitahata 
(tetsuya at apache dot org)
   
 
 Developers
   
  -  Jason Height (jheight at chariot dot net dot au)
 Agustín Martín (agusmba at terra dot es)
   
 
  
  
  

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

DO NOT REPLY [Bug 21646] - Cannot open large spreadsheet created by POI. Sheet briefly flashes.

2003-07-28 Thread bugzilla 
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21646

Cannot open large spreadsheet created by POI. Sheet briefly flashes.





--- Additional Comments From [EMAIL PROTECTED]  2003-07-28 11:15 ---
I have noticed that (In my case) as soon as the SST table becomes very big this 
happens.

I can put thousands of strings into a spreadsheet as long as there are not too 
many unique ones. As soon as there are plenty unique strings the sheet can't 
open.

Using the BIFF Viewer, I see that CONTINUE RECORD's are written for the 
spreadsheet that can't open and none are written for a spreadsheet that can 
open.

>From looking at the source (I am not sure though) it seems that these CONTINUE 
RECORDs are a major change between POI 1.5.1 and POI2.

Am I on the wrong track ???

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [ATTN:Rainer] Re: cvs commit: jakarta-poi/src/testcases/org/apache/poi/hpsf/data TestCorel.shw

2003-07-28 Thread rainer . klute 
> I have made the required changes, so the code compiles now, however,
> testEmptyProperties fails as follows.. which also needs fixing, since i
> dont think we should do a release with failing testcases. Maybe it would
> help if you compared the commit mails for your commits to HEAD and
> BRANCH. 

Thanks for the hint. I'll iron that out tonight.

Best regards
Rainer Klute

-- 
  RAINER KLUTE IT-CONSULTING GMBH
Dipl.-Inform.
Rainer Klute  [EMAIL PROTECTED]
Körner Grund 24   Telefon: +49 172 2324824
D-44143 Dortmund  Telefax: +49 231 5349423

+++ GMX - Mail, Messaging & more  http://www.gmx.net +++

Jetzt ein- oder umsteigen und USB-Speicheruhr als Prämie sichern!


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [ATTN:Rainer] Re: cvscommit: jakarta-poi/src/testcases/org/apache/poi/hpsf/data TestCorel.shw

2003-07-28 Thread Avik Sengupta 
I have made the required changes, so the code compiles now, however,
testEmptyProperties fails as follows.. which also needs fixing, since i
dont think we should do a release with failing testcases. Maybe it would
help if you compared the commit mails for your commits to HEAD and
BRANCH. 

single-test:
[junit] Testsuite: org.apache.poi.hpsf.basic.TestEmptyProperties
[junit] Tests run: 1, Failures: 1, Errors: 0, Time elapsed: 0.252
sec

[junit] Testcase: testReadFiles took 0.116 sec
[junit] FAILED
[junit] expected: but was:
[junit] junit.framework.ComparisonFailure:
expected: but was:


On Mon, 2003-07-28 at 14:43, [EMAIL PROTECTED] wrote:
> > Some problem with junit... i am using 3.8.1, so i glen, i think. This is
> > with a clean compile cycle. 
> 
> Oops, probably something went wrong with my tries to commit the source code
> to the HEAD and the REL_2.0_BRANCH. The three method calls which are in error
> do not represent not the latest working state.  I wonder if both attempts
> went wrong or whether its correct in one of the branches.
> 
> Since I am behind a firewall during the working day I cannot fix it right
> now. If you are desperately needing compilable code, replace the three faulty
> method calls by the following:
> 
> assertEquals(s.getPageCount(), 0);
> assertEquals(s.getWordCount(), 0);
> assertEquals(s.getCharCount(), 0);
> 
> Best regards
> Rainer Klute
-- 
Avik Sengupta <[EMAIL PROTECTED]>


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

cvs commit: jakarta-poi/src/testcases/org/apache/poi/hpsf/basic TestEmptyProperties.java

2003-07-28 Thread avik 
avik2003/07/28 03:18:13

  Modified:src/testcases/org/apache/poi/hpsf/basic Tag: REL_2_BRANCH
TestEmptyProperties.java
  Log:
  Made code compilable, on behalf Rainer
  
  Revision  ChangesPath
  No   revision
  
  
  No   revision
  
  
  1.1.2.2   +4 -4  
jakarta-poi/src/testcases/org/apache/poi/hpsf/basic/TestEmptyProperties.java
  
  Index: TestEmptyProperties.java
  ===
  RCS file: 
/home/cvs/jakarta-poi/src/testcases/org/apache/poi/hpsf/basic/TestEmptyProperties.java,v
  retrieving revision 1.1.2.1
  retrieving revision 1.1.2.2
  diff -u -r1.1.2.1 -r1.1.2.2
  --- TestEmptyProperties.java  26 Jul 2003 22:01:37 -  1.1.2.1
  +++ TestEmptyProperties.java  28 Jul 2003 10:18:13 -  1.1.2.2
  @@ -145,9 +145,9 @@
   assertNull(s.getLastPrinted());
   assertNull(s.getCreateDateTime());
   assertNull(s.getLastSaveDateTime());
  -assertEquals(s.getPageCount());
  -assertNull(s.getWordCount());
  -assertNull(s.getCharCount());
  +assertEquals(s.getPageCount(),0);
  +assertEquals(s.getWordCount(),0);
  +assertEquals(s.getCharCount(),0);
   assertNull(s.getThumbnail());
   assertNull(s.getApplicationName());
   }
  
  
  

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: CVSCHANGELOG -- we need this?? (ATTN: Glen)

2003-07-28 Thread Tetsuya Kitahata 

Okay, Glen

Maybe, after the
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21863
issue ;-)

-- Tetsuya ([EMAIL PROTECTED])

On Sun, 27 Jul 2003 14:11:11 +1000
(Subject: Re: CVSCHANGELOG -- we need this?? (ATTN: Glen))
Glen Stampoultzis <[EMAIL PROTECTED]> wrote:

> 
> It can be skipped by setting a system property.
> 
> The original idea was that the web-site was going to be updated 
> automatically nightly (as has previously been the case) and that it would 
> provide an easy way to see who'd made changes recently.  As yet I haven't 
> gotten around to implementing this yet.
> 
> I'm not overly concerned if you wish to remove it.  Perhaps just comment it 
> out rather than removing it.
> 
> Regards,
> 
> Glen
> 
> 
> At 07:20 AM 27/07/2003, you wrote:
> 
> >And my proposal is "remove this  from
> >the build.xml or put this line out of ".
> >Also, "how about removing this from left-side-navi of poi
> >website?"
> >
> >I think this is due to the Ant itself. Of course,
> >those who perform "ant docs" with checked-out-files from
> >"/home/cvspublic/" will not experience this phenomenon.
> >
> >Even the current Poi-website's  is obsolete.
> >Do we really need this??
> >
> >-- Tetsuya ([EMAIL PROTECTED])
> >
> >On Sat, 26 Jul 2003 17:06:58 -0400
> >"Andrew C. Oliver" <[EMAIL PROTECTED]> wrote:
> >
> > > Ahh, yes I haven't built the docs in awhile...
> > >
> > > -Andy
> > >
> > > On 7/26/03 4:52 PM, "Tetsuya Kitahata" <[EMAIL PROTECTED]> wrote:
> > >
> > > >
> > > > How about "ant docs"?
> > > >
> > > > -- Tetsuya ([EMAIL PROTECTED])
> > > >
> > > > P.S. I am using windows2k advanced server and
> > > > "SSH Secure Shell 3.2.3 (Build 279)"
> > > >
> > > > On Sat, 26 Jul 2003 16:41:43 -0400
> > > > (Subject: Re: CVSCHANGELOG -- we need this??)
> > > > "Andrew C. Oliver" <[EMAIL PROTECTED]> wrote:
> > > >
> > > >> No idea why but I've never had this problem and I run the build all the
> > > >> time.
> > > >>
> > > >> On 7/26/03 4:42 PM, "Tetsuya Kitahata" <[EMAIL PROTECTED]> wrote:
> > > >>
> > > >>>
> > > >>> Hello,
> > > >>>
> > > >>> As I mentioned before, poi-build fail at the line
> > > >>> "jakarta-poi/build.xml:410: Error running cvs log",
> > > >>> because the committers always use
> > > >>> "/home/cvs/" not "/home/cvspublic/".
> > > >>>
> > > >>> Do we really need ??
> > > >>>
> > > >>> I wanna make this line (@ build.xml) comment out
> > > >>> and also remove "cvschangelog" left-side-nav section
> > > >>> from poi website.
> > > >>>
> > > >>> Any thoughts?
> > > >>>
> > > >>> -- Tetsuya ([EMAIL PROTECTED])
> >
> >
> >
> >-
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
> Glen Stampoultzis
> [EMAIL PROTECTED]
> http://members.iinet.net.au/~gstamp/glen/



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

DO NOT REPLY [Bug 21571] - [NEEDS-INFO]EXCEL application error appears when closing and not saving a POI generated xls spreadsheet

2003-07-28 Thread bugzilla 
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21571

[NEEDS-INFO]EXCEL application error appears when closing and not saving a POI 
generated xls spreadsheet





--- Additional Comments From [EMAIL PROTECTED]  2003-07-28 09:54 ---
Hi Andy,

The generation of the excel sheet works fine. It is when opening the generated 
sheet in Microsoft Excel 2000, that the problems start. I can sussesfully open 
the POI generated sheet. After changing the data in the sheet and maybe 
resizing the columns width I get the aboved mentioned error. I just say that 
the "The memory could not be read"! Also this happens intermittently, which 
makes it more difficult to troubleshoot. I included 2 method that generate my 
sheet. Please advise :(

public void generateXls(String outputPath)
{
HSSFWorkbook wb = new HSSFWorkbook();

//Create company name font.
HSSFFont companyFont = wb.createFont();
companyFont.setFontHeightInPoints((short) 16);
companyFont.setFontName("Arial");
companyFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
companyStyle = wb.createCellStyle();
companyStyle.setFont(companyFont);

//Create heading font.
HSSFFont headingFont = wb.createFont();
headingFont.setFontHeightInPoints((short) 14);
headingFont.setFontName("Arial");
headingFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
headingStyle = wb.createCellStyle();
headingStyle.setFont(headingFont);

//Create column heading font.
HSSFFont columnHeadingFont = wb.createFont();
columnHeadingFont.setFontHeightInPoints((short) 10);
columnHeadingFont.setFontName("Arial");
columnHeadingFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
columnHeadingStyle = wb.createCellStyle();
columnHeadingStyle.setFont(columnHeadingFont);

//Create workbook font.
HSSFFont font = wb.createFont();
font.setFontHeightInPoints((short) 10);
font.setFontName("Arial");
style = wb.createCellStyle();
style.setFont(font);

HSSFSheet sheet = createXlsSheet(wb, "Daily", this.reportTitle,
this.dateline);
HSSFSheet sheet1 = createXlsSheet(wb, "Monthly",
this.monthlyReportTitle, this.monthlyDateline);
File outputDir = new File(outputPath + dir);

if (!outputDir.exists())
{
outputDir.mkdirs();
}

FileOutputStream fileOut = null;

try
{
fileOut = new FileOutputStream(outputDir.getAbsolutePath() +
File.separator + fileName + ".xls");
wb.write(fileOut);
fileOut.close();
}
catch (FileNotFoundException e)
{
LogManager.logError(this, e);

if (fileOut != null)
{
try
{
fileOut.close();
}
catch (IOException ioe)
{
}

fileOut = null;
}
}
catch (IOException e)
{
LogManager.logError(this, e);

if (fileOut != null)
{
try
{
fileOut.close();
}
catch (IOException ioe)
{
}

fileOut = null;
}
}
}

private HSSFSheet createXlsSheet(HSSFWorkbook wb, String reportType,
String reportName, String reportDateline)
{
HSSFSheet sheet = wb.createSheet(reportType);

sheet.setZoom(4, 5);

int rowCounter = 0;

//Create report heading.
HSSFRow row0 = sheet.createRow(rowCounter);
HSSFCell row0Cell0 = row0.createCell((short) 0);
row0Cell0.setCellStyle(companyStyle);
row0Cell0.setCellValue(this.COMPANYNAME);
rowCounter += 2;

HSSFRow row2 = sheet.createRow(rowCounter);
HSSFCell row2Cell0 = row2.createCell((short) 0);
row2Cell0.setCellStyle(headingStyle);
row2Cell0.setCellValue(reportName);

HSSFRow row3 = sheet.createRow(++rowCounter);
HSSFCell row3Cell0 = row3.createCell((short) 0);
row3Cell0.setCellStyle(style);
row3Cell0.setCellValue(reportDateline);
rowCounter += 3;

HSSFRow columnHeadingRow = sheet.createRow(rowCounter);

//Create column headings.
for (int i = 0; i < columnHeading.size(); i++)
{
HSSFCell headingCell = columnHeadingRow.createCell((short) i);
headingCell.setCellStyle(columnHeadingStyle);
headingCell.setCellValue((String) columnH

Re: [ATTN:Rainer] Re: cvs commit: jakarta-poi/src/testcases/org/apache/poi/hpsf/data TestCorel.shw

2003-07-28 Thread rainer . klute 
> Some problem with junit... i am using 3.8.1, so i glen, i think. This is
> with a clean compile cycle. 

Oops, probably something went wrong with my tries to commit the source code
to the HEAD and the REL_2.0_BRANCH. The three method calls which are in error
do not represent not the latest working state.  I wonder if both attempts
went wrong or whether its correct in one of the branches.

Since I am behind a firewall during the working day I cannot fix it right
now. If you are desperately needing compilable code, replace the three faulty
method calls by the following:

assertEquals(s.getPageCount(), 0);
assertEquals(s.getWordCount(), 0);
assertEquals(s.getCharCount(), 0);

Best regards
Rainer Klute

-- 
  RAINER KLUTE IT-CONSULTING GMBH
Dipl.-Inform.
Rainer Klute  [EMAIL PROTECTED]
Körner Grund 24   Telefon: +49 172 2324824
D-44143 Dortmund  Telefax: +49 231 5349423

+++ GMX - Mail, Messaging & more  http://www.gmx.net +++

Jetzt ein- oder umsteigen und USB-Speicheruhr als Prämie sichern!


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [ATTN:Rainer] Re: cvs commit: jakarta-poi/src/testcases/org/apache/poi/hpsf/data TestCorel.shw

2003-07-28 Thread Avik Sengupta 
Some problem with junit... i am using 3.8.1, so i glen, i think. This is
with a clean compile cycle. 

compile-main:
[javac] Compiling 308 source files to
/home/aviks/projects/jakarta-poi/build/classes
[javac] Compiling 132 source files to
/home/aviks/projects/jakarta-poi/build/test-classes
[javac]
/home/aviks/projects/jakarta-poi/src/testcases/org/apache/poi/hpsf/basic/TestEmptyProperties.java:148:
 cannot resolve symbol
[javac] symbol  : method assertEquals  (int)
[javac] location: class
org.apache.poi.hpsf.basic.TestEmptyProperties
[javac] assertEquals(s.getPageCount());
[javac] ^
[javac]
/home/aviks/projects/jakarta-poi/src/testcases/org/apache/poi/hpsf/basic/TestEmptyProperties.java:149:
 cannot resolve symbol
[javac] symbol  : method assertNull  (int)
[javac] location: class
org.apache.poi.hpsf.basic.TestEmptyProperties
[javac] assertNull(s.getWordCount());
[javac] ^
[javac]
/home/aviks/projects/jakarta-poi/src/testcases/org/apache/poi/hpsf/basic/TestEmptyProperties.java:150:
 cannot resolve symbol
[javac] symbol  : method assertNull  (int)
[javac] location: class
org.apache.poi.hpsf.basic.TestEmptyProperties
[javac] assertNull(s.getCharCount());
[javac] ^
[javac] Note:
/home/aviks/projects/jakarta-poi/src/testcases/org/apache/poi/hssf/record/TestRecordFactory.java
 uses or overrides a deprecated API.
[javac] Note: Recompile with -deprecation for details.
[javac] 3 errors

On Mon, 2003-07-28 at 13:13, [EMAIL PROTECTED] wrote:
> > This stuff does not compile.  I've been asked to create a build so please 
> > revert or fix this ASAP.
> 
> Glen,
> 
> it compiles and runs fine for me. Otherwise I wouldn't have committed it.
> Please send the error messages so I can see what went wrong! Thanks!
> 
> Best regards
> Rainer Klute
-- 
Avik Sengupta <[EMAIL PROTECTED]>


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [ATTN:Rainer] Re: cvs commit: jakarta-poi/src/testcases/org/apache/poi/hpsf/data TestCorel.shw

2003-07-28 Thread rainer . klute 
> This stuff does not compile.  I've been asked to create a build so please 
> revert or fix this ASAP.

Glen,

it compiles and runs fine for me. Otherwise I wouldn't have committed it.
Please send the error messages so I can see what went wrong! Thanks!

Best regards
Rainer Klute

-- 
  RAINER KLUTE IT-CONSULTING GMBH
Dipl.-Inform.
Rainer Klute  [EMAIL PROTECTED]
Körner Grund 24   Telefon: +49 172 2324824
D-44143 Dortmund  Telefax: +49 231 5349423

+++ GMX - Mail, Messaging & more  http://www.gmx.net +++

Jetzt ein- oder umsteigen und USB-Speicheruhr als Prämie sichern!


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]