예제 #1
0
 private void ordersReport_AfterGenerateWorkbook(object sender, FlexCel.Report.GenerateEventArgs e)
 {
     if (encryptionType.SelectedItem == encryptionType.Items[1])
     {
         e.File.Protection.EncryptionType = TEncryptionType.Xor;
     }
     else
     {
         e.File.Protection.EncryptionType = TEncryptionType.Standard;
     }
     e.File.Protection.OpenPassword = OpenPassGenerated.Text;
     e.File.Protection.SetModifyPassword(ModifyPassGenerated.Text, RecommendReadOnly.Checked, ReservingUser.Text);
     e.File.Protection.SetWorkbookProtection(ProtectWorkbookPass.Text, new TWorkbookProtectionOptions(false, ProtectWorkbook.Checked));
 }
예제 #2
0
        private void MinesReport_AfterGenerateWorkbook(object sender, FlexCel.Report.GenerateEventArgs e)
        {
            //do some "pretty" up for the final user.
            //we could do this directly on the template, but doing it here allows us to keep the template unprotected and easier to modify.

            e.File.ActiveSheet  = 2;
            e.File.SheetVisible = TXlsSheetVisible.Hidden;
            e.File.ActiveSheet  = 1;
            e.File.Protection.SetSheetProtection(null, new TSheetProtectionOptions(true));
            for (int r = 20; r <= FlxConsts.Max_Rows97_2003 + 1; r++)
            {
                e.File.SetRowHidden(r, true);
            }
            for (int c = 12; c <= FlxConsts.Max_Columns97_2003 + 1; c++)
            {
                e.File.SetColHidden(c, true);
            }
        }
예제 #3
0
 private void ordersReport_AfterGenerateSheet(object sender, FlexCel.Report.GenerateEventArgs e)
 {
     e.File.Protection.SetSheetProtection(ProtectSheetPass.Text, new TSheetProtectionOptions(ProtectSheet.Checked));
 }
예제 #4
0
 private void ordersReport_BeforeReadTemplate(object sender, FlexCel.Report.GenerateEventArgs e)
 {
     e.File.Protection.OpenPassword = OpenPassTemplate.Text;
 }