PlanetSquires Forums

Please login or register.

Login with username, password and session length
Advanced search  

Author Topic: setting row height in XMLEXCEL.SLL  (Read 460 times)

KEYTEKNOWLEDGY

  • Little Newbie
  • *
  • Posts: 6
setting row height in XMLEXCEL.SLL
« on: August 19, 2019, 05:16:17 PM »

I Have a header line where I wrap the text (creates 3 lines of text) in a number of columns.  I am trying to set the row height so all three lines show up (versus the default row height).   Apparently the row height setting is fixed.  I tried to set the default row height, but I dont get any change in row height.

ws.DefaultRowHeight = 30

Can anyone shed some light on how to set Row Height for a header Row?

Thanks.
Logged

Paul Squires

  • Administrator
  • Guru Member
  • *****
  • Posts: 8848
  • Windows 10
    • PlanetSquires Software
Re: setting row height in XMLEXCEL.SLL
« Reply #1 on: August 19, 2019, 11:07:10 PM »

You could try modifying the source in clsWorksheet.inc around line 256:

Code: [Select]
         sRowMaster = _
            "  <Row//ROW_INDEX// ss:AutoFitHeight=*0*>"  & $CrLf & _
            "  //CELL_DATA//" & _
            "  </Row>"& $CrLf
         Replace "*" With $Dq In sRowMaster

Change:
   ss:AutoFitHeight=*0*

To:
   ss:AutoFitHeight=*1*

Recompile the SLL.

This will auto size the height of every row in the table so that the contents will fit the display.

To resize heights of individual rows then you would need to change code around line 320 and add an ss:Height attribute.


Logged
Paul Squires
PlanetSquires Software
WinFBE Editor and Visual Designer

KEYTEKNOWLEDGY

  • Little Newbie
  • *
  • Posts: 6
Re: setting row height in XMLEXCEL.SLL
« Reply #2 on: August 20, 2019, 10:38:17 AM »

Thanks for the response.  I think that will solve my issue.  However, I have to plead ignorance of where do I find clsWorkSheet.Inc and how do I recompile  the .sll file.?
Logged

Paul Squires

  • Administrator
  • Guru Member
  • *****
  • Posts: 8848
  • Windows 10
    • PlanetSquires Software
Re: setting row height in XMLEXCEL.SLL
« Reply #3 on: August 20, 2019, 12:05:15 PM »

The source code is attached to the first post:  https://www.planetsquires.com/protect/forum/index.php?topic=3208.0
Logged
Paul Squires
PlanetSquires Software
WinFBE Editor and Visual Designer

KEYTEKNOWLEDGY

  • Little Newbie
  • *
  • Posts: 6
Re: setting row height in XMLEXCEL.SLL
« Reply #4 on: August 21, 2019, 10:39:46 AM »

OK.   I did not see the link to the source code.  i have it and have updated the .inc.  But I still dont know how to recompile the sll?
Logged

Paul Squires

  • Administrator
  • Guru Member
  • *****
  • Posts: 8848
  • Windows 10
    • PlanetSquires Software
Re: setting row height in XMLEXCEL.SLL
« Reply #5 on: August 21, 2019, 05:36:45 PM »

It's been a very long time since I used PowerBasic but I compiled the SLL (see attachment). Let me know if it does not meet your needs.
Logged
Paul Squires
PlanetSquires Software
WinFBE Editor and Visual Designer

KEYTEKNOWLEDGY

  • Little Newbie
  • *
  • Posts: 6
Re: setting row height in XMLEXCEL.SLL
« Reply #6 on: August 26, 2019, 12:24:36 PM »

Thanks Paul.  I need to move off PowerBasic and am researching alternatives.  PureBasic and FreeBasic.   Got any opinion you wish to share. 
Logged

Paul Squires

  • Administrator
  • Guru Member
  • *****
  • Posts: 8848
  • Windows 10
    • PlanetSquires Software
Re: setting row height in XMLEXCEL.SLL
« Reply #7 on: August 26, 2019, 12:58:00 PM »

FreeBasic is what I use exclusively now. A little bit of a learning curve during the transition over from PowerBasic but it was nothing too painful. I have never used PureBasic although I have heard good things about it also (although I think that the syntax is not as "BASIC" as other languages in the genre - I could be wrong about that).
Logged
Paul Squires
PlanetSquires Software
WinFBE Editor and Visual Designer

KEYTEKNOWLEDGY

  • Little Newbie
  • *
  • Posts: 6
Re: setting row height in XMLEXCEL.SLL
« Reply #8 on: August 28, 2019, 10:39:12 AM »

Thanks.  I have looked at PureBasic and you are correct.  That "BASIC" context is a bit different than BASIC.  Conversion looks to be a bit more difficult from POWERBASIC.  There are some good conversion doc's on it. 

Are there any conversion docs for conversion from PowerBasic to FreeBasic.  I am using the console compiler. Lots of "GRAPHIC ..... Statements.

Thanks again.
Logged

Josť Roca

  • Guru Member
  • *****
  • Posts: 3200
Re: setting row height in XMLEXCEL.SLL
« Reply #9 on: August 28, 2019, 12:52:02 PM »

The GRAPHIC statements are not standard, but proprietary. You will have to rewrite everything from scratch using whatever that compiler uses.

Paul Squires

  • Administrator
  • Guru Member
  • *****
  • Posts: 8848
  • Windows 10
    • PlanetSquires Software
Re: setting row height in XMLEXCEL.SLL
« Reply #10 on: August 28, 2019, 08:47:32 PM »

Are there any conversion docs for conversion from PowerBasic to FreeBasic. 

Not really but here are a couple of posts where this was previously discussed.
https://www.planetsquires.com/protect/forum/index.php?topic=4259.0
https://www.planetsquires.com/protect/forum/index.php?topic=3647.0
Logged
Paul Squires
PlanetSquires Software
WinFBE Editor and Visual Designer

KEYTEKNOWLEDGY

  • Little Newbie
  • *
  • Posts: 6
Re: setting row height in XMLEXCEL.SLL
« Reply #11 on: September 10, 2019, 10:52:40 AM »

I think I remember Jose R from the Power Basic Forums.

I have done about three conversions going back to the early 80's of this application (BICARSA) type of app, and have added a lot of addition function including purchasing, AR, etc.  Started with MS Quick Basic when the PC came out.  Originally started on an IBM 5110 with two 8" 1 MB diskettes for data storage.  (History of computing lesson).  It is for a small (but global) wholesale distributor.  So changing syntax in commands is not a big deal, more tedium.  Changing graphic commands is also not a big deal.  I have my code pretty modular where I use the keyboard, mouse, and set window sizes.  I use UDF structures for my data. 

I have two challenges.  1.  I am still using BTRIEVE for transaction processing, and have defined DDF's for relational (ODBC) queries using PSQL (Now ACTIAN).  I need to move off that platform, I think.  Probably will go to SQL or SQL lite. 
2.  When I move, I like FreeBasic because it is open source and will probably be around for a while.  However, I have a lot of things that are QB like, (Like GoSub's) and would like to move to generic FreeBasic (Not use the Lang QB option).  So that is another bit of a challenge.

Anybody got a smallish example of a freebasic program that defines a window and takes some data input and prints it out.  Kind of a "HELLO WORLD" app with some screen management stuff.  It would help me get a start.  Also, any thoughts on DB?
Logged