Ask Your Question

colion's profile - activity

2017-01-23 12:58:02 +0100 received badge  Famous Question (source)
2017-01-23 12:58:02 +0100 received badge  Notable Question (source)
2017-01-07 19:40:54 +0100 received badge  Famous Question (source)
2015-08-26 21:50:50 +0100 received badge  Notable Question (source)
2015-08-25 10:20:21 +0100 received badge  Popular Question (source)
2015-06-25 14:41:07 +0100 answered a question Sort text column including 1st cell

Thanks. That did it.

2015-06-25 14:19:18 +0100 received badge  Editor (source)
2015-06-25 14:18:07 +0100 asked a question Sort text column including 1st cell

If I sort a column of numbers all is well but not when I have a column of text.

I have a column of text that looks like this (note I type a column of text below but it displays as a line of text???)

ZZZ DDD BBB

If I choose Data > Sort > Ascending the column is sorted EXCEPT that the first cell is not included and remains unchanged, resulting in:

ZZZ BBB DDD

How can I force the first cell to be included in the sort?

2015-05-24 00:45:05 +0100 received badge  Popular Question (source)
2015-05-20 21:58:00 +0100 answered a question Importing CSV into Calc without quotes

I do get "Edit Filter Options" in the Export Text File-Field Options dialog box when I enter the Save As mode. However, this only appears to offer the option of using " or ' quotation marks when the "Save cell content as shown" is unchecked as required because text and dates are quoted in Calc. I ran through the options and everything puts either " or ' or "" around text and dates. I assume like other programs LO has the ability to output an unquoted file so I must be doing something wrong and would appreciate your advising what option settings I should use.

2015-05-20 18:01:55 +0100 asked a question Importing CSV into Calc without quotes

I have .csv files that contain text, numbers, and dates. I want to import these files into LO, operate on the rows and columns and then save them as .csv files for use by another program. However, everything that I have tried results in text and dates being quoted which cannot be used by my other programs. Please advise how to do what I want.