[office-formula] Getting Complex numbers from cells (Sections6.7.2, 6.7.3, 6.7.17)

[Eric Patterson <ericpa@exchange.microsoft.com>]

A number of the test cases for Complex Number functions reference cell [.B4].  Specifically:

 

Section 6.7.2 IMABS

                =IMABS([.B4])

 

Section 6.7.3 IMAGINARY

                =IMAGINARY([.B4])

 

Section 6.7.17 IMREAL

                =IMABS([.B4])

 

 

Given that Cell [.B4] contains "=2" and these functions are expecting Complex numbers, should these expressions be something like this:

 

Section 6.7.2 IMABS

                =IMABS(COMPLEX([.B4],[.B5]))

 

Section 6.7.3 IMAGINARY

                =IMAGINARY(COMPLEX([.B4],[.B5]))

 

Section 6.7.17 IMREAL

                =IMREAL(COMPLEX([.B4],[.B5]))

 

Thanks,
Eric Patterson