HI,
On 2007-06-14, at 13:56 , Allan Richardson wrote:
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]
You have responded to an automatically generated message from the
Issue Tracker. You cannot respond directly to these messages. Please
log onto the website, go to the issue, and enter your comments in the
Additional Comments box. When you are finished with your edits to the
issue, click the submit button to update the issue report with your
comments. This is how we keep all notes related to issues organized
and available to all in the community.
To see the Additional Comments box on the issue report, you must be
logged in, and your cookies must be enabled. Type in your user name
and password into fields displayed in the upper right corner, then
click the Login button. If you do this from the Home page, you may
have to click Login again on the Login Page. When you are logged in,
it will show that you are Logged In, and there will be a button
displayed in the upper right corner for you to click when you are
ready to log out.
Once you are logged in, you will be presented with a page called My
Start Page under the My Pages tab, and the left menu will show links
to tools. You can jump directly to your issue, by typing a number in
the input box in the right column of My Start Page, or you can select
My Issues from the Tools menu to see a list of your issues with an
open status. You can show a list of *all* your issues by choosing
'Edit Query' and selecting additional choices in the Status field, by
clicking on them with your Control key pressed down, then click on
'Submit Query'.
To send attachments regarding issues, please attach the file directly
to the issue. Use the link "Create a new attachment" on the issue and
then select Binary file (application/octet-stream) where asked, "What
kind of file is this?" if your file's type does not show in the list.
Thanks,
The OpenOffice.org Team
---------------------------------------------------------------------
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]
