My response is in-line with your original post. On 10/04/2020 10:02, Peter Kovacs wrote: > I do some user help stuff on Facebook, and learn by that more about > using OpenOffice. (I do not have much Office needs in my private live.) > > However there is in Calc the option to Format a cell. For instance if I > want to set a Cell to be of text Format I do: > > 1) Right click the cell > > 2) select format cell option > > 3) The config window will open and claim you are on the number Tab.
That is only true if the "Format Cells" dialog has not been opened previously with another tab selected, otherwise the previously selected tab will be reselected. > 4) you select then in the Category Window the Format type i.e. "text> Now why > is the tab called number? I am irritated by this. For me it is > an oxymoron. No, because a cell in a spreadsheet would in most instances contain a numeric value (eg. Numbers, Percentage, Currency, Date, Time, etc.) that could be used in a calculation. Which is what appears in the "Category" list, plus the option to treat the cell(s) as non-numeric plain text. > Does anyone remeber the thinking behind this or has it been always like > this and I just never knew. To the best of my recollection it has been this way since Sun open sourced OOo in 2001. > I mean I would not notice it if I had not to describe it to someone else. Just out of curiosity, what would you consider to be a better terminology to use for that tab. Obviously the word "Text" would be a misnomer, since spreadsheet calculations cannot be performed on plain text, without some form of prior conversion into a numeric format. > All the Best > > Peter I would disagree with Pedro's assertion that "developers don't actually use it and the users are not developers". Apache OpenOffice developers are, always have been and always will be users, but that's another debate for different forum. Best Regards Dave --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
