https://bugs.documentfoundation.org/show_bug.cgi?id=106060
Bug ID: 106060
Summary: Calc - Formula drag & Autofill - The values of the
filled formula cells include only first sheet values
Product: LibreOffice
Version: 5.2.5.1 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a calc file with about 180 sheets.
In a sheet called totals - I've used formulae to get the totals of the same
cell in sheet numbers 6 -175 .
The formula works fine/ displays properly in Calc 4.2.8 but in version 5.2.5 +
5.3.0.3 it doesn't work.
I've changed the options > calc > formulae Reference format Excel A1 as I'm
using the indirect funtion in the sheet as well.
For example - the formula reads - =sum('6'.c15:'175'.c15) - where first sheet
name is 6 and the last sheet name to get the values from is sheet 175. This
formula worked fine.
then I drag and autofill this for the column > the cell with the above formula
shows the value from sheet 6 cell c15 only & all of the autofilled cells show
the values from sheet 6 only . i.e. the values in cells on sheets 7 to sheets
175 are ignored and not added in.
I hope I've explained my problem clearly.
Steps to Reproduce:
1.I opened a new file and setup 4 sheets.
2.In sheet 2 cell a1 I entered 1 and dragged and autofilled up to 15.
3.I copied cell a1 to a15 from sheet 2 and pasted them in sheets 3 and 4.
4.I went to sheet 1 cell a1 and entered =sum( > clicked on sheet 2 cell a1 >
held shift and clicked on sheet 4 tab (to select all sheets from 2 to 4) >
clicked sheet 4 cell a1.
5.sheet 1 cell a1 showed 3 - the expected value
6.I dragged and autofilled sheet 1 cell a1 formula to sheet 1 cell a15
7.All values displayed correctly.
Hence, problem did not occur.
Then I
8.added another 172 sheets.
9.on sheet 2 I extended the values from cell a1 to a450 i.e. 1 to 450
10. I copied these to sheets 2 - 176.
11. I then ran the same sum formula in sheet 1 i.e. =sum(Sheet2!A1:Sheet176!A1)
and it only returned 1 as opposed to 175.
12.I dragged the formula down and had the same problem.
Actual Results:
As above
Expected Results:
the formula only fetched values from sheet 2 as opposed to giving the sum of
values in cell a1 of sheet 2 to sheet 176
Reproducible: Sometimes
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: StartModule
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Builds ID: LibreOffice 5.3.0.3
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:46.0) Gecko/20100101
Firefox/46.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
