Changelog

1.8.3

Improvements

  • Improved saving process to prevent crashes
  • Improved label positions in Multi Highlights
  • Improved label positions for line chart
  • Disabled UI elements on server tab when there is no connection
  • Additional Properties Sheet can now be disabled, to prevent editing
  • Colors can now be bound to cell values

Bugfixes

  • Improved the refresh via VBA
  • Use of text label for "infinity" prevented
  • Fixed Vanishing Single Highlight
  • Fixed Databinding for Data Types
  • Fixed crash with "Stacked bars" and "Chart type by series"
  • Fixed Threshold line binding
  • Fixed error when series contained only NULL values
  • Fixed link to graphomate server admin


1.8.1

Improvements

  • Improved saving process to prevent crashes
  • Improved label positions in Multi Highlights
  • Improved label positions for line chart
  • Disabled UI elements on server tab when there is no connection
  • Additional Properties Sheet can now be disabled, to prevent editing
  • Colors can now be bound to cell values

Bugfixes

  • Improved the refresh via VBA
  • Use of text label for "infinity" prevented
  • Fixed Vanishing Single Highlight
  • Fixed Databinding for Data Types
  • Fixed crash with "Stacked bars" and "Chart type by series"
  • Fixed Threshold line binding
  • Fixed error when series contained only NULL values
  • Fixed link to graphomate server admin


1.7.11

Bugfixes

  • Fixed bug with color properties

Improvements

  • Optimized internal data processing
  • Updated dependecies to tackle dropdown problems in property sheet


1.7.8

Bugfixes

  • unusable dropdown fields are fixed, relating to certain Internet Explorer versions
  • fixed drawing issues with multi highlight bubble
  • erroneous values for integer properties in basic propertysheet broke worksheet

Improvements

  • completely removed SAP UI5 from propertysheet
  • bold hatched pattern introduced
  • improved drawing of axis, when 1 pixel wide
  • improved embedded Excel worksheet in Microsoft Word, while graphomate charts are installed (see known issues)
  • installer MSI file is now signed

The following changes are inherited from graphomate charts 2.8 for Lumira Designer

Bugfixes

  • fixed double category axis when using different charttypes by series

  • fixed issues where scaling was broken using infinty outliers in percent deviation chart
  • negative infinite values are now handled correctly for deviations and highlights(single/multi)
  • fixed a display error of category labels when using hierarchical display in time mode

Improvements

  • increased the number of Data series from 10 to 12
  • statistical properties (average, median, linear regression) will now be adjusted according to the category count
  • the series/datatype styles now apply to the outliers too
  • the last element of a waterfall chart is now a result by default
  • if label shadows are enabled the automatic coloring of elementlabels located within a stackedbar chart is now disabled
  • improved label positioning for line chart labels
  • improved space provision for multihighlights
  • improved space provision for waterfall labels close to the category axis
  • new data type entries in the datatype selector will now have a default width of 40%


1.6.9

Bugfixes

  • fixed problems with dropdowns and input fields
  • chart type in APS initially showed 'waterfall'

Improvements

  • Rendering performance increased on cell changes


1.6.5

Bugfixes

  • bound manual separators combined with label picking now working

Improvements

  • "use formatted data" now usable to display excel cell formatting
  • improved screen scaling adjustments of APS 
  • removed property "user highlight color", which does not exist in Excel environment
  • added link to manual from the support menu


The following changes are changes inherited from charts for Lumira Designer 

Bugfixes

  • fixed short line with multi highlights and outliers
  • fixed missing category labels, when member names started with an underscore
  • correct display of the Deviations Configuration in the Additional Properties Sheet after starting or reloading the charts
  • incorrect user entries in the Multihighlight Configurations are intercepted
  • if in the percentage deviationchart all values are outlier, then these are now also displayed
  • series labels now consider the set padding
  • the space requirement for deviation charts when using hidden series is now determined correctly
  • incorrect positioning of the zero value replacements in the offset bar chart with missing series fixed

Improvements

  • improved responsiveness of user highlights
  • category count now considered for statistics
  • optional representation of the mean, median, or linear regression for each (visible) series
  • new tab for interaction with the graphomate server
  • set properties can be saved as a template
  • apply custom Rulesets from the new rulesbuilder for properties Data Types, Waterfall Calculation Path, (Extended) Number Format
  • display of the Rulesets applied to a chart in the design time
  • custom width for category labels in Structure Mode
  • hierarchical display of category labels by members in Structure Mode possible
  • the % sign is now removable for stacked bar charts in percentage mode
  • with only zero values, the axis is no longer displayed in the center
  • renaming the property Scaling Helper Bar Color to Scaling Helper Bar Line Color
  • new property Scaling Helper Area Color for setting the area color of the Scaling Helper in Area Mode
  • Pin Head Mode Options changed from front or back to front / top aligned or back / center aligned
  • new icon in the Additional Properties Sheet for the visibility of series


1.5

Bugfixes

  • Implemented rendering changes from last release for SAP Lumira Designer - see below
  • Missing icon for series selection added
  • cell binding for multi highlights and deviation configuration fixed
  • fixed problem when binding to empty cell
  • fixed import from SAP Lumira Designer

Improvements

  • improved error handling in several areas
  • unusable properties removed
  • log folder changed from documents/graphomate_debug_log to documents/graphomate

The following changes are changes inherited from charts for Lumira Designer 

Bugfixes

  • getSelectedMember now working on deviations again
  • Infrequent display problems of outliers fixed
  • Display problems with small, single deviation chart fixed
  • Waterfall options didn't shown sometimes
  • Fixed problems with labels in negative stacked bar chart
  • Space use of multi highlight label improved
  • Problems with 0-outliers fixed

Improvements

  • Space allocation for labels improved
  • Axis positioning for deviation charts improved
  • Chart type now selectable per series in series selector (integrated layering)
  • Stacked bar values can now be displayed as a fraction of 100%
  • Stack sums don't have to be calculated as sums of absolute values anymore ("real" sums)
  • New property stacked bar mode to choose between regular, negative, 100% and stack without absolute value addition
  • Percentage outlier thresholds implemented
  • Optional rendering of percentage deviation heads behind pins (pin head mode)
  • Possibility to choose pin head color (show line head color and pin head color)
  • Shadows are now drawn as background box
  • Threshold lines can now be defined
  • Line- and pinheads can now be displayed as "wedges"
  • Label picking: labels can now be selectively shown by different criteria
  • Additional option, to define ticks of value axis precisely
  • Redesign of advanced property sheet
  • Usage of outlier thresholds improved


1.4.3 

Bugfixes

  • Fixed value format absolute
  • Empty property on basic propertysheet broke chart

Improvements

  • Video introduction removed


1.4.0

Bugfixes

  • Render problems with some datatypes have been fixed
  • Label posititions in waterfall chart fixed for some cases
  • Sometime deviations were missing in export
  • Locale is now used for label formats
  • rare problems when entering the license have been fixed

Improvements

  • Properties are now bindable to cells
  • Analsysis ranges can now be bound as data for charts
  • At startup, an introduction video is shown
  • Automatic updates for Analysis can now be activated as an option
  • It is now possible to import and export chart templates
  • Ribbon menu has been revised
  • Chart loading from workbook has been improved (Limiting backwards compatibility to version > 1.3.5)
  • ALL_USERS flag is now being set by admin setup
  • Text scaling of the operating system is now being considered for charts


1.3.9 (Hotfix)

Bugfixes

  • fixed a problem when setting data types in basic propertysheet
  • basic propertysheet doesn't disappear anymore
  • NULL values in import data no longer create problems

Improvements

  • Implemented a message indicating failed VBA access
  • added creation date for VBA modules

1.3.4

Bugfixes

  • Fixed Excel import with more than two series fixed
  • VBA error 438 no longer present
  • Shadow color fixe
  • System info for support information fixed

Improvements

  • Deferred chart loading implemented
  • Rotated category labels now available
  • When a license is about to expire, a hint is shown
  • Ribbon elements now have tooltips
  • Chart names don't have to be unique among workbooks anymore
  • Bold text now featured in Excel charts
  • Full version with expiring licenses
  • Debug .bak files no longer created

1.2.19 (Hotfix)

Improvements

  • als Tab wird nun wieder ein eigener "graphomate"-Tab verwendet, weil der generische "Add-Ins" Tab bei vielen Kunden nicht angezeigt wurde
  • Es gibt nun ein eigenens 64bit-Installationsprogramm, weil die Admin-Installation mit Office-x64 und für "everyone" fehl schlug (Add-In wurde nicht angezeigt)

1.2.16

Bugfixes

  • Expired license no longer prevents the user from closing Excel.
  • Arrows for adjusting the element widths are now shown in the datatype tab
  • To input an invalid license key doesn't produce any errors anymore
  • No more errors are shown when deleting worksheets containing graphomate charts

Improvements

  • Copy + paste functionality has been enhanced and is now available via CTRL+C and CTRL+V. The addin specific copy and paste buttons have been removed.
  • Data binding to Excel cells has been completly overhauled. 
  • The addin now checks, if the opened workbook has been created with a newer version of graphomate charts. If yes, a warning shown.
  • Properties not usabel in Excel have been removed.
  • It is now possible, to import graphomate charts from SAP Design Studio into MS Excel
  • Single components can now be refreshed via VBA
  • Properties of single graphomate charts are now accessible from VBA e.g. can be read and written
  • The technical names for VBA scripting of those properties are shown on the bottom of the default property sheet