Issues with inserting a row into FlexSheet

Issues with inserting a row into FlexSheet

Posted by: holly.anderson on 24 January 2018, 11:29 pm EST

• 

  holly.anderson

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 24 January 2018, 11:29 pm EST

  Hello,

  I’m having some issues with inserting a row into a FlexSheet. The problems were originally explained on a different thread (https://www.grapecity.com/en/forums/wijmo/how-to-delete-or-insert-a-), but it doesn’t seem like that thread is being monitored.

  1. Is it possible to specify the default values item properties in the row that is being inserted? I’ve configured the newItemCreator property within the collectionView, but that doesn’t appear to get triggered when insertRows is called.

  2. The insertRows and deleteRows methods don’t work when columns are sorted in the FlexSheet.

  Holly

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 29 January 2018, 7:41 pm EST

  Hi Holly,
  
  We are sorry for the inconvenience for the missing thread and delayed reply. We try to observe and reply each thread posted on forum but I don’t know how this post get remained unreplied.

  Here are the answers for your queries:
  
  #1.

  There is no way to specify the default item directly using method parameter. You need to get the index for added rows and set default values. Please refer to the following code snippet:

  $('#btn1').click(function () {
                  flex.insertRows();
                  flex.rows[flex.selection.row].dataItem={id:5689,country:"India",sales:48798.654};
              });
  

  #2
  
  Thanks for reporting this issue. We are able to replicate the issue and forwarded to the concerned team for further investigation with internal tracking id 306348.

  We will let you know as we get any update on this issue.

  ~Manish

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 26 February 2018, 9:01 pm EST

  Hi Holly,
  
  The issue #306348 has been fixed and you may verify with build 5.20173.428. You may get the latest pre-release build from here:
  
  http://prerelease.componentone.com/wijmo5/

  ~Manish

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 5 March 2018, 7:55 am EST

  Hi Manish,

  I’m having a few issues with inserting and deleting rows.

  1. If I insert one row and then immediately insert another (i.e. click the Insert Row button twice), then the values set on the first inserted row disappear.

  2. Setting the values on the newly inserted row by using flex.selection works when the rows are not sorted. How can I tell which row was newly inserted when sorting is applied to the FlexSheet?

  3. The deleteRows method does not seem to work the first time it is used after inserting rows.

  Thanks,
  
  Holly

  FlexSheetDemo_InsertRow.zip

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 5 March 2018, 9:15 pm EST

  Hi Holly,

  We are working on this. We will update you on this soon.

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 6 March 2018, 11:32 pm EST

  Hi,

  To add new data item you should add the new data item in itemsSource property of flexsheet.

  Find the updated sample in attachments which implements the code.

  As for the sorting problem,it has been identified as bug . I will share the Tracking ID tomorrow.FlexSheetDemo_InsertRow.zip

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 23 March 2018, 5:36 am EST

  Any update?

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 25 March 2018, 11:20 pm EST

  Hi,

  The tracking ID for the Sorting issue is 306358. This issue was reported along with the case reported in https://www.grapecity.com/en/forums/wijmo/flexsheet---discrepancy-be

  Hence, both these cases have the same TrackingID. Once the case is resolved, both issues should get fixed as well.

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 7 April 2018, 4:45 am EST

  The issue with sorting that I observed seems to be fixed for the most part, but I’m still having some trouble. In the last sample provided by you, the Unsort button, which uses sortManager.clearSort(), no longer works as expected. Also, I’m having a problem with the following scenario.

  Steps

  1. Sort column B (descending).
  2. Click on the first cell in the 3rd row.
  3. Click the Insert Row button.

  Result
  
  All cells in the newly inserted row are blank, instead of containing the default values.

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 8 April 2018, 9:20 pm EST

  Hi,

  I have created the following cases

  1. Issue with SortManager.clearSort()- Case ID 316890
  2. Issue with Insert in FlexSheet- CaseID 316891

  I have requested the team to look into them. I will update you once I have further updates.

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 26 April 2018, 3:25 am EST

  Any update?

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 26 April 2018, 7:24 pm EST

  Hi Holly,
  
  The issue has been found fixed in build 5.20181.456. Please get the latest nightly build from here:
  
  http://prerelease.componentone.com/wijmo5/

  ~Manish