Hi, That is one of the problems with OpenOffice (and many other programs): the developers don't actually use it and the users are not developers...
Long ago I used to be developer (DBMS, Paradox), since then I have been trying to develop my user-behaviour. ;‑) But take a look at AOO Base. In any table, user defines: name of field and type of field. The latter can be e.g. "Text", "Number", "Date", "Time", "Boolean" etc. Thus it is, in some sense, equivalent of "number" format for a cell. One should consider renaming that tab to reflect its true nature/purpose. As already pointed out "Text" is a misnommer, so maybe "Type" or "Format Type" ??? Now why is the tab called number? I am irritated by this. For me it is an oxymoron. That reminds me quotation I used in one of my reports to Bugzilla. Please visit the following link: https://pasteboard.co/J39ISMV.jpg where I placed image file with due screenshots. "I should be right - I'm the user" ;‑) Regards, Czesław Wolański Le ven. 10 avr. 2020 à 13:25, Matthias Seidel <[email protected]> a écrit : > Hi Dave, > > Am 10.04.20 um 13:02 schrieb Dave: > > 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. > > That's so true! > > There is no border between users and developers at AOO. > Every user can help with development (like I do). They must only have > the courage to engage. > > Regards, > > Matthias > > > > > Best Regards > > Dave > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [email protected] > > For additional commands, e-mail: [email protected] > > > >
