Created attachment 46061 [details]
excel 2007 ru
When you save an XLS garbles "improves" cell address
in excel Initially, it was: И=AND
opening in LibreOffice was: Лист=sheet
and after a save in XLS obtain in Excel:
But in LiberOffice same file is opened:
formatting will work, but trying to adjust Excel would be a mistake for the presence of names of sheets in a formula ...
sorry my excuse english...
Created attachment 46062 [details]
test file - after seving
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
The problem still exists.
Should in Ms Excel xls conditional formatting, sheet reference NEVER be used ?
Should this be the error xls exporting ?
The xls generated seems not to comply with Ms format
Ok. So I had a look at this one.
All tests done in master with my latest changes to the cond format handling.
Import of the file looks correct. The leading sheet name is not a problem because it is a relative sheet reference like in Excel.
The problem is that the export generates then absolute sheet references. I can't reproduce the other issue with master and Excel 2010.
I'll have a look at the cond format export and try to find the code that writes the absolute sheet refs instead of the relative ones.
*** This bug has been marked as a duplicate of bug 36379 ***