https://bugs.documentfoundation.org/show_bug.cgi?id=163847
Bug ID: 163847
Summary: Calc doesn't respect hidden columns when copying
Product: LibreOffice
Version: unspecified
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a sheet that references another sheet using formulas. The problem is
that if columns are hidden the formulas (formulae?) don't get copied. If the
columns are not hidden then they get copied.
This used to work but I'm not sure when it stopped working as I only perform
this operation occasionally.
Steps to Reproduce:
I have a sheet (with column headings) that uses formulas to access data on
another sheet.
E.g. D2 contains =$'raw data'G3 and
E2 contains =IF($'raw data'.B3="Various", "Various",CONCATENATE($'raw
data'.B3,$'raw data'.C3))
1. I delete all but row 1 (heading) and row 2 (first line of data)
2. I highlight row 2, cols A-G
3. I drag that down to populate a certain number of rows
4. This duplicates the formulas all the way down (as expected)
5. I hide columns D and E
6. I highlight row 2. cols A-G
7. I drag that down to populate a certain number of rows
8. I show columns D and E
9. Columns A-C and columns F-G contain data from the sheet shown in their
respective formulas
10.Columns D and E are blank, i.e. the formulas have not been copied down
Actual Results:
Formulas in hidden columns are not copied
Expected Results:
Formulas should be copied whether hidden or not
Reproducible: Always
User Profile Reset: No
Additional Info:
I'm only a simple user so didn't understand the bits about hardware but
my processor is i3-6100 running Windows 10 Home
--
You are receiving this mail because:
You are the assignee for the bug.
