Grouping rows on Simon Berridge's Excel

General
1

Hi all!

Anyone knows if its possible to Group rows on Simon Berridge’s Excel?
Thanks

:smiley:

2

Gerardo

I am not sure what you mean with this question.

My gut reaction is No. I have not implemented all features, just a sub-set or ‘normal’ functions. There is conditional formatting available but I am not sure if this is what you mean.

Please advise exactly what you need.

Simon.

3

[quote=265073:@Simon Berridge]Gerardo

I am not sure what you mean with this question.

My gut reaction is No. I have not implemented all features, just a sub-set or ‘normal’ functions. There is conditional formatting available but I am not sure if this is what you mean.

Please advise exactly what you need.

Simon.[/quote]
Hi Simon.
Thanks, That I try to do is add several rows after one row, and “hide” this rows “grouping it” like Excel does, when rows are grouped you can clic the “plus button” beside the row and it will expand and show the hidden rows.

4

Gerardo

I am not an Excel expert and I have not seen this function before.

Let me check it out and see if I can add it to the class(es). At this point, though, I can tell you that it is not handled so is currently unavailable.

Simon.

5

[quote=265256:@Simon Berridge]Gerardo

I am not an Excel expert and I have not seen this function before.

Let me check it out and see if I can add it to the class(es). At this point, though, I can tell you that it is not handled so is currently unavailable.

Simon.[/quote]
Ok Simon, Thanks :smiley: and Regards

6

[quote=265256:@Simon Berridge]Gerardo

I am not an Excel expert and I have not seen this function before.

Let me check it out and see if I can add it to the class(es). At this point, though, I can tell you that it is not handled so is currently unavailable.

Simon.[/quote]
Hi Simon.

I write in this thread in order to not open new one.

I know that “SetCellFormula” works for doing Excel Formulas in a cell, like: Average, SUM, Date, Etc.

So I want to comment Text, you know when a String has an hyphen “-” it causes a table error and the worksheet can’t open.

So I made this Solution:

Serial = "'"+ listbox.cell(i,7) xl.SetCellValue(4, Number, Serial) xl.SetCellStyleID(4,Number, "SBS000004")

As you can see I add an Apostrophe before the text, in order to Excel can detect it like a comment.

But when I do this, Ok It write the values with hyphens without problem.
But the apostrophe is “Visible”, not invisible like when you write it on Excel.

So I investigate about “CONCATENATE” Function
and you can add one ore more texts without problem on excel.

Thinking on this I do the follow:
Dim Serial As String = “”""+lista.cell(i,6)+""""
xl.SetCellFormula(5, i+7, “=CONCATENAR(”+ Serial +")")
xl.SetCellStyleID(5,i+7, “SBS000004”)

And It doesn’t work.

Also I tried to change to:
Serie = “”+lista.cell(i,6)+""

And when I do this, Writes on Excel: #NAME? =CONCATENATE(Example-example)

Is it possible to do this?
Thanks

7

I’ made an excel file with grouped rows and saved in Excel XML, and look the XML Code, and looks like this:

<Worksheet ss:Name="Hoja1">
  <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="8" x:FullColumns="1"
   x:FullRows="1" ss:DefaultRowHeight="16">
   <Row ss:StyleID="s62">
    <Cell><Data ss:Type="String">Hola</Data></Cell>
   </Row>
   <Row ss:Hidden="1">
    <Cell><Data ss:Type="String">conc 1</Data></Cell>
   </Row>
   <Row ss:Hidden="1">
    <Cell><Data ss:Type="String">conc2</Data></Cell>
   </Row>
   <Row ss:Hidden="1">
    <Cell><Data ss:Type="String">conc3</Data></Cell>
   </Row>
   <Row ss:StyleID="s62">
    <Cell><Data ss:Type="String">Yepo</Data></Cell>
   </Row>
   <Row ss:Hidden="1">
    <Cell><Data ss:Type="String">Conc1</Data></Cell>
   </Row>
   <Row ss:Hidden="1">
    <Cell><Data ss:Type="String">Conc2</Data></Cell>
   </Row>
  </Table>

So I need to think how to process this and Do this on Xojo with the Simon Berridge’s Excel process