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 kommentar(er)
