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

[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:
http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates

Kind regards,
Cor

-- 
Cor Nouws
GPD key ID: 0xB13480A6 - 591A 30A7 36A0 CE3C 3D28  A038 E49D 7365 B134 80A6
- vrijwilliger http://nl.libreoffice.org
- volunteer http://www.libreoffice.org
- The Document Foundation Membership Committee Member

-- 
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] Simple sum in column getting zero in libreoffice calc 5

[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 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'?


The example spreadsheet you sent me privately betrays the problem. 
You are entering numbers using the style of the Indian numbering 
system - where digits are grouped in twos except for the rightmost 
three - instead of the system used in most regions of the world - 
where digits are grouped in threes throughout. In that system, large 
numbers are entered as, say, 1,23,45,678 instead of 12,345,678. If 
you don't have your language or locale set appropriately, LibreOffice 
will not recognise your entry as being a number and will instead 
preserve your exact input as a text string.


It is very easy to solve this problem: you simply need to tell 
LibreOffice that you are entering numbers in the Indian fashion. You 
can do this most easily by setting your locale correctly in 
LibreOffice (or perhaps even in your operating system before you 
install LibreOffice). Go to Tools | Options... | Language Settings | 
Languages | Language of | Locale setting, and choose an appropriate 
value there. If you have that set to English (India), Gujarati, 
Hindi, etc., you should find that Calc will accept numbers entered 
with comma separation in the Indian style.


Alternatively, if you don't wish to set your locale to an Indian one, 
you can set Indian style for number acceptance by formatting cells 
appropriately before entering values. On the Numbers tab of the 
Format Cells dialogue, there is a language selection drop-down menu 
at the top right. If you select an Indian language there, you can 
enter your values with comma separation in the Indian style.


Note that changing your locale will not automatically convert any 
existing values. You can convert them using the VALUE() function, 
providing that you have first set your locale or the cell format to 
an appropriate Indian option. Alternatively, you can simply retype any values.


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

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

[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 uncheck *


* | Allow to save document even when the document is not modified|*


*I  did not find *

*| Allow to save document even when the document is not modified|*
but I found

*| Printing sets "document modified" status | * checked


I unchecked it, but I found that nothing changed.

How can I dim the SAVE tool when I save something?

-- Forwarded message --
From: Taang Zomi 
Date: Thu, Mar 5, 2015 at 8:21 PM
Subject: Fwd: [libreoffice-users] Re: The Save Tool could not be dimmed
To: "LibreOffice, users" , Brian Barker <
b.m.bar...@btinternet.com>, tony...@mac.com, Tom Davies 
Cc: Taang Zomi , Thudik Zomi <
thudikz...@gmail.com>, Pau Thang 



The Save Tool could not be dimmed


*Thank you.*


*I followed your advice:*

*Tools | Options | LibreOffice | General | Document Status |*

*and then I unclicked | Allow to save document even when the document is
not modified|*




-- Forwarded message --
From: Taang Zomi 
Date: Thu, Mar 5, 2015 at 8:21 PM
Subject: Fwd: [libreoffice-users] Re: The Save Tool could not be dimmed
To: "LibreOffice, users" , Brian Barker <
b.m.bar...@btinternet.com>, tony...@mac.com, Tom Davies 
Cc: Taang Zomi , Thudik Zomi <
thudikz...@gmail.com>, Pau Thang 



The Save Tool could not be dimmed


*Thank you.*


*I followed your advice:*

*Tools | Options | LibreOffice | General | Document Status |*


*and then I unclicked | Allow to save document even when the document is
not modified|*

*Thank you, Tony, Brian and Tom, for your help.*


*Taang Zomi*


-- Forwarded message --
From: tonybsa 
Date: Sat, Feb 21, 2015 at 11:22 PM
Subject: Re: [libreoffice-users] Re: Styles and Formatting Not Working
To: Taang Zomi 
Cc: LibreOffice users , Brian Barker <
b.m.bar...@btinternet.com>



On 22/02/2015, at 12:37, Taang Zomi  wrote:

Just a suggestion with the Save button appearing not to dim after saving.
Do you have
"Allow to save document even when the document is not modified"
selected under the LibreOffice > General Options?

This sometimes means that the save button does not dim as you can still
save again.

Just a thought




Tony Bray
tony...@mac.com
MacBook Pro 15 inch Mid 2009
2.8 GHz Intel Core 2 Duo, 4 GB RAM,
Mac OS X  10.9.5.
LibreOffice 4.2.6.3

Ubuntu 14.04, LibreOffice 4.3.? Acer 15 inch laptop, 4 GB RAM

-- 
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] Simple sum in column getting zero in libreoffice calc 5.

[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 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' ?

One way you can get numbers as text is when you import a CSV file, and forget 
to merk the column as numbers. Or when you paste from plain text and forget the 
same.

One way to get them as numbers is to add a function in another column, 
containing
=NUMBERVALUE(B2)
if the first number is in cell B2.
Then copy this down for all numbers in the original column. Now you have a copy of your numbers, and they 
are really formatted as numbers. Now Copy this column with Edit > Copy and do a Edit > Paste 
Special over the original "text numbers", selecting only "Numbers".


--
Blessings, Joe Conner
Joshua 24:15 "...as for me and my house, we will serve the LORD."


--
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] Simple sum in column getting zero in libreoffice calc 5.

[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' ?

One way you can get numbers as text is when you import a CSV file, and forget 
to merk the column as numbers. Or when you paste from plain text and forget the 
same.

One way to get them as numbers is to add a function in another column, 
containing 
=NUMBERVALUE(B2)
if the first number is in cell B2.
Then copy this down for all numbers in the original column. Now you have a copy 
of your numbers, and they are really formatted as numbers. Now Copy this column 
with Edit > Copy and do a Edit > Paste Special over the original "text 
numbers", selecting only "Numbers".
-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
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] Calc macro tutorial

[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_ by Craig W Holden, is a somewhat specialized topic.

With LibO, one can legitimately treat books such as _Automated Data
Collection with R_ by Simon Munzert et al (ISBN 9781118834817) as the
extended documentation for LibO, precisely  because one can use R as the
preferred macro language for LibO.

On second thoughts, Munzert's book isn't an appropriate example, because
it is about web scraping.  On the gripping hand, extensions such as SMF
are, for all practical purposes, webscrapers.

Point is, with LibO, if you think that APL is the perfect macro
programming language, go for it.

>  What the heck is the documentation for then?

For people to learn what functionality is available.

Should the documentation team be creating the LibreOffice equivalent of
_Credit Risk Modeling using Excel_ by Gunter Loeffler, or _Quantitative
Models for Performance Evaluastions and Benchmarking_ by Joe Zhu?

Or would it be more suitable for the team to leave an individual or
organization to pursue the goal of "Transform finance education to be
based on LibreOffice"?
(Slogan is a deliberate misquote of Craig Holden's organization
SpreadSheet Modelling.
(Now wondering if he'd put an individual who created all of the
spreadsheets in _Excel Modelling in Corporate Finance_ using
LibreOffice, on his Honour Roll.))


jonathon

-- 
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] Simple sum in column getting zero in libreoffice calc 5.

[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 (defaults to Ctrl-M), or select the affected cells,
do right-click/properties, then select an appropriate number format.
However, LibreOffice should recognize number automatically unless
explicitely instructed to treat them as text; this can happen from weird
copy/paste, when opening files in exotic formats, or by doing it by hand.
It is also possible (although we didn't see a sample file) that there are
extra characters in the cells, or maybe an invalid decimal separator for
the file's locale.

​If you could upload a sample somewhere, we might get a better look at it
:)​

-- 
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] Calc macro tutorial

[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
development , join #libreoffice-dev
.)

Howard.

-- 
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] Calc macro tutorial

[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 they would have fixed them. Nope, I
> had to work around them yet again. It had to do with their streaming
> classes. There was a failure when the  boundary was split by a
> buffer read for some built-in text reading routines. Not like I could
> just call MS and get support.
 
I agree that their support also has issues, but the good thing is the
number of printed resources available.  Did I mention I like to read
documentation?
 
A number of years ago I completed a very large VB6 project.  A month
later MS announced the end of VB as we knew it.  That is when I decided
to go with open source where ever possible.  I still feel that way, but
sometimes it just does not work out.
 
> For sure they have a better object layer for manipulating documents.
> Not even close. I have never looked at their Macro programming
> resources, but, if possible, be certain to use the .NET classes since
> VBA is still littered with bugs. Last time I wrote a VBA application,
> half my code was related to working around bugs in their language
> implementation. These bugs initially existed in OpenOffice.org, but
> were fixed years ago; for example, bugs related to determining an
> arrays size in certain circumstances. I had to write special routines
> to deal with these issues. Moving to the .NET versions made things
> really nice, however, with full access to the .NET container classes.
> If you have no particular need to run where MSO is not supported, not
> a bad move. Good luck on your project.
>
> On 11.05.2016 08:42, dave boland wrote:
>> 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 - like I would with a VB program (did that for 6
>> years).  I was disappointed to see that it was about using the macro
>> recorder, which will not work for me.
>>
>> I get that the authors are volunteers, and that generally the do a
>> fantastic job.  However, in this area, not so much.
>>
>> I've decided that in the short term Calc (and Base) will not fit my
>> needs (documentation, support concerns) and will move the data to
>> Excel/Access.  Not what I wan to do, and not what LO community should
>> like, but it seems like the best course of action for this project.
>>
>> Dave,
>>
>> On Tue, May 10, 2016, at 02:19 PM, Andrew Pitonyak wrote:
>>> Dave, I am copying you directly since I do not know if the email
>>> client I am currently using will copy to the list; sorry about that,
>>> but I thought you might like my response faster than several hours
>>> from now when I am using my standard email client.
>>> On 10.05.2016 13:52, dave boland wrote:
 I want to automate a Calc spreadsheet to do some data analysis. I
 need some help finding a complete tutorial on Calc macros. Looking
 for something like the books published for Excell.
>>> Not familiar with them
 I read the documentation, but it says user created macros are
 beyond the scope of the documentation. REALLY! What the heck is the
 documentation for then?
>>> Done by volunteers and the documentation at which you looked was
>>> beyond their scope.
>>> http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1
>>> Chapter 12 specifically says “Macros”
>>> http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch12-calc-macros/view
>>> Chapter 13 contains numerous macro tutorials and examples (well, it
>>> did when I wrote the first draft some years back)
>>> http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch13-calc-as-simple-database/view
>>> Or, try here: http://www.pitonyak.org/oo.php This site contains
>>> numerous documents. You might want to look at these two documents.
>>> The first is a book and the second is more of a list of macros that
>>> accomplish certain tasks. It is kind of a roughly sorted brain dump.
>>> http://www.pitonyak.org/OOME_3_0.odt
>>> http://www.pitonyak.org/AndrewMacro.odt
 Tried the chat, wants to know what channel. What the heck is that?
>>> No idea.
 Tried the web version of this mail group, but it would not accept
 the catcha code.
>>> Hate those!
 I'm growing frustrated and very angry.
>>> Wait until you try to write macros. I mean, ummm, sorry you are
>>> frustrated and angry.
>>> LO Macros are very powerful in that they directly use the internal
>>> object structure and it is easy to add support for other languages.
>>> The disadvantage is that it has a steep learning curve, 

Re: [libreoffice-users] Calc macro tutorial

[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 again. It had to do with their streaming classes. There was a
failure when the  boundary was split by a buffer read for some
built-in text reading routines. Not like I could just call MS and get
support. 

For sure they have a better object layer for manipulating
documents. Not even close. I have never looked at their Macro
programming resources, but, if possible, be certain to use the .NET
classes since VBA is still littered with bugs. Last time I wrote a VBA
application, half my code was related to working around bugs in their
language implementation. These bugs initially existed in OpenOffice.org,
but were fixed years ago; for example, bugs related to determining an
arrays size in certain circumstances. I had to write special routines to
deal with these issues. Moving to the .NET versions made things really
nice, however, with full access to the .NET container classes. 

If you
have no particular need to run where MSO is not supported, not a bad
move. Good luck on your project. 

On 11.05.2016 08:42, dave boland
wrote: 

> 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 - like I would with a VB program (did
that for 6 years). I was disappointed to see that it was about using the
macro recorder, which will not work for me. 
> 
> I get that the authors
are volunteers, and that generally the do a fantastic job. However, in
this area, not so much. 
> 
> I've decided that in the short term Calc
(and Base) will not fit my needs (documentation, support concerns) and
will move the data to Excel/Access. Not what I wan to do, and not what
LO community should like, but it seems like the best course of action
for this project. 
> 
> Dave, 
> 
> On Tue, May 10, 2016, at 02:19 PM,
Andrew Pitonyak wrote: 
> 
>> Dave, I am copying you directly since I do
not know if the email client I am currently using will copy to the list;
sorry about that, but I thought you might like my response faster than
several hours from now when I am using my standard email client. 
>> 
>>
On 10.05.2016 13:52, dave boland wrote: 
>> 
>>> I want to automate a
Calc spreadsheet to do some data analysis. I need some help finding a
complete tutorial on Calc macros. Looking for something like the books
published for Excell.
>> 
>> Not familiar with them 
>> 
>>> I read the
documentation, but it says user created macros are beyond the scope of
the documentation. REALLY! What the heck is the documentation for
then?
>> 
>> Done by volunteers and the documentation at which you
looked was beyond their scope. 
>> 
>>
http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1
[1] 
>> 
>> Chapter 12 specifically says "Macros"
http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch12-calc-macros/view
[2] 
>> 
>> Chapter 13 contains numerous macro tutorials and examples
(well, it did when I wrote the first draft some years back)
http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch13-calc-as-simple-database/view
[3] 
>> 
>> Or, try here: http://www.pitonyak.org/oo.php [4] This site
contains numerous documents. You might want to look at these two
documents. The first is a book and the second is more of a list of
macros that accomplish certain tasks. It is kind of a roughly sorted
brain dump. 
>> 
>> http://www.pitonyak.org/OOME_3_0.odt [5]
http://www.pitonyak.org/AndrewMacro.odt [6] 
>> 
>> Tri
>> 
>>> ote
type="cite" style="padding-left:5px; border-left:#1010ff 2px solid;
margi
>> idth:100%"> 
>> 
>> Tried the web version of this mail group,
but it would not accept the catcha code. 
>> 
>> Hate those!
> 
> -- 
>
dave boland 
> dbola...@fastmail.fm 
> 
> -- 
> http://www.fastmail.com
- Access all of your messages and folders
> wherever you are




Links:
--
[1]
http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1
[2]
http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch12-calc-macros/view
[3]
http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch13-calc-as-simple-database/view
[4]
http://www.pitonyak.org/oo.php
[5]
http://www.pitonyak.org/OOME_3_0.odt
[6]
http://www.pitonyak.org/AndrewMacro.odt

-- 
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: 

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

[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 your cell format.
> --
> Piet van Oostrum 
> WWW: http://pietvanoostrum.com/
> PGP key: [8DAE142BE17999C4]
>

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' ?

-- 
  Regards,
  Shirish Agarwal  शिरीष अग्रवाल
  My quotes in this email licensed under CC 3.0
http://creativecommons.org/licenses/by-nc/3.0/
http://flossexperiences.wordpress.com
EB80 462B 08E1 A0DE A73A  2C2F 9F3D C7A4 E1C4 D2D8

-- 
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] Re: LO 5.0.5.2 writer freezes during save on Win 7

[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 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,
> > it is only in win 7 it sometimes does not continue.
> >
> > Looks like it helps to "warm up" the system, do a small change, save, do
> > another small change and save. If no hanging so far, then the following
> > saves in this session usually works.
> >
> > The document is large, more than 900 pages, so it usually takes some 30
> > seconds to save when it works.
> >
> > Anyone know how to track this down? Do the "usual support action" to
> > delete
> > my profile??
>
> That seems the same issue of  tdf#93553
>    which has
> been
> fixed, on master and for the 5.1.4 release. But will not likely be back
> ported to the 5.0 branch.
>
> You can check to see if it works better for you with a parallel /A admin
> install  of a current build of master or the daily build of the 5.1.4
> branch. Or upgrade to 5.1.4 when released mid-June.
>
> Stuart
>
> =-ref-=
> https://wiki.documentfoundation.org/Installing_in_parallel
> https://wiki.documentfoundation.org/ReleasePlan
>
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/LO-5-0-5-2-writer-freezes-during-save-on-Win-7-tp4183263p4183286.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] Simple sum in column getting zero in libreoffice calc 5.

[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  (note the half quote)
5 Cell formatted as text.
1 Cell number format with 1
1 Cell number format with 1
1 Cell number format with 1
1 Cell number format with 1


On Wed, May 11, 2016 at 12:03 PM, 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.
> --
>   Regards,
>   Shirish Agarwal  शिरीष अग्रवाल
>   My quotes in this email licensed under CC 3.0
> http://creativecommons.org/licenses/by-nc/3.0/
> http://flossexperiences.wordpress.com
> EB80 462B 08E1 A0DE A73A  2C2F 9F3D C7A4 E1C4 D2D8
>
> --
> 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] Simple sum in column getting zero in libreoffice calc 5.

[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 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 your cell format.
-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
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] Simple sum in column getting zero in libreoffice calc 5.

[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 this email licensed under CC 3.0
http://creativecommons.org/licenses/by-nc/3.0/
http://flossexperiences.wordpress.com
EB80 462B 08E1 A0DE A73A  2C2F 9F3D C7A4 E1C4 D2D8

-- 
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] ImageMagick RCE exploit "ImageTragick" CVE 2016-3714

[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  a current
build. Available from the project site
http://www.imagemagick.org/script/index.php   (or check for package support
for your distro).

LibreOffice does not install it, rather makes use of ImageMagick when
present as a helper for a number of image filter/conversion actions. 

Stuart

=-ref-=
https://www.cve.mitre.org/cgi-bin/cvename.cgi?name=2016-3714

https://www.imagemagick.org/discourse-server/viewtopic.php?f=4=29588%29

https://rhn.redhat.com/errata/RHSA-2016-0726.html




--
View this message in context: 
http://nabble.documentfoundation.org/ImageMagick-RCE-exploit-ImageTragick-CVE-2016-3714-tp4183302.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

Re: [libreoffice-users] Calc macro tutorial

[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 - like I would with a VB program (did that for 6 years).  I was
disappointed to see that it was about using the macro recorder, which
will not work for me.
 
I get that the authors are volunteers, and that generally the do a
fantastic job.  However, in this area, not so much.
 
I've decided that in the short term Calc (and Base) will not fit my
needs (documentation, support concerns) and will move the data to
Excel/Access.  Not what I wan to do, and not what LO community should
like, but it seems like the best course of action for this project.
 
Dave,
 
On Tue, May 10, 2016, at 02:19 PM, Andrew Pitonyak wrote:
> Dave, I am copying you directly since I do not know if the email
> client I am currently using will copy to the list; sorry about that,
> but I thought you might like my response faster than several hours
> from now when I am using my standard email client.
> On 10.05.2016 13:52, dave boland wrote:
>> I want to automate a Calc spreadsheet to do some data analysis. I
>> need some help finding a complete tutorial on Calc macros. Looking
>> for something like the books published for Excell.
> Not familiar with them
>> I read the documentation, but it says user created macros are beyond
>> the scope of the documentation. REALLY! What the heck is the
>> documentation for then?
> Done by volunteers and the documentation at which you looked was
> beyond their scope.
> http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1
> Chapter 12 specifically says “Macros”
> http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch12-calc-macros/view
> Chapter 13 contains numerous macro tutorials and examples (well, it
> did when I wrote the first draft some years back)
> http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch13-calc-as-simple-database/view
> Or, try here: http://www.pitonyak.org/oo.php This site contains
> numerous documents. You might want to look at these two documents. The
> first is a book and the second is more of a list of macros that
> accomplish certain tasks. It is kind of a roughly sorted brain dump.
> http://www.pitonyak.org/OOME_3_0.odt
> http://www.pitonyak.org/AndrewMacro.odt
>> Tried the chat, wants to know what channel. What the heck is that?
> No idea.
>> Tried the web version of this mail group, but it would not accept the
>> catcha code.
> Hate those!
>> I'm growing frustrated and very angry.
> Wait until you try to write macros. I mean, ummm, sorry you are
> frustrated and angry.
> LO Macros are very powerful in that they directly use the internal
> object structure and it is easy to add support for other languages.
> The disadvantage is that it has a steep learning curve, especially if
> you do not already understand software development. I usually
> recommend that people begin with an example that is close to what they
> need. The general language structure is essentially identical, but,
> for the most part, document manipulation methods is very different.
>> This is supposed to be user support?
> It is community support. You did not pay for the product and the
> people who will now try to help you are all volunteers; they do it
> because they like to help people as part of a community.
> If you do not care for email type support, be sure to check out
> this forum
> https://forum.openoffice.org/en
> They have some very competent Macro people hanging out in the
> macro forums.
> Best of luck!

>>  Dave, -- dave boland dbola...@fastmail.fm
> Andrew Pitonyak

>
-- 
  dave boland
  dbola...@fastmail.fm

-- 
http://www.fastmail.com - Access all of your messages and folders
  wherever you are


-- 
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] Re: LO 5.0.5.2 writer freezes during save on Win 7

[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 progress bar freeze on both systems,
> it is only in win 7 it sometimes does not continue.
> 
> Looks like it helps to "warm up" the system, do a small change, save, do
> another small change and save. If no hanging so far, then the following
> saves in this session usually works.
> 
> The document is large, more than 900 pages, so it usually takes some 30
> seconds to save when it works.
> 
> Anyone know how to track this down? Do the "usual support action" to
> delete
> my profile??

That seems the same issue of  tdf#93553
   which has been
fixed, on master and for the 5.1.4 release. But will not likely be back
ported to the 5.0 branch. 

You can check to see if it works better for you with a parallel /A admin
install  of a current build of master or the daily build of the 5.1.4
branch. Or upgrade to 5.1.4 when released mid-June.

Stuart

=-ref-=
https://wiki.documentfoundation.org/Installing_in_parallel
https://wiki.documentfoundation.org/ReleasePlan




--
View this message in context: 
http://nabble.documentfoundation.org/LO-5-0-5-2-writer-freezes-during-save-on-Win-7-tp4183263p4183286.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

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

[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,
it is only in win 7 it sometimes does not continue.

Looks like it helps to "warm up" the system, do a small change, save, do
another small change and save. If no hanging so far, then the following
saves in this session usually works.

The document is large, more than 900 pages, so it usually takes some 30
seconds to save when it works.

Anyone know how to track this down? Do the "usual support action" to delete
my profile??

Thanks
Bo

-- 
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