[Libreoffice-bugs] [Bug 53269] New: FORMATTING: All formulas with a cell ref converted to Absolute. C57 becomes $C$57

[bugzilla-daemon at freedesktop.org]

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

             Bug #: 53269
           Summary: FORMATTING: All formulas with a cell ref converted to
                    Absolute. C57 becomes $C$57
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.5.5.3 release
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: jpspare at charter.net


Created attachment 65313
  --> https://bugs.freedesktop.org/attachment.cgi?id=65313
Weekly Budget Spreadsheet with formulas with cell references. No personal data.
Figures have been changed to preserve privacy.

Problem description: 

Steps to reproduce:
1. ....open an EXCEL v95 file.
2. ....All formulas with a cell ref converted to Absolute.
C57 becomes $C$57.
3. ....If I clear out the $'s and save it it looks good until I open it again.
All of the $'s are back again. I just noticed that the spreadsheet may have
chosen EXCEL v5 instead of v95.
I uninstalled LibreOffice and installed OpenOffice. Once the file is cleaned
up, saved and opened, no $'s. Please fix LibreOffice. I like it better than
OpenOffice

Current behavior:

Expected behavior:

Platform (if different from the browser): 
Win7 Professional 64 bit              
Browser: Mozilla/5.0 (Windows NT; WOW64; rv:12.0) Gecko/20100101 Firefox/12.0

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