Minor version update

In this release:

• Both Server and Cloud versions:
  • Support for whole column and row specification as a formula operand. Heading cells are skipped. Usage examples: SUM(‘Table1.A:A’), MAX(‘Table1.2:4’)
• Cloud version:
  • Added a special logic to avoid rendering of the macros, which are not referenced in the formulas, which provided higher performance and render loop problem avoidance. This algorithm has been successfully applied and tested on the Server version of Math macro some time ago and now it is available on Cloud version as well
  • Support for extended set of non-ASCII symbols, like Umlauts

In this release:

• NETWORKDAYS function support. Usage: NETWORKDAYS(start_date, end_date, [holiday_date_1, ...])
• WORKDAY function support. Usage: WORKDAY(start_date, days, [holiday_date_1, ...])

In this release:

• Added support for CelesteCS Conditions, our new product for conditional formatting
• Minor bug fixes

In this release:

• SUM function is now more accurate in choosing between integer and floating-point result types. If all numeric arguments of this function are integers, then the result is integer, otherwise it is floating-point. Previously in most cases SUM function returned floating-point results
• Minor update in empty string processing algorithm

In this release:

• SUM function is updated to ignore “ ” symbols in calculations

In this release:

• Update SUM function to ignore empty and non-numeric values. From now on the SUM function sums LONG, DOUBLE and DATETIME values and ignores text or empty values
• Fix of incorrect work in case of empty cells set as function parameters

Long awaited statistical functions support:

• AVERAGEIF - returns an average (arithmetic mean) of all the values in a range that meet a given criteria
• AVERAGEIFS - returns an average (arithmetic mean) of all values that meet multiple criteria
• COUNT - counts the number of cells that contain numbers
• COUNTA - counts the number of cells that are not empty
• COUNTIF - counts the number of cells that meet a condition; for example, to count the number of times a particular name appears in the list
• COUNTIFS - applies criteria to cells across multiple ranges and counts the number of times all criteria are met

Often requested math and trigonometry functions support:

• PI - returns the number 3.141592653589793, the mathematical constant pi, accurate to 16 digits
• SUMIF - sums the values in a range that meet criteria
• SUMIFS - adds all of its arguments that meet multiple criteria

In this release:

• Correct work with header cell values: header cell values are usually enclosed with two not printed symbols. Standard TRIM function cannot recognize such symbols as spaces, thus it does not skip it. As a result, the values, like “ 450 “ are not recognized as numerical values and as result, header values cannot be used in calculations. Starting from this version this behavior is corrected.

In this release:

• Fixed the issue, appeared in latest Confluence versions, when rendering Math macro as a part of Page Properties macro returned empty values. The reason was in changed way of rendering internal macros in Page Properties macro – now it renders them in “preview mode”, thus Math macro was updated to support this behavior

In this release:

• DAYS function has been fixed - now it returns negative value, when end date (first parameter) is earlier than the start date (second parameter)

In this release:

• Fix for an issue of rendering the Math macro, which references the cells on another page

In this release:

• Round function now support both positive and negative numbers of meaning digits
• Fixed an issue, when unary operands, like negation worked incorrectly, being specified for the second and consequent parameter values

In this release:

• Starting from the release we officially support preview mode. It differs from the normal page rendering mode and thus we had to add some additional logic to make Math plug-in render correctly
• DATEVALUE function will now return -1 in case of incorrect parameters or any error. This will make calculation result processing simpler

In this release:

• Fixed date value extraction from date picker control

In this release:

• An optional app_link_name parameter support is added to JiraISSUECOUNT function. If set, a specified Jira app link will be used. Otherwise a primary application link is taken.

In this release:

• Fixed an issue, appeared in v.17.0, when the formulas in square or curly braces were not calculated
• Fixed a DATETIME function issue, when date value from Date Picker was processed incorrectly due to extra braces

In this release:

• Math macro results cache is returned back. This feature provides optimizations in cases when one Numerical Expression macro value is referenced in another one. From now on the referenced macro value is not calculated twice, but read from cache instead
• Smart page rendering. Starting from this release Numerical Expression macro does not render all other Numerical Expression macros on the page. It checks, which macros are referenced from the formulas and renders only referenced ones
• Ability to reference one Numerical Expression macro in another one when trial license is used. Previously a trial version ‘*’ sign spoiled referenced macro values, now it's not

We heard a lot of complains regarding removing Decimal Symbol parameter. Thus, we decided to return it back, so here it is!

In this release:

• Decimal Symbol parameter is supported again
• Net.minidev JSON-smart library usage is replaced with GSON from Google due to unresolved dependency issues

In this release:

• Dependency fix for JiraIssueCount function

In this release:

- Standard Confluence logging support. From now on Math plugin does not write its logs by default. To enable Math logging, add “com.celestecs.expression.Logger” entry with Debug level in Logging and Profiling configuration page

- Latest Confluence version support

In this release:

1. Support of JiraIssueCount function, which replaces the need to use Jira Issues macro to retrieve the number of Jira Issues. From now on you may specify JQL request as a parameter of JiraIssueCount function and it will return the number of appropriate issues. Example: JiraIssueCount(“Project = ‘Test’”)

2. New set of functions – Engineering:

a. BIN2DEC

b. DEC2BIN

c. DEC2HEX

d. DELTA

e. HEX2DEC

f. IMAGINARY

g. IMREAL

h. OCT2DEC

3. New set of functions – Financial:

a. FV

b. IRR

c. MIRR

d. NPER

e. NPV

f. PMT

g. PPMT

h. PV

i. RATE

In this release:

• Long awaited ability to use data from several pages in a single Math macro formula: just specify “[PageId]” before table field specification. PageId may be copied from the address bar while editing a src page, as it is a part of URI when Page Editor is opened. Usage example: “SUM([123123]Table1.A2:B4) / SUM([456456]Table2.B2:C2)”
• Caching of loaded pages to make macro work faster
• Better HTML to plain text conversion
• Trial version sign double appearance fix
• Removing unused extra code to make macro file size smaller

In this release:

• CurrentTable variable specificator support: If Math macro is placed inside a table cell, you may refer to the cells of its parent table with CurrentTable specificator, for example you may specify “CurrentTable.A2” instead of “Table2.A2”
• Optimizations in reading own and outer page contents: own page content is read only once and then cached for further use; the same is done with outer page.

Note: both features are available in both Server and Cloud versions of Math plugin.

In this major release:

- Ability to load Math macro dynamically. If this feature is turned on, only a tiny part of macro is loaded initially and all calculations are performed in parallel and loaded afterwards. This lets a parent page to be loaded without waiting while all calculations are finished.

In this release:

• Static Jira Issues macro load feature - fix an issue when embedded Jira Issues macro value was read like a "reading content..." instead of actual number of issues

In this release:

• LEFT text function support. Example: LEFT(Table1.A2, 2)
• RIGHT text function support. Example: RIGHT(Table1.A2, 2)
• MID text function support. Example: MID(Table1.A2, 2, 3)

In this release:

• Equal ("=") operator support. This operator compares numerical and text values. Use it in the following way: 'IF(Table1.A2 = "Hello", "yes", "no")'.

In this release:

• DATEVALUE function support. This function parses string into a date-time serial value. Use it in conjunction with TEXT function, for example: 'TEXT(DATEVALUE("24 Jan 2016"), "dd-mmm-yyyy")'.

In this release:

• VALUE function now may have zero number of parameters or an empty string as a parameter value. In both these cases it returns 0, which is convenient for the cases when the third-party macro, specified as a parameter, returns nothing or an empty string

In this release:

• A small fix in SUBSTITUTE function, which could also affect other text-related functions

In this release:

• Fixed VLOOKUP function misbehavior

In this release:

• Fixed an issue, appeared after ranges support addition

In this release:

• VLOOKUP function support
• HLOOKUP function support
• Support of num_digits parameter in ROUND function

In this release:

- Texts, like & < and > are now correctly processed

- Codebase made lighter

Starting from this version CelesteCS Math add-on is provided in two versions: for Confluence Server and Confluence Cloud. Both add-ons share the same code base, thus most new features will appear in both versions. CelesteCS Math Cloud add-on is hosted on Google App Engine servers, so it becomes a highly-available and secure solution, but at the same time it is still simple and easy to use. CelesteCS Math add-on is still hosted on parent Confluence Server's host.

In this version:

• Permissions check: added robust checks for the case when "other page" is specified as a data source for the formula
• Minor bug fixes

In this release:

- Added additional Date and Time functions:

• DAY
• HOUR
• MINUTE
• MONTH
• SECOND
• TIME
• TODAY
• WEEKDAY
• YEAR

In this release:

1. Date data type is now supported. For example you may specify the following formula: DAYS(NOW(), DATE(2016, 04,17)) and the number of days will be returned.

2. TEXT function is added to format text in EXCEL style

In this release:

- Fixed an issue with extra parenthesis in the macro output

- Few other smaller fixes

In this release:

- SUBSTITUTE function support

- REPLACE function support

- Fixed an issue, when numerical value returned instead of the text of third-party macro

In this release:

- A bug with incorrect processing macro output in some circumstances is fixed

Main features of current release:

- Text parameters are supported: a big set of text functions, such as FIND, LEN, UPPER and LOWER is added. String concatenation operator “&” is added;

- Boolean values are supported: if Math finds “TRUE” or “FALSE” values in the parameters, it works with them as with Boolean values. Logical functions return Boolean values, not 1 or 0;

- Logical function set is extended: SWITCH, TRUE, FALSE functions are added.

In this release:

CelesteCS Math plugin has been thoroughly tested to run correctly on Confluence Data Center, so from now on it may be used on Confluence cluster environments.

New in this version:

- A tiny bug with incorrect Decimal Symbols parameter processing in some situations is fixed

Minor bug fix release

Starting from Math 5.0.0 it is possible to specify a Confluence page to read table cell values from. To do that do the following:

- Set outer-values-source parameter value to Other page

- Specify page in current or any other space as other-confluence-page parameter value

- Refer table cell values in the formula as usual

Result: Table cell values will be taken from the page, specified in other-confluence-page parameter

Current version includes new algorithm of checking input parameters, which checks incorrect situations.

The following things are done:

1. Fixed an issue, when the result of Math macro calculation in a table cell could not be referenced from another instance of Math macro

2. Supported version of Confluence is updated

All CelesteCS Math logs are having INFO severity from now. Thus, if you specify higher logging level, for example WARN, the logs will not be shown.

The most valuable version update ever released!

The features you've dreamed on became a reality:

- Ranges of cells, like "A2:B10", are supported as function arguments for more convenient work with tables;

- A set of functions with unlimited number of arguments is added: SUM, AVERAGE, MAX, MIN and even more;

- Excel notation is supported, for example "SUM(Table1!A2:B10)", for simplest reuse of formulas from your favourite spreadsheet app.

Enjoy!

The following changes are there:

1. Latest Confluence version support

2. Minor bug fixes

3. Star is shown in Trial versions

From this version the following things are supported:

- Specifying table cells which contain results of formula calculation in full format, like "A + B = 4"

- Support for simple first table cell specification (A2 instead of Table1.A2) in all cases (both when the first table is a part of macro or a part of whole page)

From this version additional formatting elements are supported:

- span element to support text colors, specified in style attribute

- blockquote element, to support quote style

Starting from this version:

- Expression Macros can use values of each other when they are specified in the tables.

From this version any table on the page may be used.

- The source to take table values form - whole page or macro body - is specified by the parameter.

- Any cell of any table may be specified with notation like Table1.A1, Table2.B3 and so on.

Maintenance build with Confluence 5.7 support.

- Fixes a rare issue when table sorting was lost due to macro output post-processing.

From now on Numerical Expression macro supports tables:

- Table cells may be specified as an expression operands

- Table cell is simply referenced by column letter and row number

- Table must be inserted into Numerical Expression macro body

The following operands are supported:

• logical AND ("&&")
• logical OR ("||")
• logical NOT ("!")

The following functions are supported:

• double and(double a, double b)
  • Returns 1 if both a and b are non zero values.
• double not(double a)
  • Returns 1 if a is zero or zero if a is non zero value.
• double or(double a, double b)
  • Returns 1 if a or b is non zero. If both are zero, returns 0.

35 functions added:

• double abs(double a)
• double acos(double a)
• double asin(double a)
• double atan(double a)
• double ceil(double a)
• double copySign(double magnitude, double sign)
• double cosh(double x)
• double exp(double a)
• double floor(double a)
• double log(double a)
• double max(double a, double b)
• double min(double a, double b)
• double random()
• long round(double a)
• double signum(double d)
• double sinh(double x)
• double sqrt(double a)
• double tan(double a)
• double tanh(double x)
• double toDegrees(double angrad)
• double toRadians(double angdeg)
• ... and other

Features:

• Numerical Expressions
• Adding values from Macros
• Single and multiple expressions specification
• Result formatting
• Math functions
• Decimal symbol specification