Bug 88498

Summary:	function Countif external reference - value not cached
Product:	LibreOffice	Reporter:	raal <raal>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	medium	CC:	todventtu
Version:	3.5.0 release
Hardware:	Other
OS:	All
Whiteboard:
i915 platform:		i915 features:
Attachments:	test files

Description raal 2015-01-16 14:50:46 UTC

Created attachment 112349 [details]
test files

During creating tests for bug 40110 I've found error.

Steps to reproduce
 - unzip test files
 - open fdo40110test.ods
 - message refresh external data, choose yes
 - see all results = 1
  - save file
 - close; reopen
Warning – refresh external data


Actual results:
see ZERO 0 in last result	
after refresh value = YES -> result is correct -> 1	
after refresh value = NO -> result is incorrect -> 0 	

Expected reults:	
	value B4 should be 1; cached value

 Printscreens in bugfile

Comment 1 Beluga 2015-01-17 15:08:14 UTC

Already observed in 3.5.0, except it's B1 with 0 or 1.

Win 7 Pro 64-bit, LibO Version: 4.4.0.2
Build ID: a3603970151a6ae2596acd62b70112f4d376b99

Version: 4.5.0.0.alpha0+
Build ID: 5f6bdce0c0ac687f418821ce328f2987bf340cda
TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2015-01-17_01:06:46

Ubuntu 14.10 64-bit
LibreOffice 3.5.0rc3 
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.