March 2016 Requirement 1.2

Worksheet Protection

Addition

Worksheet Functions

Additions

Filter

Addtions

Sort

Addtions

Table

Addtions

Chart

Addtions

  • - Adds support to render a chart as a base64-encoded image by scaling the chart to fit the specified dimensions. - see details in our API Reference.

Range

Addtions

Changes

  • - getUsedRange() now supports a new optional parameter valuesOnly, When true only cells that currently have values are considered used cells. - see details in our API Reference.

RangeFormat

Addtions

  • - Adds new properties rowHeight, columnWidth as well as methods autofitRows() and autofitColumns() to adjust row height and column width. - see details in our API Reference.

April 2015 Requirement Set 1.1

March 2016 Requirement 1.3 (Preview)

Application

Addition

  • - Add application object that represents the Microsoft Word application. This currently enables you to create a new Word document in memory. - see details in our API Reference.

Range

Addition

Body

Addition

  • - Adds new parameter rangeLocation to Body.getRange() method to get a body with an origin at either the beginning or end of an body object. - see details in our API Reference.
  • - Add new method Body.splitTextRanges() that splits the body into child ranges by using delimiters. - see details in our API Reference.

Content Control

Addition

  • - Adds new parameter rangeLocation to contentControl.getRange() method to get a content control with an origin at either the beginning or end of an body object. - see details in our API Reference.
  • - Add new method contentControl.splitTextRanges() that splits the content control into child ranges by using delimiters. - see details in our API Reference.

Paragraph

Addition

  • - Adds new parameter rangeLocation to Paragraph.getRange() method to get a paragraph with an origin at either the beginning or end of an body object. - see details in our API Reference.
  • - Add new method Paragraph.splitTextRanges() that splits the paragraph into child ranges by using delimiters. - see details in our API Reference.

SectionCollection

Addition

ParagraphCollection

Addition

SearchResultCollection

Addition

April 2015 Requirement Set 1.1 & 1.2