It seems that the decision is already made in the text document.When I format or pre-format the spreadsheet as text, I get the numeric representatiof the date. In the end I saved as text and processed it with perl and vi. Never-the-less, it would be nice to know how to keep oo.o from assuming that something is a date.
Thanks, Brian Terry wrote: > From memory, it's sufficient to pre-format the spreadsheet cells as > text. I'd suggest creating a cell style with text format (F11). You > then paste as "unformatted text" using either Paste-Special or the > dropdown arrow on the paste icon. > > It that does not work, you may have to alter the default style of your > document to text (F11 again, right-click on "Default" then select > "Modify"). Paste as "unformatted text". The result will be that all > your data will be text. > > This is from a post on the forum: > "Using a decent text-editor for csv-lists is a good idea (one program, > frequently mentioned here is "csved" for Windows). > When I open a list like this one: > "19.05.",19,"0,098093712748072","http://www.openoffice.org",,19 > File>Open shows a dialog with preview. I can select the first column in > the preview and declare this column as text." > > HTH. This is an example of software out-smarting itself. > > Sonia Carey wrote: >> I am copying a table from a text document to spreadsheet. One of the >> fields in the table contains text in the format eg. 5.1.5. When pasting >> into the spreadsheet, oo.org converts this text to dates. How do I stop >> oo.org from doing this? > Send instant messages to your online friends http://au.messenger.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
