https://bugs.documentfoundation.org/show_bug.cgi?id=164331
--- Comment #5 from andréb <[email protected]> --- (In reply to m_a_riosv from comment #4) > (In reply to andréb from comment #2) > > Of course it is a bug. > > > > If the format is nominally changed, it should change the format of the > > content. > There is only one format, cell visualization, the content has not format. > If a number, formated as a number, is changed to text format, then a space is added then removed, the content is changed, so the visual number is formated as text. This, on an invidual basis. This causes the content to correctly reflect the visualization and the format. Before adding & subtracting a space this was not the case. For certain formats, such as date, this manipulation does not work at all. So tell me. How is the wanted visualization (to use your turn of phase) for a change of format not supposed to reflected in the content ? For example. You enter text which is wrongly interpreted as a date. Visually it looks more or less like what you entered. You correct the format at text. The display becomes a strange number, not close ot what you entered, or what had been displayed before. How is that not a bug ? If it is only one field, that is awkward, but not too difficult to correct. If it is many fields, that becomes also difficult to correct. Remember that the content is just how the visual is stored. It is ultimately a series of zeros & ones, which usually we do not want to see. The format tells us how the visual should be stored, and later manipulated. We don't care how it is stored, as long as it correctly corresponds to the wanted format. Thus changing the nominal format should change how it is stored. If some function was wrongly implemented, for no matter how many years, it is still wrongly implemented. If you are a developer, you have the opportunity to correct a long-standing error. It will be much appreciated. -- You are receiving this mail because: You are the assignee for the bug.
