![]() ![]() 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.In the navigation window select “Text CSV” from the drop-down.Click on the File menu and select “Open”.Here are the steps for opening this file: This file I am working with is called distributions.txt. The first step is to create and save the file. This file can be opened by Calc with a few simple steps. For example, I have a list I am creating to track distribution installations within a company. But how can this be accomplished? Simple. This comes in very handy when you need to cut and paste data for use in a spreadsheet. And many times I like to create data files in text form and THEN open them as a spreadsheet. Now, with that said, let’s take a look at some of the lesser known tips and tricks you will find in Calc. So if you need spreadsheets fr your daily job you can rest assured that ’s Calc can most likely cover all of your needs. You have probably already read my “ Lesser Known, But Very Helpful Features in Writer” and now it’s time to put the same focus on Calc, the spreadsheet application.īefore I actually get into the bulk of this article I should point out that ’s speadsheet application, Calc, is an outstanding replacement for Excel and can nearly match the Microsoft tool feature for feature. ![]() And for those users who actually want to take advantage of more than the basics of the tools, there are plenty there for you to enjoy. For those users of Microsoft Office looking to migrate to a more cost-effective, less-limiting office suite, you have made the right choice. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |