Description: I have tried the provided functionality out again together with the software combination “LibreOffice Calc 6.3.3.2-865.16”. Steps to Reproduce: 1. I can create a simple chart in an empty document based on a test table from an external file. The display is fine then. 2. I modify a single character in the corresponding path for the data range so that such a file should not be found. https://help.libreoffice.org/6.3/en-GB/text/schart/01/wiz_data_range.html The display became empty then. 3. I restored the previous file name. Actual Results: I observe that the display is still empty for the chart object. Expected Results: I would like to see the diagram from my first test step again. Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info:
Hi, do you still reproduce this kind of problem?
(In reply to BogdanB from comment #1) I can reproduce questionable software behaviour also with components for the application “LibreOffice Calc 7.0.1.2-951.10”. Can any more users get into the mood to share their experiences with adjustments for data ranges in external files? https://help.libreoffice.org/7.0/en-GB/text/scalc/guide/cellreferences.html#hd_id9209570
Can you create a screencast/video with the steps you folowed in order to easy our tests?...
(In reply to BogdanB from comment #3) Would you like to specify different file names (or questionable paths) for the data range selection according to charts as I described for my bug report?
How are the chances to achieve similar adjustments for data range selections also according to file names (or questionable paths) by macros?
Please, could you provide an archive containing the file with the chart and the external file with the data. Status has been set to NEEDINFO, please set it back to UNCONFIRMED once requested information has been provided. Best regards. JBF
(In reply to Jean-Baptiste Faure from comment #6) Please check the software behaviour once more according to my initial description. https://bugs.documentfoundation.org/show_bug.cgi?id=129609#c0 I imagine that a concrete file example is not so relevant here. Is it more important to achieve a consistent error repair for file names (or questionable paths)?
(In reply to Markus Elfring from comment #7) > (In reply to Jean-Baptiste Faure from comment #6) > Please check the software behaviour once more according to my initial > description. > https://bugs.documentfoundation.org/show_bug.cgi?id=129609#c0 > > I imagine that a concrete file example is not so relevant here. Ok, imagine, if you want. JBF
Thanks for reporting this issue. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
(In reply to Xisco Faulí from comment #9) I have tried the provided functionality out again together with the software combination “LibreOffice Calc 7.3.3.1-2.1”. I can specify a data range like “'file:///home/altes_Heim2/elfring/Projekte/LibreOffice/Test-20200113.ods'#$Test1.$A$1:$C$3” for another chart example. See also the documentation section “To Reference a Cell in Another Document”. https://help.libreoffice.org/7.3/en-GB/text/scalc/guide/cellreferences.html#hd_id9209570 The specified file name (or path) can intentionally be adjusted then so that the external file will not be found (for a moment). I observed that the cell reference was automatically reduced to a single row. Thus it seems that a typo in the file path has got the need to fix also a questionable cell reference. How do you think about any more software adjustments for similar test cases?
It is possible to intentionally modify the file name or path in such a way that the external file cannot be located temporarily. I noticed that the cell reference automatically changed to a single row. This indicates that there might be a typo in the file path that needs to be corrected, along with addressing the questionable cell reference. visit https://www.budgetingenterprise.com/