https://bugs.documentfoundation.org/show_bug.cgi?id=146099
Bug ID: 146099
Summary: Macro Basic - CALC - Link To External Data -
GotoEndOfUsedArea(False) not updating
Product: LibreOffice
Version: 7.1.6.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
