That was the problem. Originally, in Microsoft Works spreadsheet (Excel
lite), the dates were being entered as text and sorted as text. The rows
entered after migrating to Open Office were the only true dates. Now all I
need to do is make sure that future entries in that column are always
treated as text. I may need to order a book with the details of Open
Office. Thanks for resolving this for me.
Allan Richardson
former mainframe, future PC developer (trying to learn new languages)
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2007 17:51
Subject: [Issue 78415] Sort function may not put dates in correct order
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=78415
User fst changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed Jun 13 21:51:18
+0000 2007 -------
Hi,
press CTRL+F8 to use the Value Highlighting functionality.
Text is black, numbers are blue and formula results are green.
If you have a column starting with a date and some rows further this
'Date' is a
text, a sort will only performed on the numerical date cells.
Calc will not calculate with text, so it would be a good idea to convert
the
text date cells to real date cells.
frank
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.15/848 - Release Date: 6/13/2007
12:50
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
