Here's what's new in wikiCalc Beta release 0.96 (and 0.97):

In addition to all the new features added in What's new in Beta 0.95, What's new in Beta 0.91, Alpha Version 0.3, and Alpha Version 0.2, there are some new features in Beta 0.96. The new version is upwards compatible with the last, but is not downwards compatible -- once you upgrade do not use the old program to edit new data files.

Release 0.97 is virtually the same as 0.96 with the addition of some bug fixes listed on the wikiCalc Bug List page and the items at the end of this list.

This version is hopefully the final feature set to be released as version 1.0.

Overall this version should be similar to 0.95 with the addition of lots of functions, a smoother workflow for published pages, easier localization (e.g., translation into other languages), and a few additional features. Details about some of the new features and functions can be found in the help on the appropriate screen when running.

Here is a list of the main changes:
  • Added functions: DAY, MONTH, YEAR, HOUR, MINUTE, SECOND, ROUND, TRUNC, INT, DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP, HLOOKUP, VLOOKUP, INDEX, MATCH, MOD, FV, NPER, PMT, PV, RATE, SQRT, SYD, TIME, WEEKDAY, N, T, VALUE, PROPER, NPV, IRR, NOT, POWER. ERRCELL has been renamed to WKCERRCELL.
  • The complete list of functions (and a list of their arguments) is available in Help on the Edit tab.
  • UTF-8 compatible comparisons should now be performed in more places in formulas, including inline "<", etc.
  • wkcHTTP has added return types "B" (blank) and "E" (error).
  • Typed input to a cell and the VALUE function now support many more number formats, such as YYYY-MM-DD, YYYY/MM/DD, MM/DD/YY(YY), HH:MM, HH:MM:SS, 1 1/2, #N/A, $1,234.00, etc.
  • Load From Text now logs each value, does normal VALUE-function conversion of special values like 1%, 1/2/3, etc., and has a comment field to add to the audit trail
  • Added {{line-if-liveview}} which outputs text following it on the line only if the template is being used to render during Live View
  • The Preview tab has been renamed "Publish" and moved over to the right of the Format tab, and the Preview sub-tab on it was removed
  • Creating a new page now selects it for edit
  • View buttons on Page tab now display in the same window, not a popup
  • The remaining text strings were moved to WKCStrings.pm to facilitate localization
  • Added "include" ability to WKCdefinitions.txt for modularization of localization
  • No need to select site for Page tab if only one site, that site is now assumed
  • The time in the footer is updated during Ajax-assisted editing on the Edit tab
  • A new Tools / Load From Sheet command was added to load a page's clipboard from the clipboard of another page, either on a local site or from a URL
  • Added the Layout sub-tab to the Format tab for setting Vertical Alignment and Cell Padding. Added that capability to rendering and in datafile save format.
  • Custom formats may have [style=font-weight:bold;color:red] in addition to the normal [RED], etc., color settings. Any number of comparison sections (e.g., "[<100]...;") may be present in a custom format.
  • Many bugs fixed
  • (0.97) Made some changes to the trademark display at the top and bottom of the page while editing
  • (0.97) Made the HTML displayed for the Link text format a configuration setting in WKCStrings.pm
  • (0.97) Changed the default format for time values to [h]:mm:ss instead of h:mm:ss (closer to OpenOffice than Excel and hopefully less likely to result in confusion)

wikiCalc Beta Test Home