Bug 48763 - TABLE FORMATTING: (context menu) setting "Number recognition" should be possible for each individual cell
Summary: TABLE FORMATTING: (context menu) setting "Number recognition" should be possi...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsUXEval
Depends on:
Blocks: Writer-Tables-Enhancements Writer-Tables-Number-Recognition
  Show dependency treegraph
 
Reported: 2012-04-16 02:31 UTC by sasha.libreoffice
Modified: 2019-01-21 10:29 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description sasha.libreoffice 2012-04-16 02:31:27 UTC
When we right mouse click on table in Writer, there is option "Number recognition". It has some problem:

Currently "Number recognition" works globally. And when disabled, number format
of cell resets to "Text" when we delete content of cell and type another.
Expected: "Number recognition" can set individually for each table (otherwise
it should be "Global number recognition"). And when disabled it not changes
format of cells, just not recognize content.

Actually: "Number recognition" enables/disables globally. And changes format of
newly changed cells to "Text"

Reproduced in 3.3.4 and 3.5.2 on Fedora 64 bit
Comment 1 Harald Koester 2012-04-16 03:39:50 UTC
Hi Sasha,

as far as I tested the function, disabling of "Number recognition" does not change the number format of existing cells. Only if you change the content of a cell the number format is changed to "Text". And afterwords you can still assign new number formats to all cells.

The help text of the option "Number recognition" says: "If *Number recognition* is not marked, numbers are saved in text format and are automatically left-aligned."

The behaviour is not very transparent, but according to the description I think it is OK. So, to my opinion an individual "Number Recognition" is an enhancement, but not a bug. 

Harald
Comment 2 Rainer Bielefeld Retired 2012-05-02 23:25:28 UTC
Currently (parallel installation of Master "LOdev 3.6.0alpha0+  – WIN7 Home Premium (64bit) ENGLISH UI [Build ID: 52348aa]" (tinderbox: Win-x86@6-fast, pull time 2012-04-27 21:25:23)) context menu shows and changes setting in menu 'Tools -> Options -> LibO WRITER -> Table - Input in Table - Number Recognition'. Indeed, it would be nice to have that for each individual cell. But IMHO we need some more definitions for such an enhancement (What setting with priority to what other one, how can we recognize cells with individual setting, ...). 
Without that additional research this request can not be fulfilled. May be ux-advise knows more? I will ask.

The current limitation has been inherited from OOo.
Comment 3 Joel Madero 2013-07-02 04:49:50 UTC
It is a valid request - marking as NEW - also requesting input from ux.

@UX team - once you guys come up with a plan here (or close as wontfix) please set component back to writer. Thanks!
Comment 4 Joel Madero 2013-07-02 04:50:25 UTC
Astron - sorry I added you instead of mailing list - you mind registering mailing list on FDO so I can make it default cc?
Comment 5 UX-advise List 2013-07-04 14:31:54 UTC
Joel: go ahead :)
Comment 6 mahfiaz 2015-04-08 22:24:29 UTC
I couldn't reproduce it in 4.3.3, to me everything works as expected. Is this still a problem?
Comment 7 Cor Nouws 2015-04-11 14:07:35 UTC
Hi mahfiaz,

(In reply to mahfiaz from comment #6)
> I couldn't reproduce it in 4.3.3, to me everything works as expected. Is
> this still a problem?

Can you please explain what you tested?
As fas as I can see, number recognition is a global setting for Writer. SO not per document, not per table, not per cell.
See Tools > Options > Writer > Table ..
Comment 8 mahfiaz 2015-04-11 18:20:00 UTC
Cor, I made a table, set the number type for a few cells, inserted a number, deleted contents and wrote another number back. The cell preserved it's properties.

It loses the properties if you enter text (e.g end your number with enter which creates a newline, make a mistake and enter a number and a space or something similar), so it can only contain a number or be blank for the properties to be preserved. It is picky, but it somewhat works.

So I think improvement to make the cell preserve its numeric properties over containing some text (as it happens in Calc) would help (especially annoying with typing accidents like 0,3 vs 0.3 or "23,4 ", note the space).

As for LO to also store the properties as global, it's mostly useful feature, but IMO not a bug and works as expected.
Comment 9 Cor Nouws 2015-04-11 20:19:39 UTC
@mahfiaz,

thanks for your explanation. But isn't that more at place for e.g. tdf#49419
Comment 10 Robinson Tryon (qubit) 2016-08-25 05:26:51 UTC Comment hidden (obsolete)
Comment 11 Cor Nouws 2017-12-29 21:26:54 UTC
(In reply to mahfiaz from comment #8)

> So I think improvement to make the cell preserve its numeric properties over
> containing some text (as it happens in Calc) would help (especially annoying
> with typing accidents like 0,3 vs 0.3 or "23,4 ", note the space).

I agree to that.
Would make the issue of sacha.libreoffice mostly disappear?
Mind to make a new issue for that?