To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=20857
------- Additional comments from [email protected] Sun Nov 28 14:40:39 +0000 2010 ------- I too am disappointed that r1c1 UI has not yet been implemented in OpenOffice Calc and have been waiting for the now long delayed debut. I work in a professional environment and would love to advocate OpenOffice Calc as a serious contender with Microsoft Excel. But the lack of support for this common UI feature leads to an impression of the application being "not ready for the big leagues", that it isn't 'serious' software. An impression that is hard to explain away. I have enough of a technical background to understand that this is just a UI issue. The referencing to columns by letters vs numbers is irrelevant to program execution. The data of cell references are manipulated as binary values which are then translated to either '1A' or 'r1c1' for the user. And the user's cell reference entry is translated to binary values for purposes of program execution. I work with 'power users' who shun the '1A' referencing due to the need to frequently use relative column references in formulas. Using alphabetical column references would necessitate frequent manual conversion from alphabetic to the numeric value to perform the offset calculation. That is a ridiculous waste of time that doesn't stand up in productivity and performance reviews. I wonder if the postponing and low prioritization of this feature is indicative of a 'culture' problem. I see references in the OpenOffice 'blogosphere' to 'r1c1' notation as being 'old' and 'older'. I do accounting, among other things. Accountants daily use terms and concepts that were invented over five hundred years ago. 'Debits' and 'Credits' will not become obsolete due to age. Neither will 'r1c1' notation. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
