Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

2016-05-11 Thread Cor Nouws
Hi, Piet van Oostrum wrote on 12-05-16 00:40: >> Now non-plussed how to tell libreoffice to tell it to treat them >> as 'real numbers' ? > > One way you can get numbers as text is when you import a CSV file, > This is another option:

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5

2016-05-11 Thread Brian Barker
At 16:03 11/05/2016 +, Shirish Agarwal wrote: I was trying a simple addition in column =SUM(B2:B8) but that didn't work. I am getting the output as zero. Could somebody look at it and share what is/was wrong? At 19:43 11/05/2016 +, Shirish Agarwal wrote: Dear Piet, Yours and a

Fwd: [libreoffice-users] Re: The Save Tool could not be dimmed

2016-05-11 Thread Taang Zomi
*The save tool could not be dimmed * I updated my LibreOffice for Windows, and I am using 5.1.2.2. Several days ago, I noticed that the SAVE tool could not be dimmed even when I saved something. I attempted to go to *Tools | Options | LibreOffice | General | Document Status |* *so that I could

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

2016-05-11 Thread Joe Conner
Also, format the column as numbers. That way when you enter a number it is recorded as such. If the column is formatted as text, and you input a number it is interpreted as a character. On 05/11/2016 03:40 PM, Piet van Oostrum wrote: shirish शिरीष wrote: > Dear Piet, > > Yours and a

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

2016-05-11 Thread Piet van Oostrum
shirish शिरीष wrote: > Dear Piet, > > Yours and a private mail are bang on target. Libreoffice thinks that > those 'numbers' are text. This I was able to find via View > Value > highlighting . > > Now non-plussed how to tell libreoffice to tell it to treat them as > 'real numbers' ?

RE: [libreoffice-users] Calc macro tutorial

2016-05-11 Thread toki
Dave Boland wrote: >I read the documentation, but it says user created macros are beyond the scope of the documentation. REALLY! Macros, as described in books such as _Six Sigma Statistics with Excel and Minitab_ by Issa Bass (ISBN 0-07-154268-X) or _Spreadsheet Modelling in Corporate Finance_

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

2016-05-11 Thread Cley Faye
2016-05-11 21:43 GMT+02:00 shirish शिरीष : > Now non-plussed how to tell libreoffice to tell it to treat them as > 'real numbers' ? > ​Short answer: it should work :) If a cell is somehow stuck in the "text" type, you could try clearing all formatting on this cell

Re: [libreoffice-users] Calc macro tutorial

2016-05-11 Thread Howard Barr
Tried the chat, wants to know what channel. What the heck is that? I wonder if you mean *IRC (live chat)* Join us on IRC at freenode.net . The #libreoffice channel is for user support and general discussion. (If you're a coder and want to get involved in

Re: [libreoffice-users] Calc macro tutorial

2016-05-11 Thread dave boland
On Wed, May 11, 2016, at 04:18 PM, Andrew Pitonyak wrote: > > For most users, the recorder is a decent solution. > > As for support, do not expect that from MS unless you have a credit > card. I found some bugs in their C++ compiler about 15 years ago. 5 to > 10 years later I thought for sure

Re: [libreoffice-users] Calc macro tutorial

2016-05-11 Thread Andrew Pitonyak
For most users, the recorder is a decent solution. As for support, do not expect that from MS unless you have a credit card. I found some bugs in their C++ compiler about 15 years ago. 5 to 10 years later I thought for sure they would have fixed them. Nope, I had to work around them yet

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

2016-05-11 Thread shirish शिरीष
at bottom :- On 11/05/2016, Piet van Oostrum wrote: > The mailing list doesn't accept attachments. You could use Nabble for that > (http://www.libreoffice.org/get-help/nabble/) > > The simplest explanation would be that your "numbers" are entered as text. > Check

Re: [libreoffice-users] Re: LO 5.0.5.2 writer freezes during save on Win 7

2016-05-11 Thread Bo Siltberg
Thank you for a very good answer. I'll wait for the 5.1.4 release then. 2016-05-11 14:36 GMT+02:00 V Stuart Foote : > @Bo, * > > Bo Siltberg wrote > > Sometimes during save, the progress bar freezes, mostly somewhere close > to > > the middle. Usually the saving

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

2016-05-11 Thread Bruce Hohl
Check cell formats and contents in B2:B8. SUM() will not add numbers within cells formatted as text or numbers preceded by a half quote. Per below the sum() result is 4 as such items are not summed. 4 '=SUM(B2:B8) 2 Cell number format with '2 (note the half quote) 3 Cell number format with '3

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

2016-05-11 Thread Piet van Oostrum
shirish शिरीष wrote: > Hi all, > > I was trying a simple addition in column =SUM(B2:B8) > > but that didn't work . I am getting the output as zero. > > Could somebody look at it and share what is/was wrong ? > > Sharing an example worksheet for the same. > -- The mailing list

[libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

2016-05-11 Thread shirish शिरीष
Hi all, I was trying a simple addition in column =SUM(B2:B8) but that didn't work . I am getting the output as zero. Could somebody look at it and share what is/was wrong ? Sharing an example worksheet for the same. -- Regards, Shirish Agarwal शिरीष अग्रवाल My quotes in

[libreoffice-users] ImageMagick RCE exploit "ImageTragick" CVE 2016-3714

2016-05-11 Thread V Stuart Foote
Not directly a LibreOffice issue--this is just a safe computing suggestion. Folks probably should update installed version of the ImageMagick image utilities. Affecting Linux/OS X/Windows flavors. Has been patched by ImageMagick for releases > 7.0.1-2 and > 6.9.4-0 so download and upgrade to

Re: [libreoffice-users] Calc macro tutorial

2016-05-11 Thread dave boland
Andrew, Thanks for the note.  I actually do software development (Java right now) and enjoy reading documentation (no, not crazy - I've been tested). But when I read a document called "Getting Started With Macros", I reasonably expect it to cover the basics of how to create a macro from scratch

[libreoffice-users] Re: LO 5.0.5.2 writer freezes during save on Win 7

2016-05-11 Thread V Stuart Foote
@Bo, * Bo Siltberg wrote > Sometimes during save, the progress bar freezes, mostly somewhere close to > the middle. Usually the saving continues after a few seconds but someones > LO freeze and never recover. The only way out is to kill the process. This > happens in win 7, not on win 10. The

[libreoffice-users] LO 5.0.5.2 writer freezes during save on Win 7

2016-05-11 Thread Bo Siltberg
Sometimes during save, the progress bar freezes, mostly somewhere close to the middle. Usually the saving continues after a few seconds but someones LO freeze and never recover. The only way out is to kill the process. This happens in win 7, not on win 10. The progress bar freeze on both systems,