[Libreoffice-bugs] [Bug 40389] New: Re-formatting as text fails if previously contained apparently valid cell reference

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=40389

           Summary: Re-formatting as text fails if previously contained
                    apparently valid cell reference
           Product: LibreOffice
           Version: LibO 3.3.2 release
          Platform: Other
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: andr55 at laposte.net


If a cell is formatted as text, all values subsequently entered are treated as
text.  (Expected behavior)
If a cell is formatted as a number (explicitly or by default), and text
beginning with "=" is entered, it will be interpreted as a cell reference if
that would be a valid cell reference format.
If one then re-formats it as text, it continues to be interpreted as a cell
reference, instead of text.

Expected behavior :
If a cell is re-formatted as text, it will be accepted as literal text, and
never interpreted as a cell reference.

To produce:
1. Enter any value in A1
2. Ensure that A2 is formatted as numeric (explicitly or by default)
3. Enter "=A1" in A2.
4. A2 displays contents of A1.
5. Re-format A2 as text.
6. A2 still displays contents of A1.  It should display "=A1".

Note that this bug also existed in Openoffice 3.2.1 (and probably before).

(Operating system is Linux on PC hardware, but that should be unrelated.)

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.