Hello! When using LO (v4.3 or 4.4) Calc and graphing data, the **source format** is auto-checked (when it was not previously on pre-existing spreadsheets using LO v4.2) on the Y-Axis. When this is unchecked and 1234.1 is selected, everything graphs properly on Y-Axis. When the spreadsheet is saved, closed, and then reopened, the Y-Axis defaults again to Source Format 1234. This only occurs in LO v4.3 and 4.4 versions. When using LO 4.2 or previous, I don't have that issue. Has something changed in the new versions that I need to change somewhere else, or is this a bug? I am using a 13" MBP retina on OSX 10.9.5 In advance, many thanks for your time! :-) Sam
@Sam : please provide us with a test document and step by step instructions to attempt to reproduce the problem. I have no idea, for example, where this "Source format" tickbox appears, as I don't use Calc very often. Setting to NEEDINFO pending requested information, please set back to unconfirmed once you have provided it.
Created attachment 114473 [details] [Bug 90352] Calc error when graphing data with source format Hi Alex. Thanks for response. Attached is a copy of LO 4.4.1 with a sample of calc doc. Basically, on the “Y” Axis, you click it to be able to access the settings. That’s where the Source Format box is. Additionally, the problem appears to be only when the document is saved .xls format. If I save it .odt, it seems to work fine. I just discovered that in preparing to send over this document to you. I will send under separate copy the screenshots. Couldn't figure out how to send multiple attachments I hope this is helpful. Many thanks! Sam
Created attachment 114474 [details] [Bug 90352] Calc error when graphing data with source format Screenshot
Reproducible with LO 4.4.1.2, Win 8.1 Steps Done: 1. Open the attached xls file 2. Make a double left mouse click on the graph "Good Nights vs. Fatigue" 3. Make a double left mouse click on the Y-axis 4. Go to the tab NUMBERS and deselect "Source format" 5. Select in the section Format "1234.1" and press OK Interim Result: Number format is changed to X.0 6. Go to FILE -> SAVE AS and save the file as a xls file and close it 7. Reopen the saved file Result: The number format is not kept and changed back to X instead of X.0.
Confirming also on Version: 4.4.1.2 Build ID: 45e2de17089c24a1fa810c8f975a7171ba4cd432 Locale : fr_
Not a blocker though, don't even know if this is a regression yet.
Regression confirmed over Version: 4.1.4.2 Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72 When I open the XLS file in that version, the Source format is not ticked.
Confirming on Version: 4.4.2.2 Build ID: c4c7d32d0d49397cad38d62472b0bc8acff48dd6 Locale: fr_ with IT langpack The IT langpack doesn't show any hunspell dictionary as being installed, only the OSX dictionary
A workaround seems to be to delete the user profile and re-install the langpack, but this is represents an unplanned configuration change between point releases, so probably not acceptable (if I have understood the principle correctly)
(In reply to Alex Thurgood from comment #9) > A workaround seems to be to delete the user profile and re-install the > langpack, but this is represents an unplanned configuration change between > point releases, so probably not acceptable (if I have understood the > principle correctly) Arrgh, forget those last two comments, wrong bug !!
This began at the below commit. commit 1d38cb365543924f9c50014e6b2227e77de1d0c9 Author: Kohei Yoshida <kohei.yoshida@collabora.com> Date: Fri Jun 13 11:12:50 2014 -0400 fdo#71076, fdo#71767: Preserve number formats when charts are copied. Change-Id: If5ae8852152012483237e7602e56a0c46ea8748a
Migrating Whiteboard tags to Keywords: (bibisected) [NinjaEdit]
*** Bug 92719 has been marked as a duplicate of this bug. ***
(In reply to Xisco Faulí from comment #13) > *** Bug 92719 has been marked as a duplicate of this bug. *** No, it isn't. Bug 92719 could only be reproduced with *.xls-Documents, not with *.ods. Bug 92719 is a bug, witch appears in the charts of a report (created Writer-document) and has has something to do with wrong interpreting of the source-format. A date appears instead of a number.
Adding Cc: to Kohei Yoshida
Dennis Francis committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d8e731adb8608aab17385e02f4441ed3122efa40 tdf#90352: set/handle LinkNumberFormatToSource property in xls... It will be available in 6.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Dennis Francis committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=adf049390cceb11df6ba438f30138d6f92d13b41&h=libreoffice-5-4 tdf#90352: set/handle LinkNumberFormatToSource property in xls... It will be available in 5.4.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.