Bug 129609 - Checking display effects after the restore of an acceptable table file name
Summary: Checking display effects after the restore of an acceptable table file name
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
6.3.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2019-12-25 09:55 UTC by Markus Elfring
Modified: 2023-07-06 13:21 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Markus Elfring 2019-12-25 09:55:56 UTC
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:
Comment 1 BogdanB 2020-09-16 17:13:15 UTC
Hi, do you still reproduce this kind of problem?
Comment 2 Markus Elfring 2020-09-17 09:40:31 UTC
(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
Comment 3 BogdanB 2020-09-17 11:49:23 UTC
Can you create a screencast/video with the steps you folowed in order to easy our tests?...
Comment 4 Markus Elfring 2020-09-17 13:00:10 UTC
(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?
Comment 5 Markus Elfring 2020-09-19 06:36:48 UTC
How are the chances to achieve similar adjustments for data range selections also according to file names (or questionable paths) by macros?
Comment 6 Jean-Baptiste Faure 2022-01-27 22:31:47 UTC
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
Comment 7 Markus Elfring 2022-01-29 15:03:16 UTC
(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)?
Comment 8 Jean-Baptiste Faure 2022-01-29 15:56:51 UTC
(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
Comment 9 Xisco Faulí 2022-05-02 11:59:23 UTC
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.
Comment 10 Markus Elfring 2022-05-02 16:26:25 UTC
(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?
Comment 11 shqadbw 2023-07-06 13:21:25 UTC Comment hidden (spam)