https://bugs.documentfoundation.org/show_bug.cgi?id=37755
--- Comment #26 from ady <[email protected]> --- (In reply to gui from comment #25) > functional until version 3.3 or so. > > That's why I marked it as a (old ':) regression. Actually, in my tests, LO 3.3 behaves the same as current LO 26.2. OTOH, the old OOo 3.3 and current AOO behave as you want (almost); or at least I am not able to replicate the desired behavior in LO 3.3, but I do in OOo and AOO. Please keep in mind that, by default, even OOo 3.3 and AOO still aligns the cell to the right, just as LO Calc does, because the cell is still formatted as a Number; it is not really Text. So, in case of using the custom format as you want it and with your desired behavior, you would still need to align the cell to the left (as "real" Text would). This is another reason to use a General/Standard cell with "real" text in it and use the TEXT() function. So, technically, from the strict POV of LO (without considering its "predecessors"), this might not be considered as a regression (as LO Calc never worked in a different way than it is working now, or at least I am not able to replicate your desired result in LO 3.3, but I do in OOo and AOO). Having said that, IMHO the current behavior is correct, and using the TEXT() function is also the correct way to deal with this situation. If you have a Dependent cell that requires the actual numeric value, you still have the original (numeric) cell in which the actual (numeric) value is stored. FWIW, I myself use the Custom "Number" Format with some text (either to show the text in addition to the number, or even instead of it), but I only use it when the number _has_ to be stored in such cell (only, and only in that cell) and there is no other cell with that number, so any Dependent cell will take the number while the cell shows the "hard coded" text. If I can avoid this situation, I do (by using the TEXT() function). -- You are receiving this mail because: You are the assignee for the bug.
