Ejemplo n.º 1
0
        private void LayerShape(FastString Page, ShapeObject obj, FastString text)
        {
            int    styleindex = UpdateCSSTable(obj);
            string style      = GetStyleTag(styleindex);
            string old_text   = String.Empty;

            float      Width, Height;
            string     pic      = GetLayerPicture(obj, out Width, out Height);
            FastString addstyle = new FastString(64);

            if (obj.Shape == ShapeKind.Rectangle || obj.Shape == ShapeKind.RoundRectangle)
            {
                if (obj.FillColor.A != 0)
                {
                    addstyle.Append("background:").Append(System.Drawing.ColorTranslator.ToHtml(obj.FillColor)).Append(";");
                }
                addstyle.Append("border-style:solid;");
                if (obj.Border.Width != 3)
                {
                    addstyle.Append("border-width:").Append(ExportUtils.FloatToString(obj.Border.Width)).Append("px;");
                }
                addstyle.Append("border-color:").Append(System.Drawing.ColorTranslator.ToHtml(obj.Border.Color)).Append(";");
                if (obj.Shape == ShapeKind.RoundRectangle)
                {
                    addstyle.Append("border-radius:15px;");
                }
            }

            float x = obj.Width > 0 ? obj.AbsLeft : (obj.AbsLeft + obj.Width);
            float y = obj.Height > 0 ? hPos + obj.AbsTop : (hPos + obj.AbsTop + obj.Height);

            Layer(Page, obj, x, y, obj.Width, obj.Height, text, style, addstyle);
            addstyle.Clear();
        }
Ejemplo n.º 2
0
        private void OdfRowStyles(StreamWriter Out)
        {
            List <string> FList = new List <string>();
            string        s;

            for (int i = 0; i < FMatrix.Height - 1; i++)
            {
                s = ExportUtils.FloatToString((FMatrix.YPosById(i + 1) - FMatrix.YPosById(i)) / odfDivider);
                if (FList.IndexOf(s) == -1)
                {
                    FList.Add(s);
                }
            }
            FList.Sort();
            for (int i = 0; i < FList.Count; i++)
            {
                Out.WriteLine("<style:style style:name=\"ro" + FList[i] + "\" " +
                              "style:family=\"table-row\">");
                Out.WriteLine("<style:table-row-properties fo:break-before=\"auto\" " +
                              "style:row-height=\"" + FList[i] + "cm\"/>");
                Out.WriteLine("</style:style>");
            }
            Out.WriteLine("<style:style style:name=\"ro_breaked\" " +
                          "style:family=\"table-row\">");
            Out.WriteLine("<style:table-row-properties fo:break-before=\"page\" " +
                          "style:row-height=\"0.001cm\"/>");
            Out.WriteLine("</style:style>");
            Out.WriteLine("<style:style style:name=\"ta1\" style:family=\"table\" style:master-page-name=\"PageDef\">");
            Out.WriteLine("<style:table-properties table:display=\"true\" style:writing-mode=\"lr-tb\"/>");
            Out.WriteLine("</style:style>");
            Out.WriteLine("<style:style style:name=\"ceb\" style:family=\"table-cell\" style:display=\"false\"/>");
        }
Ejemplo n.º 3
0
 private void OdfMakeDocStyles(string FileName)
 {
     using (FileStream file = new FileStream(FileName, FileMode.Create))
         using (StreamWriter Out = new StreamWriter(file))
         {
             Out.WriteLine("<?xml version=\"1.0\" encoding=\"utf-8\"?>");
             Out.Write("<office:document-styles ");
             Out.Write(OdfMakeXmlHeader());
             Out.WriteLine(">");
             Out.WriteLine("<office:automatic-styles>");
             // rework!
             Out.WriteLine("<style:page-layout style:name=\"pm1\">");
             Out.WriteLine("<style:page-layout-properties " +
                           "fo:page-width=\"" + ExportUtils.FloatToString(FPageWidth / odfPageDiv) + "cm\" " +
                           "fo:page-height=\"" + ExportUtils.FloatToString(FPageHeight / odfPageDiv) + "cm\" " +
                           "fo:margin-top=\"" + ExportUtils.FloatToString(FPageTop / odfMargDiv) + "cm\" " +
                           "fo:margin-bottom=\"" + ExportUtils.FloatToString(FPageBottom / odfMargDiv) + "cm\" " +
                           "fo:margin-left=\"" + ExportUtils.FloatToString(FPageLeft / odfMargDiv) + "cm\" " +
                           "fo:margin-right=\"" + ExportUtils.FloatToString(FPageRight / odfMargDiv) + "cm\"/>");
             Out.WriteLine("</style:page-layout>");
             Out.WriteLine("</office:automatic-styles>");
             Out.WriteLine("<office:master-styles>");
             Out.WriteLine("<style:master-page style:name=\"PageDef\" style:page-layout-name=\"pm1\">");
             Out.WriteLine("<style:header style:display=\"false\"/>");
             Out.WriteLine("<style:footer style:display=\"false\"/>");
             Out.WriteLine("</style:master-page>");
             Out.WriteLine("</office:master-styles>");
             Out.WriteLine("</office:document-styles>");
         }
 }
Ejemplo n.º 4
0
 private void OdfTableCellStyles(ExportIEMStyle Style, StreamWriter Out)
 {
     Out.Write("<style:table-cell-properties fo:background-color=\"" +
               ExportUtils.HTMLColor(Style.FillColor) + "\" " +
               "style:repeat-content=\"false\" fo:wrap-option=\"wrap\" ");
     if (Style.Angle > 0)
     {
         Out.Write("style:rotation-angle=\"" + (360 - Style.Angle).ToString() + "\" " +
                   "style:rotation-align=\"none\" ");
     }
     if (Style.VAlign == VertAlign.Center)
     {
         Out.Write("style:vertical-align=\"middle\" ");
     }
     if (Style.VAlign == VertAlign.Top)
     {
         Out.Write("style:vertical-align=\"top\" ");
     }
     if (Style.VAlign == VertAlign.Bottom)
     {
         Out.Write("style:vertical-align=\"bottom\" ");
     }
     if ((Style.Border.Lines & BorderLines.Left) > 0)
     {
         Out.Write("fo:border-left=\"" +
                   ExportUtils.FloatToString(Style.Border.Width / odfDivider) + "cm " +
                   OdfGetFrameName(Style.Border.Style) + " " +
                   ExportUtils.HTMLColor(Style.Border.Color) + "\" ");
     }
     if ((Style.Border.Lines & BorderLines.Right) > 0)
     {
         Out.Write("fo:border-right=\"" +
                   ExportUtils.FloatToString(Style.Border.Width / odfDivider) + "cm " +
                   OdfGetFrameName(Style.Border.Style) + " " +
                   ExportUtils.HTMLColor(Style.Border.Color) + "\" ");
     }
     if ((Style.Border.Lines & BorderLines.Top) > 0)
     {
         Out.Write("fo:border-top=\"" +
                   ExportUtils.FloatToString(Style.Border.Width / odfDivider) + "cm " +
                   OdfGetFrameName(Style.Border.Style) + " " +
                   ExportUtils.HTMLColor(Style.Border.Color) + "\" ");
     }
     if ((Style.Border.Lines & BorderLines.Bottom) > 0)
     {
         Out.Write("fo:border-bottom=\"" +
                   ExportUtils.FloatToString(Style.Border.Width / odfDivider) + "cm " +
                   OdfGetFrameName(Style.Border.Style) + " " +
                   ExportUtils.HTMLColor(Style.Border.Color) + "\" ");
     }
     Out.WriteLine("/>");
     Out.WriteLine("</style:style>");
 }
Ejemplo n.º 5
0
        private string GetXMLFont(ExportIEMStyle style)
        {
            StringBuilder result = new StringBuilder(128);

            result.Append("<Font ss:FontName=\"").Append(style.Font.Name).Append("\" ss:Size=\"").
            Append(ExportUtils.FloatToString(style.Font.Size)).Append("\" ss:Color=\"").
            Append(ExportUtils.HTMLColor(style.TextColor)).Append("\" ").
            Append(((style.Font.Style & FontStyle.Bold) > 0 ? "ss:Bold=\"1\" " : String.Empty)).
            Append(((style.Font.Style & FontStyle.Italic) > 0 ? "ss:Italic=\"1\" " : String.Empty)).
            Append(((style.Font.Style & FontStyle.Underline) > 0 ? "ss:Underline=\"Single\" " : String.Empty)).
            Append("/>");
            return(result.ToString());
        }
Ejemplo n.º 6
0
        private void OdfColumnStyles(StreamWriter Out)
        {
            List <string> FList = new List <string>();
            string        s;

            for (int i = 1; i < FMatrix.Width; i++)
            {
                s = ExportUtils.FloatToString((FMatrix.XPosById(i) - FMatrix.XPosById(i - 1)) / odfDivider);
                if (FList.IndexOf(s) == -1)
                {
                    FList.Add(s);
                }
            }
            FList.Sort();
            for (int i = 0; i < FList.Count; i++)
            {
                Out.WriteLine("<style:style style:name=\"co" + FList[i] + "\" " +
                              "style:family=\"table-column\">");
                Out.WriteLine("<style:table-column-properties fo:break-before=\"auto\" " +
                              "style:column-width=\"" + FList[i] + "cm\"/>");
                Out.WriteLine("</style:style>");
            }
        }
Ejemplo n.º 7
0
        private void ExportODF(Stream stream)
        {
            string s;
            int    fx, fy, dx, dy, Page;

            string FTempFolder = Path.GetTempPath() + Path.GetRandomFileName();

            Directory.CreateDirectory(FTempFolder);
            Directory.CreateDirectory(FTempFolder + "\\Pictures");
            Directory.CreateDirectory(FTempFolder + "\\Thumbnails");
            Directory.CreateDirectory(FTempFolder + "\\META-INF");

            int PicCount = 0;

            Page = 0;
            OdfMakeDocStyles(FTempFolder + "\\styles.xml");

            #region Content.xml

            using (FileStream file = new FileStream(FTempFolder + "\\content.xml", FileMode.Create))
                using (StreamWriter Out = new StreamWriter(file))
                {
                    Out.WriteLine("<?xml version=\"1.0\" encoding=\"utf-8\"?>");
                    Out.Write("<office:document-content ");
                    Out.Write(OdfMakeXmlHeader());
                    Out.WriteLine(">");
                    Out.WriteLine("<office:scripts/>");
                    ExportIEMStyle Style;
                    OdfFontFaceDecals(Out);
                    Out.WriteLine("<office:automatic-styles>");
                    OdfColumnStyles(Out);
                    OdfRowStyles(Out);

                    for (int i = 0; i < FMatrix.StylesCount; i++)
                    {
                        Style = FMatrix.StyleById(i);
                        Out.WriteLine("<style:style style:name=\"ce" + i.ToString() + "\" " +
                                      "style:family=\"table-cell\" style:parent-style-name=\"Default\">");
                        if (FExportType == 0)
                        {
                            Out.Write("<style:text-properties style:font-name=\"" + Style.Font.Name + "\" " +
                                      "fo:font-size=\"" + ExportUtils.FloatToString(Style.Font.Size) + "pt\" ");
                            if ((Style.Font.Style & FontStyle.Underline) > 0)
                            {
                                Out.Write("style:text-underline-style=\"solid\" " +
                                          "style:text-underline-width=\"auto\" " +
                                          "style:text-underline-color=\"font-color\" ");
                            }
                            if ((Style.Font.Style & FontStyle.Italic) > 0)
                            {
                                Out.Write("fo:font-style=\"italic\" ");
                            }
                            if ((Style.Font.Style & FontStyle.Bold) > 0)
                            {
                                Out.Write("fo:font-weight=\"bold\" ");
                            }
                            Out.Write("fo:color=\"" + ExportUtils.HTMLColor(Style.TextColor) + "\"");
                            Out.WriteLine("/>");

                            Out.Write("<style:paragraph-properties ");
                            if (Style.HAlign == HorzAlign.Left)
                            {
                                Out.Write("fo:text-align=\"start\" ");
                            }
                            if (Style.HAlign == HorzAlign.Center)
                            {
                                Out.Write("fo:text-align=\"center\" ");
                            }
                            if (Style.HAlign == HorzAlign.Right)
                            {
                                Out.Write("fo:text-align=\"end\" ");
                            }
                            if (Style.Padding.Left > 0)
                            {
                                Out.Write("fo:margin-left=\"" +
                                          ExportUtils.FloatToString(Style.Padding.Left / odfDivider) + "cm\" ");
                            }
                            if (Style.Padding.Right > 0)
                            {
                                Out.Write("fo:margin-right=\"" +
                                          ExportUtils.FloatToString(Style.Padding.Right / odfDivider) + "cm\" ");
                            }
                            if (Style.Padding.Top > 0)
                            {
                                Out.Write("fo:margin-top=\"" +
                                          ExportUtils.FloatToString(Style.Padding.Top / odfDivider) + "cm\" ");
                            }
                            if (Style.Padding.Bottom > 0)
                            {
                                Out.Write("fo:margin-bottom=\"" +
                                          ExportUtils.FloatToString(Style.Padding.Bottom / odfDivider) + "cm\" ");
                            }
                            Out.WriteLine("/>");
                        }
                        OdfTableCellStyles(Style, Out);
                    }

                    if (FExportType == 1)
                    {
                        Out.WriteLine("<style:style style:name=\"pb\" " +
                                      "style:family=\"paragraph\" style:display=\"false\"/>");
                        for (int i = 0; i < FMatrix.StylesCount; i++)
                        {
                            Style = FMatrix.StyleById(i);
                            Out.WriteLine("<style:style style:name=\"p" + i.ToString() + "\" " +
                                          "style:family=\"paragraph\" style:parent-style-name=\"Default\">");

                            Out.Write("<style:text-properties style:font-name=\"" +
                                      Style.Font.Name + "\" fo:font-size=\"" +
                                      ExportUtils.FloatToString(Style.Font.Size) + "pt\" ");
                            if ((Style.Font.Style & FontStyle.Underline) > 0)
                            {
                                Out.Write(" style:text-underline-style=\"solid\" " +
                                          "style:text-underline-width=\"auto\" " +
                                          "style:text-underline-color=\"font-color\" ");
                            }
                            if ((Style.Font.Style & FontStyle.Italic) > 0)
                            {
                                Out.Write(" style:font-style=\"italic\" ");
                            }
                            if ((Style.Font.Style & FontStyle.Bold) > 0)
                            {
                                Out.Write(" style:font-weight=\"bold\" ");
                            }
                            Out.WriteLine(" fo:color=\"" +
                                          ExportUtils.HTMLColor(Style.TextColor) + "\"/>");

                            Out.Write("<style:paragraph-properties ");
                            if (Style.HAlign == HorzAlign.Left)
                            {
                                Out.Write("fo:text-align=\"start\" ");
                            }
                            if (Style.HAlign == HorzAlign.Center)
                            {
                                Out.Write("fo:text-align=\"center\" ");
                            }
                            if (Style.HAlign == HorzAlign.Right)
                            {
                                Out.Write("fo:text-align=\"end\" ");
                            }
                            if (Style.Padding.Left > 0)
                            {
                                Out.Write("fo:margin-left=\"" +
                                          ExportUtils.FloatToString(Style.Padding.Left / odfDivider) + "cm\" ");
                            }
                            if (Style.Padding.Right > 0)
                            {
                                Out.Write("fo:margin-right=\"" +
                                          ExportUtils.FloatToString(Style.Padding.Right / odfDivider) + "cm\" ");
                            }
                            if (Style.Padding.Top > 0)
                            {
                                Out.Write("fo:margin-top=\"" +
                                          ExportUtils.FloatToString(Style.Padding.Top / odfDivider) + "cm\" ");
                            }
                            if (Style.Padding.Bottom > 0)
                            {
                                Out.Write("fo:margin-bottom=\"" +
                                          ExportUtils.FloatToString(Style.Padding.Bottom / odfDivider) + "cm\" ");
                            }
                            Out.WriteLine("/>");
                            Out.WriteLine("</style:style>");
                        }
                    }

                    Out.WriteLine("<style:style style:name=\"gr1\" style:family=\"graphic\">");
                    Out.WriteLine("<style:graphic-properties draw:stroke=\"none\" " +
                                  "draw:fill=\"none\" draw:textarea-horizontal-align=\"left\" " +
                                  "draw:textarea-vertical-align=\"top\" draw:color-mode=\"standard\" " +
                                  "draw:luminance=\"0%\" draw:contrast=\"0%\" draw:gamma=\"100%\" " +
                                  "draw:red=\"0%\" draw:green=\"0%\" draw:blue=\"0%\" " +
                                  "fo:clip=\"rect(0cm 0cm 0cm 0cm)\" draw:image-opacity=\"100%\" " +
                                  "style:mirror=\"none\"/>");
                    Out.WriteLine("</style:style>");

                    Out.WriteLine("</office:automatic-styles>");

                    // body
                    Out.WriteLine("<office:body>");
                    Out.WriteLine("<office:spreadsheet>");
                    Out.WriteLine("<table:table table:name=\"Table\" table:style-name=\"ta1\" table:print=\"false\">");

                    for (int x = 1; x < FMatrix.Width; x++)
                    {
                        Out.WriteLine("<table:table-column table:style-name=\"co" +
                                      ExportUtils.FloatToString((FMatrix.XPosById(x) -
                                                                 FMatrix.XPosById(x - 1)) / odfDivider) + "\"/>");
                    }

                    for (int y = 0; y < FMatrix.Height - 1; y++)
                    {
                        Out.WriteLine("<table:table-row table:style-name=\"ro" +
                                      ExportUtils.FloatToString((FMatrix.YPosById(y + 1) -
                                                                 FMatrix.YPosById(y)) / odfDivider) + "\">");
                        if (FMatrix.YPosById(y) >= FMatrix.PageBreak(Page))
                        {
                            Page++;
                            if (FPageBreaks)
                            {
                                Out.WriteLine("<table:table-row table:style-name=\"ro_breaked\"/>");
                            }
                        }
                        for (int x = 0; x < FMatrix.Width; x++)
                        {
                            int i = FMatrix.Cell(x, y);
                            if (i != -1)
                            {
                                ExportIEMObject Obj = FMatrix.ObjectById(i);
                                if (Obj.Counter == 0)
                                {
                                    Obj.Counter = 1;
                                    FMatrix.ObjectPos(i, out fx, out fy, out dx, out dy);

                                    Out.Write("<table:table-cell table:style-name=\"ce" +
                                              Obj.StyleIndex.ToString() + "\" ");
                                    if (dx > 1)
                                    {
                                        Out.Write("table:number-columns-spanned=\"" + dx.ToString() + "\" ");
                                    }
                                    if (dy > 1)
                                    {
                                        Out.Write("table:number-rows-spanned=\"" + dy.ToString() + "\" ");
                                    }
                                    Out.WriteLine(">");
                                    if (Obj.IsText)
                                    {
                                        s = ExportUtils.XmlString(Obj.Text, Obj.HtmlTags);
                                        Out.Write("<text:p");
                                        if (FExportType == 1)
                                        {
                                            Out.Write(" text:style-name=\"p" + Obj.StyleIndex.ToString() + "\"");
                                        }
                                        Out.WriteLine(">" + s + "</text:p>");
                                    }
                                    else
                                    {
                                        if (Obj.Width > 0)
                                        {
                                            PicCount++;
                                            if (Config.FullTrust)
                                            {
                                                using (FileStream emfFile = new FileStream(FTempFolder + "\\Pictures\\pic" + PicCount.ToString() + ".emf", FileMode.Create))
                                                    emfFile.Write(Obj.PictureStream.ToArray(), 0, (int)Obj.PictureStream.Length);
                                            }
                                            else
                                            {
                                                using (FileStream pngFile = new FileStream(FTempFolder + "\\Pictures\\pic" + PicCount.ToString() + ".png", FileMode.Create))
                                                    pngFile.Write(Obj.PictureStream.ToArray(), 0, (int)Obj.PictureStream.Length);
                                            }
                                            if (FExportType == 1)
                                            {
                                                Out.WriteLine("<text:p>");
                                            }
                                            // need for fix of vertical position
                                            Out.WriteLine("<draw:frame draw:z-index=\"" + (PicCount - 1).ToString() + "\" " +
                                                          "draw:name=\"Pictures" + PicCount.ToString() + "\" " +
                                                          "draw:style-name=\"gr1\" " +
                                                          "draw:text-style-name=\"P1\" " +
                                                          "svg:width=\"" + ExportUtils.FloatToString(Obj.Width / odfDivider) + "cm\" " +
                                                          "svg:height=\"" + ExportUtils.FloatToString(Obj.Height / odfDivider) + "cm\" " +
                                                          "svg:x=\"0cm\" svg:y=\"0cm\">");
                                            s = Config.FullTrust ? ".emf" : ".png";
                                            Out.WriteLine("<draw:image " +
                                                          "xlink:href=\"Pictures/pic" + PicCount.ToString() + s + "\" " +
                                                          "text:anchor-type=\"frame\" xlink:type=\"simple\" xlink:show=\"embed\" xlink:actuate=\"onLoad\"/>");
                                            Out.WriteLine("</draw:frame>");
                                            if (FExportType == 1)
                                            {
                                                Out.WriteLine("</text:p>");
                                            }
                                        }
                                    }
                                    Out.WriteLine("</table:table-cell>");
                                }
                                else
                                {
                                    Out.Write("<table:covered-table-cell table:style-name=\"ceb\"");
                                    if (FExportType == 1)
                                    {
                                        Out.WriteLine("><text:p text:style-name=\"pb\"/></table:covered-table-cell>");
                                    }
                                    else
                                    {
                                        Out.WriteLine("/>");
                                    }
                                }
                            }
                            else
                            {
                                Out.Write("<table:table-cell");
                                if (FExportType == 1)
                                {
                                    Out.WriteLine("><text:p text:style-name=\"pb\"/></table:table-cell>");
                                }
                                else
                                {
                                    Out.WriteLine("/>");
                                }
                            }
                        }
                        Out.WriteLine("</table:table-row>");
                    }
                    Out.WriteLine("</table:table>");
                    Out.WriteLine("</office:spreadsheet>");
                    Out.WriteLine("</office:body>");
                    Out.WriteLine("</office:document-content>");
                }
            #endregion

            string ExportMime = FExportType == 0 ? "spreadsheet" : "text";
            OdfCreateManifest(FTempFolder + "\\META-INF\\manifest.xml", PicCount, ExportMime);
            OdfCreateMime(FTempFolder + "\\mimetype", ExportMime);
            OdfCreateMeta(FTempFolder + "\\meta.xml", Creator);

            ZipArchive zip = new ZipArchive();
            zip.AddDir(FTempFolder);
            zip.SaveToStream(Stream);
            Directory.Delete(FTempFolder, true);
        }
Ejemplo n.º 8
0
        private void ExportXML(Stream stream)
        {
            int             i, x, y, fx, fy, dx, dy;
            ExportIEMObject Obj;
            ExportIEMStyle  EStyle;

            StringBuilder builder = new StringBuilder(8448);

            builder.AppendLine("<?xml version=\"1.0\"?>");
            builder.AppendLine("<?mso-application progid=\"Excel.Sheet\"?>");
            builder.Append("<?fr-application created=\"").Append(FCreator).AppendLine("\"?>");
            builder.AppendLine("<?fr-application homesite=\"http://www.fast-report.com\"?>");
            builder.Append("<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\"");
            builder.Append(" xmlns:o=\"urn:schemas-microsoft-com:office:office\"");
            builder.Append(" xmlns:x=\"urn:schemas-microsoft-com:office:excel\"");
            builder.Append(" xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\"");
            builder.AppendLine(" xmlns:html=\"http://www.w3.org/TR/REC-html40\">");
            builder.AppendLine("<DocumentProperties xmlns=\"urn:schemas-microsoft-com:office:office\">");
            builder.Append("<Title>").Append(Report.ReportInfo.Name).AppendLine("</Title>");
            builder.Append("<Author>").Append(Report.ReportInfo.Author).AppendLine("</Author>");
            builder.Append("<Created>").Append(DateTime.Now.Date.ToString()).Append("T").Append(DateTime.Now.TimeOfDay.ToString()).AppendLine("Z</Created>");
            builder.Append("<Version>").Append(Report.ReportInfo.Version).AppendLine("</Version>");
            builder.AppendLine("</DocumentProperties>");
            builder.AppendLine("<ExcelWorkbook xmlns=\"urn:schemas-microsoft-com:office:excel\">");
            builder.AppendLine("<ProtectStructure>False</ProtectStructure>");
            builder.AppendLine("<ProtectWindows>False</ProtectWindows>");
            builder.AppendLine("</ExcelWorkbook>");

            builder.AppendLine("<Styles>");
            for (x = 0; x < FMatrix.StylesCount; x++)
            {
                EStyle = FMatrix.StyleById(x);
                builder.Append("<Style ss:ID=\"s").Append(x.ToString()).AppendLine("\">");
                builder.AppendLine(GetXMLFont(EStyle));
                builder.AppendLine(GetXMLInterior(EStyle));
                builder.AppendLine(GetXMLAlignment(EStyle));
                builder.AppendLine(GetXMLBorders(EStyle));
                builder.Append(GetXMLFormat(EStyle));
                builder.AppendLine("</Style>");
            }
            builder.AppendLine("</Styles>");

            builder.AppendLine("<Worksheet ss:Name=\"Page 1\">");
            // add table
            builder.Append("<Table ss:ExpandedColumnCount=\"").Append(FMatrix.Width.ToString()).Append("\"").
            Append(" ss:ExpandedRowCount=\"").Append(FMatrix.Height.ToString()).AppendLine("\" x:FullColumns=\"1\" x:FullRows=\"1\">");
            for (x = 1; x < FMatrix.Width; x++)
            {
                builder.Append("<Column ss:AutoFitWidth=\"0\" ss:Width=\"").
                Append(ExportUtils.FloatToString((FMatrix.XPosById(x) - FMatrix.XPosById(x - 1)) / Xdivider)).
                AppendLine("\"/>");
            }
            WriteBuf(stream, builder);

            for (y = 0; y < FMatrix.Height - 1; y++)
            {
                builder.Append("<Row ss:Height=\"").
                Append(ExportUtils.FloatToString((FMatrix.YPosById(y + 1) - FMatrix.YPosById(y)) / Ydivider)).
                AppendLine("\">");
                for (x = 0; x < FMatrix.Width; x++)
                {
                    i = FMatrix.Cell(x, y);
                    if (i != -1)
                    {
                        Obj = FMatrix.ObjectById(i);
                        if (Obj.Counter == 0)
                        {
                            builder.Append("<Cell ss:Index=\"").
                            Append(Convert.ToString(x + 1) + "\" ");
                            FMatrix.ObjectPos(i, out fx, out fy, out dx, out dy);
                            Obj.Counter = 1;
                            if (Obj.IsText)
                            {
                                if (dx > 1)
                                {
                                    builder.Append("ss:MergeAcross=\"").Append(Convert.ToString(dx++ - 1)).Append("\" ");
                                }
                                if (dy > 1)
                                {
                                    builder.Append("ss:MergeDown=\"").Append(Convert.ToString(dy++ - 1)).Append("\" ");
                                }
                                builder.Append("ss:StyleID=\"s").Append(Obj.StyleIndex.ToString()).AppendLine("\">");

                                decimal value     = 0;
                                bool    isNumeric = ExportUtils.ParseTextToDecimal(Obj.Text, Obj.Style.Format, out value);
                                string  type      = isNumeric ? "ss:Type=\"Number\"" : "ss:Type=\"String\"";
                                string  data      = Obj.HtmlTags ? "ss:Data" : "Data";
                                string  xmlns     = Obj.HtmlTags ? " xmlns=\"http://www.w3.org/TR/REC-html40\"" : String.Empty;
                                string  strValue  = isNumeric ?
                                                    Convert.ToString(value, CultureInfo.InvariantCulture.NumberFormat) :
                                                    ExportUtils.XmlString(Obj.Text, Obj.HtmlTags);
                                builder.Append("<").Append(data).Append(" ").Append(type).Append(xmlns).
                                Append(">").Append(strValue).Append("</").Append(data).Append("></Cell>");
                            }
                        }
                    }
                    else
                    {
                        builder.Append("<Cell ss:Index=\"").Append(Convert.ToString(x + 1)).Append("\"/>");
                    }
                }
                builder.AppendLine("</Row>");
                if (builder.Length > 8192)
                {
                    WriteBuf(stream, builder);
                }
            }
            builder.AppendLine("</Table>");
            builder.AppendLine("<WorksheetOptions xmlns=\"urn:schemas-microsoft-com:office:excel\">");
            if (FMatrix.PagesCount > 0)
            {
                builder.AppendLine("<PageSetup>");
                if (FMatrix.Landscape(0))
                {
                    builder.AppendLine("<Layout x:Orientation=\"Landscape\"/>");
                }

                builder.AppendLine(string.Format(CultureInfo.InvariantCulture, "<PageMargins x:Bottom=\"{0:F2}\"" +
                                                 " x:Left=\"{1:F2}\"" +
                                                 " x:Right=\"{2:F2}\"" +
                                                 " x:Top=\"{3:F2}\"/>",
                                                 FMatrix.PageBMargin(0) / MargDiv,
                                                 FMatrix.PageLMargin(0) / MargDiv,
                                                 FMatrix.PageRMargin(0) / MargDiv,
                                                 FMatrix.PageTMargin(0) / MargDiv));
                builder.AppendLine("</PageSetup>");
                builder.AppendLine("<Print>");
                builder.AppendLine("<ValidPrinterInfo/>");
                builder.AppendLine("<PaperSizeIndex>" + FMatrix.RawPaperSize(0).ToString() + "</PaperSizeIndex>");
                builder.AppendLine("</Print>");
            }
            builder.AppendLine("</WorksheetOptions>");
            // add page breaks
            if (FPageBreaks)
            {
                builder.AppendLine("<PageBreaks xmlns=\"urn:schemas-microsoft-com:office:excel\">");
                builder.AppendLine("<RowBreaks>");
                int page = 0;
                for (i = 0; i <= FMatrix.Height - 1; i++)
                {
                    if (FMatrix.YPosById(i) >= FMatrix.PageBreak(page))
                    {
                        builder.AppendLine("<RowBreak>");
                        builder.AppendLine(string.Format("<Row>{0}</Row>", i));
                        builder.AppendLine("</RowBreak>");
                        page++;
                    }
                }
                builder.AppendLine("</RowBreaks>");
                builder.AppendLine("</PageBreaks>");
            }
            builder.AppendLine("</Worksheet>");
            builder.AppendLine("</Workbook>");
            WriteBuf(stream, builder);
        }