Re: [libreoffice-users] spreadsheet formulas stopped working

[Tom Davies]

Hi :)
Has the spreadsheet been converted to an MS format such as XlsX and
back again?  Perhaps more importantly has MS Office 2007 been used to
save the Ods file?  Microsoft's support for formats that can be used
by other programs is notoriously weak.
Regards from
Tom :)



On 15 December 2015 at 01:55, RodMyers1960  wrote:
> LibreOffice 5.0.3.2 (pcBSD/FreeBSD)
> LibreOffice 5.0.3.2 (LinuxMint)
>
>
> My spreadsheets formulas have suddenly stopped calculating as they have
> been.
>
> The formulas are to add/subtract money from a previous amount. Basically I'm
> using the spreadsheet as a check book.
>
> as seen in the attached file.
>
> if any monetary amount is changed, the corresponding balance(s) do not
> change.
>
> Any ideas what happened to the spreadsheet, and how to correct it?
>
> Thank you
>
> ledger-2015.ods
> 
>
>
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/spreadsheet-formulas-stopped-working-tp4169335.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? 
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] spreadsheet formulas stopped working

[Brian Barker]

At 11:38 15/12/2015 -0500, Rodney D. Myers wrote:

On Tue, 15 Dec 2015 03:26:27 + Brian Barker wrote:

At 21:01 14/12/2015 -0500, Rodney D. Myers wrote:
My spreadsheets formulas have suddenly stopped calculating as they 
have been. [...]


In order for calculations to be repeated automatically, you have to 
have Tools | Cell Content > | AutoCalculate toggled on.


That was the ticket. I have no recollection of changing this setting.
Thank you for pointing it out


Good-oh!

Incidentally, =SUM(F4;F27) makes sense, as does =F4+F27, but 
=SUM(F4+F27) doesn't: it tries to sum a single value - the result of 
already adding F4 and F27. How about SUM(3) instead of 3? Or 
SUM(SUM(3))? The same applies to =SUM(L25-N26) and =SUM(F29-L29). 
Drop the superfluous "SUM".


Brian Barker  



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] spreadsheet formulas stopped working

[Rodney D. Myers]

On Mon, 14 Dec 2015 21:01:44 -0500
"Rodney D. Myers"  wrote:

> https://mega.nz/#!jdtFjSyD

Thought I selected no key. 

here's the link to the key






-- 
Rodney D. Myers  - kg6anx

They that can give up essential liberty to obtain a
little temporary safety deserve neither liberty nor safety.
        Ben Franklin - 1759

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] spreadsheet formulas stopped working

[Tom Davies]

Hi :)
I think this is a duplicate thread and the duplicate has been
discussed quite comprehensively already, perhaps even solved or nearly
solved.  All good! :)
Regards from
Tom :)



On 15 December 2015 at 16:19, Tom Davies  wrote:
> Hi :)
> Has the spreadsheet been converted to an MS format such as XlsX and
> back again?  Perhaps more importantly has MS Office 2007 been used to
> save the Ods file?  Microsoft's support for formats that can be used
> by other programs is notoriously weak.
> Regards from
> Tom :)
>
>
>
> On 15 December 2015 at 01:55, RodMyers1960  wrote:
>> LibreOffice 5.0.3.2 (pcBSD/FreeBSD)
>> LibreOffice 5.0.3.2 (LinuxMint)
>>
>>
>> My spreadsheets formulas have suddenly stopped calculating as they have
>> been.
>>
>> The formulas are to add/subtract money from a previous amount. Basically I'm
>> using the spreadsheet as a check book.
>>
>> as seen in the attached file.
>>
>> if any monetary amount is changed, the corresponding balance(s) do not
>> change.
>>
>> Any ideas what happened to the spreadsheet, and how to correct it?
>>
>> Thank you
>>
>> ledger-2015.ods
>> 
>>
>>
>>
>> --
>> View this message in context: 
>> http://nabble.documentfoundation.org/spreadsheet-formulas-stopped-working-tp4169335.html
>> Sent from the Users mailing list archive at Nabble.com.
>>
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems? 
>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>> List archive: http://listarchives.libreoffice.org/global/users/
>> All messages sent to this list will be publicly archived and cannot be 
>> deleted
>>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] spreadsheet formulas stopped working

[Rodney D. Myers]

On Tue, 15 Dec 2015 17:19:37 +
Brian Barker  wrote:

> Good-oh!
> 
> Incidentally, =SUM(F4;F27) makes sense, as does =F4+F27, but 
> =SUM(F4+F27) doesn't: it tries to sum a single value - the result of 
> already adding F4 and F27. How about SUM(3) instead of 3? Or 
> SUM(SUM(3))? The same applies to =SUM(L25-N26) and =SUM(F29-L29). 
> Drop the superfluous "SUM".
> 
> Brian Barker  

Cool.

This spreadsheet is 4 years old, and from 3.*.* days.

I just clicked on the "sum" button to get the  cells to add/etc. I'll
look them over and attempt to clean up

-- 
Rodney D. Myers  - kg6anx

They that can give up essential liberty to obtain a
little temporary safety deserve neither liberty nor safety.
        Ben Franklin - 1759

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] spreadsheet formulas stopped working

[Brian Barker]

At 21:01 14/12/2015 -0500, Rodney D. Myers wrote:

LibreOffice 5.0.3.2 (pcBSD/FreeBSD)
LibreOffice 5.0.3.2 (LinuxMint)

My spreadsheets formulas have suddenly stopped calculating as they 
have been. The formulas are to add/subtract money from a previous 
amount. Basically I'm using the spreadsheet as a checkbook. if any 
monetary amount is changed, the corresponding balance(s) do not 
change. Any ideas what happened to the spreadsheet, and how to correct it?


In order for calculations to be repeated automatically, you have to 
have Tools | Cell Content > | AutoCalculate toggled on. If it is off, 
you can force recalculation at Tools | Cell Content > | Recalculate 
(or F9 - or Ctrl+Shift+F9 for Recalculate Hard).



see link below
https://mega.nz/#!jdtFjSyD


Er, thanks - but how are we to make use of this without its decryption key?

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] spreadsheet formulas stopped working

[RodMyers1960]

LibreOffice 5.0.3.2 (pcBSD/FreeBSD)
LibreOffice 5.0.3.2 (LinuxMint)


My spreadsheets formulas have suddenly stopped calculating as they have
been.

The formulas are to add/subtract money from a previous amount. Basically I'm
using the spreadsheet as a check book.

as seen in the attached file.

if any monetary amount is changed, the corresponding balance(s) do not
change.

Any ideas what happened to the spreadsheet, and how to correct it?

Thank you

ledger-2015.ods
  



--
View this message in context: 
http://nabble.documentfoundation.org/spreadsheet-formulas-stopped-working-tp4169335.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted