6 Replies Latest reply: Jul 9, 2011 6:19 AM by John O'Mahoney RSS

    sheet vanishes on Clear

      Hi

       

      I have been developing a document and it has been working ok.

      I have security on most sheets using show sheets -  conditional and this has been working fine.

      (simple script loading spreadsheet with user name and 1 or 0 for each sheet)

       

      The document was working ok, but now for no apparent reason if I hit the clear button my conditional sheets vanish.

      All I have been doing since it worked is changed some items on the dashboard, but perhaps I have clicked/ edited something by mistake

       

      When I close and reopen the document the sheets re appear

       

       

      any help appreciated

      regards

      John

      (Using Version 10 64bit)

        • sheet vanishes on Clear
          Derek Jones

          Hi John

           

          can you copy and paste in this discussion the condition expression you are using in your sheet properties to verify if user can view the sheet?

           

          I suspect that by hitting the clear button you are clearing the user and so on teh conditional check it's coming back false so not showing you the sheet?

           

          rgds

           

          Derek

            • sheet vanishes on Clear

              Hi Derek

               

              Problem resolved - thanks for pointing me in the right direction

              I also had a trigger on opening of the document which selected the user from the same spreadsheet.

              seems like the load trigger is cleared when selecting the clear button.

              I just added the on username trigger back into the clear button after the clear action and it works ok.

              (not sure if this is the most elegant solution but it works)

               

              On load trigger

              Username

              =upper(osuser())

               

              Conditional - show sheet

              sum(Dashboard) = 1

               

              Excel sheet contains

              Username        Dashboard

              fifeab\johnomah     1

               

              Load statement

              AccessMatrix:

              LOAD Username,

                   Dashboard,

              FROM  [60_DataSources\Security.xlsx] (ooxml, embedded labels, table is Sheet1);