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?
Delete the default double-quote text delimiter in the dialog box when it appears and the file will be output with no text delimiter. You can change either of the delimiters to any character or any string of characters or to no character. Setting fixed length on and using " | " as the field delimiter is a quick way of putting most of the data in a form suitable for viewing as a plain text ASCII file.
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'm not sure exactly what you want, as I don't do a great deal of spreadsheet work and I've gotten used to Calc and my fingers no longer know what Excel does. But F2 toggles Enter mode and Edit mode, that is left and right cursor keys will work within a cell after you press first press F2, but after you press F2 again they will instead move you to the previous or next cell. Pressing ESC will bounce you out of Enter mode altogether and also select the entire cell again.
In Tools -> Options -> OpenOffice.org Calc you can set "Press Enter to switch to Edit Mode" as an option.
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?
[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.]
No. While OOo Calc is similar to Excel, as with any different program it has different ways of doing things and has different key bindings.
You can do some customizing yourself under Tools -> Customize in respect to setting functions to different keys than the setup provides, setting functions not currently bound to the keyboard to particular keyboard combinations or to particular buttons that you can move to a tool bar. The disadvantage of too many changes is you end up with a version of Calc that is still not very compatible with Excel and also not compatible with other people's Calc.
A lot of generally asked questions about Calc by new users are answered at http://documentation.openoffice.org/faqs/spreadsheet/index.html
The OOo 2.0 Migration guide available for download at http://documentation.openoffice.org/manuals/index.html largely discusses specifically the differences between OOo and MS Office and may be of help for quick answers and workarounds when the Excel way suddenly doesn't work.
Jallan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
