Bug 146099 - CALC Macro Basic - Link to external data not refreshed for doc loaded hidden
Summary: CALC Macro Basic - Link to external data not refreshed for doc loaded hidden
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
7.1.6.2 release
Hardware: All Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro
  Show dependency tree / graph
 
Reported: 2021-12-07 17:07 UTC by Hans-Werner
Modified: 2022-10-19 15:54 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
CSV.csv (11 bytes, text/csv)
2021-12-07 17:08 UTC, Hans-Werner 		Details
LinkToExternalData.bas (1.14 KB, text/plain)
2021-12-07 17:08 UTC, Hans-Werner 		Details
LinkToExternalData.bas (1.17 KB, text/plain)
2021-12-08 06:16 UTC, Hans-Werner 		Details
LinkToExternalData.bas (2.41 KB, text/plain)
2021-12-10 12:24 UTC, Hans-Werner 		Details
LinkToExternalData.bas (2.58 KB, text/plain)
2021-12-11 11:40 UTC, Hans-Werner 		Details
LinkToExternalData.bas (2.18 KB, text/plain)
2021-12-11 17:56 UTC, Hans-Werner 		Details
LinkToExternalData.bas (2.18 KB, text/plain)
2021-12-11 18:00 UTC, Hans-Werner 		Details
Show Obsolete (5) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Hans-Werner 2021-12-07 17:07:11 UTC 
Description:
"ODS.ods" linked to external data "CSV.csv". After modifing "CSV.csv" changes are to be seen in "ODS.ods", but "GotoEndOfUsedArea(False)" does not return new number of columns/rows.

Steps to Reproduce:
1.1 "CSV.csv" should first contain following 1 row: "0,1,2,3,4"
1.2 Link "ODS.ods" to external data "CSC.csv".  
1.3 Start macro "LinkToExternalData.bas".
1.4 Macro result: "Xmax=4 Ymax=0" - OKAY !

2.1 "CSV.csv" should second contain following 2 rows: "0,1,2,3,4,5"
2.2 Start macro "LinkToExternalData.bas".
2.3 Macro result: "Xmax=4 Ymax=0" - ERROR - Should be "Xmax=5 Ymax=1" !


Actual Results:
"GotoEndOfUsedArea(False)" returns same results for [1.X] and [2.X] (see above "Steps to Reproduce").

Expected Results:
"GotoEndOfUsedArea(False)" should return different results for [1.X] and [2.X] (see above "Steps to Reproduce").


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.8.1 (x64) / LibreOffice Community
Build ID: e1f30c802c3269a1d052614453f260e49458c82c
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL
Comment 1 Hans-Werner 2021-12-07 17:08:17 UTC 
Created attachment 176767 [details]
CSV.csv
Comment 2 Hans-Werner 2021-12-07 17:08:58 UTC 
Created attachment 176768 [details]
LinkToExternalData.bas
Comment 3 Hans-Werner 2021-12-08 06:16:35 UTC 
Created attachment 176786 [details]
LinkToExternalData.bas
Comment 4 Hans-Werner 2021-12-10 12:24:13 UTC 
Created attachment 176842 [details]
LinkToExternalData.bas
Comment 5 Hans-Werner 2021-12-11 11:40:21 UTC 
Created attachment 176863 [details]
LinkToExternalData.bas
Comment 6 Hans-Werner 2021-12-11 11:51:30 UTC 
Changed "Importance" to "enhancement".

If "Hidden" is set "True", the external link is not updated. Could it be possible to modify the CALC software the way, that the external link will be updated too when "Hidden" is set "True" ?

For details see Attachments.

The formerly inserted comments ("Description" up to "Reproducible") should be seen as obsolete.
Comment 7 Hans-Werner 2021-12-11 17:56:23 UTC 
Created attachment 176874 [details]
LinkToExternalData.bas
Comment 8 Hans-Werner 2021-12-11 18:00:49 UTC 
Created attachment 176875 [details]
LinkToExternalData.bas
Comment 9 Gerhard Weydt 2021-12-11 18:28:53 UTC 
I can confirm the behaviour in
Version: 7.2.1.2 (x64) / LibreOffice Community
Build ID: 87b77fad49947c1441b67c559c339af8f3517e22
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded