|
|
Merging Columns in NeoOffice Calc
From NeoWiki
(Difference between revisions)
| Revision as of 08:28, 15 August 2007 (edit) Jgd (Talk | contribs) (New page: You can merge two or several columns in a spreadsheet, without merging them cell by cell. In order to do that, proceed in the following way: *Copy ({{key| Cmd-C}}) the content of the colum...) ← Previous diff |
Current revision (23:18, 23 December 2007) (edit) (undo) Valterb (Talk | contribs) (botlangbar -> IT) |
||
| (One intermediate revision not shown.) | |||
| Line 1: | Line 1: | ||
| - | You can merge two or | + | You can merge two or more columns in a spreadsheet without merging them cell by cell. In order to do that, proceed as follows: |
| - | *Copy ({{key| Cmd-C}}) the content of the columns you want to merge | + | *Copy ({{key|Cmd-C}}) the content of the columns you want to merge |
| *Open a new Calc document | *Open a new Calc document | ||
| *Paste ({{key|Cmd-V}}) the content of the columns | *Paste ({{key|Cmd-V}}) the content of the columns | ||
| - | *Save the document in <tt>. | + | *Save the document in <tt>.csv</tt> format |
| - | **Choose Text | + | **Choose Text CSV (.csv) in the pop-down {{menu|File type}} menu |
| **Check {{prefName|Edit filter settings}} | **Check {{prefName|Edit filter settings}} | ||
| **Choose a name and a location for your file | **Choose a name and a location for your file | ||
| Line 11: | Line 11: | ||
| *In the {{window|Export of text files}} window, choose "{space}" in the {{prefName|Field delimiter}} field, and leave {{prefName|Text delimiter}} set on: ''' " ''' | *In the {{window|Export of text files}} window, choose "{space}" in the {{prefName|Field delimiter}} field, and leave {{prefName|Text delimiter}} set on: ''' " ''' | ||
| *Click {{button|OK}} | *Click {{button|OK}} | ||
| - | *Open the <tt>. | + | *Open the <tt>.csv</tt> file you just created |
| - | *In the {{window|Text Import}} window, in the {{section|Separated by}} section, uncheck {{prefName|Space}} (if it's checked). All the checkboxes have to be unchecked | + | *In the {{window|Text Import}} window, in the {{section|Separated by}} section, uncheck {{prefName|Space}} (if it's checked). All the checkboxes have to be unchecked. |
| *Click {{button|OK}} | *Click {{button|OK}} | ||
| *A spreadsheet appears, in which the columns are merged | *A spreadsheet appears, in which the columns are merged | ||
| *Go to the {{menu|Edit}} menu, and choose {{menu|Find and Replace}} | *Go to the {{menu|Edit}} menu, and choose {{menu|Find and Replace}} | ||
| *In the {{section|Search for}} field type: ''' " ''' | *In the {{section|Search for}} field type: ''' " ''' | ||
| - | *Leave | + | *Leave the {{section|Replace with}} field empty |
| *Click on {{button|Replace All}} | *Click on {{button|Replace All}} | ||
| - | *Copy this column and paste it | + | *Copy this column and paste it into your initial document |
| This method applies to any number of adjacent columns. | This method applies to any number of adjacent columns. | ||
| - | {{botlangbarEN|[[Fr:Fusionner des Colonnes dans NeoOffice Calc |Français]]}} | + | {{botlangbarEN|[[Fr:Fusionner des Colonnes dans NeoOffice Calc |Français]] [[It:Unire_Colonne_in_Calc|Italiano]]}} |
| [[Category:Tips and Hints]][[Category:NeoOffice]] | [[Category:Tips and Hints]][[Category:NeoOffice]] | ||
Current revision
You can merge two or more columns in a spreadsheet without merging them cell by cell. In order to do that, proceed as follows:
- Copy (Cmd-C) the content of the columns you want to merge
- Open a new Calc document
- Paste (Cmd-V) the content of the columns
- Save the document in .csv format
- Choose Text CSV (.csv) in the pop-down File type menu
- Check Edit filter settings
- Choose a name and a location for your file
- Click Save
- Press Yes to close the "may loose formatting" dialogue
- In the Export of text files window, choose "{space}" in the Field delimiter field, and leave Text delimiter set on: "
- Click OK
- Open the .csv file you just created
- In the Text Import window, in the Separated by section, uncheck Space (if it's checked). All the checkboxes have to be unchecked.
- Click OK
- A spreadsheet appears, in which the columns are merged
- Go to the Edit menu, and choose Find and Replace
- In the Search for field type: "
- Leave the Replace with field empty
- Click on Replace All
- Copy this column and paste it into your initial document
This method applies to any number of adjacent columns.
