https://bugs.freedesktop.org/show_bug.cgi?id=76411
Priority: medium
Bug ID: 76411
Assignee: [email protected]
Summary: FILEOPEN: Formula Results Incorrect (=0) on File
Re-Open
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.2.1 release
Component: Spreadsheet
Product: LibreOffice
(Note: the actual LO version I'm using is 4.2.2-2, installed on Arch Linux/xfce
with pacman -Syu yesterday, 3/19/2014.)
I opened a Calc file that has long been in use today and a particular set of
formulas displayed "zero" as their cell values. The spreadsheet is a collection
of my financial records with each line containing a transaction; the main sheet
(essentially general journal) has about 11,000 rows and 7 columns of data. The
errant formula, running throughout column G, contains:
=YEAR(C11058)&F11058
Column C contains a date; column F contains an account code. The result of the
formula should be text of the form "2014ent". While the formulas were all
correctly intact, each column G cell displayed a zero.
Further, and I don't know if this is a separate problem, another sheet (general
ledger) evaluates the cells from the journal sheet and puts SUMIF results on a
layout with accounts in rows and years in columns. Unfortunately, the cells on
this sheet have lost their references to the journal sheet. A typical formula
here now reads:
=SUMIF( $G$5:$G$13681,E$4&$B12, $E$5:$E$13681)
Note the presence of a space and the absence of a sheet name at the beginning
of the first and third parameters.
----------------
I have periodically had a similar problem in another, much simpler, spreadsheet
file. This one consists of a single sheet that produces a two-page paper
report. I have various text titling information in cells A1, A2, and A3 for the
first page and then I have formulas which reproduce that titling text for the
second page as follows:
A42: =A1
A43: =A2
A44: =A3
The past behavior, though sporadic, has shown the correct formula in the
page-two cells, but displayed zeroes. Just now though, the sheet shows the
correct text in A42, but shows blanks in A43 and A44.
----------------
In both of these spreadsheets I can display the values for the simple formulas
(=YEAR(C11058)&F11058 and =A1) by a hard recalculation with Ctrl-Shift-F9. This
does not, however, correct the sheet name deletion in the SUMIF formulas. This
hard-recalc solution was suggested on
http://ask.libreoffice.org/en/question/31185/after-updating-to-libre-office-4211-calc-stopped-performing-correctly/
I tried reproducing the problem in a new file, but am unable to. I am reluctant
to upload either of my two problem files for review since they both contain
private and sensitive data. I am happy to provide whatever other information I
can and test potential solutions. Please let me know what I can do to help
resolve this issue. Many thanks.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
