Recent

Author Topic: Fortes4Lazarus excel filter  (Read 8444 times)

r_1gm

  • New Member
  • *
  • Posts: 26
Fortes4Lazarus excel filter
« on: February 20, 2011, 05:07:24 pm »
Hi,

I using lazarus from daily snapshot(0.9.29) and fortes4lazarus from svn, and i need fortes to export report to excel, i make a simple fortes report that contain a header band and a label to test this feature, but the generated excel file cannot be opened by LibreOffice or MS Office  Cry, had anybody tried Fortes4Lazarus excel filter feature and success fully create valid excel file ?

and any body know is there any plan for LazReport support to export report to excel? Smiley

Cheers,
Rody

JanRoza

  • Hero Member
  • *****
  • Posts: 591
    • http://www.silentwings.nl
Re: Fortes4Lazarus excel filter
« Reply #1 on: February 21, 2011, 10:46:34 pm »
Just did a test with an application I made earlier and added the Excel filter to the report and ran the application. It made a readable Excel file (tested with Office 2010 and OpenOffice 3), but not all columns were filled correctly (date and time columns remained empty).
But in answer to your question: yes, I did manage to make an Excel export from FortesReport which was readable by my Office Suites.
OS: Windows 10 (64 bit) / Linux Mint (64 bit)
Laz: Lazarus 2.0.10 FPC 3.2.0
       CodeTyphon 7.2 FPC 3.3.1

r_1gm

  • New Member
  • *
  • Posts: 26
Re: Fortes4Lazarus excel filter
« Reply #2 on: February 23, 2011, 06:30:29 am »
Hi JanRoza,

Thank you for your information, it's weird why it's not readable in my case i will try again later, but not all columns were filled correctly it's also a problem too :D, hope this will be fixed.

asdf

  • Sr. Member
  • ****
  • Posts: 310
Re: Fortes4Lazarus excel filter
« Reply #3 on: February 23, 2011, 12:35:12 pm »
and any body know is there any plan for LazReport support to export report to excel?

1. Could LazReport export report to MS Excel ?

2. My 'accounting' project will need to print out many reports, which control is best between LazReport and Fortes4Laz ?
« Last Edit: February 23, 2011, 12:41:25 pm by asdf »
Lazarus 1.2.4 / Win 32 / THAILAND

anis2505

  • Full Member
  • ***
  • Posts: 201
Re: Fortes4Lazarus excel filter
« Reply #4 on: November 09, 2012, 09:54:53 pm »
Hi,

I got the same problem the generated excel file is corrupted unable to
read it with MS Excel 2010.

Does anyone solved this problem Please help

Thanks
Dear Confucius you said {A picture is worth a thousand words}
I say {a good example is worth a thousand words}

 

TinyPortal © 2005-2018