Re: [libreoffice-users] spreadsheet formulas stopped working
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
On Tue, 15 Dec 2015 03:26:27 + Brian Barker wrote: > 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 That was the ticket. I have no recollection of changing this setting. Thank you for pointing it out -- 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
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 <https://mega.nz/#!jdtFjSyD!_pwnxXuhSHJVz5tqRR2FAi2LGcs2RkGvboZYUGmzEB4> -- 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
[libreoffice-users] spreadsheet formulas stopped working
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. see link below 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 https://mega.nz/#!jdtFjSyD -- 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
[libreoffice-users] DDE link works wierd, at least to me
Linux Mint 13 LibreOffice 4.0 When linking cells within one spreadsheet, to another spreadsheet, all within the same folder. I am getting this error message, after I press the "this file contains links to other files. Should they be updated?"; "The following DDE source could not be updated possibly because the source document was not open. Please launch the source document and try again. Source : file:Legion-Post2-Ledger-BLDG-2013.ods Element : June_2013.F31 Type : soffice" Why should I have the secondary spreadsheet open. This makes no sense to me. -- Rodney D. Myers 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] Opening this Word document crashes LO rc2, opens ok in OOo
On 1/3/11 3:32 PM, Mark wrote: > When I tried to open the document I posted at > http://zentektales.com/EvenStaffRecruitment.doc, it crashed LO (I'm running > 3.3.0 rc 2), but it opened ok in OOo 3.2.1. > > (By crashed, I mean it caused all my open LO windows to disappear) > Using a mac, and LO 3.3.0 rc2, and it opens for me -- Rodney D. Myers AIM#:YAHOO: mailman452 mailman42_5 They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. Ben Franklin - 1759 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Survey: Usage of LibreOffice components
Writer = 90% Calc = 09% Impress = 00% Draw = 00% Base = 01% Math = 00% -- Rodney D. Myers AIM#:YAHOO: mailman452 mailman42_5 They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. Ben Franklin - 1759 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: JRE not found on Mac
On 11/22/10 6:29 AM, Rodney D. Myers wrote: > On 11/21/10 10:22 PM, Alexander Thurgood wrote: >> > Hi Rodney, >> > >> > >> > Le 21/11/10 22:53, Rodney D. Myers a écrit : >>>> >> > The intel platform. I did the sym-link before, but it caused WAY MORE >>>> >> > issues than it fixed, so it was removed. >>>> >> > >>>> >> > Any hints about the release of beta 3? >>>> >> > >> > Well, I am using the beta 3 at the moment, and it picked up the version >> > of Java no problem. > Weird. Intel os x 10.6.5, LO 3.3.0, 000330m1 (Build:1), > libreoffice-build 3.2.99.2 > > Java does not appear > Got it working. Downloaded the java update, and re-ran it manually. Java is now found -- Rodney D. Myers AIM#:YAHOO: mailman452 mailman42_5 They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. Ben Franklin - 1759 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: JRE not found on Mac
On 11/21/10 10:22 PM, Alexander Thurgood wrote: > Hi Rodney, > > > Le 21/11/10 22:53, Rodney D. Myers a écrit : >> > The intel platform. I did the sym-link before, but it caused WAY MORE >> > issues than it fixed, so it was removed. >> > >> > Any hints about the release of beta 3? >> > > Well, I am using the beta 3 at the moment, and it picked up the version > of Java no problem. Weird. Intel os x 10.6.5, LO 3.3.0, 000330m1 (Build:1), libreoffice-build 3.2.99.2 Java does not appear -- Rodney D. Myers AIM#:YAHOO: mailman452 mailman42_5 They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. Ben Franklin - 1759 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: JRE not found on Mac
On 11/21/10 4:23 PM, Alexander Thurgood wrote: > Hi Rodney, > > Le 21/11/10 15:05, Rodney D. Myers a écrit : > >> >> Did that twice, to make sure I did it correctly. >> >> Still no java showing up. >> > > > I hope you didn't do the symbolic linking thing that was suggested prior > to the patched files being made available. > > Additionally, the beta 3 version of LibO integrates the upstream fix > provided by OOo so it should just work again with the beta 3. > > BTW, you don't say which Mac platform you're on ? The intel platform. I did the sym-link before, but it caused WAY MORE issues than it fixed, so it was removed. Any hints about the release of beta 3? -- Rodney D. Myers AIM#:YAHOO: mailman452 mailman42_5 They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. Ben Franklin - 1759 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: JRE not found on Mac
On 11/16/10 3:03 AM, Alexander Thurgood wrote: > Le 15/11/10 11:02, Alexander Thurgood a écrit : > > P.S. The files in question can be found here : > > ftp://qa-upload.services.openoffice.org/jl162/ > > with an explanation of the problem, and its solution, here : > > http://wiki.services.openoffice.org/wiki/Documentation/FAQ/Platform/Mac_OS_X_10.6 Did that twice, to make sure I did it correctly. Still no java showing up. -- Rodney D. Myers AIM#:YAHOO: mailman452 mailman42_5 They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. Ben Franklin - 1759 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***