Bug 88498 - function Countif external reference - value not cached
Summary: function Countif external reference - value not cached
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.5.0 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-01-16 14:50 UTC by raal
Modified: 2015-01-17 15:08 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:

Attachments
test files (75.65 KB, application/zip)
2015-01-16 14:50 UTC, raal 		Details
View All

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.