Bug 63848 - Better default formatting after user editing of a cell
Summary: Better default formatting after user editing of a cell
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) rc
Hardware: Other All
: medium major
Assignee: Not Assigned
Depends on:
Blocks: Number-Format Calc-UX
  Show dependency treegraph
Reported: 2013-04-23 16:43 UTC by Michael Meeks
Modified: 2021-05-04 22:10 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:

small test sheet. (8.11 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-04-23 16:46 UTC, Michael Meeks

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Meeks 2013-04-23 16:43:22 UTC
I load the attached sheet;

delete the cell =A2 (it's text formatted and we don't want that).
select A2:A10 or so
ctrl-1 -> select 'number general'
   + notice it is already formatted this way: though it has diverse formatting in the range.
'ok' the dialog.

Notice A2 is still formatted as text.

It should be number formatted; that -really- got me just now.

I'd love to know if it's a regression in 4.0

I assume it is all down to what we stick into the SfxItemSet for a diverse set of number formats.
Comment 1 Michael Meeks 2013-04-23 16:45:23 UTC
if it is a regression AOO 3.4.1 has it too which narrows the field.
Comment 2 Michael Meeks 2013-04-23 16:46:22 UTC
Created attachment 78380 [details]
small test sheet.
Comment 3 QA Administrators 2015-03-04 02:21:37 UTC Comment hidden (obsolete)
Comment 4 Buovjaga 2015-03-23 12:28:24 UTC

Win 7 Pro 64-bit, LibO Version:
Build ID: 45e2de17089c24a1fa810c8f975a7171ba4cd432
Locale: fi_FI
Comment 5 tommy27 2016-04-16 07:27:00 UTC Comment hidden (obsolete)
Comment 6 Michael Meeks 2016-04-18 08:38:33 UTC
I guess I should be less idle and re-test this with an older version ;-) in lieu of that - this persists in master ... =)
Comment 7 QA Administrators 2017-05-22 13:23:25 UTC Comment hidden (obsolete)
Comment 8 Thomas Lendo 2019-01-05 18:18:51 UTC
Still reproducible.

Build-ID: be8897d9c63a77b223a9c0aed1d2eb689e0e0082
CPU-Threads: 4; BS: Linux 4.15; UI-Render: Standard; VCL: gtk3; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-01-02_04:49:04
Comment 9 QA Administrators 2021-01-05 03:47:41 UTC Comment hidden (obsolete)
Comment 10 Thomas Lendo 2021-05-04 22:10:49 UTC
Still reproducible.

Version: / LibreOffice Community
Build ID: 8ae3ae4bf75fdd0aaa132c956d9da029baa3adc6
CPU threads: 2; OS: Linux 5.8; UI render: default; VCL: gtk3
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-04-23_17:13:02