Calculation Engine
New formula support
Five new formulas enhance the Calculation Engine’s compatibility and analytical capabilities. This enhancement expands formula coverage for multilingual content handling, advanced calculations, statistical analysis, and data aggregation scenarios. The newly supported formulas are:
| Formula | Description |
|---|---|
| DBCS | Converts single-byte characters to double-byte characters, improving multilingual spreadsheet compatibility. |
| LET | Allows variables to be defined and reused within formulas for clearer and more efficient calculations. |
| TTEST | Facilitates statistical hypothesis testing and dataset comparison directly within spreadsheets. |
| GROUPBY | Enables dynamic data grouping and aggregation, simplifying analysis and reporting workflows. |
| BETAINV/BETA.INV | Calculates inverse beta cumulative distribution values for advanced statistical analysis. |
Docking Manager
Document tab icons
The Docking Manager now supports displaying icons on document tabs, making it easier to identify tabs and improving visual clarity.
AI AssistView
The AI AssistView now supports the following features:
Input textbox toolbar
Added a powerful input toolbar experience to the AIAssistView, featuring:
- Customizable toolbar actions with flexible positioning.
- Action button popups for quick and convenient access to input tools.
- Attachment support with upload management and status notifications for a seamless file handling experience.
Enhanced Avatar rendering in AssistView
Improved the rendering behavior of the AvatarView used within the AIAssistView with the following:
- Image scaling for sharper avatar display.
- Smoother shape rendering with anti-aliasing.
- Styling for displaying initials.
Do you have a feature request? Post the details in the feedback portal.
