4 Replies Latest reply: Aug 6, 2013 8:59 AM by Elad Betite RSS

    Get sheet name of active sheet , GetProperties();

      I'm trying to get seet name by the following code:


      Sheet s = axQlikOCX1.ActiveDocument.GetSheet(i.ToString());

      string sheetName = s.GetProperties().Name;


      In some files I get the display sheet name BUT in some I get a formula like this:

      for sheet Name="Dashboard" I get "=Only({<Index = {1}>} [$(vLanguage)])  "

      in other file

      for sheet name="Intro" I get   "=Minstring(if(Reference = 'Intro', [$(vLanguage)])) "


      Is there a way to get the display sheet name ("Intro"/"Dashboard") that suitable for all QV files?


      best regards