PlanetSquires Forums

Please login or register.

Login with username, password and session length
Advanced search  

Author Topic: Excel & Print in New visual designer  (Read 1605 times)

Petrus Vorster

  • Senior Member
  • ***
  • Posts: 465
Excel & Print in New visual designer
« on: December 27, 2017, 03:32:19 PM »

Hi All

I am anxiously awaiting the first release of Paul's new visual designer.

Two things i would need is the Excel functions i am using in the .sll for Powerbasic.
The other is the xprint functions of Powerbasic which makes printing as simple as 123.

Being a hobbyist with a tough day job and little time at night, my mind is too tired to try and figure out complex functions.
I like the simplicity it provides.

Would the excel function work in Freebasic and would there be extended print functions like Xprint or something in that line?

Thanks for the work you guys are putting into this! I cannot wait!!

Paul Squires

  • Administrator
  • Guru Member
  • *****
  • Posts: 9301
  • Windows 10
    • PlanetSquires Software
Re: Excel & Print in New visual designer
« Reply #1 on: December 27, 2017, 04:12:02 PM »

Hi Peter,

I can certainly port that xmlExcel code over to FreeBasic. Hopefully make improvements during the conversion :)
I also agree that a great class for FB would be one that emulates XPrint or something similar. Printing in Windows is a pain and a class would certainly make it easier. I have created a class (called WinXPrint) but it is pretty rough and needs more loving before it can be considered good enough.

Paul Squires
PlanetSquires Software
WinFBE Editor and Visual Designer

Klaas Holland

  • Junior Member
  • **
  • Posts: 106
  • FF3 User
Re: Excel & Print in New visual designer
« Reply #2 on: December 30, 2017, 07:37:17 AM »

Hi Paul and Petrus,

I work with (a little modified) version of Paul's WinXPrint and a couple of Functions to make this possible:

'              .XPrint (24, PUsing ("     LevDatum   Aantal   Artikel                        AantalKg     Prijs      Bedrag " ))
            .XPrint (Regel, PUsing ("     \      \   ######   \                            \ ########  #####.##   ######.## ", _
                                          OT.Datum, RT.Aantal, Art.Omschr,         RT.AantalKg, DStr(RT.FPrijs), DStr(Bedrag) ))

In Free Basic there are some nice printing options and a restriction that you have to know.

When anyone has interest I will show you how it works.