[OFFICE-2026] Getting Complex numbers from cells (Sections 6.7.2, 6.7.3, 6.7.17) - OASIS Technical Committees Issue Tracker

XML

Word

Printable

Proposal:

Hide

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]))

Show
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] ))
Resolution:

Hide

Most have been corrected in the current draft and this is a trivial issue

Show
Most have been corrected in the current draft and this is a trivial issue

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])