ROneCOne 1.10.0
ROneCOne 1.10.0
The sixteen demo workbooks now fit their text in Excel. ROneCOne.cls differs from 1.9.1 only
in its release header, so upgrading is a drop-in replacement and no calling code changes.
Fixed
The renders used to review the demos come from a tool that draws Calibri and Consolas narrower
than Excel does, so they hid most of the layout problems. Measured with Excel's own AutoFit, the
1.9.1 workbooks split or clipped 74 cells, soft-wrapped 50 code lines mid-expression, and cut off
text in rows too short to hold it. Excel keeps the height a row was saved with and does not
resize it on open, so a row the builder left unsized showed only the first line of its wrapped
text. Every capability demo's title band was also a few points short of its 24-point title.
The builders now size everything from Excel's measurements. A code line longer than its column
breaks with a VBA line continuation, the style the Excel Table demo already used, and each example
row takes its height from its longest cell. Five snippets that already carried a statement onto a
second line lacked the _ continuation VBA requires, and now end the line with it. Every table
row has an explicit height. Value columns widen only in the DateTime, HTTP, and Excel Table demos,
where a timestamp, an escaped string, or a joined list needs the room. The two SHA-256 digests on
the Text sheet are 64 hex characters with nowhere to break, so they still wrap mid-string, inside
rows sized to hold them.
Expected Booleans showed as checkboxes beside the plain TRUE the macro writes, because the
workbook builders stored a JavaScript Boolean as an Excel checkbox cell. They are now written as
=TRUE and =FALSE, so both columns show TRUE.
The capability demos' Examples titles read naturally: "Live HTTP examples" rather than "Live
http + async examples". Their Status columns show PASS in green and CHECK in red, as the
Delegates and Collections demos already did, and NOT RUN now shows in amber in all sixteen.
The HTTP benchmark times the same three downloads overlapped and in sequence, and the sheet now
labels both columns and shows both to six decimals. Its note says what overlapping can save and
that fast responses can take the same time either way. The demo module's comments no longer
promise a saving the measurement does not always show. The Collections benchmark subtitle names
both scales it measures.
Changed
The Excel Table demo serializes its sample row with ToJson(True), so the JSON shows indented and
wraps at its own line breaks rather than splitting inside a key.
Release evidence
Each of three fresh Microsoft 365 Excel processes passed the same 997 live assertions as 1.9.1.
All ten suite benchmark scenarios met their release gates in every sample. The medians ran
invocation 0.11, collection 0.16, ordering 0.93, dictionary build and read 0.14, 100,000 indexed
lookups 0.26, keyed mutation 0.66, 10,000 list writes 0.06, 2,000 row reads 0.07, 10,000 hash set
reads 0.01, and constrained maintenance 0.47 seconds.
All sixteen demo workbooks were rebuilt from their builders and run in place, and all 205 of their
examples passed. An AutoFit check in Excel over every cell, merged title bands included, reported
only the two digests, and every rendered sheet was reviewed. The VBE casing round trip over the
runtime, all eighteen demo modules, and a host module brought every token back as written.
Static analysis on pyVBAanalysis 1.3.1 reported zero diagnostics across the runtime source, the
live test modules, the demo modules, and all sixteen final workbooks. 89 Python contract tests pin
the source, the demos, and the documentation. Every packaged VBA module round-tripped
byte-for-byte.