Bug 89301 - No price calculation due Err:509
Summary: No price calculation due Err:509
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.0.1 rc
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-02-10 23:22 UTC by Eugene Savitsky
Modified: 2015-02-11 12:10 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
problem file (733.74 KB, application/zip)
2015-02-10 23:22 UTC, Eugene Savitsky
Details
Screenshot (225.14 KB, image/png)
2015-02-11 11:35 UTC, Eugene Savitsky
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Eugene Savitsky 2015-02-10 23:22:00 UTC
Created attachment 113300 [details]
problem file

1. Open the file in LO.
2. Look at columns L and M.

Result: Err:509


In Excel there is a price present - works fine.
Comment 1 Eugene Savitsky 2015-02-10 23:27:11 UTC
Dup of https://bugs.documentfoundation.org/show_bug.cgi?id=45833 ?
Comment 2 raal 2015-02-11 07:09:53 UTC
I can not confirm with Version: 4.5.0.0.alpha0+
Build ID: 40432ac6caa478474d73786f95b808c14e106ff2
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-02-03_01:24:42

I can not confirm with Version: 4.5.0.0.alpha0+
Build ID: 1845b6af3991ca5521eef48aafe1d0489e2ff8f6
TinderBox: Win-x86@42, Branch:master, Time: 2015-02-02_09:30:48

I can not confirm with Version: 4.4.0.3
ID build: de093506bcdc5fafd9023ee680b8c60e3e0645d7

Columns L and M have results.

Please try with version 4.4.0.3, setting as needinfo.
Comment 3 Eugene Savitsky 2015-02-11 11:34:16 UTC
On other computer the same. See screenshot attached. Columns L and M.
Comment 4 Eugene Savitsky 2015-02-11 11:35:06 UTC
Created attachment 113307 [details]
Screenshot

screenshot of a problem. LO 4.4.0.2
Comment 5 raal 2015-02-11 11:55:32 UTC
(In reply to Eugene Savitsky from comment #4)
> Created attachment 113307 [details]
> Screenshot
> 
> screenshot of a problem. LO 4.4.0.2

Hello,
it's a bad screenshot. Actual version is 4.4.0.3 /  do you have actual version? http://www.libreoffice.org/download/libreoffice-fresh/

What is your operating system?
Comment 6 raal 2015-02-11 12:02:04 UTC
in column L is formula leading to another file
='file:///tmp/Расчет HP 2014-12-04-02 (PP14091, кухня - Väike-Kaare 9, Евгений Савицкий).xlsx'#$сводная.L10

To confirm a bug please attach this file "Расчет HP 2014-12-04-02 (PP14091, кухня - Väike-Kaare 9, Евгений Савицкий).xlsx". I see cached values only because this file doesn't exist on my computer..
Comment 7 Eugene Savitsky 2015-02-11 12:07:16 UTC
OK, with 4.4.0.3 it WFM indeed. Tnx.
Comment 8 raal 2015-02-11 12:10:53 UTC
Closing as WFM