Loading...

XML

Word

Printable

Type: New Feature
Resolution: Done
Priority: Minor
Fix Version/s: 3.9.1
Affects Version/s: 3.8.3
Component/s: None
Security Level: Jimmy
Labels:
- formula

gh.sprint.customfield.default.name:
Sprint 7

TDIST is changed to T.DIST.2T and T.DIST.RT since Excel 2010, but the required arguments number also change from 3 to 2. It's an special case, not just simply renamed.

list of renamed functions: https://support.office.com/en-us/article/What-s-New-Changes-made-to-Excel-functions-355d08c8-8358-4ecb-b6eb-e2e443e98aac?ui=en-US&rs=en-US&ad=US&fromAR=1#bm2
https://www.zkoss.org/wiki/ZK_Spreadsheet_Essentials/Features_and_Usages/Supported_Formula_Functions

relates to

ZSS-1235 Support those statistical functions renamed in Excel 2010: BINOM.DIST,CHISQ.DIST.RT,CHISQ.INV.RT,EXPON.DIST,F.DIST.RT,F.INV.RT,GAMMA.DIST,GAMMA.INV,HYPGEOM.DIST,MODE.SNGL,NORM.DIST,POISSON.DIST,RANK.EQ,STDEV.S,STDEV.P,T.INV.2T,VAR.P,VAR.S,WEIBULL.DIST

Closed

Assignee:: henrichen

Reporter:: hawk

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Created:: 08/Jun/16 3:03 AM

Updated:: 19/Oct/16 6:13 AM

Resolved:: 19/Oct/16 6:13 AM

Details

Description

Attachments

Issue Links

Activity

People

Dates