Merging Columns in NeoOffice Calc

From NeoWiki

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		Revision as of 09:58, 15 August 2007 (edit) (undo) Sardisson (Talk | contribs) (some tiny polish while tired; thanks jacqueline!) Next diff →
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.

---

Revision as of 09:58, 15 August 2007

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.