I am working with a TableView and there seems to be a limit of 100 rows that can be added. Even if I prompt for the number of rows to add , say for example 150, when I add 150 rows in Excel and submit only 100 will actually be inserted. Does anyone know if there is a limit to the number of rows that will actually be added no matter the value you pass to the NumberOfEmptyRowsToAdd property?
Yes, TableView NumberOfEmptyRowsToAdd is hard capped at 100.
Yes, TableView NumberOfEmptyRowsToAdd is hard capped at 100.
The standard functionality NumberOfEmptyRowsToAdd is limited correct, but you can import more. Not sure if this helps though with your case.
You can have a param NoOfRows in the Excel. Refresh the Excel, read the NoOfRows and then add the no of rows requested
Dim tvRow As New TableViewRow()
..
tv.Rows.Add(tvRow)
In may case with about 20 columns, validating each cell, encrypting each cell, inserting the records to DB (main and related table records), the whole submit/save process takes around 14s for 6k and 80s for 30k records. The initial refresh to get the view wll also take a few seconds.
The downside is that the user has to hit refresh before pasting/editing data but in my case TableViews were the only "secure" way to get sensitive data into OneStream without have readable files/records in OneStream (not even admins were accepted to read the data)
