Esempio n. 1
0
        private void btnCreatePdf_Click(object sender, EventArgs e)
        {
            // create a PDF document
            Document document = new Document();

            // set the license key
            document.LicenseKey = "B4mYiJubiJiInIaYiJuZhpmahpGRkZE=";

            // add a page to the PDF document
            PdfPage firstPage = document.AddPage();

            string logoImagePath = System.IO.Path.Combine(Application.StartupPath, @"..\..\img\evologo-250.png");
            string certificateFilePath = System.IO.Path.Combine(Application.StartupPath, @"..\..\certificates\evopdf.pfx");

            PdfFont pdfFont = document.Fonts.Add(new Font("Arial", 10, FontStyle.Regular, GraphicsUnit.Point));
            TextElement descriptionTextElement = new TextElement(0, 0,
                "A digital signature was applied on the logo image below. Click on the image to see the signature details", pdfFont);
            AddElementResult addResult = firstPage.AddElement(descriptionTextElement);

            // create the area where the digital signature will be displayed in the PDF document
            // in this sample the area is a logo image but it could be anything else
            ImageElement logoElement = new ImageElement(0, addResult.EndPageBounds.Bottom + 10, 100, logoImagePath);
            addResult = firstPage.AddElement(logoElement);

            //get the #PKCS 12 certificate from file
            DigitalCertificatesCollection certificates = DigitalCertificatesStore.GetCertificates(certificateFilePath, "evopdf");
            DigitalCertificate certificate = certificates[0];

            // create the digital signature over the logo image element
            DigitalSignatureElement signature = new DigitalSignatureElement(addResult.EndPageBounds, certificate);
            signature.Reason = "Protect the document from unwanted changes";
            signature.ContactInfo = "The contact email is [email protected]";
            signature.Location = "Development server";
            firstPage.AddElement(signature);

            string outFilePath = System.IO.Path.Combine(Application.StartupPath, "DigitalSignature.pdf");

            // save the PDF document to disk
            document.Save(outFilePath);

            // close the PDF document to release the resources
            document.Close();

            DialogResult dr = MessageBox.Show("Open the saved file in an external viewer?", "Open Rendered File", MessageBoxButtons.YesNo);
            if (dr == DialogResult.Yes)
            {
                try
                {
                    System.Diagnostics.Process.Start(outFilePath);
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    return;
                }
            }
        }
Esempio n. 2
0
 private string ExtractTextFromImage(string filePath)
 {
     Document modiDocument = new Document();
     modiDocument.Create(filePath);
     modiDocument.OCR(MiLANGUAGES.miLANG_ENGLISH);
     MODI.Image modiImage = (modiDocument.Images[0] as MODI.Image);
     string extractedText = modiImage.Layout.Text;
     modiDocument.Close();
     return extractedText;
 }
Esempio n. 3
0
        private void btnCreatePdf_Click(object sender, EventArgs e)
        {
            // create a PDF document
            Document document = new Document();

            // set the license key
            document.LicenseKey = "B4mYiJubiJiInIaYiJuZhpmahpGRkZE=";

            // add a page to the PDF document
            PdfPage firstPage = document.AddPage();

            string imagesPath = System.IO.Path.Combine(Application.StartupPath, @"..\..\Img");

            // display image in the available space in page and with a auto determined height to keep the aspect ratio
            ImageElement imageElement1 = new ImageElement(0, 0, System.IO.Path.Combine(imagesPath, "evologo-250.png"));
            AddElementResult addResult = firstPage.AddElement(imageElement1);

            // display image with the specified width and the height auto determined to keep the aspect ratio
            // the images is displayed to the right of the previous image and the bounds of the image inside the current page
            // are taken from the AddElementResult object
            ImageElement imageElement2 = new ImageElement(addResult.EndPageBounds.Right + 10, 0, 100,
                    System.IO.Path.Combine(imagesPath, "evologo-250.png"));
            addResult = firstPage.AddElement(imageElement2);

            // Display image with the specified width and the specified height. It is possible for the image to not preserve the aspect ratio
            // The images is displayed to the right of the previous image and the bounds of the image inside the current page
            // are taken from the AddElementResult object
            ImageElement imageElement3 = new ImageElement(addResult.EndPageBounds.Right + 10, 0, 100, 50,
                    System.IO.Path.Combine(imagesPath, "evologo-250.png"));
            addResult = firstPage.AddElement(imageElement3);

            string outFilePath = System.IO.Path.Combine(Application.StartupPath, "ImageElementDemo.pdf");

            // save the PDF document to disk
            document.Save(outFilePath);

            // close the PDF document to release the resources
            document.Close();

            DialogResult dr = MessageBox.Show("Open the saved file in an external viewer?", "Open Rendered File", MessageBoxButtons.YesNo);
            if (dr == DialogResult.Yes)
            {
                try
                {
                    System.Diagnostics.Process.Start(outFilePath);
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    return;
                }
            }
        }
        public void ImprimirEtiquetas(String Titulo, String Modelo, String Gramos, String ID)
        {
            String sPath = "C:\\Users\\Adan Cervera\\Desktop\\TestGit\\TestGit\\POS.View\\VentasView\\CONTENEDORES.lbx";
            bpac.Document objDoc = new Document();
            objDoc = new Document();
            if (objDoc.Open(sPath) != null)
            {
                objDoc.GetObject("objTitulo").Text = Titulo;
                objDoc.GetObject("modelo").Text = Modelo;
                objDoc.GetObject("gramos").Text = Gramos;
                objDoc.GetObject("codebar").Text = ID.ToString() + '-' + Gramos;

                objDoc.StartPrint("", bpac.PrintOptionConstants.bpoDefault);
                objDoc.PrintOut(1, bpac.PrintOptionConstants.bpoDefault);
                objDoc.EndPrint();
                objDoc.Close();
            }
        }
 private void CloseDocument(Document document)
 {
     if (delayedCodeBehindClose)
     {
         documentCloseTimer = CreateTimer(() =>
             {
                 documentCloseTimer = null;
                 document.Close();
             }, 500);
     }
     else
     {
         document.Close();
     }
 }
Esempio n. 6
0
        private void btnConvert_Click(object sender, EventArgs e)
        {
            this.Cursor = Cursors.WaitCursor;

            string outFilePath = Path.Combine(Application.StartupPath, "HtmlToPdfElement.pdf");

            // the PDF document
            Document document = null;

            try
            {
                //create a PDF document
                document = new Document();

                // set the license key
                document.LicenseKey = "B4mYiJubiJiInIaYiJuZhpmahpGRkZE=";

                //optional settings for the PDF document like margins, compression level,
                //security options, viewer preferences, document information, etc
                document.CompressionLevel = PdfCompressionLevel.Normal;
                document.Margins = new Margins(10, 10, 0, 0);
                //document.Security.CanPrint = true;
                //document.Security.UserPassword = "";
                document.DocumentInformation.Author = "HTML to PDF Converter";
                document.ViewerPreferences.HideToolbar = false;

                // set if the JPEG compression is enabled for the images in PDF - default is true
                document.JpegCompressionEnabled = cbJpegCompression.Checked;

                //Add a first page to the document. The next pages will inherit the settings from this page
                PdfPage page = document.Pages.AddNewPage(PdfPageSize.A4, new Margins(10, 10, 0, 0), PdfPageOrientation.Portrait);

                // the code below can be used to create a page with default settings A4, document margins inherited, portrait orientation
                //PdfPage page = document.Pages.AddNewPage();

                // add a font to the document that can be used for the texts elements
                PdfFont font = document.Fonts.Add(new Font(new FontFamily("Times New Roman"), 10, GraphicsUnit.Point));

                // add header and footer before renderng the content
                if (cbAddHeader.Checked)
                    AddHtmlHeader(document);
                if (cbAddFooter.Checked)
                    AddHtmlFooter(document, font);

                // the result of adding an element to a PDF page
                AddElementResult addResult;

                // Get the specified location and size of the rendered content
                // A negative value for width and height means to auto determine
                // The auto determined width is the available width in the PDF page
                // and the auto determined height is the height necessary to render all the content
                float xLocation = float.Parse(textBoxXLocation.Text.Trim());
                float yLocation = float.Parse(textBoxYLocation.Text.Trim());
                float width = float.Parse(textBoxWidth.Text.Trim());
                float height = float.Parse(textBoxHeight.Text.Trim());

                if (radioConvertToSelectablePDF.Checked)
                {
                    // convert HTML to PDF
                    HtmlToPdfElement htmlToPdfElement;

                    // convert a URL to PDF
                    string urlToConvert = textBoxWebPageURL.Text.Trim();

                    htmlToPdfElement = new HtmlToPdfElement(xLocation, yLocation, width, height, urlToConvert);

                    //optional settings for the HTML to PDF converter
                    htmlToPdfElement.FitWidth = cbFitWidth.Checked;
                    htmlToPdfElement.EmbedFonts = cbEmbedFonts.Checked;
                    htmlToPdfElement.LiveUrlsEnabled = cbLiveLinks.Checked;
                    htmlToPdfElement.JavaScriptEnabled = cbScriptsEnabled.Checked;
                    htmlToPdfElement.PdfBookmarkOptions.HtmlElementSelectors = cbBookmarks.Checked ? new string[] { "H1", "H2" } : null;

                    // add theHTML to PDF converter element to page
                    addResult = page.AddElement(htmlToPdfElement);
                }
                else
                {
                    HtmlToImageElement htmlToImageElement;

                    // convert HTML to image and add image to PDF document

                    // convert a URL to PDF
                    string urlToConvert = textBoxWebPageURL.Text.Trim();

                    htmlToImageElement = new HtmlToImageElement(xLocation, yLocation, width, height, urlToConvert);

                    //optional settings for the HTML to PDF converter
                    htmlToImageElement.FitWidth = cbFitWidth.Checked;
                    htmlToImageElement.LiveUrlsEnabled = cbLiveLinks.Checked;
                    htmlToImageElement.JavaScriptEnabled = cbScriptsEnabled.Checked;
                    htmlToImageElement.PdfBookmarkOptions.HtmlElementSelectors = cbBookmarks.Checked ? new string[] { "H1", "H2" } : null;

                    addResult = page.AddElement(htmlToImageElement);
                }

                if (cbAdditionalContent.Checked)
                {
                    // The code below can be used add some other elements right under the conversion result
                    // like texts or another HTML to PDF conversion

                    // add a text element right under the HTML to PDF document
                    PdfPage endPage = document.Pages[addResult.EndPageIndex];
                    TextElement nextTextElement = new TextElement(0, addResult.EndPageBounds.Bottom + 10, "Below there is another HTML to PDF Element", font);
                    nextTextElement.ForeColor = Color.Green;
                    addResult = endPage.AddElement(nextTextElement);

                    // add another HTML to PDF converter element right under the text element
                    endPage = document.Pages[addResult.EndPageIndex];
                    HtmlToPdfElement nextHtmlToPdfElement = new HtmlToPdfElement(0, addResult.EndPageBounds.Bottom + 10, "http://www.google.com");
                    addResult = endPage.AddElement(nextHtmlToPdfElement);
                }

                // save the PDF document to disk
                document.Save(outFilePath);

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
            finally
            {
                // close the PDF document to release the resources
                if (document != null)
                    document.Close();

                this.Cursor = Cursors.Arrow;
            }

            DialogResult dr = MessageBox.Show("Open the saved file in an external viewer?", "Open Rendered File", MessageBoxButtons.YesNo);
            if (dr == DialogResult.Yes)
            {
                try
                {
                    System.Diagnostics.Process.Start(outFilePath);
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    return;
                }
            }
        }
Esempio n. 7
0
        private void btnCreatePdf_Click(object sender, EventArgs e)
        {
            // create a PDF document
            Document document = new Document();

            // set the license key
            document.LicenseKey = "B4mYiJubiJiInIaYiJuZhpmahpGRkZE=";

            // add a page to the PDF document
            PdfPage firstPage = document.AddPage();

            // Create a Times New Roman .NET font of 10 points
            System.Drawing.Font ttfFont = new System.Drawing.Font("Times New Roman", 10, System.Drawing.GraphicsUnit.Point);
            // Create a Times New Roman Italic .NET font of 10 points
            System.Drawing.Font ttfFontItalic = new System.Drawing.Font("Times New Roman", 10,
                        System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point);
            // Create a Times New Roman Bold .NET font of 10 points
            System.Drawing.Font ttfFontBold = new System.Drawing.Font("Times New Roman", 10,
                        System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point);
            // Create a Times New Roman Bold .NET font of 10 points
            System.Drawing.Font ttfFontBoldItalic = new System.Drawing.Font("Times New Roman", 10,
                        System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point);

            // Create a Sim Sun .NET font of 10 points
            System.Drawing.Font ttfCJKFont = new System.Drawing.Font("SimSun", 10,
                        System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point);

            // Create the PDF fonts based on the .NET true type fonts
            PdfFont newTimesFont = document.AddFont(ttfFont);
            PdfFont newTimesFontItalic = document.AddFont(ttfFontItalic);
            PdfFont newTimesFontBold = document.AddFont(ttfFontBold);
            PdfFont newTimesFontBoldItalic = document.AddFont(ttfFontBoldItalic);

            // Create the embedded PDF fonts based on the .NET true type fonts
            PdfFont newTimesEmbeddedFont = document.AddFont(ttfFont, true);
            PdfFont newTimesItalicEmbeddedFont = document.AddFont(ttfFontItalic, true);
            PdfFont newTimesBoldEmbeddedFont = document.AddFont(ttfFontBold, true);
            PdfFont newTimesBoldItalicEmbeddedFont = document.AddFont(ttfFontBoldItalic, true);

            PdfFont cjkEmbeddedFont = document.AddFont(ttfCJKFont, true);

            // Create a standard Times New Roman Type 1 Font
            PdfFont stdTimesFont = document.AddFont(StdFontBaseFamily.TimesRoman);
            PdfFont stdTimesFontItalic = document.AddFont(StdFontBaseFamily.TimesItalic);
            PdfFont stdTimesFontBold = document.AddFont(StdFontBaseFamily.TimesBold);
            PdfFont stdTimesFontBoldItalic = document.AddFont(StdFontBaseFamily.TimesBoldItalic);

            // Create CJK standard Type 1 fonts
            PdfFont cjkJapaneseStandardFont = document.AddFont(StandardCJKFont.HeiseiKakuGothicW5);
            PdfFont cjkChineseTraditionalStandardFont = document.AddFont(StandardCJKFont.MonotypeHeiMedium);

            // Add text elements to the document

            TextElement trueTypeText = new TextElement(0, 10, "True Type Fonts Demo:", newTimesFontBold);
            AddElementResult addResult = firstPage.AddElement(trueTypeText);

            // Create the text element
            TextElement textElement1 = new TextElement(20, addResult.EndPageBounds.Bottom + 10, "Hello World !!!!", newTimesFont);
            // Add element to page. The result of adding the text element is stored into the addResult object
            // which can be used to get information about the rendered size in PDF page.
            addResult = firstPage.AddElement(textElement1);

            // Add another element 5 points below the text above. The bottom of the text above is taken from the AddElementResult object
            // set the font size
            newTimesFontItalic.Size = 15;
            TextElement textElement2 = new TextElement(20, addResult.EndPageBounds.Bottom + 5, "Hello World !!!!", newTimesFontItalic);
            textElement2.ForeColor = System.Drawing.Color.Green;
            addResult = firstPage.AddElement(textElement2);

            newTimesFontBoldItalic.Size = 20;
            TextElement textElement3 = new TextElement(20, addResult.EndPageBounds.Bottom + 5, "Hello World !!!!", newTimesFontBoldItalic);
            textElement3.ForeColor = System.Drawing.Color.Blue;
            addResult = firstPage.AddElement(textElement3);

            TextElement stdTypeText = new TextElement(0, addResult.EndPageBounds.Bottom + 10, "Standard PDF Fonts Demo:", newTimesFontBold);
            addResult = firstPage.AddElement(stdTypeText);

            TextElement textElement4 = new TextElement(20, addResult.EndPageBounds.Bottom + 10, "Hello World !!!!", stdTimesFont);
            addResult = firstPage.AddElement(textElement4);

            stdTimesFontItalic.Size = 15;
            TextElement textElement5 = new TextElement(20, addResult.EndPageBounds.Bottom + 5, "Hello World !!!!", stdTimesFontItalic);
            textElement5.ForeColor = System.Drawing.Color.Green;
            addResult = firstPage.AddElement(textElement5);

            stdTimesFontBoldItalic.Size = 20;
            TextElement textElement6 = new TextElement(20, addResult.EndPageBounds.Bottom + 5, "Hello World !!!!", stdTimesFontBoldItalic);
            textElement6.ForeColor = System.Drawing.Color.Blue;
            addResult = firstPage.AddElement(textElement6);

            // embedded true type fonts

            TextElement embeddedTtfText = new TextElement(0, addResult.EndPageBounds.Bottom + 10, "Embedded True Type Fonts Demo:", newTimesFontBold);
            addResult = firstPage.AddElement(embeddedTtfText);

            // russian text
            TextElement textElement8 = new TextElement(20, addResult.EndPageBounds.Bottom + 5, "Появление на свет!!", newTimesEmbeddedFont);
            addResult = firstPage.AddElement(textElement8);

            string outFilePath = System.IO.Path.Combine(Application.StartupPath, "TextsAndFontsDemo.pdf");

            // save the PDF document to disk
            document.Save(outFilePath);

            // close the PDF document to release the resources
            document.Close();

            DialogResult dr = MessageBox.Show("Open the saved file in an external viewer?", "Open Rendered File", MessageBoxButtons.YesNo);
            if (dr == DialogResult.Yes)
            {
                try
                {
                    System.Diagnostics.Process.Start(outFilePath);
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    return;
                }
            }
        }
Esempio n. 8
0
        private static void ImprimirEtiqueta(Int32 CodigoBarras, String Titulo, String Descripcion)
        {
            String sPath = "C:\\Users\\Adan Cervera\\Desktop\\TestGit\\TestGit\\POS.View\\VentasView\\RECARGAS.lbx";
            Document objDoc = new Document();
            objDoc = new Document();
            if (objDoc.Open(sPath) != null)
            {
                objDoc.GetObject("codebar").Text = CodigoBarras.ToString();
                objDoc.GetObject("modelo").Text = Titulo;
                objDoc.GetObject("marca").Text = Descripcion;

                objDoc.StartPrint("", bpac.PrintOptionConstants.bpoDefault);
                objDoc.PrintOut(1, bpac.PrintOptionConstants.bpoDefault);
                objDoc.EndPrint();
                objDoc.Close();
            }
        }
Esempio n. 9
0
 private static void CloseWordApp(Document wordDoc, Application wordApp)
 {
     wordDoc.Close(false, false, false);
     wordApp.Application.Quit();
 }
Esempio n. 10
0
        private void ConvertWord2PDF(string inputFile, string outputPath)
        {
            try
            {
                if (outputPath.Equals("") || !File.Exists(inputFile))
                {
                    throw new Exception("Either file does not exist or invalid output path");
                }

                // app to open the document belower
                Microsoft.Office.Interop.Word.Application wordApp = new Microsoft.Office.Interop.Word.Application();
                Document wordDocument = new Document();

                // input variables
                object objInputFile = inputFile;
                object missParam = Type.Missing;

                wordDocument = wordApp.Documents.Open(ref objInputFile, ref missParam, ref missParam, ref missParam,
                    ref missParam, ref missParam, ref missParam, ref missParam, ref missParam, ref missParam,
                    ref missParam, ref missParam, ref missParam, ref missParam, ref missParam, ref missParam);

                if (wordDocument != null)
                {
                    // make the convertion
                    wordDocument.ExportAsFixedFormat(outputPath, WdExportFormat.wdExportFormatPDF, false,
                        WdExportOptimizeFor.wdExportOptimizeForOnScreen, WdExportRange.wdExportAllDocument,
                        0, 0, WdExportItem.wdExportDocumentContent, true, true,
                        WdExportCreateBookmarks.wdExportCreateWordBookmarks, true, true, false, ref missParam);
                }

                // close document and quit application
                wordDocument.Close();
                wordApp.Quit();

                MessageBox.Show("File successfully converted");
                ClearTextBoxes();
            }
            catch (Exception e)
            {
                throw e;
            }
        }
Esempio n. 11
0
        private void btnTestTable_Click(object sender, EventArgs e)
        {
            tabControl2.SelectTab("tabPageTest");

            string regFileName = cbxRegDoc.Text;
            if (testFileName == null || testFileName.Trim() == "")
            {
                MessageBox.Show("请选择一个目标文档");
            }
            else if (regFileName == null || regFileName.Trim() == "")
            {
                MessageBox.Show("请选择一个规程文档");
            }
            else if (!isTextMode())
            {
                MessageBox.Show("非文本文档检测模式不支持表格匹配,请在目录检测中选择文本模式");
            }
            else
            {
                HandleTable handleTable = new HandleTable(testWord);

                string path = System.Environment.CurrentDirectory;
                string name = regFileName;
                name = path + "\\resources\\" + name + ".doc";

                Document regDoc = new Document();
                HandleDocument handleDocument = new HandleDocument();

                WaitingForm wf = new WaitingForm();
                HandleWaitingForm.startWaitingForm(wf);

                if (!testDocIsOpen)
                {
                    testDocIsOpen = true;
                    testDoc = handleDocument.openDocument(testFileName, testWord);
                }

                regDoc = handleDocument.openDocument(name, testWord);

                handleTable.contrastTablesOfDocs(regDoc, testDoc, showItemInfo, tvRegTable
                    , tvTestTable, null, null, null);

                Object saveChanges = false;
                object unknow = Type.Missing;

                regDoc.Close(ref saveChanges, ref unknow, ref unknow);

                HandleWaitingForm.closeWaitingForm(wf);

                plTOC.Hide();
                plKeyWord.Hide();
                plMultiInfo.Hide();

                plTableTest.Show();
                showTableTreeView();
                hideTOCTreeView();

                isMultiple = false;
                tabCalculateTable.Show();
                tabControlMulti.Hide();
            }
        }
Esempio n. 12
0
        private void btnCreatePdf_Click(object sender, EventArgs e)
        {
            string pdfToModify = textBoxPdfFilePath.Text.Trim();

            // create a PDF document
            Document document = new Document(pdfToModify);

            // set the license key
            document.LicenseKey = "B4mYiJubiJiInIaYiJuZhpmahpGRkZE=";

            // get the first page the PDF document
            PdfPage firstPage = document.Pages[0];

            string logoTransImagePath = System.IO.Path.Combine(Application.StartupPath, @"..\..\img\evologo-100-trans.png");
            string logoOpaqueImagePath = System.IO.Path.Combine(Application.StartupPath, @"..\..\img\evologo-100.jpg");

            // add an opaque image stamp in the top left corner of the first page
            // and make it semitransparent when rendered in PDF
            ImageElement imageStamp = new ImageElement(1, 1, logoOpaqueImagePath);
            imageStamp.Opacity = 50;
            AddElementResult addResult = firstPage.AddElement(imageStamp);

            // add a border for the image stamp
            RectangleElement imageBorderRectangleElement = new RectangleElement(1, 1, addResult.EndPageBounds.Width,
                                addResult.EndPageBounds.Height);
            firstPage.AddElement(imageBorderRectangleElement);

            // add a template stamp to the document repeated on each document page
            // the template contains an image and a text

            System.Drawing.Image logoImg = System.Drawing.Image.FromFile(logoTransImagePath);

            // calculate the template stamp location and size
            System.Drawing.SizeF imageSizePx = logoImg.PhysicalDimension;

            float imageWidthPoints = UnitsConverter.PixelsToPoints(imageSizePx.Width);
            float imageHeightPoints = UnitsConverter.PixelsToPoints(imageSizePx.Height);

            float templateStampXLocation = (firstPage.ClientRectangle.Width - imageWidthPoints) / 2;
            float templateStampYLocation = firstPage.ClientRectangle.Height / 4;

            // the stamp size is equal to image size in points
            Template templateStamp = document.AddTemplate(new System.Drawing.RectangleF(templateStampXLocation, templateStampYLocation,
                    imageWidthPoints, imageHeightPoints + 20));

            // set a semitransparent background color for template
            RectangleElement background = new RectangleElement(0, 0, templateStamp.ClientRectangle.Width, templateStamp.ClientRectangle.Height);
            background.BackColor = Color.White;
            background.Opacity = 25;
            templateStamp.AddElement(background);

            // add a true type font to the document
            System.Drawing.Font ttfFontBoldItalic = new System.Drawing.Font("Times New Roman", 10,
                        System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point);
            PdfFont templateStampTextFont = document.AddFont(ttfFontBoldItalic, true);

            // Add a text element to the template. You can add any other types of elements to a template like a HtmlToPdfElement.
            TextElement templateStampTextElement = new TextElement(3, 0, "This is the Stamp Text", templateStampTextFont);
            templateStampTextElement.ForeColor = System.Drawing.Color.DarkBlue;
            templateStamp.AddElement(templateStampTextElement);

            // Add an image with transparency to the template. You can add any other types of elements to a template like a HtmlToPdfElement.
            ImageElement templateStampImageElement = new ImageElement(0, 20, logoImg);
            // instruct the library to use transparency information
            templateStampImageElement.RenderTransparentImage = true;
            templateStamp.AddElement(templateStampImageElement);

            // add a border to template
            RectangleElement templateStampRectangleElement = new RectangleElement(0, 0, templateStamp.ClientRectangle.Width,
                        templateStamp.ClientRectangle.Height);
            templateStamp.AddElement(templateStampRectangleElement);

            // dispose the image
            logoImg.Dispose();

            string outFilePath = System.IO.Path.Combine(Application.StartupPath, "PdfStamps.pdf");

            // save the PDF document to disk
            try
            {
                document.Save(outFilePath);
            }
            finally
            {
                document.Close();
            }

            DialogResult dr = MessageBox.Show("Open the saved file in an external viewer?", "Open Rendered File", MessageBoxButtons.YesNo);
            if (dr == DialogResult.Yes)
            {
                try
                {
                    System.Diagnostics.Process.Start(outFilePath);
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    return;
                }
            }
        }
Esempio n. 13
0
        public Dictionary<string, List<string>> generateSpecificationRegTOC(string filepath)
        {
            ApplicationClass app = new ApplicationClass();
            Document doc = new Document();
            HandleDocument handleDocument = new HandleDocument();
            doc = handleDocument.openDocument(filepath,app);

            Dictionary<string,List<string>> dict  = new Dictionary<string,List<string>>();
            int c = doc.Paragraphs.Count;
            bool isStart = false;
            string chapter = "";
            Regex regNum = new Regex("^[0-9]");
            Regex reg = new Regex(@"[\u4e00-\u9fa5]");//

            
            for (int i = 1; i <= c; i++)
            {
                string s = doc.Paragraphs[i].Range.Text;
      
                //int ccc = Convert.ToInt32(s[s.Length - 1]);
                //MessageBox.Show(ccc.ToString());

                if(s.IndexOf("第") == 0 && (s.IndexOf("章") ==  2 || s.IndexOf("章") == 3))
                {
                    isStart = true;
                }
                if (isStart)
                {
                    if (s.IndexOf("第") == 0 && (s.IndexOf("章") == 2 || s.IndexOf("章") == 3))
                    {
                        s = s.Replace("\r", "");
                        chapter = s;
                        dict.Add(s,new List<string>());
                    }
                    else if (regNum.IsMatch(s) && reg.IsMatch(s))
                    {
                        s = s.Replace("\r", "");
                        dict[chapter].Add(s);
                    }
                }
            }
            

            Object saveChanges = false;
            object unknow = Type.Missing;

            doc.Close(ref saveChanges, ref unknow, ref unknow);
            app.Quit(ref saveChanges, ref unknow, ref unknow);

            return dict;
        }
Esempio n. 14
0
 private void quit(ApplicationClass word, Document doc )
 {
     Object saveChanges = false;
     object unknow = Type.Missing;
    
     doc.Close(ref saveChanges, ref unknow, ref unknow);
     word.Quit(ref saveChanges, ref unknow, ref unknow);
 }
Esempio n. 15
0
        private void closeDoc(Document doc)
        {
            Object saveChanges = false;
            object unknow = Type.Missing;

            doc.Close(ref saveChanges, ref unknow, ref unknow);
        }
Esempio n. 16
0
        private static void createPartialSettingsFile(Document document)
        {
            string partialFileName = document.FullName + ".partial";
            string partialShortFileName = document.Name + ".partial";

            // Check if partial already exists
            if (File.Exists(partialFileName))
            {
                outputPartial(string.Format("File {0} already exists.", partialShortFileName));
                return;
            }

            List<string> lines = File.ReadAllLines(document.FullName).Skip(1).ToList();

            outputPartial(string.Format("Creating {0}.", partialShortFileName));
            output("\t\tWrite the partial names, each in its own line. Then save the file.");

            string partialFileContents = "";

            if (lines.Count > 0)
            {
                partialFileContents = "original";

                string originalFileContents = string.Join(Environment.NewLine, lines);
                FileName originalFileName = new FileName(document);
                string partialOriginalPath = originalFileName.Combine("original");

                createAndInsertIntoProjectItem(partialOriginalPath, originalFileContents, document);
            }

            createAndInsertIntoProjectItem(partialFileName, partialFileContents, document, true);

            // Close the main file.
            document.Close(vsSaveChanges.vsSaveChangesNo);

            // Rewrite the file to remove the partialize! line
            File.WriteAllLines(document.FullName, lines);
        }
        private void importButton_Click(object sender, EventArgs e)
        {
            // clears the textbox before a contract is loaded

            contract_tb.Clear();

            // opening the openfiledialog1 control to allow the user to select a file

            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                try
                {

                    //Create a document object

                    Document document = new Document();

                    document.LoadFromFile(openFileDialog1.FileName);

                    docToTxtName = openFileDialog1.FileName + ".txt";

                    //Save doc file to a txt format.

                    document.SaveToFile(docToTxtName, FileFormat.Txt);

                    document.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("The file could not be read: " + ex.Message);
                }

                TextToBox();

            }
        }
Esempio n. 18
0
        private void saveResultButton_Click(object sender, EventArgs e)
        {
            saveFileDialog1.FileName = CreateFileName();
            switch (houseType.Text)
            {
                case "Кирпичный":
                    {
                        houseType1 = "кирпичного";
                    }
                    break;

                case "Панельный":
                    {
                        houseType1 = "панельного";
                    }
                    break;

                case "Монолитный":
                    {
                        houseType1 = "монолитного";
                    }
                    break;

                default:
                    break;
            }

            try
            {
                if (DialogResult.OK == saveFileDialog1.ShowDialog())
                {
                    wdApp = new Application();
                    var wdDoc = new Document();

                    wdDoc = wdApp.Documents.Open(System.Windows.Forms.Application.StartupPath + "\\m2.doc", Missing, true);
                    wdApp.ActiveDocument.Words[1].Select();
                    wdApp.Selection.Copy();
                    wdDoc.Close();
                    string template = "\\шаблоны\\ОсновнойШаблон.doc";

                    if (bankName.Text == "втб 24")
                    {
                        template = "\\шаблоны\\ВТБ24.doc";
                    }

                    if (ownerOrg.Checked)
                    {
                        template = "\\шаблоны\\Организация.doc";
                    }

                    wdDoc = wdApp.Documents.Open(System.Windows.Forms.Application.StartupPath + template, Missing, true);
                    object replaceAll = WdReplace.wdReplaceAll;

                    // Gets a NumberFormatInfo associated with the en-US culture.
                    NumberFormatInfo nfi = new CultureInfo("en-US", false).NumberFormat;

                    nfi.NumberDecimalDigits = 0;
                    nfi.NumberGroupSeparator = " ";

                    nfi.PositiveSign = "";
                    customerPadeg();

                    string ownerFullName = ownerSurname.Text + " " + ownerName.Text + " " + ownerInit.Text;
                    string customerFullName = customerSurname.Text + " " + customerName.Text + " " + customerInit.Text;

                    calculationDate.CustomFormat = "dd MMMM yyyy";
                    string calculationDateStr = calculationDate.Text;
                    int lenght = calculationDateStr.Length;
                    string temp = null;
                    string t;

                    for (int i = 0; i < lenght; i++)
                    {
                        if (i == 3)
                        {
                            t = calculationDateStr[i].ToString().ToUpper();
                            temp += t;
                        }
                        else
                        {
                            temp += calculationDateStr[i];
                        }
                    }

                    calculationDateStr = temp;

                    calculationDate.CustomFormat = "dd/MM/yy";
                    int sentencesCount = wdDoc.Sentences.Count;
                    string topColontitul = topColontitulCreator();

                    wdDoc.Sections[1].Headers[WdHeaderFooterIndex.wdHeaderFooterPrimary].Range.Text = topColontitul;

                    ReplaceTextWord(ref wdApp, "@@MO@@", MO.Text);

                    if (ownerOrg.Checked)
                    {
                        if (bankName.Text == "втб 24")
                        {
                            ReplaceTextWord(ref wdApp, "@@ownerOrgname@@",
                                            "Операционный офис «Владикавказский» филиала №2351 ВТБ 24 (ЗАО)");
                            ReplaceTextWord(ref wdApp, "@@INN@@", "7710353606");
                            ReplaceTextWord(ref wdApp, "@@OGRN@@", "1027739207462");
                            ReplaceTextWord(ref wdApp, "@@KPP@@", "231002001");
                            ReplaceTextWord(ref wdApp, "@@orgAddress@@", "РСО-Алания, г. Владикавказ, ул. Коцоева, д.13");
                        }
                        else
                        {
                            ReplaceTextWord(ref wdApp, "@@ownerOrgname@@", orgName.Text);
                            ReplaceTextWord(ref wdApp, "@@INN@@", orgINN.Text);
                            ReplaceTextWord(ref wdApp, "@@OGRN@@", orgOGRN.Text);
                            ReplaceTextWord(ref wdApp, "@@KPP@@", orgKPP.Text);
                            ReplaceTextWord(ref wdApp, "@@orgAddress@@", orgAdd.Text);
                        }
                    }

                    ReplaceTextWord(ref wdApp, "@@houseType1@@", houseType1);
                    ReplaceTextWord(ref wdApp, "@@calculationDateStr@@", calculationDateStr);
                    ReplaceTextWord(ref wdApp, "@@houseType@@", houseType.Text.ToLower());
                    ReplaceTextWord(ref wdApp, "@@roomsT@@", roomsT);
                    ReplaceTextWord(ref wdApp, "@@roomsX@@", roomsX);
                    ReplaceTextWord(ref wdApp, "@@lm2@@", lm2text.Text);
                    ReplaceTextWord(ref wdApp, "@@m2@@", m2text.Text);
                        ReplaceTextWord(ref wdApp, "@@raion@@", ", " + textBox1.Text);
                    ReplaceTextWord(ref wdApp, "@@customerNameInits@@", customerFamiliyR + " " + getInits());
                    ReplaceTextWord(ref wdApp, "@@calculationDate@@", calculationDate.Text);
                    if (newBuildingCheck.Checked)
                    {
                        var wdNew = new Document();

                        wdNew = wdApp.Documents.Open(
                            System.Windows.Forms.Application.StartupPath + "\\новостройка.doc", Missing, true);
                        wdNew.Sections[1].Range.Select();
                        wdNew.Sections[1].Range.Copy();
                        wdNew.Close();

                        wdApp.Selection.Find.ClearFormatting();
                        wdApp.Selection.Find.Text = "@@новостройка@@";
                        while (wdApp.Selection.Find.Execute(
                            ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                            ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                            ref Missing, ref Missing, ref Missing, ref Missing, ref Missing))
                        {
                            //wdNew = wdApp.Documents.Open(System.Windows.Forms.Application.StartupPath + "новостройка.doc", Missing, true);

                            //wdApp.Selection.Text = "";
                            wdApp.Selection.Paste();

                            wdApp.ActiveDocument.Sections[1].Range.Select();
                        }
                    }
                    else
                    {
                        ReplaceTextWord(ref wdApp, "@@новостройка@@", "");
                    }

                    ReplaceTextWord(ref wdApp, "@@customerFullname@@", customerFullName);

                    roomsAsString();
                    ReplaceTextWord(ref wdApp, "@@rooms1@@", rooms1);

                    ReplaceTextWord(ref wdApp, "@@customerFullnameR@@", customerFullNameR);
                    ReplaceTextWord(ref wdApp, "@@customerFullnameT@@", customerFullNameT);

                    ReplaceTextWord(ref wdApp, "@@customerFullnameD@@", customerFullNameD);
                    ReplaceTextWord(ref wdApp, "@@rooms@@", roomsAsString());
                    ReplaceTextWord(ref wdApp, "@@appartmentNum@@", "№" + appartmentNum.Text);
                    ReplaceTextWord(ref wdApp, "@@street@@", street.Text);
                    ReplaceTextWord(ref wdApp, "@@houseNum@@", houseNum.Text);

                    string buildNum = null;
                    if (buildingNum.Text != "")
                    {
                        buildNum = ", корп." + buildingNum.Text;
                    }
                    else
                    {
                        buildNum = buildingNum.Text;
                    }
                    ReplaceTextWord(ref wdApp, "@@buildingNum@@", buildNum);
                    ReplaceTextWord(ref wdApp, "@@customerAddress@@", customerAddres.Text);
                    ReplaceTextWord(ref wdApp, "@@floor@@", floor.Value.ToString());
                    ReplaceTextWord(ref wdApp, "@@floors@@", floors.Text);
                    ReplaceTextWord(ref wdApp, "@@town@@", town.Text);
                    ReplaceTextWord(ref wdApp, "@@cost@@", finalCostRounded.ToString("N", nfi));
                    ReplaceTextWord(ref wdApp, "@@contractNum@@", contractNum.Text);
                    ReplaceTextWord(ref wdApp, "@@contractDate@@", contractDate.Text);
                    ReplaceTextWord(ref wdApp, "@@customerName@@", customerName.Text);
                    ReplaceTextWord(ref wdApp, "@@customerInit@@", customerInit.Text);
                    ReplaceTextWord(ref wdApp, "@@likvidCost@@", likvidCost.ToString("N", nfi));
                    ReplaceTextWord(ref wdApp, "@@stringCost@@", costStr.ToLower());

                    getUvaj();
                    ReplaceTextWord(ref wdApp, "@@uvaj@@", uvaj);

                    //Customer Passport
                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@customerPassport@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = customerPassport.Text;

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@customerPassNum@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = customerPassNum.Text;

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@customerPassOVD@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = customerPassOVD.Text;

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@customerPassDate@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = customerPassDate.Text;

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@customerFullAddress@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = customerAddres.Text;

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                    //owner Passport
                    if (owners.Count > 1)
                    {
                        int ownerIndex = 0;
                        foreach (Owner owner in owners)
                        {
                            ownerIndex++;
                            wdApp.Selection.Find.ClearFormatting();
                            wdApp.Selection.Find.Text = "@@ownerFullnameD@@";
                            wdApp.Selection.Find.Replacement.ClearFormatting();
                            wdApp.Selection.Find.Replacement.Text = owner.ownerFullNameD + "; @@ownerFullnameD@@";

                            wdApp.Selection.Find.Execute(
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                            //ReplaceTextWord(ref wdApp, "@@ownerFullnameD@@",owner.ownerFullNameD + "; @@ownerFullnameD@@");

                            wdApp.Selection.Find.ClearFormatting();
                            wdApp.Selection.Find.Text = "@@ownerFullnameT@@";
                            wdApp.Selection.Find.Replacement.ClearFormatting();
                            wdApp.Selection.Find.Replacement.Text = owner.ownerFullNameT + "; @@ownerFullnameT@@";

                            wdApp.Selection.Find.Execute(
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                            //ReplaceTextWord(ref wdApp, "@@ownerFullnameT@@", owner.ownerFullNameT + "; @@ownerFullnameT@@");

                            wdApp.Selection.Find.ClearFormatting();
                            wdApp.Selection.Find.Text = "@@ownerFullnameR@@";
                            wdApp.Selection.Find.Replacement.ClearFormatting();
                            wdApp.Selection.Find.Replacement.Text = owner.ownerFullNameR + "; @@ownerFullnameR@@";

                            wdApp.Selection.Find.Execute(
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                            //ReplaceTextWord(ref wdApp, "@@ownerFullnameR@@", owner.ownerFullNameR + "; @@ownerFullnameR@@");

                            wdApp.Selection.Find.ClearFormatting();
                            wdApp.Selection.Find.Text = "@@ownerFullname1@@";
                            wdApp.Selection.Find.Replacement.ClearFormatting();
                            wdApp.Selection.Find.Replacement.Text = owner.ownerFullName + ";/rn@@ownerFullname1@@";

                            wdApp.Selection.Find.Execute(
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                            //ReplaceTextWord(ref wdApp, "@@ownerFullname1@@", owner.ownerFullName + ";/rn@@ownerFullname1@@");

                            wdApp.Selection.Find.ClearFormatting();
                            wdApp.Selection.Find.Text = "@@ownerFullname@@";
                            wdApp.Selection.Find.Replacement.ClearFormatting();
                            wdApp.Selection.Find.Replacement.Text = ownerIndex + "." + owner.ownerFullName + "/rn";

                            wdApp.Selection.Find.Execute(
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                            //ReplaceTextWord(ref wdApp, "@@ownerFullname@@", ownerIndex + "." + owner.ownerFullName + "/rn");

                            wdApp.Selection.Find.ClearFormatting();
                            wdApp.Selection.Find.Text = "@@passportSerial@@";
                            wdApp.Selection.Find.Replacement.ClearFormatting();
                            wdApp.Selection.Find.Replacement.Text = owner.passportSerial;

                            wdApp.Selection.Find.Execute(
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                            //ReplaceTextWord(ref wdApp, "@@passportSerial@@", owner.passportSerial);

                            wdApp.Selection.Find.ClearFormatting();
                            wdApp.Selection.Find.Text = "@@ownerPassport@@";
                            wdApp.Selection.Find.Replacement.ClearFormatting();
                            wdApp.Selection.Find.Replacement.Text = ownerPassport.Text;

                            wdApp.Selection.Find.Execute(
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                            //ReplaceTextWord(ref wdApp, "@@ownerPassport@@", ownerPassport.Text);

                            wdApp.Selection.Find.ClearFormatting();
                            wdApp.Selection.Find.Text = "@@ownerPassNum@@";
                            wdApp.Selection.Find.Replacement.ClearFormatting();
                            wdApp.Selection.Find.Replacement.Text = owner.passNum;

                            wdApp.Selection.Find.Execute(
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                            //ReplaceTextWord(ref wdApp, "@@ownerPassNum@@", owner.passNum);

                            wdApp.Selection.Find.ClearFormatting();
                            wdApp.Selection.Find.Text = "@@ownerPassOVD@@";
                            wdApp.Selection.Find.Replacement.ClearFormatting();
                            wdApp.Selection.Find.Replacement.Text = owner.OVD;

                            wdApp.Selection.Find.Execute(
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                            //ReplaceTextWord(ref wdApp, "@@ownerPassOVD@@", owner.OVD);

                            wdApp.Selection.Find.ClearFormatting();
                            wdApp.Selection.Find.Text = "@@ownerPassDate@@";
                            wdApp.Selection.Find.Replacement.ClearFormatting();
                            wdApp.Selection.Find.Replacement.Text = owner.passDate;

                            wdApp.Selection.Find.Execute(
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                            //ReplaceTextWord(ref wdApp, "@@ownerPassDate@@", owner.passDate);

                            wdApp.Selection.Find.ClearFormatting();
                            wdApp.Selection.Find.Text = "@@ownerFullAddress@@";
                            wdApp.Selection.Find.Replacement.ClearFormatting();
                            wdApp.Selection.Find.Replacement.Text = owner.address + ";/rn" +
                                                                    "@@ownerFullname@@ Паспорт гражданина РФ серии @@ownerPassport@@ №@@ownerPassNum@@, выдан @@ownerPassDate@@ @@ownerPassOVD@@. Проживает по адресу: @@ownerFullAddress@@";

                            wdApp.Selection.Find.Execute(
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                            //ReplaceTextWord(ref wdApp, "@@ownerFullAddress@@", owner.address + ";/rn" + "@@ownerFullname@@ Паспорт гражданина РФ серии @@ownerPassport@@ №@@ownerPassNum@@, выдан @@ownerPassDate@@ @@ownerPassOVD@@. Проживает по адресу: @@ownerFullAddress@@");
                        }

                        ReplaceTextWord(ref wdApp, "; @@ownerFullnameD@@", "");
                        ReplaceTextWord(ref wdApp, "; @@ownerFullnameT@@", "");
                        ReplaceTextWord(ref wdApp, "; @@ownerFullnameR@@", "");
                        ReplaceTextWord(ref wdApp, "; @@ownerFullname@@", "");
                        ReplaceTextWord(ref wdApp, ";/rn@@ownerFullname1@@", "");
                        ReplaceTextWord(ref wdApp, "; @@ownerPassport@@", "");
                        ReplaceTextWord(ref wdApp, "; @@ownerPassNum@@", "");
                        ReplaceTextWord(ref wdApp, "; @@ownerPassOVD@@", "");
                        ReplaceTextWord(ref wdApp, "; @@ownerPassDate@@", "");
                        ReplaceTextWord(ref wdApp, "; @@ownerFullAddress@@", "");
                        ReplaceTextWord(ref wdApp,
                                        ";/rn@@ownerFullname@@ Паспорт гражданина РФ серии @@ownerPassport@@ №@@ownerPassNum@@, выдан @@ownerPassDate@@ @@ownerPassOVD@@. Проживает по адресу: @@ownerFullAddress@@",
                                        "");
                        InsertParagraphs(ref wdApp);
                    }
                    else
                    {
                        ReplaceTextWord(ref wdApp, "@@ownerFullnameD@@", ownerFullNameD);
                        ReplaceTextWord(ref wdApp, "@@ownerFullnameT@@", ownerFullNameT);
                        ReplaceTextWord(ref wdApp, "@@ownerFullnameR@@", ownerFullNameR);
                        ReplaceTextWord(ref wdApp, "@@ownerFullname@@", ownerFullName);
                        ReplaceTextWord(ref wdApp, "@@ownerFullname1@@", ownerFullName);
                        ReplaceTextWord(ref wdApp, "@@ownerPassport@@", ownerPassport.Text);
                        ReplaceTextWord(ref wdApp, "@@ownerPassNum@@", ownerPassNum.Text);
                        ReplaceTextWord(ref wdApp, "@@ownerPassOVD@@", ownerPassOVD.Text);
                        ReplaceTextWord(ref wdApp, "@@ownerPassDate@@", ownerPassDate.Text);
                        ReplaceTextWord(ref wdApp, "@@ownerFullAddress@@", ownerAddress.Text);
                    }

                    //
                    ReplaceTextWord(ref wdApp, "@@ownerDoc@@", ownerDocs.Text);
                    ReplaceTextWord(ref wdApp, "@@registrationDoc@@", registrationDoc.Text);
                    ReplaceTextWord(ref wdApp, "@@ownerFullnameD@@", ownerFullNameD);
                    ReplaceTextWord(ref wdApp, "@@ownerFullnameT@@", ownerFullNameT);
                    ReplaceTextWord(ref wdApp, "@@ownerFullnameR@@", ownerFullNameR);
                    ReplaceTextWord(ref wdApp, "@@ownerFullname@@", ownerFullName);
                    ReplaceTextWord(ref wdApp, "@@ownerFullname1@@", ownerFullName);
                    ReplaceTextWord(ref wdApp, "@@ownerPassport@@", ownerPassport.Text);
                    ReplaceTextWord(ref wdApp, "@@ownerPassNum@@", ownerPassNum.Text);
                    ReplaceTextWord(ref wdApp, "@@ownerPassOVD@@", ownerPassOVD.Text);
                    ReplaceTextWord(ref wdApp, "@@ownerPassDate@@", ownerPassDate.Text);
                    ReplaceTextWord(ref wdApp, "@@ownerFullAddress@@", ownerAddress.Text);

                    var padeg = new Declension();

                    string test = objectDataGrid.Rows[41].Cells[1].Value.ToString();
                    kadastr = padeg.GetAppointmentPadeg(test, 2);
                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@tehPass@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = kadastr;

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.1.2@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[2].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.1.3@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[3].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.1.4@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[4].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.1.5@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[5].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.1.6@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[6].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.1.7@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[7].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.1.8@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[8].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.1.9@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[9].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.1.10@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[10].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.1.11@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[11].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.1.12@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[12].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.1.13@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[13].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.1.14@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[14].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.1.15@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[15].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.1.16@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[16].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.1@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[18].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.2@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[19].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.3@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[20].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.4@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[21].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.5@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[22].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.6@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[23].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.7@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[24].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.8@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[25].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.9@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[26].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.10@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[27].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.11@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[28].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.12@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[29].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.13@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[30].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.14@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[31].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.15@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[32].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.16@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[33].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.17@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[34].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.18@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[35].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.19@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[36].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.20@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[37].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.21@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[38].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.2.22@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[39].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.1@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[41].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.2@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[42].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.3@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[43].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.4@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[44].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.5@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[45].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.6@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[46].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.7@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[47].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.8@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[48].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.9@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[49].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.10@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[50].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.11@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[51].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.12@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[52].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.13@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[53].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.14@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[54].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.15@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[55].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.16@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[56].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.17@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[57].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.18@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[58].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.19@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[59].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.20@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[60].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.21@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[61].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.22@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[62].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    /*wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.23@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[63].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                                 ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                 ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                 ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);*/
                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.23@@";
                    while (wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing))
                    {
                        //Microsoft.Office.Interop.Word.Range r1;

                        //r1.Text = objectDataGrid.Rows[63].Cells[1].Value.ToString();
                        wdApp.Selection.Text = objectDataGrid.Rows[63].Cells[1].Value.ToString();

                        //wdApp.Selection.Font.Superscript = 1;
                        //                        wdApp.Selection.PasteAndFormat(Microsoft.Office.Interop.Word.WdRecoveryType.wdPasteDefault);
                        wdApp.ActiveDocument.Sections[1].Range.Select();
                    }

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.24@@";
                    while (wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing))
                    {
                        //Microsoft.Office.Interop.Word.Range r1;

                        //r1.Text = objectDataGrid.Rows[63].Cells[1].Value.ToString();
                        wdApp.Selection.Text = objectDataGrid.Rows[64].Cells[1].Value.ToString();

                        //wdApp.Selection.Font.Superscript = 1;
                        //                        wdApp.Selection.PasteAndFormat(Microsoft.Office.Interop.Word.WdRecoveryType.wdPasteDefault);
                        wdApp.ActiveDocument.Sections[1].Range.Select();
                    }

                    //wdApp.Selection.Find.ClearFormatting();
                    //wdApp.Selection.Find.Text = "@@2.1.3.24@@";
                    //wdApp.Selection.Find.Replacement.ClearFormatting();
                    //wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[64].Cells[1].Value.ToString();

                    //wdApp.Selection.Find.Execute(
                    //             ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                    //             ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                    //             ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.25@@";
                    while (wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing))
                    {
                        wdApp.Selection.Text = objectDataGrid.Rows[65].Cells[1].Value.ToString();

                        wdApp.ActiveDocument.Sections[1].Range.Select();
                    }

                    //wdApp.Selection.Find.ClearFormatting();
                    //wdApp.Selection.Find.Text = "@@2.1.3.25@@";
                    //wdApp.Selection.Find.Replacement.ClearFormatting();
                    //wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[65].Cells[1].Value.ToString();

                    //wdApp.Selection.Find.Execute(
                    //             ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                    //             ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                    //             ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.26@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[66].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.27@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[67].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.28@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[68].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.29@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[69].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.30@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[70].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.31@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[71].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.32@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[72].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.33@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[73].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.34@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[74].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.35@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[75].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.36@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[76].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.37@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[77].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.38@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[78].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@2.1.3.39@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = objectDataGrid.Rows[79].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a0.1@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[0].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a0.2@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[1].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a0.3@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[2].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a0.4@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[3].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a0.5@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[4].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a0.6@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[5].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a0.7@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[6].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a0.8@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[7].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a0.9@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[8].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a0.10@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[9].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a0.11@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[10].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a0.12@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[11].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a0.13@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[12].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a0.14@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[13].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a0.15@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[14].Cells[1].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.1@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[0].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.2@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[1].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.3@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[2].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.4@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[3].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.5@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[4].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.6@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[5].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.7@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[6].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.8@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[7].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.9@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[8].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.10@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[9].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.11@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[10].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.12@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[11].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.13@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[12].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.14@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[13].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.15@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[14].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.16@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[15].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.17@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[16].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.18@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[17].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.19@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[18].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a1.20@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[19].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.1@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[0].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.2@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[1].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.3@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[2].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.4@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[3].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.5@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[4].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.6@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[5].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.7@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[6].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.8@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[7].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.9@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[8].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.10@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[9].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.11@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[10].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.12@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[11].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.13@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[12].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.14@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[13].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.15@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[14].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.16@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[15].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.17@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[16].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.18@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[17].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.19@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[18].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a2.20@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[19].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.1@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[0].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.2@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[1].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.3@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[2].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.4@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[3].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.5@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[4].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.6@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[5].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.7@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[6].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.8@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[7].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.9@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[8].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.10@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[9].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.11@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[10].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.12@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[11].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.13@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[12].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.14@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[13].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.15@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[14].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.16@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[15].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.17@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[16].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.18@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[17].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.19@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[18].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@a3.20@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = analogsGrid.Rows[19].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.1@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text =
                        ((double)(calculationAppartaments.Rows[0].Cells[2].Value)).ToString("N", nfi);

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.2@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text =
                        ((double)(calculationAppartaments.Rows[1].Cells[2].Value)).ToString("N", nfi);

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.3@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text =
                        ((double)(calculationAppartaments.Rows[2].Cells[2].Value)).ToString("N", nfi);

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.4@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[3].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.5@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[4].Cells[2].Value.ToString();
                    string pattern = "MMMM yyyyг.";
                    string d1 = Convert.ToDateTime(analogsGrid.Rows[18].Cells[2].Value.ToString()).ToString(pattern);
                    string d2 = Convert.ToDateTime(analogsGrid.Rows[18].Cells[3].Value.ToString()).ToString(pattern);
                    string d3 = Convert.ToDateTime(analogsGrid.Rows[18].Cells[4].Value.ToString()).ToString(pattern);
                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.6@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();

                    wdApp.Selection.Find.Replacement.Text = d1;

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.7@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[6].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.8@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[7].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.9@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[8].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.10@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[9].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.11@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[10].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.12@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[11].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.13@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[12].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.14@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[13].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.15@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[14].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.16@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[15].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.17@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[16].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.18@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[17].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.19@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[18].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.20@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[21].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.21@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[20].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.22@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[21].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.23@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[22].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.24@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[23].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.25@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[24].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.26@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[25].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.27@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[26].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.28@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[27].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.29@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[28].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.30@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[29].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.31@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[30].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.32@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[31].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.33@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[32].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.34@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[33].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b1.35@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[34].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.1@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text =
                        ((double)(calculationAppartaments.Rows[0].Cells[3].Value)).ToString("N", nfi);

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.2@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text =
                        ((double)(calculationAppartaments.Rows[1].Cells[3].Value)).ToString("N", nfi);

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.3@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text =
                        ((double)(calculationAppartaments.Rows[2].Cells[3].Value)).ToString("N", nfi);

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.4@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[3].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.5@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[4].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.6@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();

                    wdApp.Selection.Find.Replacement.Text = d2;

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.7@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[6].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.8@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[7].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.9@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[8].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.10@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[9].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.11@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[10].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.12@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[11].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.13@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[12].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.14@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[13].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.15@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[14].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.16@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[15].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.17@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[16].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.18@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[17].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.19@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[18].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.20@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[21].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.21@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[20].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.22@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[21].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.23@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[22].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.24@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[23].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.25@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[24].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.26@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[25].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.27@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[26].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.28@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[27].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.29@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[28].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.30@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[29].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.31@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[30].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.32@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[31].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.33@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[32].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.34@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[33].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b2.35@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[34].Cells[3].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.1@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text =
                        ((double)(calculationAppartaments.Rows[0].Cells[4].Value)).ToString("N", nfi);

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.2@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text =
                        ((double)(calculationAppartaments.Rows[1].Cells[4].Value)).ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.3@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text =
                        ((double)(calculationAppartaments.Rows[2].Cells[4].Value)).ToString("N", nfi);

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.4@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[3].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.5@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[4].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.6@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();

                    wdApp.Selection.Find.Replacement.Text = d3;

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.7@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[6].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.8@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[7].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.9@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[8].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.10@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[9].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.11@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[10].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.12@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[11].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.13@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[12].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.14@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[13].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.15@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[14].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.16@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[15].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.17@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[16].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.18@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[17].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.19@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[18].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.20@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[21].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.21@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[20].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.22@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[21].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.23@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[22].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.24@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[23].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.25@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[24].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.26@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[25].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.27@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[26].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.28@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[27].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.29@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[28].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.30@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[29].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.31@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[30].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.32@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[31].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.33@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[32].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.34@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[33].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b3.35@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[34].Cells[4].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b4.1@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text =
                        ((double)(calculationAppartaments.Rows[35].Cells[2].Value)).ToString("N", nfi);

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b4.2@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text = calculationAppartaments.Rows[36].Cells[2].Value.ToString();

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b4.3@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text =
                        ((double)(calculationAppartaments.Rows[37].Cells[2].Value)).ToString("N", nfi);

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "@@b4.4@@";
                    wdApp.Selection.Find.Replacement.ClearFormatting();
                    wdApp.Selection.Find.Replacement.Text =
                        ((double)(calculationAppartaments.Rows[38].Cells[2].Value)).ToString("N", nfi);

                    wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);

                    wdApp.Selection.Find.ClearFormatting();
                    wdApp.Selection.Find.Text = "м2";
                    while (wdApp.Selection.Find.Execute(
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                        ref Missing, ref Missing, ref Missing, ref Missing, ref Missing))
                    {
                        wdApp.Selection.Characters[2].Font.Superscript = 1;
                    }

                    //saving
                    try
                    {
                        int x = wdDoc.Shapes.Count;
                        x = wdDoc.Shapes.Count;
                        for (int k = 1; k < x; k++)
                        {
                            Shape shape = wdDoc.Shapes[k];

                            //string l = shape.AlternativeText;
                            if (shape.AlternativeText.Contains("cont"))
                            {
                                wdDoc.Shapes[k].TextEffect.Text = "№ " + contractNum.Text + " от " +
                                                                  calculationDate.Text + "г.";
                            }
                        }
                        /*
                       for (int k = 1; k < x; k++)
                        {
                            Microsoft.Office.Interop.Word.Shape shape = wdDoc.Shapes[k];

                            if (shape.AlternativeText.Contains("first"))
                            {
                                System.Drawing.Image firstPageImg = System.Drawing.Image.FromFile(imagesGrid.Rows[0].Cells[2].Value.ToString());

                               //Clipboard.SetImage(firstPageImg);
                                shape.Select();
                                wdDoc.Shapes[k].CanvasItems.AddPicture(imagesGrid.Rows[0].Cells[2].Value.ToString());
                                wdDoc.Shapes[k].Apply();

                               // wdApp.Selection.PasteSpecial();
                               // wdApp.ActiveDocument.Shapes.AddPicture(imagesGrid.Rows[0].Cells[2].Value.ToString(), Type.Missing, Type.Missing, Type.Missing, Type.Missing, 500, 370, Type.Missing);
                                //wdApp.Selection.InlineShapes.AddPicture(imagesGrid.Rows[0].Cells[2].Value.ToString(), Type.Missing, Type.Missing, Type.Missing);
                                //wdApp.Selection.InlineShapes
                                //Clipboard.Clear();
                            }
                        }*/
                    }
                    catch (Exception exp)
                    {
                    }

                    /*foreach (Microsoft.Office.Interop.Word.Table table in wdApp.ActiveDocument.Tables)
                    {
                        try
                        {
                            //  if (table.Columns[0].Cells[0].Range.Text.Contains("@@1@@"))
                            //{
                            foreach (Microsoft.Office.Interop.Word.Column col in table.Columns)
                            {
                                foreach (Microsoft.Office.Interop.Word.Cell cell in col.Cells)
                                {
                                    int rowCount = imagesGrid.RowCount;
                                    string l = cell.Range.Text;
                                    if (l.Contains("@@1@@"))
                                    {
                                        cell.Select();
                                        cell.Range.Text = "";
                                        wdApp.Selection.InlineShapes.AddPicture(imagesGrid.Rows[1].Cells[2].Value.ToString(), Type.Missing, Type.Missing, Type.Missing);
                                        wdApp.Selection.Find.ClearFormatting();
                                        wdApp.Selection.Find.Text = "@@1@@";
                                        wdApp.Selection.Find.Replacement.ClearFormatting();
                                        wdApp.Selection.Find.Replacement.Text = "";

                                        wdApp.Selection.Find.Execute(
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                                    }

                                    if (l.Contains("@@2@@"))
                                    {
                                        cell.Select();

                                        //cell.Range.Text = "";
                                        wdApp.Selection.InlineShapes.AddPicture(imagesGrid.Rows[2].Cells[2].Value.ToString(), Type.Missing, Type.Missing, Type.Missing);
                                        wdApp.Selection.Find.ClearFormatting();
                                        wdApp.Selection.Find.Text = "@@2@@";
                                        wdApp.Selection.Find.Replacement.ClearFormatting();
                                        wdApp.Selection.Find.Replacement.Text = "";

                                        wdApp.Selection.Find.Execute(
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                                    }
                                    if (l.Contains("@@3@@"))
                                    {
                                        cell.Select();

                                        //cell.Range.Text = "";
                                        wdApp.Selection.InlineShapes.AddPicture(imagesGrid.Rows[3].Cells[2].Value.ToString(), Type.Missing, Type.Missing, Type.Missing);
                                        wdApp.Selection.Find.ClearFormatting();
                                        wdApp.Selection.Find.Text = "@@3@@";
                                        wdApp.Selection.Find.Replacement.ClearFormatting();
                                        wdApp.Selection.Find.Replacement.Text = "";

                                        wdApp.Selection.Find.Execute(
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                                    }

                                    if (l.Contains("@@4@@"))
                                    {
                                        cell.Select();

                                        //cell.Range.Text = "";
                                        wdApp.Selection.InlineShapes.AddPicture(imagesGrid.Rows[4].Cells[2].Value.ToString(), Type.Missing, Type.Missing, Type.Missing);
                                        wdApp.Selection.Find.ClearFormatting();
                                        wdApp.Selection.Find.Text = "@@4@@";
                                        wdApp.Selection.Find.Replacement.ClearFormatting();
                                        wdApp.Selection.Find.Replacement.Text = "";

                                        wdApp.Selection.Find.Execute(
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                                    }

                                    if (l.Contains("@@5@@"))
                                    {
                                        cell.Select();

                                        //cell.Range.Text = "";
                                        wdApp.Selection.InlineShapes.AddPicture(imagesGrid.Rows[5].Cells[2].Value.ToString(), Type.Missing, Type.Missing, Type.Missing);
                                        wdApp.Selection.Find.ClearFormatting();
                                        wdApp.Selection.Find.Text = "@@5@@";
                                        wdApp.Selection.Find.Replacement.ClearFormatting();
                                        wdApp.Selection.Find.Replacement.Text = "";

                                        wdApp.Selection.Find.Execute(
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                                    }

                                    if (l.Contains("@@6@@"))
                                    {
                                        cell.Select();

                                        //cell.Range.Text = "";
                                        wdApp.Selection.InlineShapes.AddPicture(imagesGrid.Rows[6].Cells[2].Value.ToString(), Type.Missing, Type.Missing, Type.Missing);
                                        wdApp.Selection.Find.ClearFormatting();
                                        wdApp.Selection.Find.Text = "@@6@@";
                                        wdApp.Selection.Find.Replacement.ClearFormatting();
                                        wdApp.Selection.Find.Replacement.Text = "";

                                        wdApp.Selection.Find.Execute(
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                                    }

                                    if (l.Contains("@@7@@"))
                                    {
                                        cell.Select();

                                        //cell.Range.Text = "";
                                        wdApp.Selection.InlineShapes.AddPicture(imagesGrid.Rows[7].Cells[2].Value.ToString(), Type.Missing, Type.Missing, Type.Missing);
                                        wdApp.Selection.Find.ClearFormatting();
                                        wdApp.Selection.Find.Text = "@@7@@";
                                        wdApp.Selection.Find.Replacement.ClearFormatting();
                                        wdApp.Selection.Find.Replacement.Text = "";

                                        wdApp.Selection.Find.Execute(
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                                    }

                                    if (l.Contains("@@8@@"))
                                    {
                                        cell.Select();

                                        //cell.Range.Text = "";
                                        wdApp.Selection.InlineShapes.AddPicture(imagesGrid.Rows[8].Cells[2].Value.ToString(), Type.Missing, Type.Missing, Type.Missing);
                                        wdApp.Selection.Find.ClearFormatting();
                                        wdApp.Selection.Find.Text = "@@8@@";
                                        wdApp.Selection.Find.Replacement.ClearFormatting();
                                        wdApp.Selection.Find.Replacement.Text = "";

                                        wdApp.Selection.Find.Execute(
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                                    }

                                    if (l.Contains("@@9@@"))
                                    {
                                        cell.Select();

                                        //cell.Range.Text = "";
                                        wdApp.Selection.InlineShapes.AddPicture(imagesGrid.Rows[9].Cells[2].Value.ToString(), Type.Missing, Type.Missing, Type.Missing);
                                        wdApp.Selection.Find.ClearFormatting();
                                        wdApp.Selection.Find.Text = "@@9@@";
                                        wdApp.Selection.Find.Replacement.ClearFormatting();
                                        wdApp.Selection.Find.Replacement.Text = "";

                                        wdApp.Selection.Find.Execute(
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                                    }

                                    if (l.Contains("@@10@@"))
                                    {
                                        cell.Select();

                                        //cell.Range.Text = "";
                                        wdApp.Selection.InlineShapes.AddPicture(imagesGrid.Rows[10].Cells[2].Value.ToString(), Type.Missing, Type.Missing, Type.Missing);
                                        wdApp.Selection.Find.ClearFormatting();
                                        wdApp.Selection.Find.Text = "@@10@@";
                                        wdApp.Selection.Find.Replacement.ClearFormatting();
                                        wdApp.Selection.Find.Replacement.Text = "";

                                        wdApp.Selection.Find.Execute(
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref Missing, ref Missing, ref Missing, ref Missing, ref Missing,
                                                     ref replaceAll, ref Missing, ref Missing, ref Missing, ref Missing);
                                    }
                                }
                            }
                        }

                        //  }
                        catch (Exception except)
                        {
                        }
                    }

                    /*for (int k = 1; k < x; k++)
                    {
                        Microsoft.Office.Interop.Word.Shape shape = wdDoc.Shapes[k];
                        float shift = 150;
                        string l = shape.AlternativeText;
                        if (l == "facade")
                        {
                            shape.IncrementTop(-shift);
                        }
                        if (l == "appartmentNum")
                        {
                            shape.IncrementTop(-shift);

                            //shape. = "Оцениваемая квартира №"+appartmentNum.Text;
                        }
                        if (l == "podezd")
                        {
                            shape.IncrementTop(-shift);
                        }
                        if (l == "stairway")
                        {
                            shape.IncrementTop(-shift);
                        }
                    }*/

                    //

                    wdApp.ActiveDocument.SaveAs(saveFileDialog1.FileName);

                    wdDoc.Close();
                    wdApp.Documents.Close();
                    wdApp.Quit();
                }
            }
            catch (Exception except)
            {
                //MessageBox.Show(except.Message);
                saveState();

                //wdApp.Documents.Close();
                wdApp.Quit();
            }
        }
Esempio n. 19
0
        private void btnFindTable_Click(object sender, EventArgs e)
        {
            tabControl2.SelectTab("tabCalculateTable");

            string regFileName = cbxRegDoc.Text;
            string tablename = cbxTableList.Text;

            if (testFileName == null || testFileName.Trim() == "")
            {
                MessageBox.Show("请选择一个目标文档");
            }
            else if (regFileName == null || regFileName.Trim() == "")
            {
                MessageBox.Show("请选择一个规程文档");
            }
            else
            {
                if ((!regFileName.Equals(preRegFileName) || !testFileName.Equals(preTestFileName)
                    || cbxTableListChanged == true))
                {
                    dataView.Rows.Clear();
                    rbTableTest.Clear();

                    WaitingForm wf = new WaitingForm();
                    HandleWaitingForm.startWaitingForm(wf);

                    string path = System.Environment.CurrentDirectory;
                    string name = regFileName;
                    name = path + "\\resources\\" + name + ".doc";

                    Document regDoc = new Document();
                    HandleDocument handleDocument = new HandleDocument();

                    
                    if (!testDocIsOpen)
                    {
                        testDocIsOpen = true;
                        testDoc = handleDocument.openDocument(testFileName, testWord);
                    }

                    regDoc = handleDocument.openDocument(name, testWord);
                    showItemInfo.Clear();
                    flagList.Clear();//清空标记合并单元格的标志
                    if (tablename != "")
                    {
                        calTables(1, regDoc, wf, tablename);
                    }
                    else
                    {
                        calTables(tableName.Length, regDoc, wf, "");
                    }
                    rbTableTest.Text = "请选择关键字";
                    KeyWord keyWord = new KeyWord();
                    //keyWord.highLightRichString(rbTableTest, testWord, testDoc, keyItemList);
                    rtbStandard.Text = keyWord.getStandardList();
                    generatekeyItemCombox();
                    
                    Object saveChanges = false;
                    object unknow = Type.Missing;

                    regDoc.Close(ref saveChanges, ref unknow, ref unknow);

                    HandleWaitingForm.closeWaitingForm(wf);

                    plTOC.Hide();
                    plKeyWord.Hide();
                    plMultiInfo.Hide();

                    plTableTest.Show();
                    showTableTreeView();
                    hideTOCTreeView();

                    cbxTableListChanged = false;
                    preRegFileName = regFileName;
                    preTestFileName = testFileName;

                    isMultiple = false;
                    tabControl2.Show();
                    tabControlMulti.Hide();
                }
            }

        }
Esempio n. 20
0
 public void CloseDocument(Document doc)
 {
     if (doc.Closing())
     {
         doc.Close();
     }
     RefreshControls();
 }
Esempio n. 21
0
        private void btnCreatePdf_Click(object sender, EventArgs e)
        {
            // create a PDF document
            Document document = new Document();

            // set the license key
            document.LicenseKey = "B4mYiJubiJiInIaYiJuZhpmahpGRkZE=";

            // add a page to the PDF document
            PdfPage firstPage = document.AddPage();

            // draw rectangle
            RectangleElement rectangle1 = new RectangleElement(10, 10, 150, 100);
            rectangle1.ForeColor = System.Drawing.Color.Blue;
            rectangle1.LineStyle.LineWidth = 5; // a 5 points line width
            rectangle1.LineStyle.LineJoinStyle = LineJoinStyle.RoundJoin;
            firstPage.AddElement(rectangle1);

            // draw colored rectangle
            RectangleElement rectangle2 = new RectangleElement(200, 10, 150, 100);
            rectangle2.ForeColor = System.Drawing.Color.Blue;
            rectangle2.BackColor = System.Drawing.Color.Green;
            firstPage.AddElement(rectangle2);

            // draw gradient colored rectangle
            RectangleElement rectangle3 = new RectangleElement(400, 25, 100, 50);
            rectangle3.ForeColor = System.Drawing.Color.Blue;
            rectangle3.Gradient = new GradientColor(GradientDirection.Vertical, System.Drawing.Color.Green, System.Drawing.Color.Blue);
            firstPage.AddElement(rectangle3);

            // draw ellipse
            EllipseElement ellipse1 = new EllipseElement(75, 200, 70, 50);
            ellipse1.ForeColor = System.Drawing.Color.Blue;
            ellipse1.LineStyle.LineDashStyle = LineDashStyle.Dash;
            firstPage.AddElement(ellipse1);

            // draw ellipse
            EllipseElement ellipse2 = new EllipseElement(275, 200, 70, 50);
            ellipse2.ForeColor = System.Drawing.Color.Blue;
            ellipse2.BackColor = System.Drawing.Color.Green;
            firstPage.AddElement(ellipse2);

            // draw ellipse
            EllipseElement ellipse3 = new EllipseElement(450, 200, 50, 25);
            ellipse3.ForeColor = System.Drawing.Color.Blue;
            ellipse3.Gradient = new GradientColor(GradientDirection.Vertical, System.Drawing.Color.Green, System.Drawing.Color.Blue);
            firstPage.AddElement(ellipse3);

            BezierCurveElement bezierCurve1 = new BezierCurveElement(10, 350, 100, 300, 200, 400, 300, 350);
            bezierCurve1.ForeColor = System.Drawing.Color.Blue;
            bezierCurve1.LineStyle.LineWidth = 3;
            bezierCurve1.LineStyle.LineJoinStyle = LineJoinStyle.RoundJoin;
            firstPage.AddElement(bezierCurve1);

            BezierCurveElement bezierCurve2 = new BezierCurveElement(10, 350, 100, 400, 200, 300, 300, 350);
            bezierCurve2.ForeColor = System.Drawing.Color.Green;
            bezierCurve2.LineStyle.LineWidth = 3;
            bezierCurve2.LineStyle.LineJoinStyle = LineJoinStyle.RoundJoin;
            firstPage.AddElement(bezierCurve2);

            string outFilePath = System.IO.Path.Combine(Application.StartupPath, "ShapesDemo.pdf");

            // save the PDF document to disk
            document.Save(outFilePath);

            // close the PDF document to release the resources
            document.Close();

            DialogResult dr = MessageBox.Show("Open the saved file in an external viewer?", "Open Rendered File", MessageBoxButtons.YesNo);
            if (dr == DialogResult.Yes)
            {
                try
                {
                    System.Diagnostics.Process.Start(outFilePath);
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    return;
                }
            }
        }
        private void cmdViewContracts_Click(object sender, EventArgs e)
        {
            string sotien;
            string benvay;
            string identi, ngaycap, noicap, soDT, Diachi, BankAccount, BankName;
            string makh, ngayhd, kyhan, laisuat, mahd;
            string sqlStr, strDate;
            int maloaiKH, length, i;
            double loinhuan;
            string strLoinhuan;
            object sourcefile;
            object destfile;
            DateTime ngaydaohan;
            TimeSpan ngaychiulai;
            OleDbDataReader oleReader;
            ApplicationClass word = new ApplicationClass();
            Document doc = new Document();

            if (cbxDonvitinh.Text == "Ngay")
                ngaydaohan = cbxDateContracts.Value.AddDays(int.Parse(cbxKyhan.Text));
            else if (cbxDonvitinh.Text == "Thang")
                ngaydaohan = cbxDateContracts.Value.AddMonths(int.Parse(cbxKyhan.Text));
            else ngaydaohan = cbxDateContracts.Value.AddYears(int.Parse(cbxKyhan.Text));
            ngaychiulai = ngaydaohan.Subtract(cbxDateContracts.Value);
            System.Diagnostics.Process Proc = new System.Diagnostics.Process();
            makh = cbxMaKH.Text;
            ngayhd = cbxDateContracts.Value.ToShortDateString();
            kyhan = cbxKyhan.Text;
            laisuat = cbxLaisuat.Text;
            sotien = txtTongtien.Text;
            length = sotien.Length;
            benvay = "";
            Diachi = "";
            soDT = "";
            ngaycap = "";
            identi = "";
            BankAccount = "";
            BankName = "";
            mahd = txtMaHD.Text.Replace("\\", "");
            mahd = mahd.Replace("/", "_");
            mahd = mahd.Replace(":", "_");
            mahd = mahd.Replace(" ", "_");
            mahd = mahd.Replace("*", "");
            mahd = mahd.Replace("<", "");
            mahd = mahd.Replace("|", "");
            mahd = mahd.Replace(">", "");
            strDate = cbxDateContracts.Value.ToShortDateString().Replace("/", "_");
            i = 1;
            loinhuan = Tinhloi(ngaychiulai, sotien, laisuat);
            strLoinhuan = loinhuan.ToString();
            while (3*i < length)
            {
                sotien = sotien.Insert(length - 3*i, ".");
                i++;
            }

            length = strLoinhuan.Length;
            i = 1;
            while (3 * i < length)
            {
                strLoinhuan = strLoinhuan.Insert(length - 3 * i, ".");
                i++;
            }

            sqlStr = "SELECT [TenKH], [DinhDanh], FORMAT([Ngaycap], 'dd/mm/yyyy') AS Ngaycap, [Noicap], [SoDT], [Diachi], [TaikhoanNH], [TenNH], [MaLoaiKH] FROM [KHACHHANG] WHERE [MaKH] = '" + makh + "'";
            maloaiKH = 0;
            try
            {
                oleReader = contractDb.genDataReader(sqlStr);
                if (oleReader.Read())
                {
                    benvay = oleReader["TenKH"].ToString();
                    identi = oleReader["Dinhdanh"].ToString();
                    ngaycap = oleReader["Ngaycap"].ToString();
                    noicap = oleReader["Noicap"].ToString();
                    soDT = oleReader["SoDT"].ToString();
                    Diachi = oleReader["Diachi"].ToString();
                    BankAccount = oleReader["TaikhoanNH"].ToString();
                    BankName = oleReader["TenNH"].ToString();
                    maloaiKH = int.Parse(oleReader["MaLoaiKH"].ToString());
                    benvay = benvay.Replace(" ", "");
                }
            }
            catch (Exception ex)
            {
                return;
            }

            //Ghi hop dong ra file
            if (cbxLoaiHD.Text == "Cho vay")
            {
                if (maloaiKH == 1)
                    //Khach hang doanh nghiep
                    //sourcefile = @"E:\Project\SVN\quanlydongtien\Source\Quanlydongtien\Quanlydongtien\bin\Temp\Hopdong\Khachhangdoanhnghiep.doc";
                    sourcefile = @dirWork + "\\Temp\\Hopdong\\Chovay\\Khachhangdoanhnghiep.doc";
                else
                    //Khach hang ca nhan
                    sourcefile = @dirWork + "\\Temp\\Hopdong\\Chovay\\Khachhangcanhan.doc";
            }
            else
            {
                if (maloaiKH == 1)
                    sourcefile = @dirWork + @"\Temp\Hopdong\Huydong\Khachhangdoanhnghiep.doc";
                else sourcefile = @dirWork + @"\Temp\Hopdong\Huydong\Khachhangcanhan.doc";
            }

            if (cbxLoaiHD.Text == "Cho vay")
                destfile = @dirWork + @"\Contracts\Chovay\" + mahd + "_" + strDate + ".doc";
            else destfile = @dirWork + @"\Contracts\Huydong\" + mahd + "_" + strDate + ".doc"; ;
            object missing = Type.Missing;

            try
            {
                doc = word.Documents.Open(ref sourcefile, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);
                doc.Activate();
                if (!Utilities.Replace_String_In_Word_File(ref doc, "#TEN KHACH HANG#", benvay))
                {
                    doc.Close(ref missing, ref missing, ref missing);
                    word.Application.Quit(ref missing, ref missing, ref missing);
                    return;
                    //doc.SaveAs(ref destfile, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);
                }

                if (!Utilities.Replace_String_In_Word_File(ref doc, "#Dia chi khach hang#", Diachi))
                {
                    doc.Close(ref missing, ref missing, ref missing);
                    word.Application.Quit(ref missing, ref missing, ref missing);
                }

                if (!Utilities.Replace_String_In_Word_File(ref doc, "#Dien thoai#", soDT))
                {
                    doc.Close(ref missing, ref missing, ref missing);
                    word.Application.Quit(ref missing, ref missing, ref missing);
                }

                if (!Utilities.Replace_String_In_Word_File(ref doc, "#Tong so tien#", sotien))
                {
                    doc.Close(ref missing, ref missing, ref missing);
                    word.Application.Quit(ref missing, ref missing, ref missing);
                }

                if (!Utilities.Replace_String_In_Word_File(ref doc, "#Laisuat#", laisuat))
                {
                    doc.Close(ref missing, ref missing, ref missing);
                    word.Application.Quit(ref missing, ref missing, ref missing);
                }

                if (!Utilities.Replace_String_In_Word_File(ref doc, "#Thoihan#", kyhan))
                {
                    doc.Close(ref missing, ref missing, ref missing);
                    word.Application.Quit(ref missing, ref missing, ref missing);
                }

                if (!Utilities.Replace_String_In_Word_File(ref doc, "#Donvi#", cbxDonvitinh.Text))
                {
                    doc.Close(ref missing, ref missing, ref missing);
                    word.Application.Quit(ref missing, ref missing, ref missing);
                }

                if (!Utilities.Replace_String_In_Word_File(ref doc, "#Ngayhopdong#", cbxDateContracts.Value.ToShortDateString()))
                {
                    doc.Close(ref missing, ref missing, ref missing);
                    word.Application.Quit(ref missing, ref missing, ref missing);
                }

                if (!Utilities.Replace_String_In_Word_File(ref doc, "#Ngaydaohan#", ngaydaohan.ToShortDateString()))
                {
                    doc.Close(ref missing, ref missing, ref missing);
                    word.Application.Quit(ref missing, ref missing, ref missing);
                }

                if (!Utilities.Replace_String_In_Word_File(ref doc, "#Phiuythacvon#", txtPhiUT.Text))
                {
                    doc.Close(ref missing, ref missing, ref missing);
                    word.Application.Quit(ref missing, ref missing, ref missing);
                }

                if (!Utilities.Replace_String_In_Word_File(ref doc, "#Account Numver#", BankAccount))
                {
                    doc.Close(ref missing, ref missing, ref missing);
                    word.Application.Quit(ref missing, ref missing, ref missing);
                }

                if (!Utilities.Replace_String_In_Word_File(ref doc, "#Bank Name#", BankName))
                {
                    doc.Close(ref missing, ref missing, ref missing);
                    word.Application.Quit(ref missing, ref missing, ref missing);
                }

                if (!Utilities.Replace_String_In_Word_File(ref doc, "#Loinhuan#", strLoinhuan))
                {
                    doc.Close(ref missing, ref missing, ref missing);
                    word.Application.Quit(ref missing, ref missing, ref missing);
                }

                doc.SaveAs(ref destfile, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);
                doc.Close(ref missing, ref missing, ref missing);
                word.Application.Quit(ref missing, ref missing, ref missing);
                Proc.StartInfo.FileName = @"WINWORD.EXE";
                Proc.StartInfo.Arguments = destfile.ToString();
                Proc.Start();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                doc.Close(ref missing, ref missing, ref missing);
                word.Application.Quit(ref missing, ref missing, ref missing);
            }
        }