LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This 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

Reply
 
Search this Thread
Old 05-20-2013, 11:42 PM   #1
sharky
Member
 
Registered: Oct 2002
Posts: 396

Rep: Reputation: 37
Libre Office calc does not update


I have a simple formula in a cell:

Code:
=H11-D12-E12+F12+G12
If I input a number into, for example G12, then the cell containing the formula calculates and updates it's value.

However, if I delete the contents of G12 the value in the cell containing the formula does not update.

F9 does not recalculate it either.

If I input '0' in G12 then the cell will recalculate but it will not recalculate if the contents is deleted.

Looks like bug to me.
 
Old 05-21-2013, 01:23 AM   #2
evo2
Guru
 
Registered: Jan 2009
Location: Japan
Distribution: Mostly Debian and Scientific Linux
Posts: 5,432

Rep: Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192
Hi,

what do you think should be the value of the calculation if G12 is undefined? Are you expecting an error to be thrown?

Evo2.
 
Old 05-21-2013, 04:41 AM   #3
jdkaye
Senior Member
 
Registered: Dec 2008
Location: Westgate-on-Sea, Kent, UK
Distribution: Debian Testing Amd64
Posts: 4,771

Rep: Reputation: Disabled
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

Last edited by jdkaye; 05-21-2013 at 04:43 AM.
 
Old 05-21-2013, 01:12 PM   #4
sharky
Member
 
Registered: Oct 2002
Posts: 396

Original Poster
Rep: Reputation: 37
Quote:
Originally Posted by evo2 View Post
Hi,

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.
 
Old 05-21-2013, 06:52 PM   #5
timl
Member
 
Registered: Jan 2009
Location: Sydney, Australia
Distribution: Fedora,CentOS
Posts: 302

Rep: Reputation: 41
How do you delete G12?

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
 
Old 05-21-2013, 08:53 PM   #6
evo2
Guru
 
Registered: Jan 2009
Location: Japan
Distribution: Mostly Debian and Scientific Linux
Posts: 5,432

Rep: Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192
Hi,

Quote:
Originally Posted by sharky View Post
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?

Cheers,

Evo2.
 
Old 05-23-2013, 01:39 PM   #7
sharky
Member
 
Registered: Oct 2002
Posts: 396

Original Poster
Rep: Reputation: 37
Quote:
Originally Posted by timl View Post
How do you delete G12?

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 View Post
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?

Cheers,

Evo2.
More dangerous than having an incorrect value?
 
Old 05-23-2013, 07:25 PM   #8
evo2
Guru
 
Registered: Jan 2009
Location: Japan
Distribution: Mostly Debian and Scientific Linux
Posts: 5,432

Rep: Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192Reputation: 1192
Hi,
Quote:
Originally Posted by sharky View Post
More dangerous than having an incorrect value?
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.
 
Old 05-24-2013, 02:05 PM   #9
sharky
Member
 
Registered: Oct 2002
Posts: 396

Original Poster
Rep: Reputation: 37
Quote:
Originally Posted by evo2 View Post
Hi,

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.

Thanks for the feedback.

Last edited by sharky; 05-24-2013 at 02:09 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] where are macros stored in libre office calc 3.6.2+ knobby67 Linux - Software 3 04-25-2013 11:28 PM
Unoconv Convertor for RHEL 6 : Libre office & open office utility vishwajeet jagtap Linux - Software 0 02-15-2013 09:44 AM
Libre Office Calc, copy formular from one sheet to another knobby67 Linux - Software 1 11-14-2012 09:30 AM
[SOLVED] Libre Office Calc: I want to prevent changes to all but a few cells. damgar Linux - Software 2 07-09-2012 10:27 AM
LXer: Libre Office Initial plans for the free office suite [German] LXer Syndicated Linux News 2 11-14-2010 05:14 PM


All times are GMT -5. The time now is 01:32 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration