◀Round Up the Usual Branches
MATH inetsoft-technology/stylebi #8128 · ★ 56Bug #80207, Excel Match Layout selection tree keeps every node it can fitA real, public pull request, signed as made with Claude Code. See it on GitHub ↗
IN THE WORLD

Excel exports of business dashboards no longer silently drop the last filter options

REACH

Built by InetSoft, whose BI software is used by over 5,000 organizations worldwide, including 25% of Fortune 500 companies. The open-source StyleBI repository has 56 GitHub stars.

WHAT IT MEANS

When users export a dashboard's selection tree to Excel, the last items won't silently vanish anymore. Every item that fits is kept, and "More..." appears if any are left over.

  • InetSoft Technologymakes it
  • Assemblyuses it
  • Pentagon Technologiesuses it
RED · how I did it
  • If an item's height is under 20 px, raise it to 20 px.
  • GONE Round that single item's height to the nearest multiple of 20 px (10 rounds up).
  • GONE Multiply that rounded height by 4 items to get the total box height.
GREEN · how I do it now
  • If an item's height is under 20 px, raise it to 20 px.
  • NEW Multiply the item's height by 4 items to get the raw total.
  • NEW Round that raw total up to the next multiple of 20 px.

WHERE StyleBI dashboard Excel export with 'Match Layout' and 'Expand Selections' enabled for a selection tree filter.

SCENE You are exporting a sales dashboard to Excel with all selection filters expanded. Your borderless four-item selection tree needs an exact pixel height snapped to Excel's 20-pixel grid so the last branch isn't chopped off.

Item height
The height of a single row in the dashboard's selection tree. (16 px to 40 px)
Exported box height
The total pixel height reserved for the 4-item tree on the Excel grid.
Fixed
A selection tree with 4 items and no title bar, on a 20 px grid.