https://bugs.documentfoundation.org/show_bug.cgi?id=155435
Bug ID: 155435
Summary: Duplicating sheet containing COUNTIF references to
ranges in external files damages formula
Product: LibreOffice
Version: 7.4.6.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Copy of complex sheet A from source spreadsheet, which contains datapoints, to
a new spreadsheet using Paste-All succeeds. Call this new sheet A'
In the new spreadsheet, clicking on the new pasted sheet A' nametag offers an
option to duplicate the sheet. The duplicated sheet fails to refer to the
source spreadsheet data correctly, making calculations fail.
The issue seems to be data ranges not being duplicated correctly, with
unnecessary 'file:' references which confuses a range statement.
Copying works using: enter sheet A', select top-left All cell and Ctrl-C.
Create new sheet. Select cell A1 and Paste-All.
No corruption occurrs and the source data is accessed correctly.
Example of the good A' cell formula content, which correctly accesses the
remote data in 'long filename':
=COUNTIFS('file:///C:/NEngDRoot/_Threepwood/Proj-01 BESS/Tranche_2_May_23/BESS
Analysis 202305 Tranch2-v1.ods'#$'BESS
Data'.AZ8:AZ17527,">="&E10,'file:///C:/NEngDRoot/_Threepwood/Proj-01
BESS/Tranche_2_May_23/BESS Analysis 202305 Tranch2-v1.ods'#$'BESS
Data'.AZ8:AZ17527,"<"&F10)
"Duplicate sheet" tab option mangles this formula as follows:
=COUNTIFS('file:///C:/NEngDRoot/_Threepwood/Proj-01 BESS/Tranche_2_May_23/BESS
Analysis 202305 Tranch2-v1.ods'#$'BESS
Data'.AZ8:'file:///C:/NEngDRoot/_Threepwood/Proj-01 BESS/Tranche_2_May_23/BESS
Analysis 202305
Tranch2-v1.ods'#$BESS1.AZ17527,">="&E10,'file:///C:/NEngDRoot/_Threepwood/Proj-01
BESS/Tranche_2_May_23/BESS Analysis 202305 Tranch2-v1.ods'#$'BESS
Data'.AZ8:'file:///C:/NEngDRoot/_Threepwood/Proj-01 BESS/Tranche_2_May_23/BESS
Analysis 202305 Tranch2-v1.ods'#$BESS1.AZ17527,"<"&F10)
The duplicate is much longer and instead of using the good datarange:
'long filename'#$'BESS Data'.AZ8:AZ17527
we now have the failing:
'long filename'#$'BESS Data'.AZ8:'long filename'#$BESS1.AZ17527
Where did the "BESS1" come from??
The data in here is confidential and consists of numerous columns of 17,520
deep datapoints; files are large.
--
You are receiving this mail because:
You are the assignee for the bug.
