Using Excel structured references syntax in Calc

Just curious if there is a way to use structured references syntax in Calc?

Hi @waholayo,

Looks like the answer is no – or at least, none of us knows!

Please file an enhancement bug and provide as much information about this new feature as possible. Don’t forget to mark your bug as an ‘enhancement’. The QA team will be happy to help you triage your feature request in the bugtracker.

Please post a link to any bugs you file in a comment below using the format “fdo#123456”.

(You should now have enough karma to post comments on Answers :slight_smile:


@qubit1 Thanks. I’ll go ahead to file an enhancement bug as suggested. Not sure how complex it will be to implement “structure reference syntax” for Calc, but at least I hope this can further minimize some compatibility issues when exchanging files with MS Office users.

@waholayo - I don’t yet understand what you want to ask and why your are refering to an Excel manual. Could please explain yoiur question a bit better?

@ROSt53 Sorry my question came out of blue while opening an .xlsx file in Calc, and then realized some formula couldn’t compute correctly cause it uses “structure reference syntax” instead of the common “cell reference syntax”. Now I know that Calc doesn’t support “structure reference synax” yet.