Bug 107895 - Calc doesn't distinguish dates from numbers when deleting cells content
Summary: Calc doesn't distinguish dates from numbers when deleting cells content
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.1.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-05-16 15:29 UTC by Dolespa
Modified: 2017-05-18 17:18 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Dolespa 2017-05-16 15:29:35 UTC 
Description:
Al eliminar contenido seleccionado tipo de datos a borrar (backspace), no distingue las fechas y las considera como números, con lo cual es imposible borrar números sin eliminar fechas, y tampoco es posible eliminar solo fechas.


Steps to Reproduce:
1. Ingresar números y fechas
2. Seleccionar las celdas donde se encuentran los números.
3. Presionar backspace, e indicar solo Valores
4. Se eliminan no solo los números sino tamibén las fechas.

Si se quieren eliminar solo las fechas, seleccionandolas en el paso 3, no produce ningún efecto.

Actual Results:  
Se eliminan datos incorrectamente.

Expected Results:
Deberían eliminarse solo los datos seleccionados (solo números o fechas, según el ejemplo planteado)


Reproducible: Always

User Profile Reset: yes

Additional Info:


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:53.0) Gecko/20100101 Firefox/53.0
Comment 1 tommy27 2017-05-17 13:41:36 UTC 
please translate in english.
Comment 2 Dolespa 2017-05-17 16:28:40 UTC 
Sorry for the translation...

When deleting content by selecting data type to be deleted (backspace), does not distinguish dates and considers them as numbers, which makes it impossible to delete numbers without deleting dates, and it is not possible to delete only dates.


Steps to Reproduce:
1.Enter numbers and dates
2.Select the cells where the data is located.
3.Press backspace, and in the "Delete content" window, select only "Numbers".
4.By accepting, not only the numbers but also the dates are eliminated.

If you want to delete the dates only, selecting them in step 3 does not produce any effect.

Actual Results: 
Data is deleted incorrectly.

Expected Results:
Only the selected data should be deleted (only numbers or dates, depending on the example)

Reproducible: Always

User Profile Reset: yes
Comment 3 tommy27 2017-05-18 05:26:53 UTC 
I don't reproduce it under Win8.1x64 using LibO 5.3.2.2

I suggest you to upgrade to LibO 5.3.3.2 and tell if issue persists.
also try to reset the user profile: https://wiki.documentfoundation.org/UserProfile
Comment 4 Dolespa 2017-05-18 14:15:59 UTC 
Hi... I tried it in 5.3.3.2 and it is already solved.

Thank you!
Comment 5 tommy27 2017-05-18 17:18:43 UTC 
nice to hear that.
correct status is WORKSFORME since we don't know the exact committ that fixed it.