Version history
CloudConfluence Cloud2023-08-16Minor version update Minor version update24.5.0Confluence Data Center 6.0.1 - 8.8.12022-07-19Minor bug fixes Version 24.5.0 • Released 2022-07-19 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Minor bug fixes.
24.5.0Confluence Server 6.0.1 - 8.8.12022-07-19Minor bug fixes Version 24.5.0 • Released 2022-07-19 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Minor bug fixes.
24.3.0Confluence Data Center 6.0.1 - 7.18.32021-12-18Minor bugs fixes and Log4j issue notice (in short: our plugins are not affected) Version 24.3.0 • Released 2021-12-18 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Log4j vulnerability notice: We do not enable logging in the standard versions of our plugins, so any logger objects (log4j or any other) are not created on any (even previous) public releases of CelesteCS plugins. Thus, our plugins are not affected by this vulnerability and never were.
- Minor bugs fixes, related to using of deprecated APIs.
24.3.0Confluence Server 6.0.1 - 7.18.32021-12-18Minor bugs fixes and Log4j issue notice (in short: our plugins are not affected) Version 24.3.0 • Released 2021-12-18 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Log4j vulnerability notice: We do not enable logging in the standard versions of our plugins, so any logger objects (log4j or any other) are not created on any (even previous) public releases of CelesteCS plugins.
- Minor bugs fixes, related to using of deprecated APIs.
24.2.0Confluence Data Center 6.0.1 - 7.15.32021-01-19Quote escaping support Version 24.2.0 • Released 2021-01-19 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Single and double quotes now may be specified in a parameter string - it has to be escaped like here: CONCAT("First \"string\"", 'Second \'string\'').
24.2.0Confluence Server 6.0.1 - 7.15.32021-01-19Quote escaping support Version 24.2.0 • Released 2021-01-19 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Single and double quotes now may be specified in a parameter string - it has to be escaped like here: CONCAT("First \"string\"", 'Second \'string\'').
24.1.0Confluence Data Center 6.0.1 - 7.10.22020-11-10Datetime data type support in addition and subtraction operations. Version 24.1.0 • Released 2020-11-10 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialFrom now on the datetime parameter may be specified as the first parameter of the following operators:
- Addition (+). You may specify datetime value as the first parameter and a numeric value as the second parameter. The integer part of it will be added to the datetime parameter. Example: DATEVALUE('10-Nov-2020') + 5.
- Subtraction (-). You may do the same with “-“ operation. Example: DATEVALUE('10-Nov-2020') - 5.
24.1.0Confluence Server 6.0.1 - 7.10.22020-11-10Datetime data type support in addition and subtraction operations. Version 24.1.0 • Released 2020-11-10 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialFrom now on the datetime parameter may be specified as the first parameter of the following operators:
- Addition (+). You may specify datetime value as the first parameter and a numeric value as the second parameter. The integer part of it will be added to the datetime parameter. Example: DATEVALUE('10-Nov-2020') + 5.
- Subtraction (-). You may do the same with “-“ operation. Example: DATEVALUE('10-Nov-2020') - 5.
24.0.0Confluence Data Center 6.0.1 - 7.8.32020-11-03Most valuable release of this year! New functions are added. Version 24.0.0 • Released 2020-11-03 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialSupport for Jira issue field reading functions. Calculate sums, averages, minimums, maximums, counts of specified Jira issue fields from Confluence. Standard and custom fields may be specified. Field value types are preserved.
The following new functions are supported:
- JIRAISSUEFIELDVALUES - returns Jira issue field values by field name.
- JIRAISSUEFIELDVALUESBYFIELDID - returns Jira issue field values by field identifier.
24.0.0Confluence Server 6.0.1 - 7.8.32020-11-03Most valuable release of this year! New functions added. Version 24.0.0 • Released 2020-11-03 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialSupport for Jira issue field reading functions. Calculate sums, averages, minimums, maximums, counts of specified Jira issue fields from Confluence. Standard and custom fields may be specified. Field value types are preserved.
The following new functions are supported:
- JIRAISSUEFIELDVALUES - returns Jira issue field values by field name.
- JIRAISSUEFIELDVALUESBYFIELDID - returns Jira issue field values by field identifier.
23.1.0Confluence Data Center 6.0.1 - 7.8.32020-04-21New functions support. Version 23.1.0 • Released 2020-04-21 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialThe following new functions are supported:
- HOURS - returns the number of hours between two datetime values. Minutes and seconds are ignored.
- MINUTES - returns the number of minutes between two datetime values. Seconds are ignored.
23.1.0Confluence Server 6.0.1 - 7.8.32020-04-21New functions support. Version 23.1.0 • Released 2020-04-21 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialThe following new functions are supported:
- HOURS - returns the number of hours between two datetime values. Minutes and seconds are ignored.
- MINUTES - returns the number of minutes between two datetime values. Seconds are ignored.
23.0.0Confluence Data Center 6.0.1 - 7.3.52020-03-24Confluence Read-Only Mode support Version 23.0.0 • Released 2020-03-24 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Confluence Read-only mode is now supported, so if you switch your Confluence to read-only mode for site maintenance, CelesteCS Math continues working normally.
23.0.0Confluence Server 6.0.1 - 7.3.52020-03-24Confluence Read-Only Mode support Version 23.0.0 • Released 2020-03-24 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Confluence Read-only mode is now supported, so if you switch your Confluence to read-only mode for site maintenance, CelesteCS Math continues working normally.
22.1.0Confluence Data Center 6.0.1 - 7.3.52019-08-13DATEDIF function support Version 22.1.0 • Released 2019-08-13 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- DATEDIF function support. This function calculates the number of days, months and years between specified dates.
22.1.0Confluence Server 6.0.1 - 7.3.52019-08-13DATEDIF function support Version 22.1.0 • Released 2019-08-13 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- DATEDIF function support. This function calculates the number of days, months and years between specified dates.
22.0.0Confluence Data Center 6.15.3 - 6.15.102019-05-16Confluence Datacenter support Version 22.0.0 • Released 2019-05-16 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Math plugin has been thoroughly tested and verified for Atlassian Confluence Datacenter compatibility
22.0.0Confluence Server 5.5 - 6.15.102019-05-16Confluence Datacenter support Version 22.0.0 • Released 2019-05-16 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Math plugin has been thoroughly tested and verified for Atlassian Confluence Datacenter compatibility
21.1.0Confluence Server 5.5 - 6.15.102019-02-19Macro recursive render depth limit Version 21.1.0 • Released 2019-02-19 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Macro recursive render depth limit: we have limited the number of possible self renderings with 10 times
21.0.0Confluence Server 5.5 - 6.14.32019-01-29From now any Confluence page element may be referenced with JQuery-like selector Version 21.0.0 • Released 2019-01-29 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Support for GETCONFLUENCEPAGEDATA function, which returns the contents of the specified page as plain text
- Support for GETCONFLUENCEPAGEDATAASHTML function, which returns the contents of the specified page as HTML
- Support for GETCONFLUENCEPAGEELEMENTCOUNT function, which returns the number of the Confluence page elements according to the specified query. See the query language description here
- Support for GETCONFLUENCEPAGEELEMENTDATA function, which returns the contents of the specified page element as plain text
- Support for GETCONFLUENCEPAGEELEMENTDATAASHTML function, which returns the contents of the specified page element as HTML
20.4.0Confluence Server 5.5 - 6.14.32019-01-08Support of ‘Decimal symbol’ and ‘Digit grouping symbol’ parameters in Math Cloud Version 20.4.0 • Released 2019-01-08 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- ‘Decimal symbol’ and ‘Digit grouping symbol’ parameters are now supported in Math Cloud
- Better readable values for ‘Decimal symbol’ and ‘Digit grouping symbol’ parameters. Example: ‘ (space)’ instead of ‘ ’, ’.(dot)’ instead of ‘.’
- Fixed an issue of incorrectly read ‘ ‘ value for ‘Digit grouping symbol’ parameter
20.2.0Confluence Server 5.5 - 6.13.202019-01-04Fixed long values with decimal group separator parsing issue Version 20.2.0 • Released 2019-01-04 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Fixed long values with decimal group separator parsing issue
20.1.0Confluence Server 5.5 - 6.13.202018-12-25At last! Support for digit grouping symbols and better decimal symbols support Version 20.1.0 • Released 2018-12-25 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Support for “Digit grouping symbol” parameter, which specifies the symbol, which divides numbers to groups in some locales. Possible values: "" (default), " ", ".", ",", "'"
- Better support for “Decimal symbol” parameter – now it is used in all number formatting-related operations
19.0.0Confluence Server 5.5 - 6.13.202018-08-14A long awaited ability to specify whole column/row as a formula operand is here Version 19.0.0 • Released 2018-08-14 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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
- Both Server and Cloud versions:
18.5.0Confluence Server 5.5 - 6.10.32018-05-23NETWORKDAYS and WORKDAY functions support Version 18.5.0 • Released 2018-05-23 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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, ...])
18.4.0Confluence Server 5.5 - 6.9.32018-04-24CelesteCS Conditions support Version 18.4.0 • Released 2018-04-24 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Added support for CelesteCS Conditions, our new product for conditional formatting
- Minor bug fixes
18.3.0Confluence Server 5.5 - 6.8.52018-04-03From now SUM function recognizes numeric types more accurately Version 18.3.0 • Released 2018-04-03 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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
18.2.0Confluence Server 5.5 - 6.8.52018-03-27SUM function update Version 18.2.0 • Released 2018-03-27 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- SUM function is updated to ignore “ ” symbols in calculations
18.1.0Confluence Server 5.5 - 6.8.52018-03-20SUM function update Version 18.1.0 • Released 2018-03-20 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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
18.0.0Confluence Server 5.5 - 6.7.32018-03-13Most awaited new functions support Version 18.0.0 • Released 2018-03-13 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialLong 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
17.9.0Confluence Server 5.5 - 6.7.32018-02-19Correct work with header cell values Version 17.9.0 • Released 2018-02-19 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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.
17.8.0Confluence Server 5.5 - 6.7.32018-02-06Correct work with Page Properties macro in latest versions of Confluence Version 17.8.0 • Released 2018-02-06 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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
17.7.0Confluence Server 5.5 - 6.7.32018-01-18DAYS function fixed Version 17.7.0 • Released 2018-01-18 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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)
17.6.0Confluence Server 5.5 - 6.6.172017-10-24Fix for a complex rendering case Version 17.6.0 • Released 2017-10-24 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Fix for an issue of rendering the Math macro, which references the cells on another page
17.5.0Confluence Server 5.5 - 6.4.32017-09-07Fixes for round function and unary operands Version 17.5.0 • Released 2017-09-07 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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
17.4.0Confluence Server 5.5 - 6.3.42017-09-04Preview mode support Version 17.4.0 • Released 2017-09-04 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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
17.3.0Confluence Server 5.5 - 6.3.42017-08-30Better Confluence date picker support in date processing functions Version 17.3.0 • Released 2017-08-30 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Fixed date value extraction from date picker control
17.2.0Confluence Server 5.5 - 6.3.42017-08-29Support for Jira application link name parameter in JiraISSUECOUNT function Version 17.2.0 • Released 2017-08-29 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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.
17.1.0Confluence Server 5.5 - 6.3.42017-08-24Bug-fixing release Version 17.1.0 • Released 2017-08-24 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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
17.0.0Confluence Server 5.5 - 6.3.42017-08-17Source page rendering optimizations Version 17.0.0 • Released 2017-08-17 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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
16.3.0Confluence Server 5.5 - 6.3.42017-06-13Decimal Symbol parameter is back! Version 16.3.0 • Released 2017-06-13 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialWe 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
16.2.0Confluence Server 5.0.3 - 6.2.42017-05-22Dependency fixes for JiraIssueCount function Version 16.2.0 • Released 2017-05-22 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Dependency fix for JiraIssueCount function
16.1.0Confluence Server 5.0.3 - 6.2.42017-05-17Standard Confluence logging support Version 16.1.0 • Released 2017-05-17 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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
16.0.0Confluence Server 5.0.3 - 6.1.42017-05-10Replacement of Jira Issues macro and biggest amount of new supported functions! Version 16.0.0 • Released 2017-05-10 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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
15.0.0Confluence Server 5.0.3 - 6.1.42017-04-10Ability to specify table values from several pages in a single formula Version 15.0.0 • Released 2017-04-10 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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
14.0.0Confluence Server 5.0.3 - 6.1.42017-03-29CurrentTable variable specificator support and page load optimizations Version 14.0.0 • Released 2017-03-29 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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.
12.0.0Confluence Server 5.0.3 - 6.1.42017-03-27Ability to load macro dynamically Version 12.0.0 • Released 2017-03-27 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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.
11.8.0Confluence Server 5.0.3 - 6.1.42017-03-21Support of Jira macro load in static way Version 11.8.0 • Released 2017-03-21 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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
11.7.0Confluence Server 5.0.3 - 6.1.42017-02-03LEFT, RIGHT and MID text functions support Version 11.7.0 • Released 2017-02-03 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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)
11.6.0Confluence Server 5.0.3 - 6.0.72017-01-27Equal ("=") operator support Version 11.6.0 • Released 2017-01-27 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Equal ("=") operator support. This operator compares numerical and text values. Use it in the following way: 'IF(Table1.A2 = "Hello", "yes", "no")'.
11.5.0Confluence Server 5.0.3 - 6.0.72017-01-24DATEVALUE function support Version 11.5.0 • Released 2017-01-24 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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")'.
11.4.0Confluence Server 5.0.3 - 6.0.72016-11-07Empty parameter list support for VALUE function Version 11.4.0 • Released 2016-11-07 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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
11.3.0Confluence Server 5.0.3 - 5.10.92016-10-15SUBSTITUTE function fix Version 11.3.0 • Released 2016-10-15 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- A small fix in SUBSTITUTE function, which could also affect other text-related functions
11.2.0Confluence Server 5.0.3 - 5.10.92016-10-14VLOOKUP function fix Version 11.2.0 • Released 2016-10-14 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Fixed VLOOKUP function misbehavior
11.1.0Confluence Server 5.0.3 - 5.10.92016-10-07A quick hotfix for the major version Version 11.1.0 • Released 2016-10-07 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Fixed an issue, appeared after ranges support addition
11.0.0Confluence Server 5.0.3 - 5.10.92016-10-04Lookup functions support and other enhancements Version 11.0.0 • Released 2016-10-04 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- VLOOKUP function support
- HLOOKUP function support
- Support of num_digits parameter in ROUND function
10.1.0Confluence Server 5.0.3 - 5.10.92016-08-12HTML-encoded symbols support Version 10.1.0 • Released 2016-08-12 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Texts, like & < and > are now correctly processed
- Codebase made lighter
10.0.0Confluence Server 5.0.3 - 5.10.92016-07-04CelesteCS Math for Confluence Cloud is available! Powered by Google App Engine! Version 10.0.0 • Released 2016-07-04 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialStarting 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.
9.0.0Confluence Server 5.0.3 - 5.10.92016-06-27User permission checks are greatly enhanced Version 9.0.0 • Released 2016-06-27 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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
8.1.0Confluence Server 5.0.3 - 5.10.92016-04-04Grown Date and Time feature maturity with additional functions support Version 8.1.0 • Released 2016-04-04 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Added additional Date and Time functions:
- DAY
- HOUR
- MINUTE
- MONTH
- SECOND
- TIME
- TODAY
- WEEKDAY
- YEAR
8.0.0Confluence Server 5.0.3 - 5.9.142016-03-31Date data type is now supported Version 8.0.0 • Released 2016-03-31 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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
7.4.0Confluence Server 5.0.3 - 5.9.142016-03-12Bugfix release Version 7.4.0 • Released 2016-03-12 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- Fixed an issue with extra parenthesis in the macro output
- Few other smaller fixes
7.3.0Confluence Server 5.0.3 - 5.9.142016-03-07Additional text functions support Version 7.3.0 • Released 2016-03-07 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- SUBSTITUTE function support
- REPLACE function support
- Fixed an issue, when numerical value returned instead of the text of third-party macro
7.1.0Confluence Server 5.0.3 - 5.9.142016-02-29Minor bugfix release Version 7.1.0 • Released 2016-02-29 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn this release:
- A bug with incorrect processing macro output in some circumstances is fixed
7.0.0Confluence Server 5.0.3 - 5.9.142016-02-22Math goes beyond Math with Text and Boolean parameters support! Version 7.0.0 • Released 2016-02-22 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialMain 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.
6.0.0Confluence Server 5.0.3 - 5.9.142016-01-26From now CelesteCS Math plugin suppports Confluence Data Center Version 6.0.0 • Released 2016-01-26 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialIn 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.
5.2.0Confluence Server 5.0.3 - 5.9.142016-01-19A tiny bug fix release Version 5.2.0 • Released 2016-01-19 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialNew in this version:
- A tiny bug with incorrect Decimal Symbols parameter processing in some situations is fixed
5.1.0Confluence Server 5.0.3 - 5.9.142016-01-13Bug fix release Version 5.1.0 • Released 2016-01-13 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialMinor bug fix release
5.0.0Confluence Server 5.0.3 - 5.9.142015-12-24Ability to refer table cell values from any other Confluence page Version 5.0.0 • Released 2015-12-24 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialStarting 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
4.3.0Confluence Server 5.0.3 - 5.9.142015-12-22Smart input parameters check Version 4.3.0 • Released 2015-12-22 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialCurrent version includes new algorithm of checking input parameters, which checks incorrect situations.
4.2.0Confluence Server 5.0.3 - 5.9.142015-12-03Now Math macro calculation result in a table cell may be referenced correctly Version 4.2.0 • Released 2015-12-03 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialThe 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
4.1.0Confluence Server 5.0.3 - 5.9.142015-11-18Standard logging support Version 4.1.0 • Released 2015-11-18 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialAll 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.
4.0.0Confluence Server 5.0.3 - 5.8.182015-10-27Excel notation, ranges of cells (A2:B10), functions with any number of arguments Version 4.0.0 • Released 2015-10-27 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialThe 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!
3.3.0Confluence Server 5.0.3 - 5.8.182015-06-23Latest Confluence version support Version 3.3.0 • Released 2015-06-23 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialThe following changes are there:
1. Latest Confluence version support
2. Minor bug fixes
3. Star is shown in Trial versions
3.2.0Confluence Server 5.0.3 - 5.7.42015-04-23Support for table cells with values like "A + B = 4" and other features Version 3.2.0 • Released 2015-04-23 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialFrom 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)
3.1.1Confluence Server 5.0.3 - 5.7.42015-04-21Better formatting support Version 3.1.1 • Released 2015-04-21 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialFrom this version additional formatting elements are supported:
- span element to support text colors, specified in style attribute
- blockquote element, to support quote style
3.1.0Confluence Server 5.0.3 - 5.7.42015-04-20Support for table cells with Numerical Expression macro Version 3.1.0 • Released 2015-04-20 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialStarting from this version:
- Expression Macros can use values of each other when they are specified in the tables.
3.0.0Confluence Server 5.0.3 - 5.7.42015-04-07Numerical Expression goes beyond the macro borders! Version 3.0.0 • Released 2015-04-07 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialFrom 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.
2.0.2Confluence Server 5.0.3 - 5.7.42015-01-28Confluence 5.7 support Version 2.0.2 • Released 2015-01-28 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialMaintenance build with Confluence 5.7 support.
2.0.1Confluence Server 5.0.3 - 5.6.62014-12-05Hotfix build Version 2.0.1 • Released 2014-12-05 • Supported By Celeste Creative Solutions • Paid via Atlassian • Commercial- Fixes a rare issue when table sorting was lost due to macro output post-processing.
2.0.0Confluence Server 5.0.3 - 5.6.62014-12-01Tables support Version 2.0.0 • Released 2014-12-01 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialFrom 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
1.2.0Confluence Server 5.0.3 - 5.6.62014-11-20Logical functions and operands are now supported Version 1.2.0 • Released 2014-11-20 • Supported By Celeste Creative Solutions • Paid via Atlassian • CommercialThe 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.
1.1.0Confluence Server 5.0.3 - 5.6.62014-10-09Rich set of math functions is added Version 1.1.0 • Released 2014-10-09 • Supported By Celeste Creative Solutions • Paid via Atlassian • Commercial35 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
1.0.0Confluence Server 5.0.3 - 5.6.62014-10-01Initial but yet very powerful version Version 1.0.0 • Released 2014-10-01 • Supported By Celeste Creative Solutions • Paid via Atlassian • Atlassian Closed-SourceFeatures:
- Numerical Expressions
- Adding values from Macros
- Single and multiple expressions specification
- Result formatting
- Math functions
- Decimal symbol specification