B4J Question JPOI SetRange

[micro]

Hi to all
I attached a test file, a example written to learn the Jpoi library
Why SetRange does not work properly?

SetNamedRange(wb, "sheet1", "Range_name", "$A$2:$A$" & 20) 'set the range
SetNamedRange(wb, "sheet1", "Range_pieces", "$B$2:$B$" & 20)

Thanks

 

[Erel]

Why SetRange does not work properly?

You should better describe what doesn't work for you.

Have you tried this example: https://www.b4x.com/android/forum/t...nd-templates-with-jpoi-library.57689/#content ?

 

[micro]

You should better describe what doesn't work for you.

The bar displayed are incorrect (see attached file in the first post)

Sub AppStart (Form1 As Form, Args() As String)
    MainForm = Form1
    'MainForm.RootPane.LoadLayout("Layout1") 'Load the layout file.
    MainForm.Show
    Dim wb As PoiWorkbook
    wb.InitializeExisting(File.DirAssets, "template.xlsx", "")
    Dim s1 As PoiSheet = wb.GetSheet(0)    'unica sheet
    Dim i As Int
    For i = 1 To 20     ' bar displayed, but is not so
        Dim row As PoiRow = s1.CreateRow(i)
        row.CreateCellString(0, "Name" & i)
        row.CreateCellNumeric(1, Rnd(100, 1000))
    Next
    SetNamedRange(wb, "sheet1", "Range_name", "$A$2:$A$" & 20) 'set the range
    SetNamedRange(wb, "sheet1", "Range_pieces", "$B$2:$B$" & 20)
    wb.Save(File.DirApp, "Chart.xlsx")
    wb.Close
    fx.ShowExternalDocument(File.GetUri(File.DirApp, "Chart.xlsx"))
End Sub

Thanks

 

[Daestrum]

I ran your code from post #1 and both ranges are being created, could it be the code you use to generate the graphics is where the problem lies?

 

[micro]

I ran your code from post #1 and both ranges are being created, could it be the code you use to generate the graphics is where the problem lies?

There is no code to produce graphics, see template.xlsx in Files Folders.
Thanks

 

[Daestrum]

After I edited the data range for the graph to Range_name;Range_pieces all the columns were visible.

 

[micro]

After I edited the data range for the graph to Range_name;Range_pieces all the columns were visible.

??
This is in my template.xlsx (after chart.xlsx)

but as you see not all bars are displayed.

 

[Daestrum]

After I regenerated the template file it seems to work now.
(The template was generated inside the b4j app by drawing the graph to the spreadsheet, so is not exactly like your original)