poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Singh, Arshi (Indsys)" <Arshi.Si...@ge.com>
Subject RE: RE: Re: HSSF Workbook not opening in MS Excel
Date Thu, 09 Oct 2003 04:48:54 GMT
Hi,
   I tested using poi 1.10. It works fine , but with 2.0 pre3 im getting this problem. I need
to use the setDisplayGridlines() function in 2.0 pre3. 
   As per your mails, it seems the problem is fixed in a newer version. Can you let me know
which one is this new version ( CVS ? ). Or if it is yet to be released, by when should i
expect it to come.

Thanks
Arshi.

-----Original Message-----
From: Avik Sengupta [mailto:avik.sengupta@itellix.com]
Sent: Wednesday, October 08, 2003 11:42 PM
To: POI Users List; poi-dev@jakarta.apache.org
Subject: Re: RE: Re: HSSF Workbook not opening in MS Excel


Thanks.  Cheers to jason for fxing a very long running issue. 

I've marked the bug fixed, and added some testcases to the CVS (in
branch.. will do head tomorrow)

We should do a pre4 sometime soon. 

Regards
-
Avik


   -------Original Message-------
   &gt; From: Robert Lowe &lt;rmlowe@rmlowe.com&gt;
   &gt; Subject: RE: Re: HSSF Workbook not opening in MS Excel
   &gt; Sent: 08 Oct 2003 23:01:23
   &gt;
   &gt;  I just tested with a fresh build from CVS, and confirmed that
the problem I
   &gt;  reported is fixed.
   &gt;  
   &gt;  Cheers,
   &gt;  Rob
   &gt;  
   &gt;  
   &gt;  -----Original Message-----
   &gt;  From: Avik Sengupta [mailto:avik.sengupta@itellix.com]
   &gt;  Sent: Tuesday, October 07, 2003 11:17 PM
   &gt;  To: POI Users List
   &gt;  Subject: Re: Re: HSSF Workbook not opening in MS Excel
   &gt;  
   &gt;  
   &gt;  Yeah, thats the &quot;too many unique strings&quot; bug that i
talked about.
   &gt;  We think its been solved in current CVS. Since the bug has been
raised in
   &gt;  different forms by many people, we are waiting for some
confirmation from a
   &gt;  few early testers before we do a new release.
   &gt;  
   &gt;  Arshi however says that his file was generated correctly with
1.10. That
   &gt;  would make it a different beast, since this particluar bug has
been around
   &gt;  since after 1.5.1
   &gt;  
   &gt;  Regards
   &gt;  -
   &gt;  Avik
   &gt;  
   &gt;     -------Original Message-------
   &gt;     &gt; From: Patrick Nolan
   &gt;     &gt; Subject: Re: HSSF Workbook not opening in MS Excel
   &gt;     &gt; Sent: 07 Oct 2003 20:04:28
   &gt;     &gt;
   &gt;     &gt;  Guys,
   &gt;     &gt;
   &gt;     &gt;  Robert Lowe and I were having the same problem. As
Robert confirms
   &gt;  below,
   &gt;     &gt;  we narrowed it down to this: In certain cases (which
are described
   &gt;  below),
   &gt;     &gt;  calling the overloaded String version setCellValue,
but passing in
   &gt;  a String
   &gt;     &gt;  representation of a number caused the spreadsheet to
not open in
   &gt;  Excel.
   &gt;     &gt;
   &gt;     &gt;  - Pat
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;  ----------------------
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;  Pat,
   &gt;     &gt;
   &gt;     &gt;  I do believe this is related to having strings that
look like
   &gt;  numbers,
   &gt;     &gt;  since
   &gt;     &gt;  I was able to isolate the problem to a particular
column with that
   &gt;  format.
   &gt;     &gt;  In my case the strings contain around eight digits and
no decimal
   &gt;  point. I
   &gt;     &gt;  don't think your workaround will work for me though
since leading
   &gt;  zeroes
   &gt;     &gt;  might be significant.
   &gt;     &gt;
   &gt;     &gt;  It does seem to be correlated with the size of the
output too--I
   &gt;  don't see
   &gt;     &gt;  this problem with small files.
   &gt;     &gt;
   &gt;     &gt;  Best,
   &gt;     &gt;  Rob
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;  -----Original Message-----
   &gt;     &gt;  From: Patrick Nolan [mailto:PNolan@fiberlink.com]
   &gt;     &gt;  Sent: Monday, October 06, 2003 8:30 PM
   &gt;     &gt;  To: Robert Lowe
   &gt;     &gt;  Subject: RE: Help! Spreadsheet does not open if one
more column is
   &gt;  added
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;  Robert,
   &gt;     &gt;
   &gt;     &gt;  Yes, I did find a solution. I discovered that passing
a number,
   &gt;  which has
   &gt;     &gt;  one decimal place, as a string to the setCellValue
causes the
   &gt;  problem. What
   &gt;     &gt;  I did to fix the problem was to convert it to a double
and then
   &gt;  pass it to
   &gt;     &gt;  the method, which invokes an overloaded version of the
method. If a
   &gt;  number
   &gt;     &gt;  with more than one decimal place is passed as a string
it works
   &gt;  fine. I
   &gt;     &gt;  haven't had a chance to log this in the poi bugzilla.
   &gt;     &gt;
   &gt;     &gt;  Please let me know if this turns out to be your
problem. This will
   &gt;  support
   &gt;     &gt;  my opinion that this is a bug.
   &gt;     &gt;
   &gt;     &gt;  Pat
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;                        &quot;Robert Lowe&quot;
   &gt;     &gt;                                               cc:
   &gt;     &gt;
Subject:  RE: Help!
   &gt;     &gt;  Spreadsheet does not open if one more column is added
   &gt;     &gt;                        10/04/2003 05:06
   &gt;     &gt;                        PM
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;  Hi Patrick, did you ever find a solution to this? It
sounds quite
   &gt;  similar
   &gt;     &gt;  to
   &gt;     &gt;  a problem I'm having: spreadsheet with around 30,000
rows, no
   &gt;  errors but
   &gt;     &gt;  Excel 2000 is unable to open the file that is
produced.
   &gt;     &gt;
   &gt;     &gt;  My workaround so far has been to fall back to the
1.5.1
   &gt;  release--not ideal
   &gt;     &gt;  as I really need some of the newer features.
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;  Best regards,
   &gt;     &gt;
   &gt;     &gt;  Robert Lowe
   &gt;     &gt;  http://RMLowe.com/
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;  -----Original Message-----
   &gt;     &gt;  From: Patrick Nolan [mailto:PNolan@fiberlink.com]
   &gt;     &gt;  Sent: Wednesday, October 01, 2003 5:34 AM
   &gt;     &gt;  To: poi-user@jakarta.apache.org
   &gt;     &gt;  Subject: Help! Spreadsheet does not open if one more
column is
   &gt;  added
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;  Hi,
   &gt;     &gt;
   &gt;     &gt;  Any ideas on what is happening here? I can't figure
this one out..
   &gt;  spent 4
   &gt;     &gt;  hours on it already and no closer to a solution! :(
   &gt;     &gt;
   &gt;     &gt;  SPECS:
   &gt;     &gt;        POI version: poi-2.0-pre3-20030728.jar
   &gt;     &gt;        OS: Solaris
   &gt;     &gt;
   &gt;     &gt;  SCENARIO:
   &gt;     &gt;        I am building a spreadsheet based on a resultset
object. It
   &gt;  is quite
   &gt;     &gt;  a simple implementation. There are 8 columns in the
query which
   &gt;  will map to
   &gt;     &gt;  8 columns in the spreadsheet. The spreadsheet is
created without
   &gt;  any
   &gt;     &gt;  exceptions thrown. It is &lt; 1meg in size and does
not exceed 7k
   &gt;  rows. This
   &gt;     &gt;  is the query: SELECT customername,
domaingroupname,username,
   &gt;     &gt;  dialsvcplanname,
   &gt;     &gt;
dialserviceplantypename,billingtotal,hourstotal,minutestotal
   &gt;     &gt;  FROM rep_billing_sum where accountid = '1011'
   &gt;     &gt;
   &gt;     &gt;  PROBLEM:
   &gt;     &gt;        When I open the spreadsheet in excel, it opens
as an empty
   &gt;     &gt;  spreadsheet. If I take the last column off of the
query
   &gt;  (&quot;minutestotal&quot;),
   &gt;     &gt;  the spreadsheet saves as expected and opens fine in
excel. This
   &gt;  field is a
   &gt;     &gt;  simple NUMBER field in Oracle. The two previous fields
are also the
   &gt;  same
   &gt;     &gt;  type. I redirected the output of the full query to a
text file and
   &gt;     &gt;  everything is written fine, including output of the
last column.
   &gt;     &gt;
   &gt;     &gt;  CODE:
   &gt;     &gt;
   &gt;     &gt;  this.rsmd = newRset.getMetaData();
   &gt;     &gt;  this.columnCount = (short)rsmd.getColumnCount();
   &gt;     &gt;  this.rset = newRset;
   &gt;     &gt;  HSSFSheet sheet = wb.createSheet(&quot;new
sheet&quot;);
   &gt;     &gt;  HSSFRow row;
   &gt;     &gt;  HSSFCell cell;
   &gt;     &gt;  HSSFCellStyle style;
   &gt;     &gt;  HSSFDataFormat format = wb.createDataFormat();
   &gt;     &gt;  style = wb.createCellStyle();
   &gt;     &gt;  style.setDataFormat((short)0);//just general format
for test
   &gt;     &gt;  while (rset.next()) {
   &gt;     &gt;        // create the row.
   &gt;     &gt;        row = sheet.createRow(index++);
   &gt;     &gt;        for (short i = 0; i &lt; columnCount; i++) {
   &gt;     &gt;              cell = row.createCell(i);
   &gt;     &gt;              cell.setCellValue(rset.getString(i+1));
   &gt;     &gt;              cell.setCellStyle(style);
   &gt;     &gt;        }
   &gt;     &gt;  }
   &gt;     &gt;  // the spreadsheet gets written as a file down here
   &gt;     &gt;
   &gt;     &gt;
   &gt;  
   &gt;  &gt;
---------------------------------------------------------------------
   &gt;     &gt;  To unsubscribe, e-mail:
poi-user-unsubscribe@jakarta.apache.org
   &gt;     &gt;  For additional commands, e-mail:
poi-user-help@jakarta.apache.org
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;                        &quot;Avik Sengupta&quot;
   &gt;     &gt;                                        ,
   &gt;     &gt;                                                 cc:
   &gt;     &gt;                        10/07/2003 10:44
Subject:  Re: HSSF
   &gt;  Workbook not opening in MS Excel
   &gt;     &gt;                        AM
   &gt;     &gt;                        Please respond to
   &gt;     &gt;                        &quot;POI Users List&quot;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;  Which version are you using? There was a bug wherein
the file would
   &gt;  get
   &gt;     &gt;  corrupted if more than a particular number of unique
strings were
   &gt;  there in
   &gt;     &gt;  the sheet. This bug has been fixed in current CVS, if
you want to
   &gt;  try that
   &gt;     &gt;  out.
   &gt;     &gt;
   &gt;     &gt;  Or it could be a similar but different bug.. in which
case its down
   &gt;  to
   &gt;     &gt;  reading hex dumps again :(
   &gt;     &gt;
   &gt;     &gt;  You say its the same data ... are you sure its
*exactly* the same
   &gt;  data? If
   &gt;     &gt;  it is, then its a big bug... I dont think it would be
memory issue
   &gt;  while
   &gt;     &gt;  generating.. not if you are able to consistently
replicate the
   &gt;  error.
   &gt;     &gt;
   &gt;     &gt;  Regards
   &gt;     &gt;  -
   &gt;     &gt;  Avik
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;     -------Original Message-------
   &gt;     &gt;     &gt; From: Singh, Arshi (Indsys)
   &gt;     &gt;     &gt; Subject: HSSF Workbook not opening in MS Excel
   &gt;     &gt;     &gt; Sent: 07 Oct 2003 13:26:44
   &gt;     &gt;     &gt;
   &gt;     &gt;     &gt;  Hi All,
   &gt;     &gt;     &gt;
   &gt;     &gt;     &gt;  I am creating a workbook with 27 tabs
(sheets), using poi,
   &gt;  hssf.
   &gt;     &gt;     &gt;
   &gt;     &gt;     &gt;  I had successfully done it earlier and opened
that
   &gt;  workbook in
   &gt;     &gt;  MSExcel. Now due to some mysterious reason when i
create a workbook
   &gt;  for the
   &gt;     &gt;  same data, it does not open in MSExcel. The size of
workbook is
   &gt;  also
   &gt;     &gt;  slightly more...575 kb (earlier 566 kb).
   &gt;     &gt;     &gt;
   &gt;     &gt;     &gt;  I fail to understand the reason for this. If
i try to open
   &gt;  the
   &gt;     &gt;  workbook that i had generated earlier, it opens
perfectly with 27
   &gt;  tabs. But
   &gt;     &gt;  this new workbook having same data fails to open. It
just flashes
   &gt;  the
   &gt;     &gt;  MSExcel with no document on it.
   &gt;     &gt;     &gt;
   &gt;     &gt;     &gt;  Could this be due to some memory problem
while generating
   &gt;  the
   &gt;     &gt;  workbook repeatedly. Kindly help me to detect the
problem. I did
   &gt;  not make
   &gt;     &gt;  any changes in code since then, but all of a sudden
this problem
   &gt;  starting
   &gt;     &gt;  coming.
   &gt;     &gt;     &gt;
   &gt;     &gt;     &gt;  Regards,
   &gt;     &gt;     &gt;  Arshi
   &gt;     &gt;     &gt;  g  GE Industrial Systems
   &gt;     &gt;     &gt;  ________________________________________
   &gt;     &gt;     &gt;
   &gt;     &gt;     &gt;  Arshi Singh
   &gt;     &gt;     &gt;  GE-IBC, Datawarehousing
   &gt;     &gt;     &gt;  GE Industrial Systems
   &gt;     &gt;     &gt;  Center Point, HUDA Lane
   &gt;     &gt;     &gt;  Begumpet, Secunderabad 500 003
   &gt;     &gt;     &gt;
   &gt;     &gt;     &gt;  email:  Arshi.Singh@geind.ge.com
   &gt;     &gt;     &gt;  Tel:  91-40-27881480 (D), 1800
   &gt;     &gt;     -------Original Message-------
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;     &gt;
   &gt;  
   &gt;  &gt;
---------------------------------------------------------------------
   &gt;     &gt;  To unsubscribe, e-mail:
poi-user-unsubscribe@jakarta.apache.org
   &gt;     &gt;  For additional commands, e-mail:
poi-user-help@jakarta.apache.org
   &gt;     -------Original Message-------
   &gt;  
   &gt;  
   &gt;  
   &gt;  
   &gt;  
   &gt;
---------------------------------------------------------------------
   &gt;  To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
   &gt;  For additional commands, e-mail:
poi-user-help@jakarta.apache.org
   -------Original Message-------



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Mime
View raw message