![]() ![]() Let’s take a look at a very simple example. What you can do with this feature is, with the help of an easy graphical wizard, copy data from a range of cells and/or multiple sheets and run one of many functions on that data. If you’ve never used Data Consolidation you have been missing a very handy tool. The next time you open the file file with, Calc will format it for you. Notice the addition of the quotes around each entry? You can continue to go back to the txt file and edit so long as you continue to save the file in its original format within Calc.And you don’t have to worry about adding the quotes when editing with a text editor. “RM 101″,”Human Resources”,”Elive Compiz” “PC LOCATION”,”DEPARTMENT”,”DISTRIBUTION” Once in Calc I added another line to this file:Īfter saving this file I opened up the txt version of the file which now looks like: If you edit this file in Calc you will notice some changes. When this file is opened you will have a perfectly formatted spreadsheet ready for you to work with (see Figure 2). In that case you would only want to select Comma from the possibilities as including Space would separate the single value “Ubuntu 9.04” into the values “Ubuntu” and “9.04”. If you were to include spaces as a separator with that file you would mess up the column structure. The problem arises if you have a comma separated list but a single value can be two words. Say, for example, you have a list that is separated by both commas and spaces you can have both. In the options window (see Figure 1) you will notice there are different separator options you can add or remove. In the new window select the options relevant to your file. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |