It is described that a cell can be referenced from another document for a formula. I have tried out to specify a file name also for a data range on the page “Chart wizard: 2. Data ranges”. But it seems that this specification is not accepted so far. (The background colour became red in the text field “Data range”.) How do you think about to retrieve required data from external files here (instead of putting diagrams only into the same document of the data source)?
Please see https://ask.libreoffice.org/en/question/169195/external-data-in-calc/
(In reply to Xisco Faulí from comment #1) I suggest to take another look for the direct support of external data by the chart wizard.
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone else confirms it.
This enhancement has been in UNCONFIRMED status for a while, moving it to NEW... Note to the reporter: Changing the status to NEW doesn't mean the enhancement is going to be implemented. In order to do so, either you implement it yourself, you find someone to do it for you or you get professional support < https://www.libreoffice.org/get-help/professional-support/ >
Charts are created based on data in the spreadsheet. And there you can insert external data (https://wiki.documentfoundation.org/Faq/Calc/113).
(In reply to Heiko Tietze from comment #5) > Charts are created based on data in the spreadsheet. And there you can > insert external data I suggest to change this software limitation.
Eike, any chance to unleash the power of external data? I believe it makes not much sense and will be a source of confusion to have variable data in charts only but not in the spreadsheet.
*** Bug 121982 has been marked as a duplicate of this bug. ***
Setting back to Unconfirmed instead of Reopened until Eike is commenting. See https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/REOPENED
Actually that should already had worked. Taking.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/354b29ace32b19a1b40e46612349b8d76f00c0c6 Resolves: tdf#122011 fix ValidExternal() check It will be available in 6.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/80168 for 6-3
(In reply to Commit Notification from comment #11) I am surprised that a tiny change for the condition check “… mnTab >= -1” should fix this software situation. (In reply to Eike Rathke from comment #12) Will the duplicate mark for the topic “Support for database items as data source in charts” (Bug 121982) be also reconsidered once more?
(In reply to Markus Elfring from comment #13) > I am surprised that a tiny change for the condition check “… mnTab >= -1” > should fix this software situation. Sometimes two tiny bits can make a huge difference.. > Will the duplicate mark for the topic “Support for database items as data > source in charts” (Bug 121982) be also reconsidered once more? Done.
(In reply to Eike Rathke from comment #14) Thanks for your constructive feedback. I am curious if it will trigger any more desirable software improvements.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/commit/58367241f53ffca86c933f1cec506f05513b6a4f Resolves: tdf#122011 fix ValidExternal() check It will be available in 6.3.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
(In reply to Commit Notification from comment #16) I have tried the provided functionality out again together with the software combination “LibreOffice Calc 6.3.3.1-861.1”. Related software behaviour can be improved further then. * I can copy an inappropriate test URL into the data range selection for the chart wizard. It can happen that I get notified by a modal message dialogue (without a title) about the non-existing path several times. I find the notification approach annoying then. * I can copy also an acceptable test URL into the input field. I would appreciate further assistance in the selection for desired file names.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/bcdb92870bdfe6f44b0d571ded756ba59fe09b87 tdf#122011: sc: Add UItest It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.