https://bugs.documentfoundation.org/show_bug.cgi?id=139910
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |NEW Resolution|INSUFFICIENTDATA |--- --- Comment #13 from ady <[email protected]> --- Although I am not the original reporter, I believe this bug is still present in current versions of LO (7.4 – 7.6.alpha). STR: 1. Create 3 worksheets with space characters in their respective names. 2. In the last 2 worksheets, introduce some number in their respective cells A1. 3. Use a 3D formula in "$'Sheet 1'.A1" such as: =SUM($'Sheet 2'.A1:$'Sheet 3'.A1) (note the space characters in the names of the worksheets, and the use of "$" for absolute references for worksheets). 4. Save as ods. 5. Save as xls (97-2003) and close. 6. Open the ods file and save it as xlsx (2007-365). 7. Compare the results of the formulas: ods and xls > =SUM($'Sheet 2'.A1:$'Sheet 3'.A1) xlsx > =SUM('sheet 2':$'Sheet 3'.A1:A1) Note that 'sheet 2' lacks the "$". 8. On Recalculate Hard, the xlsx file will show the #NAME? error instead of the 3D formula. The other 2 files work as expected, and the values in the respective A1 cells can be updated and the formula will be updated; not so for the xlsx file. IOW, the export filter to xlsx is not producing the correct 3D formula. Considering that others have reproduced this behavior in the past too, I am setting this to NEW. -- You are receiving this mail because: You are the assignee for the bug.
