Where is data after open

Where is data after open

Posted by: david on 22 October 2019, 11:38 pm EST

• 

  david

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 22 October 2019, 11:38 pm EST

  Hello,

  I’ve saved a sheet

  fpSpread1.Save(fullFileName, false);
  

  I’ve loaded the file

  fpSpread1.Open(_fullFileName);
  

  After I look on a cell but it’s empty

  fpSpread1_Sheet1.Cells[0, 0].Text
  

  Note that spread display data. Then where is my data ?
  
  thks

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 24 October 2019, 4:43 pm EST

  Hello,

  Could you please check with the following line of code:

  fpSpread1_Sheet1.Cells[0, 0].Value
  
  

  Thanks,
  
  Mohit

• 

  david

  • Post Options:
  • Link
    Copy

  Posted 24 October 2019, 5:54 pm EST

  it returns null.
  
  In addition, the spread has 500 lines (number of lines when the spread is not initialized) when in fact the file contains only 6 (and 6 lines are well displayed).

  The file data is correctly displayed after opening but the spread / sheetview object does not seem to be initialized

• 

  david

  • Post Options:
  • Link
    Copy

  Posted 28 October 2019, 6:31 pm EST

  nobody can answer ?

• 

  tosch

  • Post Options:
  • Link
    Copy

  Posted 29 October 2019, 1:03 am EST

  Try opening your file in a XML editor and see if you can find the data.
  
  The values for the cells are in Spread/Data/Sheets/Sheet/DataArea/Cells/Cell.

  Tom

• 

  david

  • Post Options:
  • Link
    Copy

  Posted 30 October 2019, 1:14 am EST

  The data are present

  I have attached a sample project
  
  To use :
  
  1 : click button “Initialize” (to load data) (see : Rowcount label = 2)
  
  2 : select a cell (see at bottom of grid the text and value of selected cell)
  
  3 : click button “Save”
  
  4 : click button “Clear”
  
  5 : Click button “Load” (rowCount label=500 and 2 lines displayed !)
  
  6 : select a cell (row and column indexes = 0; Text and Value properties are empty)
  
  TestSpread_Xml.zip

• 

  tosch

  • Post Options:
  • Link
    Copy

  Posted 31 October 2019, 2:25 am EST

  if you do this after .Open all will be fine:
  
  FpSpread1_Sheet1 = FpSpread1.Sheets(0);

  Thomas

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 31 October 2019, 4:45 pm EST

  Hello David,

  We are very sorry for the delay. Due to some technical problems, issue is missed from our list. I think your issue is resolved now. If you still facing any problem, please feel free to revert or open a new case.

  Thanks,
  
  Mohit