Changelog

Follow up on the latest improvements and updates.

RSS

NewAccoPlanningV2v2.3.0.0

New accoPLANNINGV2 release: v2.3.0.0

accoPLANNING V2 — Release notes, version 2.3.0.0
## Highlights
  • Versions, redesigned.
    The report's own saved state is now called
    Report
    , and a named version holds only your own view of the grid. Choose which version opens when you open the report, and keep a version in the report to share it with everyone.
  • Review changes before you save.
    A new Writeback dialog lists every change waiting to be saved, lets you take back single changes, and keeps a log of each save.
  • A far more capable AI assistant.
    The assistant can now do most of what you can do by hand, from moving fields and changing measures to locking cells and saving versions, and it can explain the cell you are on. When the report author allows it, it can also answer questions about your numbers.
  • Large reports load faster and more reliably.
    When Power BI does not send all the data, the grid now says so and keeps the grid read-only instead of showing totals that are wrong.
## New features
### Save state and versions
  • The report's own saved state is called
    Report
    wherever you see it. Everyone opens on it until they choose a version of their own.
  • A named version keeps only what you set for yourself: open groups, sort, row and column order, filter picks, the swap of rows and columns, and sizes. Settings, themes, formats, rules and calculations belong to the report, so an author's later changes reach everyone, whichever version they use.
  • Changes to your view last until you close the report.
    Save state
    keeps them in the version you use, and a dot under
    Save state
    shows that you have unsaved changes.
  • Tick
    Open on start
    on a version in the Versions dialog to open the report in it next time. With no version ticked, the report opens on Report.
  • Save as new version
    is on the arrow beside
    Save state
    .
  • While editing the report,
    Save to report
    keeps a copy of one of your versions in the report, where it does not expire. Tick
    Share
    on the copy to let everyone who opens the report see and use it. Versions others share are listed under
    Shared with you
    .
  • Reset
    puts back your last save. It no longer deletes your versions or custom themes.
  • Opening the report keeps your versions and custom themes from expiring.
### Writeback
  • A new
    Review changes before saving
    setting, under Settings > Data > Editing, is off by default. With it on,
    Save Data
    and Ctrl+Shift+S open a Writeback dialog, and
    Commit
    saves.
- The
Changes
tab lists each change waiting to be saved (a typed value, a splash, a paste, a fill, a delete, a comment, a lock or a change from the assistant) with its time, the cells it changed with their values before and after, and whether it is pending, failed or committed.
- Take back one pending change, or all of them with
Discard pending
.
Undo
brings them back.
- The
Log
tab lists each save, newest first, with every cell it sent and whether it was saved.
### Measures
  • Each number measure can set its own default splash in
    Manage measures
    : how a number typed into a total is spread, the driver for a driver splash, and whether the splash dialog asks first. A paste onto a total, and the assistant when you do not say how to spread, use it too.
  • Importing from accoPLANNING v1 now brings each measure's default distribution method across.
  • A measure's settings open with the basics first (label, type, role and how it adds up), and the rest in groups: Bindings, Chart, Comments, Format, Editing and Validation.
### AI assistant
  • A new switch,
    Send the grid's values
    , in Settings on the AI assist tab, lets the assistant answer questions about your numbers, such as "which region is furthest over budget?". It is off by default and saved with the report. A warning shows next to the switch, and under the message box while it is on. Comments are never sent.
  • The assistant can now:
- undo and redo, save state, save, switch, rename and delete versions, save your changed numbers, export to Excel and reset,
- change any setting in the Settings dialog, your custom fill lists, a code column shown beside its field, and whether a filter takes one member or several,
- move fields between the rows, the columns and the Filters bar, swap rows and columns, and filter to all but some members,
- change any setting of a measure, and add, delete and move measures,
- add comments, and open a cell's comments or line items,
- lock and unlock cells,
- make highlight rules that test another measure, colour whole rows, columns or labels, and take their colour from a measure, in any colour,
- continue a pattern as the fill handle does, spread a number over the selected cells, and change cells where another measure meets a condition,
- size columns and rows, go to a cell and select cells,
- explain the cell you are on: why it cannot be typed into, why it is coloured, or where its number comes from,
- open the Help & guide at the answer to a "how do I" question, or start the guided tour.
  • A change that reaches past the grid or cannot be undone, such as saving data or deleting a version, runs on its own, with a warning first.
  • One
    Apply
    is one undo step, and an
    Undo
    button under the answer takes all of it back.
  • The assistant knows which cells you have selected and what it changed last, so "make these bold" or "make it blue instead" lands where you mean.
  • A calculated row or measure the assistant adds can be formatted in the same request.
  • When the assistant asks a question with a few clear answers, the answers show as buttons. A waiting plan can be answered with "yes" or "no".
  • A request that needs more than 12 changes is done in turns, up to 48 changes.
  • In large reports, the assistant looks up a name you mention before it makes the change.
  • Stop
    cancels a request. The assistant gives up after 60 seconds, and waits once when the AI service is busy.
  • Last request, on the AI assist tab, shows how many tokens the request used.
  • With AI assist on, every message goes to the AI service, and everything it proposes waits for
    Apply
    . With AI assist off, number commands work offline as before.
### Grid
  • An empty grid says why: no measures to show, no rows that match your filters (with
    Clear filters
    ), or no data. The footer says it too.
  • In merged column headers, an open column group can be moved by its header, so two groups trade places whether they are open or closed.
  • Merge lone own nodes
    and
    Exclude own nodes
    can be switched from the right-click menus on the row and column headers and on the grid background.
  • The
    Manage Cal
    button shows how many calculations the report has.
### Data loading
  • Data loads in parts of 30,000 rows, and large reports load faster.
  • While data reloads, the grid keeps showing what it had, read-only, until the new data is all there.
  • When Power BI stops sending rows, or columns reach the 30,000 limit, a warning icon says so. The toolbar shows "Not all data loaded" and editing stays locked, since the totals are incomplete.
## Improvements and fixes
  • A blank number in the data counts as 0 in calculations and totals, so an average over ten rows divides by ten. A 0 typed onto a blank cell is not a change and is not saved. Blank text, dates and yes/no values stay blank.
  • In very large reports, a value could go missing or two rows could share their cells, which gave wrong totals and could save an edit to the wrong row. Every row now keeps its own cells.
  • Reloading a large report no longer closes open groups or loses the sort and row order of rows that load late.
  • A dragged row or column now stays where you drop it, every time.
  • When a field matches several columns of the writeback table whose names differ only in upper and lower case, the save is refused and names the columns, instead of writing to one of them.
  • An author going back to editing from reading view no longer finds the report's settings locked.
  • Ctrl+Home scrolls back to the top of a long grid.
  • The assistant says why it could not make a change, names a name it could not find, and lists the matches when a name fits several members.
  • The assistant keeps the rest of a highlight rule it changes, and zooms from 40% to 300%, as the zoom control does.
## Please note
  • Open groups, sort, row and column order, sizes, spacers, formats on rows and columns, the report's saved state and named versions saved before version 2.3.0.0 no longer match the grid's rows and columns, and need to be set again.
  • Changes to your view are no longer saved as you work. Use
    Save state
    to keep them.
The new release is available now from AppSource.
NewaccoPLANNINGv1.1.2.6

New accoPLANNING release: v1.1.2.6

Version 1.1.2.5 brings the following fixes and improvements
New Features
Adds option to export configuration, to be used for import in accoPLANNINGV2.
The new release is available now from AppSource.
NewAccoPlanningV2v2.2.0.0

New accoPLANNINGV2 release: v2.2.0.0

accoPLANNING V2 — Release notes, version 2.2.0.0
## Highlights
  • Import your accoPLANNING v1 settings.
    A new
    Import
    tab in the grid's Settings reads a settings export from accoPLANNING v1 and carries your configuration across, so existing planning reports can move to V2 without being rebuilt by hand.
  • Easier writeback.
    Rows and columns are now written by default, numbers are written as changes (deltas), and fields your table does not have are skipped instead of failing the save.
  • Richer conditional formatting.
    Rules can test another measure, colour whole rows, columns and headers, and take their style from a measure.
  • Your own view is remembered.
    Each user's filters, sizes, row order, outline, sort and swap of rows and columns are kept, with the report's saved state as the starting point.
## New features
### Import from accoPLANNING v1
  • Upload or paste a v1 settings export on the new
    Import
    tab.
  • The import brings across:
- connection and writeback settings,
- what each measure is for and its values (formats, validation, dropdowns, comments and locks),
- layout, toolbar and permissions,
- conditional formats, including rules based on measures,
- style settings, combined into one report theme,
- custom measures, as calculated measures,
- custom dimensions, as dimension calculations,
- versions and comments that cover all measures.
  • Before you import, a checklist shows which fields and measures to bind. If something cannot be imported, the import tells you which measure or field to bind.
  • For security, credentials and the licence key are never part of the export. Enter them again after you import.
### Writeback
  • Fields in
    Rows
    and
    Columns
    are written by default, as well as
    Measures
    .
  • A new
    Write this field
    setting lets you choose, per field, whether saving writes it. A transaction key is always written.
  • Numbers in Measures now start on
    Delta
    write mode; everything else starts on
    Absolute
    .
  • An optional field whose column your table does not have is skipped, and the person saving is told which fields were left out.
### Grid
  • Conditional formatting
    can test another measure, paint whole rows, columns and headers, and take a style from a measure.
  • Custom themes
    can be saved in the report.
  • Layout
    : move fields by dragging the grid's own labels, and open a Layout panel from the grid's corner.
  • Comments
    : a year or group row can take a comment of its own, and a Comment column with no measure chosen covers every measure.
  • A side-by-side field on the rows gets its own column beside the row labels.
  • A transaction key stays hidden in the grid until you show it with the eye icon.
  • Context menus show only the actions that work on what you clicked, and
    Conditional formatting
    now sits next to
    Format
    on the header menus.
  • The lock menu follows
    Locked by
    to a lock measure.
  • You can hide the AI Assistant button for yourself from its right-click menu and show it again from a cell.
  • Reset
    clears everything the visual keeps for you.
  • Save state
    saves to the active version, and versions are kept separate from Default.
### Personal settings
  • Each user's filters, sizes, row and column order, outline, sort and swap of rows and columns are kept per visual. When a user has not changed them, the report's saved state is used.
  • General settings and toolbar button visibility are set once by the report author.
### Connection and credentials
  • The grid's Connection tab shows the status of the stored credential.
  • Stored credential fields in the format pane show
    ********
    , so you can see that a credential is saved without revealing it.
## Improvements and fixes
  • The loading screen welcomes you with the product name.
  • Dates on rows or columns are shown as dates, in the format you choose. Power BI's "March 14" format is read as month and day.
  • A value you are typing counts as unsaved from the first keystroke.
  • When you type over a selection, every digit you type is kept in the input dialog.
  • A dragged row or column holds its place while its neighbours slide, and dragging over a closed group no longer opens it.
  • You can no longer open the comment dialog from a cell that cannot take a comment.
The new release is available now from AppSource.
ImprovedfixedaccoCOMMENTv1.2.1.0

New accoCOMMENT release: v1.2.1.0

Version 1.2.1.0 brings the following fixes and improvements:
Fixes
  • "Display latest comment" tooltip is now accurate
    : The setting's tooltip now correctly reflects whether the audit log timestamp column was found in your data, instead of always showing the "not found" message.
  • Toggling "Display latest comment" off and back on now reliably re-selects the newest comment again.
  • More reliable validation on save
    : Field rules such as minimum/maximum comment length, minimum/maximum values, allowed file types, and maximum file size are now consistently enforced when saving a comment, even for fields that aren't marked as required. Previously some of these limits could be silently bypassed on optional fields.
  • Fixed an issue where a custom writeback column name configured for the Tags module's was not being used when saving.
Improvements
  • Clear/Cancel button
    : A Clear button on the comment form now appears once you've changed something.
  • Dropdown, Tags, and Value fields now restore their configured default value when the form is cleared.
The new release is available now from AppSource.
NewfixedaccoPLANNINGv1.1.2.5

New accoPLANNING release: v1.1.2.5

Version 1.1.2.5 brings the following fixes and improvements
New Features
Custom Excel Export
A fully rebuilt Excel export now reconstructs the pivot table's cross-tab layout directly — matching exactly what is shown on screen, including your row and column hierarchy groupings and all visible measures. Subtotals and Grand Total rows are included and marked in bold. Previously the export relied on Flexmonster's internal rendering which could produce inconsistent results for certain hierarchy and measure configurations.
Per-Measure Lock Column Assignment
Each measure in your report can now be individually configured to use a specific lock column (or none at all). A "Lock measure" dropdown appears in the Cell locks formatting pane for every bound measure, replacing the older all-or-nothing approach. Reports configured before this version continue to work unchanged; existing lock column assignments are automatically migrated on first load.
A "Writeback column name" field is also available per lock column, letting you override the database column name used when writing lock state back without renaming the field in your data model.
Bug Fixes
  • Shadow calculations in batch-row mode:
    Calculated fields (shadow calculations) whose output targets overlapped with other pending edits could retain stale delta values when saving in batch-row mode. This is now resolved — all calculation output targets are included in the delta merge on save.
  • Exclude Zeros with multiple measures:
    When "Exclude Zeros" was enabled and an entry had one measure edited to a delta of zero, that edit entry could be incorrectly dropped even if other measures on the same row still had non-zero delta values in the same entry (like when using Shadow calculations). The check now considers all measures before dropping an entry.
  • Delta merge with multiple pending edits per row:
    When multiple pending edits existed for the same data row (e.g., after several unsaved changes), the delta merge in batch processing could apply an incorrect base value for later edits. This is now fixed.
  • Checkbox rendering:
    In certain configurations, boolean/checkbox cells could render with a
    checked="null"
    HTML attribute — which HTML treats as truthy — causing checkboxes to appear checked regardless of their actual value. Fixed to emit an empty attribute string instead.
  • Comment input type in mixed-type rows:
    In rows where a measure can be either numeric or text, comment input fields could incorrectly receive a
    type="number"
    or
    type="checkbox"
    attribute, breaking text entry. The input type is now always forced to
    text
    for comment fields.
NewimprovedfixedaccoMASTERDATAv1.2.0.4

New accoMASTERDATA release: v1.2.0.4

Version 1.2.0.4 brings the following fixes and improvements:
  • Fixed a bug causing changes to be cleard when a writeback attempt fails, preventing trying again with same changes.
  • Fixed dropdown values not being available for filters when a measure is configured as dropdown
  • Fixed a bug causing Dynamic number foratting string to not work properly.
  • Fixed a bug causing two spinners to appear when saving data.
  • Implemented column header styling to each column in column settings.
  • Implemented ability to change font for visual in General styling and column settings.
  • When deleting a row, the next in line is now in focus for easier rapid deletion.
  • Added PBI conditional format for validation settings.
  • Expanded to range of configurations being exported when Exporting settings, to now include per measure settings. Note this reuires using the same measures where imported to apply.
Deprecations:
  • Deprecated date column custom date edit format. If this setting is configured a deprecation warning can be found in place of the column setting. This warning allows you to keep the setting for now or remove exiting configuration. Going forward, edit format is controled by the PBI General Date format / Measure format / System format.
NewimprovedfixedaccoPLANNINGv1.0.87.3

New accoPLANNING release: v1.0.87.3

Version 1.0.87.3 brings the following fixes and improvements
Bug fixes
  • Fixed date format being flipped between leaf cells and totals
  • Prevented a bug causing grid to get misaligned when attempting to write in a cell partially offscreen
  • Fixed non-writable string cells being displayed as "1"
  • Fixed "Crtl + Alt + I" not opening acooPLANNING's info
  • Fixed Column header text alignment not working
  • Fixed splashing/calculating in cell with = only working when used as first char
  • Fixed an issue that would stop pasting of values that extend past the visually displayed rows
  • Fixed an issue where splashing with a valid splashing measure would fail to complete with the error "The x must be a number"
  • Fixed a bug causing locked/non-writable cells to ignore the specified decimal limit
  • Fixed a bug causing locked cells to display a 0
  • Fixed a bug where a boolean checkmark could appear in the header
  • Fixed a bug causing input to not work for Matrix layout if no rows/columns was defined in the data-wells
  • Fixed an issue where cleared date values would not be saved due to the native clear value being incompatible, a new clear value for dates has been defined as "1900-01-01" to represent a cleared/deleted value, and can be handled accordingly.
  • Fixed a bug causing the Edit button for custom calculations to not properly select the calculation when pressed.
  • Fixed borders on column headers being applied for rows as well.
  • Fixed Totals styling applying on hierarchy headers when turned off
  • Fixed a bug causing Save Layout to not function properly when "Auto Expand" was set to None
  • Fixed a bug causing turnary shadow calculations to not properly function with "=="
  • Fixed a bug causing some text alignemnt in advanced customization to not function properly
Improvements
  • Power BI measure format now gets applied as grid format for measure
  • Implemented ad hoc Hierarchy filtering via a Right click context menu entry.
  • Backwards compatability patch for introduction of Schemaname field, has been removed. Schemaname will no longer be derived from tableName when formatted as Schemaname.tableName. Tablename syntax has not been changed.
  • Added PBI conditional formatting functionality to "Self-hosted API URL" field in Connection, allowing for a measure to be used.
  • Added PBI Drill down/up to visual
  • Implemented a Measure index for Custom calculation (Measure), Allowing for setting the measure index among other measures, the index placement is done in the same order as is shown in the Calculation Overview.
  • Improved the displayed date format in totals to reflect the same used for leafs
  • Comments saving was changed some time ago to save the full given history of comments from a cell together. This has now been reverted to the original way of saving one comment per cell.
  • Added Edit button for custom measures
  • Improved API Writeback SQL to only insert on given columns.
  • Implemented a Keybind to launch url links from cells by using either (Crtl + Click) or (Alt + Click)
  • Implemented Swiss specific separator setting.
  • Improved
  • Updated Info resource links in the toolbar info panel
  • Implemented Lock cells on specific measure. You can now individually assign which grid measures' editability should be controlled by which lock cell measure. This is controlled in the Formatting settings using per measure settings.
  • Implemented Comment on Locked cell toggle, to allow users to comment on locked cells
  • Added functionality to use parent levels in Custom calculations
  • Expanded available Flexmonster native aggregations
Date/DateTime Format
Formatting is now prioritized in the following order:
  1. PBI formatting settings - General measure formatting
  2. Data model measure format
  3. User browser/system format
The new release is available now from AppSource.
NewimprovedfixedaccoCOMMENTv1.2.0.1

New accoCOMMENT release: v1.2.0.1

Version 1.2.0.1 brings the following fixes and improvements:
🐛 Bug Fixes:
  • Date and datetime values
    are now handled consistently in UTC, preventing timezone-related discrepancies when saving data.
  • Fixed an issue where the
    identity column value
    was not correctly captured in the audit log after an insert or delete operation.
  • Fixed a bug where the
    required field indicator
    was incorrectly shown on the Comment History module.
  • Fixed an issue where
    database connection errors
    from certain authentication providers were not surfaced correctly, making them difficult to diagnose.
  • Connections to the database are now always
    properly closed
    after a save operation, even if an error occurs mid-way.
  • Improved
    error messages
    across save, submit, and approve actions to be clearer and more actionable.
New Features
Locked Modules:
  • Rows can now be locked via a dedicated
    Locked Modules
    measure field in Power BI.
  • Locked rows cannot be edited, submitted, approved, or deleted, keeping your data protected.
Date Module:
  • A new
    Date
    module type is now available in the module palette, allowing date values to be captured and written back alongside your comments.
Measure Autocomplete in Comments (
#
Mentions):
  • Typing
    #
    inside a comment field now opens an
    inline autocomplete dropdown
    listing your available measures.
  • Use the arrow keys to navigate,
    Enter
    to insert, and
    Escape
    to dismiss.
  • Works in both plain text and rich text mode.
Collapsible Long Comments:
  • Long comments in the
    Comment History
    are now automatically truncated.
  • A toggle arrow lets you expand or collapse individual entries to keep the history clean and easy to browse.
Improvements
Buttons:
  • Default button size has been reduced for a more
    compact and less intrusive
    UI.
  • The
    Submit
    and
    Approve
    buttons are now grouped as sub-actions of the
    Save button
    , appearing with a smooth animation when a Workflow is configured. This reduces visual clutter.
Settings Panel:
  • Settings checkboxes now display an
    info tooltip
    even when the setting is enabled, giving clearer guidance on what each option does.
  • Labels and checkboxes are better aligned for improved readability.
Comment History:
  • The lock/read-only state of a row now
    updates in real time
    as data changes, so you no longer need to re-select a row to see its current state.
  • Improved messaging: tooltips and notifications now clearly explain
    why
    an action is blocked (e.g. locked, submitted, or approved).
The new release is available now from AppSource.
NewimprovedfixedaccoCOMMENTv1.1.1.5

New accoCOMMENT release: v1.1.1.5

Version 1.1.1.5 brings the following fixes and improvements::
  • Fixed progress indicator missing from Comment module
  • Fixed some UI element spacing
  • Fixed State buttons being able to fully overlap
  • Fixed a bug causing validation to fail after repeat save attempt
  • Fixed a UI element overflowing for button styling
  • Improved various UI elements
  • Added writeback column name, input field for transaction keys to the general settings
  • Edit modules button is now hidden when in view mode
  • Made some improvements to stability
  • Added additional informational links to the info page
  • Improved the writeback table assistance script
  • Improved audit logging. In order to not fail writes due to an audit log column being too small, the logged string values are now trimmed to fit in such cases
  • Added delete functionality to comment history
  • Implemented new feature to on load display latest comment as editing. This setting can be found in the General tab under the Data section of the visual settings. This setting is on by default
  • Implemented a new submit button along with a new Email notification functionality
  • Made Rating look cleaner in comment history
  • Updated Info links
  • Renamed Notifications to Workflow Receivers
  • Improved Date/Datetime handling
  • Implemented Approve button for already submitted comments. This button allows for approving an already submitted comment, incrementing the state of the comment
  • Added a visual indication of a comment state in comment history
  • Comments with approval state 1 (Submitted) ang 2 (Approved) are now read-only
  • Implemented new setting to set Editing of comments to be restricted to own comments, requiring Entra ID be enabled for custom visual to do so
  • Improved title navigation in settings
  • Improved controls for comment history
The new release is available now from AppSource.
NewimprovedfixedaccoMASTERDATAv1.1.17.6

New accoMASTERDATA release: v1.1.17.6

Version 1.1.17.6 brings the following fixes and improvements::
  • Fixed dynamic formatting for columns
  • Fixed a bug causing some column context options to not work when having grouped columns
  • Fixed a bug causing booleans to retain the change indicator when switched back to original value
  • Fixed a bug causing a visual crash in a specific case where visual did not recieve a format for a date column
  • Fixed some incorect placeholder text
  • Fixed flickering during resizing of visual due to fast re-renders
  • Improved the API's identification of DB table structure
  • Updated and added links to the info tab
  • Implemented a switchable split button to the "Create Row" button, providing an alternate "Create Multiple Rows" button, allowing for selecting a number of rows to created
  • Implemented measure based Row update/creation lock. Lock row updates with a measure provided to a "Cell lock" data well. Lock row creation with a PBI conditional formatting measure in PBI formatting settings under "Cell locks" -> "Allow row creation"
  • Changed visual data loading behavior from single data fetch of up to ~30k rows. To segmented fetching of data in smaller customizable segment sizes, which get's fetched when scrolling, functioning like Lazy Loading. The new data row segment size is limited to a minimum of 100 rows, with upper limit being 30k rows or Power BI data engine limit, which ever is lower. This segment size can be set in PBI formatting panel under "Data Load" -> "Rows load size", Default is 1000
The new release is available now from AppSource.
Load More
→