accoTOOL
Home
Feedback
Changelog

Changelog

Follow up on the latest improvements and updates.

RSS

new

fixed

improved

accoMASTERDATA

v1.1.14.2

New accoMASTERDATA release: v1.1.14.2

Version 1.1.14.2 brings the following fixes and improvements::
  • Fixed a bug causing lower resolution of visual when in PBI service and a scroll bar is visible.
  • Fixed row creation form elements not being aligned
  • Fixed some incorrect spacings in multiline cells
  • Fixed a bug causing new measures to not be properly registered by the visual
  • Fixed some minor UI elements in settings
  • Fixed required value setting for dates
  • Fixed Validation for dates
  • Fixed new rows having empty default values instead of Nulls
  • Fixed being able to toggle between dropdown KV or not when a PBI conditional formatting measure was used
  • Implemented a way to use transaction keys for new rows. An input field with PBI conditional formatting, is generated in the Formatting settings panel, for each transaction key measures in the measure well. Using this input field, allows for specifying the transaction key value to be used for new rows.
  • Now allows server port delimiter to be either "," or ":"
  • Implemented pagination for dropdown options in the settings window.
  • Added styling of percentages in different colors
  • Added setting to allow custom values in dropdown
  • Adjusted dropdown option order of Key value in the UI, to match the naming convention.
  • Implemented notifications in the toolbar. Will contain messages from accobat when needed.
  • Added context menu option to "Search for value using google"
  • Added writeback option "Ignore empty cells in rows" for ignoreing blank cells when saving.
The new release is available now from AppSource.

new

improved

fixed

accoPLANNING

v1.0.83.5

New accoPLANNING release: v1.0.83.5

Version 1.0.83.5 brings the following fixes and improvements::
  • Updated UI for several elements in advanced edit menu.
  • Increased max width of cells to 800px from 500px
  • Added Toolbar height adjustment setting in Layout "Toolbar settings" tab
  • Added custom size settings for dropdown window in Cell dropdown "Cutom size" tab
  • Implemented persistant read status for notifications when notification bell is opened.
  • Implemented new rightclick context copy menu to copy either displayed or actual value.
  • Implemented conditional cell locking via Conditions.
  • Implemented support for multiple celllock measures.
  • Added setting "Cell lock mode" for selecting logic opperand to use with cell lock measures.
  • Implemented a toggle in the advanced edit menu "Allow free text input in calculations" for Custom calculations and Sahdow calculations
  • Implemented additional enctryption trigger on username input for ease of use (Previously only password input triggered encryption for credentials) - a reference value "Reference User" can be found under Assistance tab in Writeback settings.
  • Replaced toggle "Use Fabric Connection" with a dropdown "Writeback target type"
  • Implemented Powerbi Drillthrough support in rightclick context menu.
  • Implemented Weighted averages aggregation for numeric datatypes, upon selection gives access to a dropdown "Aggregation Weight" for selecting the weight column.
  • Reworked comments and comments on specific measures functionality,
  • Fixed a bug causing Currency Symbol to not work properly for measure specific setting.
  • Fixed toolbar button hover text not disapearing when clicked.
  • Fixed Toolbar buttons to now be less aggresively hidden when visual is narrow.
  • Fixed Edit button for custom calculations not properly selecting the calculation for edit.
  • Fixed checkmark box unintentionally showing in header.
  • Fixed text alignment for grand totals not working.
  • Fixed long overflow header not gettting truncated (hover to show full).
  • Fixed a bug that caused copying cells where some are nonwritable, to not copying all selected cells.
  • Fixed text alignment not applying to nonwritable cells.
  • Fixed splashing calculations not functioning properly in some language regions.
Multiple comment measures
AccoPLANNING now supports multiple comment measures, along with new configuration options for assigning them to specific measures.
The following changes has been made to accomedate this:
1) Removed measure limit from comment measure well.
2) Implemented configuration tab in Comment formatting settings with the following options,
- "Comment to configure" the selected comment to apply bellow options for.
- "Measure to display on" the measure to assign the above selection to.
- "Type" What type of measure the above selection should be treated as.
Type definitions:
(Writeback): Writeback target for comments, is not shown in grid.
(Comment): Comments are display and saved on if no writeback measure.
(Metadata): Metadata is shown as context information on comments.
New comment Writeback priority order for comments:
(1: specific + writeback)
(2: specific + comment)
(3: allMeasures + writeback)
(4: allMeasures + comment)`
3) Defaults are set to continue support for old single comment measure solutions
(by default all measures are assigned to "All Measures", and last measure in well is considered type "Comment" with rest as "Metadata")
The new release is available now from AppSource.

new

fixed

improved

accoMASTERDATA

v1.1.13.1

New accoMASTERDATA release: v1.1.13.1

Version 1.1.13.1 brings the following fixes and improvements:
  • Fixed the UI alignemnt of some elements
  • Fixed a bug causing datetime to be shifted by the timezone offset of the client due to localization. Now datetime is consistant from the client to the database and back.
  • Fixed Default values not working for dropdown columns
  • Fixed Conditions with date not working
  • Fixed Conditions with calculated columns not working
  • Fixed a bug when creating a row when no existing rows in grid or row with null id. Causing the id auto increment to return null.
  • Fixed a bug, causing new rows with string as id's to not be able to be saved.
  • Fixed a bug, causing paste of across columns to not function properly
  • Fixed Special column formantting not displaying properly for new rows
  • Fixed a bug causing relative splashing to multiply the value relatively across cells rather than devide.
  • Fixed some incorrect info in the info panel.
  • Fixed pagination not working properly when infinite scroll was disabled.
  • Fixed shadowcalculations being able to be created without at least one measure reference in the formula
  • Fixed incorrect error "unexpected end of JSON" when license was missing for writeback
  • Fixed a bug causing invalid dates to not be properly checked before saving.
  • Implemented UpdateDate and UpdateDetails for writeback table, using the same Timestamp and Username stamp from auditlog, mirrored into connection
  • Implemented Transaction Keys, with a new "Transaction Keys" measure box
  • Improved some error messages to be more user friendly
  • Implemented Shadow Calculations for string columns (concat)
  • Improved measure boxes to now be compatibled with simple columns(data model)
  • Improved dropdown menus to now expand to fit long option
  • Improved String inputs to allow multiline inputs
  • Implemented allignemnt for checkbox columns
  • Implemented rightclick contexmenu button to reset filters
  • Improved date time formatting and moved it to be per-column in Settings->Column tab
  • Improved UI for creating calculated columns
  • Improved writeback for columns inserts to only insert on columns defined in the visual
  • Improved settings for dropdowns to be applied automatically, eliminating the need for an apply button
  • Improved the UI for creating rows via Form.
  • Moved create row with tab to general settings.
  • Improved Auditlog SQLQuery optional column to now quote string inputs for better copy paste reuse.
  • Improved scrollbar in grid to now follow when tabbing through columns.
  • Implemented Multiline "Display Value As" for text columns.
  • Updated Icons for data wells being able to contain both Measures and Datafields with both icons.
  • Improved splashing UI
  • Changed handleing of Key Value dropdown pairs, to now show label in both dropdown and cell, but sends value to DB.
  • Implemented dynamic local storage of user specific usestates, these include [Column width/Row height (dragged), Recent colors (colorpicker), Collapsed/Expanded groupings, Sorting, Filters]. Note this feature requires explicit allowence in Powerbi to function.
The new release is available now from AppSource.

new

accoCOMMENT

v1.0.0.0

New accoCOMMENT release: v1.0.0.0

Version 1.0.0.0 brings the following fixes and improvements::
  • Added helper text for modules
  • Major Theme framework
  • General Styling
  • Expanded telemetry with AAD user info
  • Implemented transaction key on create
  • Finished writeback support
  • Finished Validation framework
  • Implemented updatedate + updateDetails on writeback
  • Implemented Dropdown default selection
  • Implemented option for plain text copy of rich text
  • Implemented comment character count
  • Refined comment history
  • Added collapsable comment history panel
  • Implemented Notification framework + User read persistance.
  • Added connection port syntax for , or :
  • Implemented keyboard navigation
The new release is available now from AppSource.

fixed

new

accoPLANNING

v1.0.81.3

New accoPLANNING release: v1.0.81.3

Version 1.0.81.3 brings the following fixes and improvements::
  • Shadow calculations no longer trim closing parentheses incorrectly.
  • Duplicate numbers in formulas? No problem — fixed!
  • Improved keyboard navigation after dropdown selection.
  • Splashing now works correctly for:
  • Dates (replace-only)
  • Null cells (no more zeroes!)
  • Editing text cells handles characters better (though improvements are ongoing).
  • Text alignment now works properly for column headers.
  • Fixed formula string parsing in shadow calculations when using "/".
  • Prevented token duplication with [[ ]] in shadow calculations.
  • Corrected measure type detection for calculated fields — settings now populate as expected.
  • Input is no longer cleared when min/max validation fails.
  • Fixed token fusion when editing shadow calculations.
  • Shadow calculations now handle nested parentheses correctly.
  • Currency flip toggle works consistently across all measures.
  • Fixed loading spinner apearing under other elements.
  • Fixed a bug causing some number formats being unable to evaluate.
  • Fixed datetime shifting due to timezone localization.
  • Fixed a bug causing Comment toolbar button to be displayed when no comment measure is defined.
  • Fixed decimal & thousend seperators to properly interpret input depending on chosen seperator format.
  • Upgraded Flexmonster version for enhanced stability.
  • Better telemetry to help us help you faster.
  • Increased allowed first characters for cell input.
  • Shadow calculations now support writable measures as output.
  • Warnings now appear when text exceeds allowed comment length (ongoing).
  • Calculation Overview now includes an Edit button for custom calculations.
  • New toggle to hide column hierarchy names in Layout → Hierarchy.
  • Long column headers are truncated when space runs out — full text shown on hover (ongoing).
  • Comments can now be tied to specific measures only.
  • Conditional formatting (Power BI style) added to Validation Min/Max settings.
  • Locked or non-writable checkmark cells now display proper checkmark
  • Excel exports now use a more identifiable sheet name: "accoPLANNING Export".
  • Toolbar upgraded to the new MUI-styled design.
  • Toolbar settings are now customizable under Settings → Layout → Toolbar Settings.
  • Permissions added for:
  • Enabling Advanced Edit while in read mode.
  • Exporting to Excel while in read mode.
  • Clearer user messaging when circular dependencies are detected in shadow calculations.
  • Advanced Edit menu received a fresh new look 🎨.
  • Customization pane under Advanced Edit updated with improved layout and styling.
  • Added user permission toggle to control access to Advanced Edit mode.
  • Implemented pbi conditional formatting for "Reporting mode" user permission
The new release is available now from AppSource.

new

improved

fixed

accoMASTERDATA

v1.1.9.3

New accoMASTERDATA release: v1.1.9.3

Version 1.1.9.3 brings the following fixes and improvements::
  • Fixed validation testing field not being inclusive for Min/Max.
  • Fixed visual grid being limited to 1000 rows, now allows rendering of up to 30000 rows (max limit from powerbi api).
  • Fixed "Required value" settings toggle & "Make field required" column header option, to now properly require a value to save.
  • Fixed prepend/append disapearing when swapping to and from percent format.
  • Fixed grouping on calculated column not working properly
  • Fixed UI for toolbar save button being too low & and save counter being too high.
  • Fixed disabled toolbar buttons, not properly using the configured style.
  • Fixed calculated column crashing the visual if ' or . was used in the calculation formula.
  • Fixed a bug causing Paste (copy&paste) across multiple rows to sometimes paste on incorrect column.
  • Fixed some column header buttons not applying theme color correctly.
  • Fixed a crash occuring when entering dropdown settings with no measures configured.
  • Fixed a bug causing measures to sometimes not be added to the grid when a custom state was saved.
  • Fixed a bug causing initial state to be reset when columns settings was interacted with.
  • Fixed a bug where date formats didnt properly follow the format set in the measure.
  • Fixed column header alignment not applying
  • Implemented initial support for fabric writeback. This is a limited implementation, with some restrictions due to the missing Identity in fabric warehouse, and unsuported OUTPUT keyword (For this initial implementation, Inserts of new rows is only possible when rowID is string due to the missing identity in fabric warehouse. Auditlog is limited due to the missing OUTPUT keyword, making id's in auditlog inconsistant)
  • Developed first implementation of Selfhosted API for accoMASTERDATA.
  • Implemented column grouping, allowing for columns to be grouped an being collapsable, can be configured in the settings->grouping tab.
  • Implemented formatting options for Boolean type columns, (Checkbox, Toggle switch).
  • Implemented functionality for Exporting and Importing of report settings/configuration, Exported settings comes in .JSON format, Import settings from .Json or .txt
  • General improvements to settings UI
  • Implemented and improved Paste functionality across multiple cells. (Replace/Even/Relative)
  • Improved settings UI for Validation/Conditions.
  • Adjusted icon size of Prepend/Apend icons to scale with font size.
  • Removed functionality of creating a new row after input in last cell of created rows.
  • Implemented option "Create new row with tab" to create new row when pressing Tab while the last cell of top row is selected. (default: off)
  • Implemented Dynamic default values for Measures & RowID's, via measures(pbi conditional formatting) in pbi formattingsettings pane.
  • Improved SQL differenctiation between Azure/fabric SQL and Fabric warehouse, for better compatability.
  • Implemented Fabric writeback via cloud API.
  • Implemented Fabric writeback via SelfHosted API (Retroactively)
  • Improved the date/time formatting and moved it into columns settings, making the format per column.
  • Implemented additional aggregations for string columns (Min, Max, First, Last, Count, Distinct Count).
  • Implemented a checkbox to column groupings which determines the default Expanded state.
  • Implemented Percentage slider as a formatting option for number columns.
  • Added dynamic formatting string for calculated columns.
  • Implemented single click for boolean columns (checkmarks/toggles).
  • Implemented ability to delete multiple selected columns at once.
The new release is available now from AppSource.

new

v1.0.77.2

accoPLANNING

New accoPLANNING release: v1.0.77.2

Version 1.0.77.2 brings the following fixes and improvements::
  • Fixed Text Allignment for column headers not working
  • Fixed Shadowcalculations not splitting formula string on "/" re-populating input formula when editing
  • Fixed Shadowcalculations encapsulating tokens with "[ ]" when re-populating input formula, causing end product to have double "[[ ]]"
  • Fixed Calculation measures sometimes having incorrect type, causing some settings to not properly populate for Calculation measures
  • Renamed sheet name when exporting to excel to be better recognized as accoplanning export
  • Updated Toolbar to new MUI styled toolbar
  • Implemented various toolbar customization options under Settings->Layout->Toolbar settings
  • Implemented User permission toggle for Advanced edit mode while in read mode
  • Implemented User permission toggle for Exporting to excel while in read mode
The new release is available now from AppSource.

new

fixed

improved

accoMASTERDATA

v1.1.5.2

New accoMASTERDATA release: v1.1.5.2

Version 1.1.5.2 brings the following fixes and improvements:
  • fixed RowID not using "Writeback column name" setting
  • fixed setting box being able to be dragged outside window.
  • fixed writeback keybind adding an empty change to pending changes, causing the API to reject the writeback attempt
  • fixed custom calculations not working with decimal values with comma seperator
  • fixed empty conditions overwriting others by disallowing empty conditions
  • fixed unresponsive selecter on column "display value as" setting
  • Implemented a Temporary fix for Identity columns failing to write to Auditlog
  • Fixed MUI license sometimes not applything properly
  • Fixed being able to put special characters in condition titles, causing conditions to break.
  • Fixed auditlog handleing of Identity writeback columns when creating rows, now uses output from writeback to identity columns for auditlog.
  • Fixed Date type columns having an empty string instead of NULL as value on creation.
  • Fixed editing of custom calculated columns causing making values apear blank.
  • Fixed handleing of Toggle on rules to properly disable and enable.
  • Fixed Validation Min and Max to be inclusive instead of exclusive
  • Fixed Validation Apply button being grayed out for date columns.
  • Fixed being able to remove validation for a column.
  • Settings dialog styling updated
  • Added keybind when making dropdown options to begin a new option (Enter)
  • Added section for default values on columns for Row creation, under Settings -> Column "Row Creation"
  • Added filtering options to context menu when right-clicking on a cell
  • Improved user feedback for several actions
  • Added button with label for String operator in the condition flyout
  • Added toggles to conditions in the condition list which allows for disable/enable of conditions
  • Implemented automatic trimming of leading and trailing spaces on server name for connection
  • Added email syntax to the URL formatting of strings columns.
  • Added option for prepending/apending of icons for conditions
  • Added group names for the respective groups when grouping on columns
  • Added new QuickFilter feature to the toolbar, allowing for quick ad-hoc filtering on the grid
  • Implemented flyout for custom calculated columns with selectable column tokens.
  • Added initial Implementation for Percentage as a "Display value as" for numeric column types
  • Added custom calculated columns as option for conditional formatting(Conditions)
  • Improved Telemetry
  • Improved performance of pasting data into the grid.
  • Implemented Pasting options for Numeric data, Replace/Even/Relative
  • Added visual indication of which column is grouped on, when grouped on multiple columns
  • Improved UX for Tags to now include a multiselect dropdown list of all current tags and previeously typed during the session.
  • Implemented an indicator on column headers when configured as dropdown.
The new release is available now from AppSource.

new

fixed

improved

v1.0.64.6

accoPLANNING

New accoPLANNING release: v1.0.64.6

Version 1.0.64.6 brings the following fixes and improvements::
  • Got rid a some pesky bugs
  • Renamed "Reduce Data Exposure" to "Send Only Keys"
  • Copy & Paste from Excel now pastes in the same format as the copied structure. (highlight & copy 3x3 square in excel, Paste in 3x3 square in accoPLANNING)
  • Added darker border around status triangle on cells to better make it out when cell background is similar color to the triangle
  • Implemented "Themes" which allows for setting a predefined look that can then be build on top of
The new release is available now from AppSource.

new

improved

fixed

v1.0.63.6

accoPLANNING

New accoPLANNING release: v1.0.63.6

Version 1.0.63.6 brings the following fixes and improvements::
  1. Got rid a some pesky bugs
  2. Renamed "Custom dimensions" to "Calculations"
  3. accoPLANNING now supports writeback to database columns using unicode characters(emoji) in it's name
  4. Added functionality to only send data from the fields "Measures, Transaction keys, User, Comments, CellLock, Non-writeable measures" by using the setting "Send only keys" in "Settings"
  5. Added functionality to display Null values as a given symbol via the "Show blank values as" setting in "Formatting"
  6. Added functionality to generate writeback table SQL script based on the current grid configuration, via the "Show writeback table script" setting in "Connection"
The new release is available now from AppSource.
Load More
→