[libreoffice-users] Input field typing in Calc, 3.4.1

Hi.
This could be related to the bug 
https://bugs.freedesktop.org/show_bug.cgi?id=38195
I have assumed that the input/editing field (formula bar?) in calc is 
untyped, it is plain text without formatting. The bug above results I 
think from formatting from the paste not being stripped.

I have found another peculiarity. May be it stems from pasting in the 
end of string terminator or some formatting info.
LO3.3.2 on Linux does not suffer this problem. LO3.4.1 on mac does.
Type a date into the formula bar/input field, say 2011-03-12 (or 
12/03/2011).

Say you want to repeat dates changing just one part and want to paste 
the rest to save time.

highlight and copy the start part 2011-03-
click in a new cell, paste into the input field so you have 2011-03- and 
type 08 so you get the date 2011-03-08 and press enter. The data is 
entered as a date.

Now do the same thing again but highlight and copy the end part -03-12
click in a new cell, type 2010 and paste into the input field so you 
have 2010-03-12 and press enter. The data is entered as general. You can 
change the data type to date and you can subtract these numbers as dates 
but they do not sort as dates or change format to a different date format.

This also happens if I paste into the middle. I.e. type 12/(paste 
10)/2010. Only when I paste to the beginning is it accepted as a date. 
I.e. (paste 10)/12/2010

If this can this be replicated on non-mac 3.4.1 I will file a general bug.

steve

--
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