[Libreoffice-bugs] [Bug 48785] New: FORMATTING: conditional format damaged, by adding sheet reference in fomula when file loaded

[bugzilla-daemon at freedesktop.org]

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

             Bug #: 48785
           Summary: FORMATTING: conditional format damaged, by adding
                    sheet reference in fomula when file loaded
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.5.2 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: giuliano.lotta at gmail.com


Created attachment 60096
  --> https://bugs.freedesktop.org/attachment.cgi?id=60096
original file, resaved (damaged) file, screenshot of cond formula after and
before saving.

Problem description: 
when RELOADED a good Excel file, cell reference in conditional receive sheet
reference, and formula get damaged (sheet reference is forbidden in excel
conditional format)
If saved with new added sheet reference, the file is no more correct for MS
Excel, and loose conditional formatting.  
The xls file is still readable (and correctly interpreted) by LO

The "sheet reference adding", is not present it the file is and ODS format (it
happens to be addend only if XLS)

The sheet reference si added also if copying a sheet form an xls file, to a new
one.


Steps to reproduce:
create a such file:
1. create a file xls with conditional format
2. save it, and close the file
3. reopen the xls file an look at the conditional formatting formula (the sheet
reference has been added)
4. save the file and it no longer will be usable in Ms Excel.
5. open in Ms Excel, and the conditional format is gone

Notice:

in the FIRST file save, the file  is correct, and Ms Excel reads it correctly.

WHEN REloaded once more and resaved, cell reference in conditional receive
sheet reference, and get damaged ( because sheet reference is forbidden in
excel conditional format). 


Current behavior:
LO shouldn’t add any sheet reference in the conditional format formula.

Expected behavior:
The conditional format formula should not be changed

Platform (if different from the browser): 

Browser: Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:11.0) Gecko/20100101
Firefox/11.0

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