On Sun, 2006-02-12 at 17:52 -0500, Clare Kuehn wrote: > Another related question -- sorry to bother you! -- is whether someone could > write a macro to give the option of having no text delimiter ... in the > drop-down menu of Edit Filter Settings in the .csv dialogue box?
You should be able to just delete or change the character shown there and OOo will accept it. > Further: I have discovered that OO copies Excel in a lot of things, but not > in some ways. For instance, in Excel, F2 toggles first to Enter mode and then > to Edit mode in a cell. How do I toggle to Edit mode from within the cell? F2 > in OO only works to get to Enter mode. I couldn't find an existing function that does this. However, any of the up/down/left/right keys will get you back into enter mode, so you could record a macro: - go to Tools-Macro-Record macro, - then press left-arrow then right-arrow - not the other way round or it won't work for the first column. (Or down then up.) - now click the Stop Recording button (appears in a hover window when you start recording). - then name and save the macro. - now, in Tools-Customise-Keyboard assign this macro to an unused key (say F3). Your macro will be listed under the category OpenOffice-User- Standard-Module1 (or similar). - select the macro you just recorded (in the Function box), select the F3 shortcut key and click the Modify button. Now you can press F2 for edit mode and F3 for enter mode. > Lastly: Is there some way to set OO to have all Excel features, such as this? > I mean, change from OO features to Excel ones instantly? Or do I have to wait > for people to write macros? No. Many of OOo's better features come from structural design differences and, in any case, attempting to imitate Excel completely would be a losing strategy. Excel would always be ahead. I think you have identified it yourself - while OOo is familiar to you, some things are better and some are worse. The absence of this particular feature is one 'worse' case (I've noticed it's absence myself and I've rarely used Excel, and never used this feature in Excel). > [Not that all OO ways are worse than Excel's (some are better). But a) I'm > used to Excel, and b) some are better in Excel.] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
