Hi Leonard, On Saturday, 2007-06-09 20:47:54 +0300, Leonard Mada wrote:
> >>*However, does ANY user need exactly the A1:IV65536 range*??? > > > >Yes, if you want row heights / column widths / cell attributes to apply > >to an entire sheet. Probably not for pasting some "tech journalists' > >test data". > > A. I still feel that NO-one needs exactly 65536 rows x 256 columns. No, but a fast way to select the entire sheet, whatever size it has, and apply some attribute or style. > Now, to give a usefulness to the 'CTRL'+'A' key, I return back to my > previous post: give the user 2 choices > 1.) first choice: display window where user can select the number of > columns and rows > (for default values see paragraph 2.) ) > 2.) select everything UP TO: > - the right-most column that is NOT empty > - the bottom-most row that is NOT empty Both choices don't cover scenarios where the user wants to apply attributes quickly to an area that covers more than just cells already containing data. Btw, both methods are more or less already possible: 1. Enter the range in the Name Box, the edit box left to the input line and function wizard icon. Ok, that currently is not exactly a "number of columns and rows". 2. Press Shift+Ctrl+End > B. Why copy everything (attributes, possibly even content) thousand of > times? We don't copy attributes to each cell. Attributes are stored in sets of items and identical sets in run lengths per column, so when pressing Ctrl+A and applying some attribute, given that all resulting attribution is identical, 256 copies of references to a set of items are stored in memory. This is different with cell content, which currently is stored separately for each cell. Certainly an area that could be improved. And just was for string cells with identical content. > In Impress, you can define the settings for a *MASTER SLIDE*. > > So, why is there NO such *MASTER-CELL* in Calc? For attribution there is. It is called the Default cell style, you may find it in the Stylist, F11 or menu Format -> Styles and Formatting. A Master-Cell-Content doesn't make much sense, does it? Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
