// // This code is part of Document Solutions for Word demos. // Copyright (c) MESCIUS inc. All rights reserved. // using System; using System.IO; using System.Drawing; using System.Collections.Generic; using System.Linq; using System.Globalization; using GrapeCity.Documents.Word; namespace DsWordWeb.Demos { // This example demonstrates the available text functions " + // that can be used with the 'calc' report templates feature " + // to perform various operations on strings." + // For example, to insert the concatenation of three text data fields, " + // the template '{{calc Concat(ds.a, ds.b, ds.c)}}' can be used. " + // The data source used in this demo contains a single record " + // with random string values. " + public class DataTplCalcText { public GcWordDocument CreateDocx() { const int MinLen = 5; var rnd = Util.NewRandom(); int next() { return rnd.Next(1, 5); } string nextWord() { for (int i = 0; i < 50; ++i) { var t = Util.LoremIpsumWord(); if (t.Length >= MinLen) return t; } return "lorem"; } // Generate a simple data source with pairs of random numeric data: var data = new[] { new { a = nextWord(), b = nextWord(), c = nextWord(), n = next(), }, }; var doc = new GcWordDocument(); doc.Body.Sections.First.PageSetup.Margin.Top = 36; doc.Body.Sections.First.PageSetup.Margin.Bottom = 36; doc.Body.Sections.First.PageSetup.Margin.Left = 36; doc.Body.Sections.First.PageSetup.Margin.Right = 36; var paras = doc.Body.Paragraphs; // Add the data source: doc.DataTemplate.DataSources.Add("ds", data); // Styles and templates to show results: var bulletListTemplate = doc.ListTemplates.Add(BuiltInListTemplateId.BulletDefault, "bulletListTemplate"); var exStyle = doc.Styles[BuiltInStyleId.Heading3]; exStyle.ParagraphFormat.TabStops.Add(110); var resStyle = doc.Styles[BuiltInStyleId.Strong]; add("Data", "{{ds.a}}"); add("Data", "{{ds.b}}"); add("Data", "{{ds.c}}"); add("Data", "{{ds.n}}"); add("Asc", "{{calc Asc(ds.a)}}"); add("Concat", "{{calc Concat(ds.a, ds.b, ds.c)}}"); add("Contains", "{{calc Contains(ds.a, \"s\")}}"); add("EndsWith", "{{calc EndsWith(ds.a, \"s\")}}"); add("Insert", "{{calc Insert(ds.a, ds.n, ds.b)}}"); add("InStr", "{{calc InStr(ds.a, \"s\")}}"); add("InStr", "{{calc InStr(ds.a, \"s\", ds.n)}}"); add("LCase", "{{calc LCase(\"Lorem Ipsum!\")}}"); add("Len", "{{calc Len(ds.a)}}"); add("LSet", "{{calc LSet(ds.a, 12)}}"); add("LSet", "{{calc LSet(ds.a, 12, \"!\")}}"); add("Mid", "{{calc Mid(ds.a, 2)}}"); add("Mid", "{{calc Mid(ds.a, 2, 1)}}"); add("Remove", "{{calc Remove(ds.a, 2)}}"); add("Remove", "{{calc Remove(ds.a, 2, 1)}}"); add("Replace", "{{calc Replace(\"loremipsumlobortis\", \"lorem\",\"ipsum\")}}"); add("RSet", "{{calc RSet(ds.a, 12)}}"); add("RSet", "{{calc RSet(ds.a, 12, \"!\")}}"); add("StartsWith", "{{calc StartsWith(ds.a, \"s\")}}"); add("StrReverse", "{{calc StrReverse(ds.a)}}"); add("Trim", "{{calc Trim(\" Lorem Ipsum \")}}"); add("UCase", "{{calc UCase(\"Lorem Ipsum!\")}}"); // Process the templates: doc.DataTemplate.Process(CultureInfo.GetCultureInfo("en-US")); // Add a short note describing the demo at the top of the document: paras.Insert( "This example demonstrates the available text functions " + "that can be used with the 'calc' report templates feature " + "to perform various operations on strings." + "For example, to insert the concatenation of three text data fields, " + "the template '{{calc Concat(ds.a, ds.b, ds.c)}}' can be used. " + "The data source used in this demo contains a single record " + "with random string values. " + "Please see this sample source code for full details.", InsertLocation.Start); paras.Insert("Report templates: available calc operators", doc.Styles[BuiltInStyleId.Heading1], InsertLocation.Start); // Done: return doc; void add(string caption, string expr) { // \x200B is a zero-width space used to prevent template expansion: paras.Add(caption + "\t" + expr.Insert(1, "​​​\x200B") + " : ", exStyle).ListFormat.Template = bulletListTemplate; paras.Last.GetRange().Runs.Add(expr, resStyle); } } } }