Differences in Designer compared to same file opened with OpenSpreadFile

Differences in Designer compared to same file opened with OpenSpreadFile

Posted by: kevin.keller on 15 February 2019, 4:19 pm EST

• 

  kevin.keller

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 15 February 2019, 4:19 pm EST

  I have a spread file saved from the Com 8 version of Spread.
  
  When I open it with the designer overall looks correct Buttons where they should be, percent cell types have the correct look, combo boxes have the lists.
  
  When I open it in VB.Net using the OpenSpreadFile it is missing the buttons that are in the spread as well as the combo boxes don’t seem to have their lists, percent cell types seem to be lost as well.

  I am currently using the trial version to do some proof of concept for the company… Could these missing items be related to that?

  Attached is the sample spread file Saved from Com it is just from our demo data not real stuff

  Thanks for any guidance,

  Kevin

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 20 February 2019, 4:20 am EST

  Hi Kevin,

  It seems that spread file did not get through. Please resend it.
  
  I would also suggest you to go through the online documentation here:
  
  https://help.grapecity.com/spread/SpreadNet12/WF/webframe.html#spwin-open-spreadcom.html
  
  https://help.grapecity.com/spread/SpreadNet12/WF/webframe.html#spwin-comimport.html

  COM and .NET are two different environments, so when you open a file created in COM environment, it may differ from .NET environment.

  Thanks,
  
  Deepak Sharma

• 

  kevin.keller

  • Post Options:
  • Link
    Copy

  Posted 21 February 2019, 10:11 am EST

  Try this… forgot had to be zipped
  
  MBSs.zip

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 22 February 2019, 4:55 am EST

  Hi Kevin,
  
  I opened the file with Spread .NET v12, in VB.NET environment, it seemed to open the file with no loss.
  
  Please refer to the attached image.
  
  In case you find anything not loading in Spread correctly, please let me know.

  Thanks,
  
  Deepak Sharma

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 22 February 2019, 4:55 am EST - Updated 30 September 2022, 1:59 pm EST

  Here is the image, attached.

  

  807×693 31.5 KB

• 

  kevin.keller

  • Post Options:
  • Link
    Copy

  Posted 22 February 2019, 8:06 am EST - Updated 30 September 2022, 1:59 pm EST

  Can you show me the code you used to open the file with?
  
  I am using Spread 12.45.20181.0 in VB.net as well…

  Attached are images from both the vb test app and designer with the code snippet I am using when opening files.

  Thanks,

  Kevin

  

  1001×485 156 KB

  

  965×514 180 KB

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 25 February 2019, 5:02 am EST

  Hi Kevin,

  I am using the code as follows to open the ss7 file:

  fpSpread1.OpenSpreadFile(Application.StartupPath & "\MBSs.ss7", -1)
  

  Thanks,
  
  Deepak Sharma

• 

  kevin.keller

  • Post Options:
  • Link
    Copy

  Posted 25 February 2019, 8:24 am EST

  Thank you Deepak,

  It appears I was using the OpenSpreadFile on the ActiveSheet which appears to behave differently.

  Thanks again,

  Kevin

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 27 February 2019, 1:12 am EST

  Hello,

  Glad that I could help!

  Regards,
  
  Deepak Sharma