Recent

Author Topic: LazFlexCel  (Read 17188 times)

wOvAN

  • New Member
  • *
  • Posts: 47
    • wxSoft.Ru
LazFlexCel
« on: April 16, 2010, 09:53:33 am »
Hello, I've ported Delphi's FlexCel (Free 2.5.3 version) component.
(Native Excel Report tool).
Tested  it on Win32/Win64 and a little on Lin64.

LazFlexCel_0.0.3.7z

It needs some more testing on Linux. So try it. I hope it'll be useful.

Leledumbo

  • Hero Member
  • *****
  • Posts: 8114
  • Programming + Glam Metal + Tae Kwon Do = Me
Re: LazFlexCel
« Reply #1 on: April 16, 2010, 10:06:50 am »
Isn't it a commercial component? What about the license?

wOvAN

  • New Member
  • *
  • Posts: 47
    • wxSoft.Ru
Re: LazFlexCel
« Reply #2 on: April 16, 2010, 10:12:27 am »
The version Flexcel v2.5.3  is free under MPL license

Quote
License
This is free software, subject to the Mozilla Public License. If you find it useful, and if you can afford it (it's $30) you can register it at

http://shareit1.element5.com/product.html?productid=161531

You will make my day a little happier :-) .If you can't afford it, well, don't worry, you can use it the same. (I would like an email anyway, telling me that you use it and how, but that's up to you). The real reason behind me asking you to contact, is that I would like to know how many people if someone is using this, and how many people thinks it's so good they can pay $30 for it. Supporting a product is a complex work, and I want to be sure it's being useful to someone.

Now, for the cut and paste…

The contents of this file are subject to the Mozilla Public License Version 1.1 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at
http://www.mozilla.org/MPL/
Software distributed under the License is distributed on an "AS IS" basis, WITHOUT WARRANTY OF
ANY KIND, either express or implied. See the License for the specific language governing rights and
limitations under the License. 

JuhaManninen

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3647
  • I like bugs.
Re: LazFlexCel
« Reply #3 on: April 16, 2010, 07:21:07 pm »
Linker error:
/usr/bin/ld: cannot find -lgsf-1

Opensuse 11.2 Linux.

wOvAN

  • New Member
  • *
  • Posts: 47
    • wxSoft.Ru
Re: LazFlexCel
« Reply #4 on: April 16, 2010, 08:40:36 pm »
Linker error:
/usr/bin/ld: cannot find -lgsf-1

Opensuse 11.2 Linux.


On Linux it depends on following libraries:

libglib-2.0.so
libgobject-2.0.so
libgsf-1.so
libxml2.so

I tested on Fedora 64 and placed this libraries from it in folder "Lin64_Required_Libs"

they might be present in the system but not linked to actual names, like:
libglib-2.0.so.0.2200.3  ->  libglib-2.0.so 

so you need to find 'em and create symbolic link in that case.

mica

  • Full Member
  • ***
  • Posts: 192
Re: LazFlexCel
« Reply #5 on: April 16, 2010, 09:48:30 pm »
Linker error:
/usr/bin/ld: cannot find -lgsf-1

Opensuse 11.2 Linux.


install libgsf and libgsf-devel with yast/smart/whatever you use.

JuhaManninen

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3647
  • I like bugs.
Re: LazFlexCel
« Reply #6 on: April 16, 2010, 10:25:33 pm »
I got the lib. FlexCel package now installs and show nice icons in palette.
How am I supposed to use it? I don't have Excel in my Linux.

Juha

mica

  • Full Member
  • ***
  • Posts: 192
Re: LazFlexCel
« Reply #7 on: April 17, 2010, 10:39:24 am »
Yes,some Demos woulde be nice.

wOvAN

  • New Member
  • *
  • Posts: 47
    • wxSoft.Ru
Re: LazFlexCel
« Reply #8 on: April 17, 2010, 02:13:23 pm »
Yes,some Demos woulde be nice.
There are docs and delphi's demos in the original distribution.

faber

  • Guest
Re: LazFlexCel
« Reply #9 on: April 24, 2010, 09:36:34 pm »
Works Great (Import).
Finally got something sensible to read xls. BIG THX  :)

JuhaManninen

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3647
  • I like bugs.
Re: LazFlexCel
« Reply #10 on: April 25, 2010, 10:35:15 pm »
It needs some more testing on Linux. So try it. I hope it'll be useful.

This component is highly windows specific. It uses OLE for example.
Under Linux, the best result I got was SIGSEGV.
What kind of testing you want that people do on Linux?

The examples are Delphi specific. They use BDE controls TTable and TQuery + others.
You could convert or create some examples that work on Windows at least.

Still, I believe this is a good component for those who make Win-only programs with Lazarus.
Next you can make something similar for OpenOffice suite. :-)

Juha

mica

  • Full Member
  • ***
  • Posts: 192
Re: LazFlexCel
« Reply #11 on: April 27, 2010, 05:17:26 pm »
hmm same problem with Linux 32 bit here.
A simple

FlexCelImport1.OpenFile(filename);
 try
  FlexCelImport1.Save('filename);
 finally
FlexCelImport1.CloseFile;

brings strange errors like sigsev or list out of bounds......

wOvAN

  • New Member
  • *
  • Posts: 47
    • wxSoft.Ru
Re: LazFlexCel
« Reply #12 on: April 27, 2010, 08:06:11 pm »
hmm same problem with Linux 32 bit here.
A simple

FlexCelImport1.OpenFile(filename);
 try
  FlexCelImport1.Save('filename);
 finally
FlexCelImport1.CloseFile;

brings strange errors like sigsev or list out of bounds......

Try to find out, what is wrong with it and fix it.  :)

wOvAN

  • New Member
  • *
  • Posts: 47
    • wxSoft.Ru
Re: LazFlexCel
« Reply #13 on: April 27, 2010, 08:13:42 pm »
It needs some more testing on Linux. So try it. I hope it'll be useful.

This component is highly windows specific. It uses OLE for example.
Under Linux, the best result I got was SIGSEGV.
What kind of testing you want that people do on Linux?

The examples are Delphi specific. They use BDE controls TTable and TQuery + others.
You could convert or create some examples that work on Windows at least.

Still, I believe this is a good component for those who make Win-only programs with Lazarus.
Next you can make something similar for OpenOffice suite. :-)

Juha


It doesn't use OLE, if you need this component to work on Linux and you get errors you should fix it and publish if you want so.

For now I don't have time and the need to make it work on linux, I've converted it enough to be compilable on linux. You can't make it work :)

José Mejuto

  • Full Member
  • ***
  • Posts: 136
Re: LazFlexCel
« Reply #14 on: April 28, 2010, 08:46:55 pm »
It doesn't use OLE, if you need this component to work on Linux and you get errors you should fix it and publish if you want so.

For now I don't have time and the need to make it work on linux, I've converted it enough to be compilable on linux. You can't make it work :)

Hello,

It uses OLE in Windows and depends on libgsf, libxml2, libgobject and libglib in Linux. So at least the first is not present in standard non gnome distributions, but I'm not sure, my Linux skills are quite limited.