https://bugs.documentfoundation.org/show_bug.cgi?id=94284
Luke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Hardware|x86-64 (AMD64) |All OS|Mac OS X (All) |All --- Comment #8 from Luke <[email protected]> --- There are a couple of issues here. First of all Excel does not have an exact 1-to-1 match for Axis crosses at "Start" and "End". Instead Excel has "Automatic" and "Maximum Axis Value". End seems to match closely to "Maximum Axis Value". However Start does not. For example when I created a scatter chart in Calc, set to start, exported it to XLSX, and opened it in Excel, Excel correctly displayed the chart with axis crosses at "Automatic" AND a value of -1.5(this is greyed out). When I saved as XLS, Excel gave the following warning: "This file contained features which were not recognized by this version of Excel. These features will not be saved. The resulting chart crossed at 0, not 1.5 when opened in Excel. Exactly like Calc does when it exports this chart. The difference is Excel sets it to automatic while calc sets it to 0. But the end result is the same. The good news is End appears to be the same as "Maximum Axis Value" and the binary format does support both "Automatic" and "Maximum Axis Value". The exporter should be using these parameters instead of 0. I'll attach examples to be analyzed with a tool like oledump. Ilya, For future reference, below is what you should have included in your original Description along with a sample document. This is how to write a good bug report. The steps to reproduce are: 1. Create a XY (Scatter) 2. Edit the chart 3. Format axis -> Positioning -> Axis Line -> Cross other axis at -> Select Start or Finish 4. Save as XLS 5. Close and reopen Expected results: Axis remains at start or finish Actual results: Axis set to value=0 -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
