View Issue Details

IDProjectCategoryView StatusLast Update
0013526Lazarus CCR-public2009-09-03 19:52
ReporterjluixAssigned ToJosé Mejuto 
PrioritynormalSeveritymajorReproducibilityhave not tried
Status resolvedResolutionno change required 
Summary0013526: When saving Excel 5.0 files with FPSpreadSheet with size over 64 kbs a Stream Exception ocurrs
DescriptionHi!

I'm creating several Excel 5 files with FPSpreadSheet, with several sheets per book (not always the same number) and Lazarus raises a Stream Exception whenever the file size reaches over 64 kbs (at least that's what I think). The file is created, but after that I can't open it with OpenOffice Calc because it seems to be corrupted (I'm working under Ubuntu 8.10 so I can't try with M$ Excel). With not so big files OpenOffice works fine.

Kind regards.
TagsNo tags attached.
WidgetsetGTK 2
Attached Files

Activities

Felipe Monteiro de Carvalho

2009-05-20 16:05

developer   ~0027799

Some changes were made. Is it working now for you?

2009-05-28 19:42

 

test_xls.zip (55,587 bytes)

Claudio Romero

2009-05-28 19:47

reporter   ~0028108

Last edited: 2009-05-28 23:42

I didn't have problem with the size in Windows, but in linux the excel file is
corrupted.
I upload two excel example produced with the same code, windows excel works, linux excel not work.


Also raises an exception if the destiny file exist. (no big problem)


I used the Directory revision 811 of fpSpreadsheet (26/05/2009)
GNU tarball from
http://lazarus-ccr.svn.sourceforge.net/viewvc/lazarus-ccr/components/fpspreadsheet/

Tested in
- Lazarus 0.9.27 fpc 2.2.4 svn 20212 (26/05/2009) Windows XP SP3.
- Lazarus 0.9.27 fpc 2.2.4 svn 20135 (23/05/2009) Linux Slax 6.02
  (Slackware 12 based) GTK2 kernel 2.6.27.
- Lazarus 0.9.27 fpc 2.2.3 svn 18263 (12/01/2009) Slackware 10 GTK2 kernel
  2.4.32.

Regards.

Claudio Romero

2009-05-29 03:22

reporter   ~0028123

Upload test_13526.tar.gz (example lazarus program), in linux will produce corrupt excel.

Regards.

2009-05-29 03:23

 

test_13526.tar.gz (129,721 bytes)

José Mejuto

2009-09-02 01:47

developer   ~0030306

It should work now but you must compile the package with the option "-dUSE_NEW_OLE"

Open package, go to "compiler options" -> "Other" -> "Custom options" and add:

-dUSE_NEW_OLE

USE_NEW_OLE flag compiles with the "virtuallayer_ole" system instead the "fpolestorage" one.

José Mejuto

2009-09-02 17:20

developer   ~0030332

Compile with "-dUSE_NEW_OLE" and close if everything is OK.

Issue History

Date Modified Username Field Change
2009-04-16 10:27 jluix New Issue
2009-04-16 10:27 jluix Widgetset => GTK 2
2009-04-16 10:34 Vincent Snijders LazTarget => -
2009-04-16 10:34 Vincent Snijders Assigned To => Felipe Monteiro de Carvalho
2009-04-16 10:34 Vincent Snijders Status new => assigned
2009-05-20 16:05 Felipe Monteiro de Carvalho Note Added: 0027799
2009-05-20 16:05 Felipe Monteiro de Carvalho Status assigned => feedback
2009-05-28 19:42 Claudio Romero File Added: test_xls.zip
2009-05-28 19:47 Claudio Romero Note Added: 0028108
2009-05-28 20:14 Claudio Romero Note Edited: 0028108
2009-05-28 23:42 Claudio Romero Note Edited: 0028108
2009-05-29 03:22 Claudio Romero Note Added: 0028123
2009-05-29 03:23 Claudio Romero File Added: test_13526.tar.gz
2009-06-06 15:17 Felipe Monteiro de Carvalho Status feedback => confirmed
2009-09-02 01:47 José Mejuto Note Added: 0030306
2009-09-02 17:18 José Mejuto Status confirmed => assigned
2009-09-02 17:18 José Mejuto Assigned To Felipe Monteiro de Carvalho => José Mejuto
2009-09-02 17:20 José Mejuto Status assigned => resolved
2009-09-02 17:20 José Mejuto Resolution open => no change required
2009-09-02 17:20 José Mejuto Note Added: 0030332
2009-09-03 19:52 Vincent Snijders Project Packages => Lazarus CCR