Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
Sorry but I can't replicate your problem. As soon as I click on the green arrow after changing the value of G12, LO immediately updates the value of cell containing the formula.
I'm using LO version Version 4.0.3.3. So no bug that I can find.
jdk
what do you think should be the value of the calculation if G12 is undefined? Are you expecting an error to be thrown?
Evo2.
If I do the same thing in excel, that is, I delete the contents of G12, then the formula updates immediately with the value of G12 taken as 0. That is what I expected in calc. I was not expecting an error returned.
If I paste the formula back into the cell it re-calculates as if G12, which is empty, is 0. If I place a value in G12 it automatically recalculates. If I delete the contents of G12 the formula does not recalculate and it now contains an incorrect value.
If I press the delete key in G12 the formula field updates immediately
If I press Backspace in G12 I get a box with options. I simply hit enter, G12 becomes 0 and the formula field updates correctly
If I hit the space bar in G12 and then hit enter, G12 is blank and the formula field becomes #VALUE!
If I do the same thing in excel, that is, I delete the contents of G12, then the formula updates immediately with the value of G12 taken as 0.
Wow, that sounds like dangerous behaviour. But, if it that is what excel does, it could possibly be what calc is supposed to do. Is there any documentation for calc that states what the expected behaviour is?
If I press the delete key in G12 the formula field updates immediately
If I press Backspace in G12 I get a box with options. I simply hit enter, G12 becomes 0 and the formula field updates correctly
If I hit the space bar in G12 and then hit enter, G12 is blank and the formula field becomes #VALUE!
More information is required to research further
Cheers
I click on G12 and hit the delete key.
---------- Post added 05-23-13 at 11:40 AM ----------
Quote:
Originally Posted by evo2
Hi,
Wow, that sounds like dangerous behaviour. But, if it that is what excel does, it could possibly be what calc is supposed to do. Is there any documentation for calc that states what the expected behaviour is?
I would argue that variables being silently set to zero, does result in an incorrect value. No high level language that I've ever used does it that way. Use of an undefined variable should result in an error, not be silently ignored. But maybe that is one of the peculiarities of a spreadsheet as a high level language.
I would argue that variables being silently set to zero, does result in an incorrect value. No high level language that I've ever used does it that way. Use of an undefined variable should result in an error, not be silently ignored. But maybe that is one of the peculiarities of a spreadsheet as a high level language.
Cheers,
Evo2.
Understand where you're coming from but I don't think a spreadsheet should behave like a programming language. Variables can be set or assigned to cells and in that case there might be an issue if the contents is deleted. But that shouldn't be the case for the cell, only the variable - at least I've never seen a spreadsheet behave that way.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.