aoiu / as3xls

Automatically exported from code.google.com/p/as3xls
0 stars 0 forks source link

want write more then 255 length text in the cell #45

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
when i am exporting the xls file, the cell is unable to accommodate the text of 
length more then 255.

Please give me the solution to fit large text data in to the cell.

Original issue reported on code.google.com by nrangababu@gmail.com on 9 May 2011 at 2:31

GoogleCodeExporter commented 8 years ago
Were you able to resolve this on your own?  We just encountered this today 
using Excel 2007.

Original comment by carey.th...@gmail.com on 24 Jan 2012 at 4:33

GoogleCodeExporter commented 8 years ago
[deleted comment]
GoogleCodeExporter commented 8 years ago
[deleted comment]
GoogleCodeExporter commented 8 years ago
I did some investigation and the 255 character length is a limitation of the 
BIFF2 format in which this library exports data. This practically means that 
this is not a trivial bug to fix, but possibly a big chunk of the code would 
have to be re-written to be able to export cells containing strings longer than 
255 chars.

Original comment by thesande...@gmail.com on 20 Feb 2012 at 10:30

GoogleCodeExporter commented 8 years ago
Oh, It sounds indeed like a big chunk of code to rewrite, is there a chance you 
might know any indication of time when this can be solved?

Thanks 

Original comment by lexand...@gmail.com on 21 Feb 2012 at 9:03

GoogleCodeExporter commented 8 years ago

This truncation of cell text will occur once you have 257 characters. At this 
point all text will be truncated. If you have 258 characters you will see your 
first character again, at 259 you will see your first two and so on. 

This causes some very strange results, and it appears that the only solution is 
catching any cell that is longer than 257 characters and perhaps moving the 
remaining content into another cell. 

Original comment by rob...@gmail.com on 27 Feb 2012 at 11:22

GoogleCodeExporter commented 8 years ago
If you look at the ExcelFile.as, you will see the string type use LABEL such as
cell.type = Type.LABEL;  that explains why it truncates to 255.  I have tried 
other types, but none of them working.  Any body get a better idea?

Thanks,
LCN

Original comment by LinhNgu...@mkgcs.com on 16 Apr 2012 at 4:14

GoogleCodeExporter commented 8 years ago
Does anyone has a fix for this(Excel truncation)?
Please share if any one has

Thanks,
Sekhar

Original comment by dbcs.f...@gmail.com on 23 Aug 2012 at 2:04

GoogleCodeExporter commented 8 years ago
Hi everybody,

I am facing the same problem with as3xls. For cells with large amount of text, 
the text gets abruptly truncated!

I need this very urgently. Has anybody come up with the solution to this 
problem yet?
I see that the original author has not updated the library to rectify this 
problem.

Thanks,
Barnadeep

Original comment by barnade...@gmail.com on 24 Apr 2013 at 5:51

GoogleCodeExporter commented 8 years ago
Hi,

Unfortunately I can only echo what I've posted before. This library writes in 
BIFF2 format which was originally used by Excel 2.0 (I can't even find when it 
was released, it was before 1990).

To read more on BIFF2 and its limitations, go to section 2.2 in this document: 
http://www.openoffice.org/sc/excelfileformat.pdf

Long story short, while this library uses BIFF2, this issue can't be fixed and 
no one really should use this library in production code. You may export to CSV 
instead, that's trivial. Also, to save you some time, some of our users already 
complained that they could only open the files created with as3xls in Excel 
2010 after relaxing the security settings to allow the opening of legacy 
workbooks - although I haven't tried whether this really has to be done.

Regards,
Zsolt

Original comment by thesande...@gmail.com on 24 Apr 2013 at 6:48

GoogleCodeExporter commented 8 years ago
same issue!! still no fixes?? 

Original comment by okter80 on 11 Mar 2014 at 5:21

GoogleCodeExporter commented 8 years ago
Anyone got a workaround?

Original comment by shimona....@gmail.com on 16 Apr 2014 at 1:02

GoogleCodeExporter commented 8 years ago
[deleted comment]
GoogleCodeExporter commented 8 years ago
I just ran into the same issue. After some research I concluded that it's not a 
trivial fix. The export format is BIFF2, which is really really old and has 
LABEL cell limit 255. All strings are exported as LABEL cells so no hope 
without upgrading to BIFF8 format, which requires using a different cell type 
LABELSST, and the addition of a string table SST in the format. 

It's interesting that the importer recognizes and properly imports BIFF8. So if 
anybody got 2 days to work on this he probably could figure out how to buff the 
exporter to BIFF8 without reading the BIFF8 spec.

Original comment by A.Bankn...@gmail.com on 14 Aug 2014 at 3:43