topic Re: Terrible !!! All sheets are deleted in Integration, Extension & APIs

Terrible !!! All sheets are deleted

Anonymous — Tue, 20 Jan 2015 12:31:03 GMT

If you run this "code" ... All sheets are deleted of the open document and if you want to work with it you must delete the file QVF

MessageBox.Show(" CreateSheet Sheet2 ");

ISheet mySheet = application.CreateSheet("Sheet2");

if (mySheet != null)

{

try

{

mySheet.Properties.MetaDef.Title = "Sheet2";

mySheet.Properties.Rank = 2;

}

catch (Exception)

{

MessageBox.Show("error to create sheet");

throw;

}

Re: Terrible !!! All sheets are deleted

Wed, 21 Jan 2015 12:53:11 GMT

Hi,

Your sheets are not deleted, but your application will not open in the client unless you set the title on the sheets. to be able to set the title you must call Suspend / Resume layout.

mySheet.SuspendLayout();

mySheet.Properties.MetaDef.Title = "Sheet2";

mySheet.Properties.Rank = 2;

mySheet.ResumeLayout();

Or set the properties when creating the sheet like this:

ISheet mySheet = application.CreateSheet("Sheet2",

new SheetProperties { Rank = 0, MetaDef = new SheetMetaDataDef { Title="My sheet" } });

Best regards

Lars-Göran Book

Re: Terrible !!! All sheets are deleted

Anonymous — Wed, 21 Jan 2015 13:07:03 GMT

ok now works!! but also you must to write it in your pages to help.

http://help.qlik.com/sense/en-US/developer/#../Subsystems/NetSdk/Content/HowTos/NetSdk_WorkWith_GenericObject.htm?Highli…

thanks corchi