https://bugs.documentfoundation.org/show_bug.cgi?id=97101
--- Comment #3 from David <[email protected]> --- Hi, I understand Miguels proposal and I appreciate the assumption that I am not ignorant. I am familiar with the tactile mouse functions of the GUI Text to Columns approach, which does not process live changes. However, my need was a bit deeper and involved nesting functions. To explain my case and familiarity with spreadsheets and functions here is the code I used to solve my problem. =RIGHT(VLOOKUP(B$36,$A$3:$AC$30,2),LEN(VLOOKUP(B$36,$A$3:$AC$30,2))-FIND("-",VLOOKUP(B$36,$A$3:$AC$30,2))-1) As you can see I was able to work the issue through and the solution was more complex than previously revealed. As I created the solution I also realized the complexity of nested functions for the average person. My belief is that spreadsheets are for common office suite users who have context technical needs and usually lack the programming skills and logic (years in education and an office setting as the IT go-to person). My philosophy leads me to believe that this solution is out of the normal spreadsheet user's range of skills. As I found that this new function was added to Google docs - I thought I should forward the proposal. If you agree with my beliefs about the usability of a spreadsheet in a common person's hand - then perhaps you share a similar philosophy as well and this functionality should be added to improve the product. I also believe that Google docs is a competitor to stay abreast of more than Microsoft these days. Most MS users I know frequently expressed more dissatisfaction with each new MS product release they were forced to use. They were never allowed to load a Linux migrated package to try. Too bad some of us focus too heavily on MS as the competitor. Thank you for your consideration of my proposal! -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
