There are warnings telling you what's happening, but the user has to be savvy enough to break out of the default operation and do something else or the work will be lost and the original data modified and maybe corrupted. All your formatting and formulas will be lost. If you open a text file and import the data, then go forward and format the cells or add formulas as you would in a normal spreadsheet, then save the file, OOo will save the work back into the original file, as plain text again. Maybe I misunderstand what you've done, but using File > Open with a text file does not create a spreadsheet document. My method does however have one advantage in that you can just select the csv file and open it just by selecting open file with openoffice - so it saves time when doing lots of documents as the rename is quicker than the other process the other method i used did that as well. Further-and maybe more important-it produces a spreadsheet document, not a "text file" document.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |