Extensible Document Limitations

Extensible documents are powerful, but there are some limitations when using different file types. Extensible documents cannot reference themselves.

Text File Limitations

  • Does not support images.

Microsoft Word Limitations

  • Word charts cannot be converted to PDF.

Microsoft PowerPoint Limitations

  • PowerPoint cannot be converted to PDF.

  • When using the Rich Text box component with any Extensible Document or Dashboards, the following display format properties will be ignored in OneStream application and Modern Browser Experience:

    • FontFamily

    • FontSize

    • Bold

    • Italic

    • TextColor

    • BackgroundColor

    • BorderColor

  • You can still process and open an Extensible PowerPoint Document that contains an Alt Text - Document Variable with MeasurementUnit, PageWidth, and PageHeight settings that are equal to < 1 inch.

  • The out-of-range settings will automatically be converted to the minimum values equivalent to MeasurementUnit=Inch, PageWidth=1, and PageHeight=1. This includes:

    • When MeasurementUnit=Document and PageWidth < 300 or PageHeight < 300.

    • When MeasurementUnit=Centimeter and PageWidth < 2.54 or PageHeight < 2.54.

    • When MeasurementUnit=Inch and PageWidth < 1 or PageHeight < 1.

    • When MeasurementUnit=Millimeter and PageWidth < 25.4 or PageHeight < 25.4.

    • When MeasurementUnit=Point and PageWidth < 72 or PageHeight < 72.

    NOTE: You can process and open an Extensible PowerPoint Document that contains a measurement equal to an integer (for example, MeasurementUnit=123). The integer will be treated as an invalid value, such as MeasurementUnit=invalid, and be automatically converted to the default Inch setting.

Microsoft Excel Limitations

  • You can only have 500 or less rows and 50 or less columns. If you include an Argument for an Excel Sheet or Excel Named Range that exceeds the maximum limit, you will receive an error message when attempting to process.

  • The center across columns function is not supported.

  • Excel Spark lines is not supported.

  • Word wrap is not supported.

  • 3D charts are not supported.

  • Modifications to colors of individual chart items in a series does not carry through to a PDF.

  • Fitting columns to a page is not supported.

  • Repeating columns and rows is not supported.

  • Cell comments do not display on a PDF after processing.

  • Background images do not display after processing in Excel or PDF.

  • Shapes do not display after processing in Excel or PDF.

  • Smart Art does not display after processing in Excel or PDF.

  • Macros are not supported.

The following Excel functions are not supported in extensible documents.

  • ACCRINT

  • ACCRINTM

  • AGGREGATE

  • AMORDEGRC

  • AMORLINC

  • BAHTTEXT

  • BETA.DIST

  • BETA.INV

  • BINOM.DIST

  • BINOM.DIST.RANGE

  • BINOM.INV

  • BINOMDIST

  • CHISQ.DIST

  • CHISQ.DIST.RT

  • CHISQ.INV

  • CHISQ.INV.RT

  • CHISQ.TEST

  • CONFIDENCE.T

  • COUPDAYBS

  • COUPDAYS

  • COUPDAYSNC

  • COUPNCD

  • COUPNUM

  • COUPPCD

  • COVARIANCE.P

  • COVARIANCE.S

  • CRITBINOM

  • CUBEKIPIMEMBER

  • CUBEMEMBER

  • CUBEMEMBERPROPERTY

  • CUBERANKEDMEMBER

  • CUBESET

  • CUBESETCOUNT

  • CUBEVALUE

  • DDB

  • DEVSQ

  • DISC

  • DURATION

  • EXPON.DIST

  • EXPONDIST

  • F.DIST

  • F.DIST.RT

  • F.INV

  • F.INV.RT

  • F.TEST

  • FACTDOUBLE

  • FILTERXML

  • FISHER

  • FISHERINV

  • FORECAST

  • FVSCHEDULE

  • GAMMA

  • GAMMA.DIST

  • GAMMA.INV

  • GAUSS

  • GCD

  • GETPIVOTDATA

  • GROWTH

  • HARMEAN

  • HYPGEOM.DIST

  • HYPGEOMDIST

  • INTRATE

  • ISPMT

  • KURT

  • LCM

  • LIMEST

  • LOGEST

  • MDURATION

  • MULTINOMINAL

  • NEGBINOM.DIST

  • NEGBINOMDIST

  • ODDFPRICE

  • OFFFYIELD

  • ODDLPRICE

  • ODDLYIELD

  • PERCENTILE.EXC

  • PERCENTILE.ING

  • PERCENTILERANK.EXC

  • PERCENTILERANK.INC

  • PERMUT

  • PERMUTATIONA

  • PHI

  • POISSON

  • POISSON.DIST

  • PRICE

  • PRICEDISC

  • PRICEMAT

  • PROB

  • QUARTILE.EXC

  • QUARTILE.INC

  • RANK.AVG

  • RANK.EQ

  • RECEIVED

  • ROMAN

  • RSQ

  • RTD

  • SERIESSUM

  • SKEW.P

  • SLN

  • STANDARDIZE

  • STDEVPA

  • STEYK

  • SYN

  • T.DIST

  • T.DIST.2T

  • T.DIST.RT

  • T.INV

  • T.INV.2T

  • T.TEST

  • TBILLEQ

  • TBILLPRICE

  • TBILLYIELD

  • TREND

  • TRIMMEAN

  • UNICHAR

  • VARA

  • VARPA

  • VDB

  • WEBSERVICE

  • WEIBULL

  • WEIBULL.DIST

  • XIRR

  • YIELD

  • YIELDDISC

  • YIELDMAT

  • Z.TEST

  • ZTEST