PlanetSquires Forums

Please login or register.

Login with username, password and session length
Advanced search  

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

KEYTEKNOWLEDGY

  • Little Newbie
  • *
  • Posts: 3
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: 8822
  • 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: 3
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: 8822
  • 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: 3
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: 8822
  • 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