Merging Columns in NeoOffice Calc

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
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 several columns in a spreadsheet, without merging them cell by cell. In order to do that, proceed in the following way:+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>.cvs</tt> format +*Save the document in <tt>.csv</tt> format
-**Choose Text CVS (.cvs) in the pop-down {{menu|File type}} menu+**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>.cvs</tt> file you just created+*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 empty the {{section|Replace with}} field+*Leave the {{section|Replace with}} field empty
*Click on {{button|Replace All}} *Click on {{button|Replace All}}
-*Copy this column and paste it in your initial document;+*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.


This article in other languages: Français Italiano
Personal tools