You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/05/28 17:49:17 UTC
[Bug 122399] New: Can't calculate formula
https://issues.apache.org/ooo/show_bug.cgi?id=122399
Bug ID: 122399
Issue Type: DEFECT
Summary: Can't calculate formula
Product: Calc
Version: AOO400-dev
Hardware: PC
OS: Windows 8
Status: UNCONFIRMED
Severity: critical
Priority: P3
Component: viewing
Assignee: issues@openoffice.apache.org
Reporter: endriusk@interia.pl
CC: issues@openoffice.apache.org
Created attachment 80740
--> https://issues.apache.org/ooo/attachment.cgi?id=80740&action=edit
Can't calculate formula in column M
AOO can't calculate this formula:
=L6-(-4~3)
Why?
For example MSO and LO calculate this formula.
Look on column M in attached file.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122399] Can't calculate formula
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122399
--- Comment #8 from Andrzej <en...@interia.pl> ---
Hello Rob
1. I attached screen shot from MSO 2010, LO and AOO.
"It would help if you can find out what "4~3" represents." - I don't know what
means, but if MSO 2010 open this file as "repairs mode" maybe AOO should be
open this file in "repairs mode"?
What you fink about this?
2. The question from the different border cell. Rob I new to formating border
cell use settings center borders, but in AOO I don't find him. Look et MSO
2003, 2007, 2010 or 2013 then you understand me. In MSO formating cell border
he is more intuitive. Please correct this.
3. If I using my file long time in AOO then the AOO slows down then- hi is like
the mud -it's very difficult.
I want only help for you to cerate very good office, so don't be angry to me.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122399] Can't calculate formula
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122399
--- Comment #3 from Andrzej <en...@interia.pl> ---
Hallo Rob
Thanks for your help.
I get file from my friend, and I cut section from him in LO and save as xlsx.
That is why you probably can not unlock him in MSO 2013. So now I attached
original file "measure.xlsx". Try open him.
"What does ~ mean in your spreadsheet? What operator is it?" - I don't know
why he use "~" instead of "," but if I open this file "measure.xlsx" on LO all
is right.
On the margin: Do you use MSO 2013? Why? You don't like AOO? I am disappointed.
;-(
I greet
PS: Sorry for my English. I don't know him, but try all explain.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122399] Can't calculate formula
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122399
--- Comment #2 from Andrzej <en...@interia.pl> ---
Created attachment 80741
--> https://issues.apache.org/ooo/attachment.cgi?id=80741&action=edit
oryginal file
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122399] Can't calculate formula
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122399
--- Comment #4 from Rob Weir <ro...@apache.org> ---
Measure.xslx gives me an error in Excel 2013 also. So something is wrong in
the original file.
Also, the same formula, entered into a new Excel spreadsheet also gives an
error.
I don't know what LO is doing here, but whatever it is, it is not compatible
with Excel or OpenOffice.
It would help if you can find out what "4~3" represents.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122399] Can't calculate formula
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122399
--- Comment #5 from Andrzej <en...@interia.pl> ---
Created attachment 80753
--> https://issues.apache.org/ooo/attachment.cgi?id=80753&action=edit
AOO4.0-bulid_1487177
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122399] Can't calculate formula
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122399
Rob Weir <ro...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #9 from Rob Weir <ro...@apache.org> ---
So in your Excel 2010 image it shows that Excel stripped the formula. So I
think the formula is not valid. There could be a bug also in LO that it is not
reporting the bad formula.
For other questions on borders, etc., please post to the community support
forums here:
http://forum.openoffice.org/
We want to use Bugzilla for bug reports only.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122399] Can't calculate formula
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122399
--- Comment #7 from Andrzej <en...@interia.pl> ---
Created attachment 80755
--> https://issues.apache.org/ooo/attachment.cgi?id=80755&action=edit
LO4.0.3
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122399] Can't calculate formula
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122399
Rob Weir <ro...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needmoreinfo
--- Comment #1 from Rob Weir <ro...@apache.org> ---
Your sheet gives me an error when loaded into Excel 2013. I'm prompted to
repair the sheet and when I do the formulas are lost.
In OpenOffice the tilde is the reference concatenation operator, used to
express complex (not contiguous) ranges. See:
http://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Creating_formulas
Something like "=L6-(-4~3)" is treated as a syntax error in OpenOffice.
If I enter the same formula into Excel 2013 it is also treated as an error.
Could this be a localization error, where you are using the ~ on your keyboard
to express a basic spreadsheet operator? What does ~ mean in your spreadsheet?
What operator is it?
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122399] Can't calculate formula
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122399
--- Comment #6 from Andrzej <en...@interia.pl> ---
Created attachment 80754
--> https://issues.apache.org/ooo/attachment.cgi?id=80754&action=edit
EXCEL2010
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.