Excel Transformation

Rainbow PDF Server Based Converter V3.0 converts workbook files created in Microsoft Excel 97 to 2003 into PDF or SVG. Windows version also supports conversion into JPEG or PNG or TIFF or Multi-page TIFF. Most Excel chart features can be converted.

Transformation Specification

MS Excel Document

Rainbow PDF Server Based Converter V3.0 supports documents created in the following Excel programs:

  • ".xls" extension files files created with:
    Microsoft Excel 97 for Windows
    Microsoft Excel 2000
    Microsoft Excel 2002
    Microsoft Excel 2003
    Microsoft Office Excel 2007
  • ".xlsx" and ".xlsm" and ".xltx" and ".xltm" extension files created with:
    Microsoft Office Excel 2007

Transformation Specification

  • The program targets sheets from the first sheet to the last sheet in order, and generates pages for print according to the size of the paper and the expansion reduction rate specified by "Page Setup" for each sheet.
  • Sheets with no data are disregarded.
  • When a sheet has data only in the lower right cell, a blank page is outputted until it reaches that cell.
  • When a "Print Area" has been specified in an MS Excel sheet, only the data in the range of the print area are targeted to generate pages for print.
  • All rendering in this program is independent of the Microsoft Excel program therefore, although cell format, row height, and column width in this program are designed to simulate those of Excel, results may not be exactly the same.
  • Charts will simulate Excel excluding 3D View.
  • Raster images are allocated as it is.
  • Although for the most part, Autoshape is processed by simulating the original, there are some shapes that output differently or not at all.

Restrictions and Limitations

  • The conversion result is in print layout format.
  • Portions of 3D View charts cannot be converted.
  • Images set in the header or footer are disregarded.
  • Certain characters of word art might not be reproduced.
  • Object shadows, text shadows and 3-D effects are not supported.
  • Row height and column width might not be set correctly.
  • Text box margins might not reproduce correctly.
  • Multimedia objects such as movies and sounds, etc. are disregarded.
  • Gradation and a translucent color might differ from Excel.
  • Password protected documents cannot be converted.
  • In MS Office, if the font specified to a character doesn't have corresponding glyph, another suitable font might be substituted. Such substitution is not done with this product.
  • WMF/EMF contained in documents made by earlier versions of MS Office 95, and saved again in later version of MS Office 97, might not convert.
  • Embedded objects and linked objects of OLE cannot be displayed (If the information for display is embedded in the document, it might display).
  • Shapes (VML) pasted from the other Office files are not convertible. (If information for the display is embedded in the document, it might be displayed).
  • Elements specified to Table/Pivot style are disregarded.
  • Elements specified to Conditional Formatting are disregarded.
  • [Format Cells] - [Alignment] - [Text Control] -[Shrink to fit] is not supported.
  • If there is a long character string of tens of thousands of characters without the linefeed (CRLF), the conversion may fail.
  • [Format Text Effects] and [Format Shape]
    • When you select [Gradient fill] - [Type - Path] in the Format Shape dialog with PowerPoint2007, the converted result shows the same as when you select [Gradient fill] - [Type - Rectangular].
    • When you specify [Gradient fill] - [Transparency] with PowerPoint2007, it will be ignored and the converted result shows only as 0%.
    • When you specify [Gradient fill] - [Rotate with shape] with PowerPoint2007, it will be ignored and the converted result shows the same as when it is unchecked.
    • When you specify [Picture or texture fill] - [Tiling Option] with PowerPoint2007, all settings of the option will be ignored and converted as [Scale X : 100%] and [Scale Y : 100%]
    • When you specify [Picture or texture fill] and a picture is specified, the shape of the picture will be replaced with a rectangle.
    • The specification of [Slide background fill] will be ignored.
    • [3-D Format] and [3-D Rotation] are not supported. They are converted as if these are not specified.
    • When you specify [Text Box] - [Autofit], the size of the text may not be reproduced correctly.
    • [Picture or texture fill] and [Gradient fill] specified for filling color of text are disregarded.
    • All the specifications for Text Outline are disregarded.
  • [SmartArt] is not supported. It will be deleted.
  • New [Shapes] added in Office2007 will not be converted. They will be deleted. Please note that some shapes which look like 2003 shapes are not converted if these are 2007's originals. A 10-point Star will be converted as an 8-point Star, a 12-point Star will be converted as a16-point Star.
  • When rotation or clipping are specified to a figure, Flip (reversal of right to left or the top to bottom) is disregarded.
  • When an image is specified as the background of a figure, even if rotation is specified, the background image does not rotate.
  • Transparent color specified to a figure is disregarded.
  • Stylized text created by Office 2007 WordArt is not converted the same way.
  • When an image is pasted on a figure, even if rotation is specified to the figure, the image does not rotate.
  • When [Picture fill] and an image are simultaneously specified as the background of a figure, only the image becomes effective.
  • ActiveX controls cannot be displayed. (If the information for display is embedded in the document, it might display).
  • Borders and fill colors on a checkbox control are not supported.
  • 3-D effects on a checkbox control are not supported. They are converted as if these are not specified.

The following are limitations in the conversions from the MS-Excel Charts.

  • Surface chart is not correctly displayed.
  • Size, position, aspect ratio and angle of the displayed chart (especially 3-D chart) might not be displayed the same as those of the original Excel chart.
  • Data table display is not supported.
  • axis scale units are not supported.
  • Data labels other than value cannot be displayed. The display of multiple value labels in Bubble charts are also not supported.
  • Data labels legend key display is not supported.
  • Elaborate fill effects, such as Gradient or Texture, are not supported.
  • The vertical orientation of the axis label is not supported.
  • Hierarchical item labels might not be correctly displayed.
  • Maximum, minimum and major unit etc. of the axis scale might be different from Excel.
  • In combination charts, the legend item might not be displayed in the correct order.
  • Custom (by specifying the range of cell) error amount is not supported.
  • The position of the data labels might differ from Excel.
  • The last 3 patterns in “border style” are not supported.
  • Superscript and subscript in the axis label fonts are not supported.
  • "Round corners" in the chart area is not supported.
  • Display of the equation in the trendline is not supported.
  • If the chart overlaps with the axis, the chart may be placed on the axis and the axis may disappear.
  • The appearance of an approximated curve may differ from Excel.
  • With the time series axis, when the display style is not specified, the display style may differ from Excel.
  • Even if the data of an item axis is the date, it does not become a time series axis if you don't explicitly specify it as the time series axis.