Re: [libreoffice-users] calc sort

On 01/07/12 03:48, Johnny Rosenberg wrote:
> 2012/1/7 James <bjlockie@lockie.ca>:
> > I made a simple sheet in calc that just contained 'Tue' and 'Wed'.
> > Both cells are a date format but I tried to sort them and they won't change order.
> > 3.5
>
> I don't know about other people on this list, but I certainly need a
> some more information about this.
> Those two cells, how did you enter their content? Just typing ”Tue”
> and ”Wed” into them or typing actual dates and then format them to
> only view weekdays?
> Exactly how did you sort them?
>
>
> Kind regards
>
> Johnny Rosenberg
> ジョニー・ローゼンバーグ

I typed 'Tue' and 'Wed' and then formatted them as NN.
I used the Data-Sort menuitem.
Are they strings even though I made them NN format?
If so, shouldn't Calc put ' in front of them?

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted