from:"Krunoslav Šebetić"

It is really easy to use, and I love the way it can be customized (in 
sense of formating bibliography entries) but just wonder - what happens 
when I send "zotero odt" to some one who doesn't have it installed? Does 
bibliography shows as it should?

On 08/18/2013 05:47 PM, Krunoslav Šebetić wrote:
First time I installed it, it wasn't showing in LO user interface, 
I've downloaded id again, upgraded Firefox to 23 and now it is showing 
in UI and allows me to use it. Still have to play with it a little bit 
to see what that thing can really do, but sure it is improvement over 
LO integrated bibliography system.

On 08/18/2013 04:23 PM, Tom Davies wrote:

Hi :)
Congrats!!  Have you really solved it and got it all working properly 
now?  Is Zotero easy enough to use?

Some of my colleagues wont even try LO until it can do things that 
they never need it to do anyway.  One of the interns mentioned it 
being difficult to do bibliography and stuff so now no-one will even 
use it to write simple one-page letters.

Regards from
Tom :)

----
*From:* Krunoslav Šebetić 
*To:*
*Cc:* users@global.libreoffice.org
*Sent:* Sunday, 18 August 2013, 13:36
*Subject:* Re: [libreoffice-users] Bibliography entry system and
word/character counting

On 08/18/2013 02:30 PM, Robert Funnell wrote:
    > On Sun, 18 Aug 2013, Krunoslav Šebetić wrote:
>
>> On 08/18/2013 02:09 PM, Krunoslav Šebetić wrote:
>>>  On 08/18/2013 08:20 AM, Jean-Baptiste Faure wrote:
    >>> >  Le 17/08/2013 12:46, Krunoslav Šebetić a écrit :
>>> > >  Hi,
>>> > > > >  think that LO should have (a little bit) better
>>> bibliography entry
>>> > >  system. Every thing works just fine, but I miss some
features
>>> with > >  thing
>>> > >  I'm writing now.
>>> > > > >  When I do Insert - Indexes an tables - Bibliography
entry I
>>> can insert
>>> > >  entry from the document or from Bibliography database.
Thing is
>>> that > >  the
>>> > >  reference system I use require shortening of textnotes:
>>> >  You should try Zotero instead which works well with LO.
>>> > >  Best regards.
>>> >  JBF
>>> >
>>>  Heard of that, never used it, I'll give it a try - thanks
for replay
>>>  because I really need something more powerful...
>>
>> Page
http://www.zotero.org/support/word_processor_plugin_installation
>> says it will work with 3.5.6 what about 4.0.4 or 4.2 beta?
>>
> The Zotero version numbers are a bit confusing. 3.5.6 is the
version
> number of the latest Zotero plugin for LibreOffice. As the page
says,
> the plugin is 'compatible with all versions of LibreOffice',
including
> 4. (The plugin is _not_ compatible with version 4 of Apache
OpenOffice.)

Didn't install it right first time - got it working now - thanks!

-- 
To unsubscribe e-mail to:

users+unsubscr...@global.libreoffice.org
<mailto: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: [Solved] Re: [libreoffice-users] Bibliography entry system and word/character counting

First time I installed it, it wasn't showing in LO user interface, I've 
downloaded id again, upgraded Firefox to 23 and now it is showing in UI 
and allows me to use it. Still have to play with it a little bit to see 
what that thing can really do, but sure it is improvement over LO 
integrated bibliography system.

On 08/18/2013 04:23 PM, Tom Davies wrote:

Hi :)
Congrats!!  Have you really solved it and got it all working properly 
now?  Is Zotero easy enough to use?

Some of my colleagues wont even try LO until it can do things that 
they never need it to do anyway.  One of the interns mentioned it 
being difficult to do bibliography and stuff so now no-one will even 
use it to write simple one-page letters.

Regards from
Tom :)

    *From:* Krunoslav Šebetić 
*To:*
*Cc:* users@global.libreoffice.org
*Sent:* Sunday, 18 August 2013, 13:36
*Subject:* Re: [libreoffice-users] Bibliography entry system and
word/character counting

On 08/18/2013 02:30 PM, Robert Funnell wrote:
> On Sun, 18 Aug 2013, Krunoslav Šebetić wrote:
>
>> On 08/18/2013 02:09 PM, Krunoslav Šebetić wrote:
>>>  On 08/18/2013 08:20 AM, Jean-Baptiste Faure wrote:
    >>> >  Le 17/08/2013 12:46, Krunoslav Šebetić a écrit :
>>> > >  Hi,
>>> > > > >  think that LO should have (a little bit) better
>>> bibliography entry
>>> > >  system. Every thing works just fine, but I miss some
features
>>> with > >  thing
>>> > >  I'm writing now.
>>> > > > >  When I do Insert - Indexes an tables - Bibliography
entry I
>>> can insert
>>> > >  entry from the document or from Bibliography database.
Thing is
>>> that > >  the
>>> > >  reference system I use require shortening of textnotes:
>>> >  You should try Zotero instead which works well with LO.
>>> > >  Best regards.
>>> >  JBF
>>> >
>>>  Heard of that, never used it, I'll give it a try - thanks for
replay
>>>  because I really need something more powerful...
>>
>> Page
http://www.zotero.org/support/word_processor_plugin_installation
>> says it will work with 3.5.6 what about 4.0.4 or 4.2 beta?
>>
> The Zotero version numbers are a bit confusing. 3.5.6 is the
version
> number of the latest Zotero plugin for LibreOffice. As the page
says,
> the plugin is 'compatible with all versions of LibreOffice',
including
> 4. (The plugin is _not_ compatible with version 4 of Apache
OpenOffice.)

Didn't install it right first time - got it working now - thanks!

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

<mailto: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] Bibliography entry system and word/character counting

On 08/18/2013 02:30 PM, Robert Funnell wrote:

On Sun, 18 Aug 2013, Krunoslav Šebetić wrote:

On 08/18/2013 02:09 PM, Krunoslav Šebetić wrote:

 On 08/18/2013 08:20 AM, Jean-Baptiste Faure wrote:
>  Le 17/08/2013 12:46, Krunoslav Šebetić a écrit :
> >  Hi,
> > > >  think that LO should have (a little bit) better 
bibliography entry
> >  system. Every thing works just fine, but I miss some features 
with > >  thing

> >  I'm writing now.
> > > >  When I do Insert - Indexes an tables - Bibliography entry I 
can insert
> >  entry from the document or from Bibliography database. Thing is 
that > >  the

> >  reference system I use require shortening of textnotes:
>  You should try Zotero instead which works well with LO.
> >  Best regards.
>  JBF
>
 Heard of that, never used it, I'll give it a try - thanks for replay
 because I really need something more powerful...

Page http://www.zotero.org/support/word_processor_plugin_installation 
says it will work with 3.5.6 what about 4.0.4 or 4.2 beta?

The Zotero version numbers are a bit confusing. 3.5.6 is the version 
number of the latest Zotero plugin for LibreOffice. As the page says, 
the plugin is 'compatible with all versions of LibreOffice', including 
4. (The plugin is _not_ compatible with version 4 of Apache OpenOffice.)

Didn't install it right first time - got it working now - thanks!

--
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] Bibliography entry system and word/character counting


On 08/18/2013 02:09 PM, Krunoslav Šebetić wrote:

On 08/18/2013 08:20 AM, Jean-Baptiste Faure wrote:

Le 17/08/2013 12:46, Krunoslav Šebetić a écrit :

Hi,

think that LO should have (a little bit) better bibliography entry
system. Every thing works just fine, but I miss some features with 
thing

I'm writing now.

When I do Insert - Indexes an tables - Bibliography entry I can insert
entry from the document or from Bibliography database. Thing is that 
the

reference system I use require shortening of textnotes:

You should try Zotero instead which works well with LO.

Best regards.
JBF



Heard of that, never used it, I'll give it a try - thanks for replay 
because I really need something more powerful...


Page http://www.zotero.org/support/word_processor_plugin_installation 
says it will work with 3.5.6 what about 4.0.4 or 4.2 beta?


--
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] Bibliography entry system and word/character counting


On 08/18/2013 08:20 AM, Jean-Baptiste Faure wrote:

Le 17/08/2013 12:46, Krunoslav Šebetić a écrit :

Hi,

think that LO should have (a little bit) better bibliography entry
system. Every thing works just fine, but I miss some features with thing
I'm writing now.

When I do Insert - Indexes an tables - Bibliography entry I can insert
entry from the document or from Bibliography database. Thing is that the
reference system I use require shortening of textnotes:

You should try Zotero instead which works well with LO.

Best regards.
JBF



Heard of that, never used it, I'll give it a try - thanks for replay 
because I really need something more powerful...


--
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] Bibliography entry system and word/character counting

2013-08-17 Thread Krunoslav Šebetić


Hi,

think that LO should have (a little bit) better bibliography entry 
system. Every thing works just fine, but I miss some features with thing 
I'm writing now.


When I do Insert - Indexes an tables - Bibliography entry I can insert 
entry from the document or from Bibliography database. Thing is that the 
reference system I use require shortening of textnotes:


Some text some text [author, year_of_publishing: page_of_citation], some 
text from the same author and the same book, just another page, so I 
should not enter authors name (short name from bibliography database), I 
should put word "ibid." instead [ibid: page].


Now I can't insert [ibid: page] as field or to relate it somehow with 
bibliography field inserted above. Since that kind of reference is not 
field, if I change something in my document, I need to hunt all these 
inserts and change it manually to [author, year: page] format because 
[ibid...] works only if the first reference before [ibid...] is from the 
same author and the same book.


Think that feature should be added to LO: Insert - Indexes and tables - 
Bibliography entry and the dialog box should have some additional 
fields: check box and empty text box. Now, I should be able to choose a 
bibliography entry from bibliography database, then chose that new check 
box and enter the word I wont to display in document. Chosen 
bibliography entry from dialog box should be related to the word from 
text box.


LO should connect [ibid:page] with [author, year: page] and display 
[ibid:page] only if right above Bibliography entry (as field) is the 
same one we connected earlier. If I change the document and remove above 
bibliography entry field, [ibid:page] should change to [author, year:page].


I'm forced to use [ibid: page] and I'm unable do it as fields - now I 
have to hunt down every manual [ibid:page] I make.


Is there way to do this?

Also, think it should not be a problem to add some additional 
information in the same place with word and character count. Think it 
would be nice if we had:


Words (characters) [cards] | 1249 (7568) [4,204]

Look here (well, I'm not writing in Serbian but idea of typography card 
stays the same):

http://www.proz.com/forum/money_matters/126748-equivalent_of_characters_including_spaces_in_words.html#1047157

Now I have to open KCalc over and over again. Think that should not be 
very complicate to add?


Kruno


--
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] How to define a dictionary for new language?

2013-07-31 Thread Krunoslav Šebetić


On 07/31/2013 10:07 AM, Sergio Martino wrote:

Hi,

a friend of mine would like to build a dictionary for a local dialect
and he asked for my help.

First I build the aff and dic files and I tested them with hunspell. It
works.


Can you help me to do this, is there any tutorial or something? How to 
build aff and dic so it can be tested?


Kruno

--
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: Customizing Number Format of each level in "Writer->Tools->Outline Numbering"

2013-07-26 Thread Krunoslav Šebetić


On 07/26/2013 02:34 PM, Krunoslav Šebetić wrote:

On 07/26/2013 11:52 AM, Sina Momken wrote:

On 07/25/2013 04:29 PM, Regina Henschel wrote:

Hi Sina
Sina Momken schrieb:

Let me show you what exact Outline Numbering I want using the example
below:

LevelExample(desired output)Associated Paragraph Style
1 Chapter 3:Chapter
2  3.2-Heading 1
3   3.2.5-Heading 2
43.2.5.9-Heading 3
5 (b)none
6  Fig (3.12)Fig Caption
7   (3.27)Formula
8Table (3.20)Table Caption

As you can see in the example above the '3' in "Fig (3.12)", "(3.27)"
and "Table (3.20)" is the chapter number at level 1.
[..]

How can I achieve my desired output I mentioned in first example using
LO Writer?



You do the outline numbering with Chapter, Heading 1 , ... with normal
outline numbering. You need to define a paragraph style "Chapter" and
alter the assignment between paragraph style and level in the outline
numbering dialog.

LibreOffice uses the field "Number range" for numbering in captions.
Therefore these are not at all in the outline numbering. But when you
insert a caption to a table or figure, you will see a Options-buttons.
There you can tell LibreOffice to count newly for each chapter.

The "caption" item in the context menu is only a shortened way to set a
caption. You can also write your own caption inserting the field 
"Number

range" manually. That will be the right way for numbering formulas.

The Autotext FN puts the formula and the formula-numbering in a 
table. I

would not use it, because it is not easily possible to move paragraphs,
when the movement crosses a table. I would position the formula number
using a tab. For display formulas in own paragraphs you can define a
suitable paragraph style.

The captions are normal paragraphs, so you can add the needed brackets
manually as you need them.

Each "Number range" will generate its own index later on.

The numbers of the outline can be inserted using fields.

Do not try to mimic the way things are done in Word, the concepts are
different. But you can be sure, that you can write well formatted
academic papers in LibreOffice.

Kind regards
Regina



Using LibreOffice internal captions or "Number range" has some problems
that MUST be solved to be used:

1. Cross-Reference in the text body: Assume you has inserted a new
"Number range" named "Fig" either using "Caption" or inserting manually.
Regardless of the need to manually correct brackets and the whole
format, when you want to insert the Fig number in your text using
Cross-reference, there is NO way to insert the whole Fig number while
preserving its format. For example if you has entered the text "Fig
(2.1) something" under a picture, there is no way to automatically
insert "Fig (2.1)" in your text using Cross-reference.


I first must admit that I didn't read this whole thread and I'm not 
sure what you actually need, but think you can insert text "Fig (2.1)" 
in a cross reference.


I hope I understood you well and I really wont to help you:

First you should insert your picture and set anchoring as Regina said. 
Then insert text "Fig." after that go Insert - Cross-reference, choose 
Variable tab and there (in format box) select Text, enter e.g "(2.1)" 
and then write rest of the caption text.


Now select only "Fig. (2.1)" or what ever you need and go to 
Cross-reference tab, choose Set reference, enter it's name in Name 
box, and choose Insert.


Place your cursor in desire position and then in Cross-reference tab 
choose insert reference, select reference, and in a white box left to 
the Name select Reference, hit Insert.


I hope that's what you wont to do. You still have to manually insert 
Variables and set cross-reference, but you sort the brackets problem.



Kruno


And, you can always define a custom style for that "Fig (2.1)" variable 
text and then go Insert - Indexes and tables - Indexes and tables - 
Additional styles, choose three dots right to label and define that 
style to level you need...


Not sure does thins helps you, but hey... :)

--
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: Customizing Number Format of each level in "Writer->Tools->Outline Numbering"

2013-07-26 Thread Krunoslav Šebetić


On 07/26/2013 11:52 AM, Sina Momken wrote:

On 07/25/2013 04:29 PM, Regina Henschel wrote:

Hi Sina
Sina Momken schrieb:

Let me show you what exact Outline Numbering I want using the example
below:

LevelExample(desired output)Associated Paragraph Style
1 Chapter 3:Chapter
2  3.2-Heading 1
3   3.2.5-Heading 2
43.2.5.9-Heading 3
5 (b)none
6  Fig (3.12)Fig Caption
7   (3.27)Formula
8Table (3.20)Table Caption

As you can see in the example above the '3' in "Fig (3.12)", "(3.27)"
and "Table (3.20)" is the chapter number at level 1.
[..]

How can I achieve my desired output I mentioned in first example using
LO Writer?



You do the outline numbering with Chapter, Heading 1 , ... with normal
outline numbering. You need to define a paragraph style "Chapter" and
alter the assignment between paragraph style and level in the outline
numbering dialog.

LibreOffice uses the field "Number range" for numbering in captions.
Therefore these are not at all in the outline numbering. But when you
insert a caption to a table or figure, you will see a Options-buttons.
There you can tell LibreOffice to count newly for each chapter.

The "caption" item in the context menu is only a shortened way to set a
caption. You can also write your own caption inserting the field "Number
range" manually. That will be the right way for numbering formulas.

The Autotext FN puts the formula and the formula-numbering in a table. I
would not use it, because it is not easily possible to move paragraphs,
when the movement crosses a table. I would position the formula number
using a tab. For display formulas in own paragraphs you can define a
suitable paragraph style.

The captions are normal paragraphs, so you can add the needed brackets
manually as you need them.

Each "Number range" will generate its own index later on.

The numbers of the outline can be inserted using fields.

Do not try to mimic the way things are done in Word, the concepts are
different. But you can be sure, that you can write well formatted
academic papers in LibreOffice.

Kind regards
Regina



Using LibreOffice internal captions or "Number range" has some problems
that MUST be solved to be used:

1. Cross-Reference in the text body: Assume you has inserted a new
"Number range" named "Fig" either using "Caption" or inserting manually.
Regardless of the need to manually correct brackets and the whole
format, when you want to insert the Fig number in your text using
Cross-reference, there is NO way to insert the whole Fig number while
preserving its format. For example if you has entered the text "Fig
(2.1) something" under a picture, there is no way to automatically
insert "Fig (2.1)" in your text using Cross-reference.


I first must admit that I didn't read this whole thread and I'm not sure 
what you actually need, but think you can insert text "Fig (2.1)" in a 
cross reference.


I hope I understood you well and I really wont to help you:

First you should insert your picture and set anchoring as Regina said. 
Then insert text "Fig." after that go Insert - Cross-reference, choose 
Variable tab and there (in format box) select Text, enter e.g "(2.1)" 
and then write rest of the caption text.


Now select only "Fig. (2.1)" or what ever you need and go to 
Cross-reference tab, choose Set reference, enter it's name in Name box, 
and choose Insert.


Place your cursor in desire position and then in Cross-reference tab 
choose insert reference, select reference, and in a white box left to 
the Name select Reference, hit Insert.


I hope that's what you wont to do. You still have to manually insert 
Variables and set cross-reference, but you sort the brackets problem.



Kruno

--
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] Exporting parts of a odt document based on headings in Navigator

2013-07-06 Thread Krunoslav Šebetić


Hi,

I've downloaded LibreOffice Getting started guide. Is there a way to 
save every chapter separately based on Navigator headings. I know 
chapters can be downloaded from LibreOffice wiki but wonder can 
LibreOffice do it anyway.


So, is it possible to automatically generate multiple files from a 
single odt?


Thanks,

Krunoslav

--
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: Horizontal lines (rules) disappeared from Insert menu

2013-06-26 Thread Krunoslav Šebetić

On 06/26/2013 04:56 PM, V Stuart Foote wrote:

The Insert --> Horizontal Rule feature was removed at the 4.0.0 release,
including its gallery of graphics objects. And it was not replaced.

There is an active bug fdo#60858
, and discussion in
the UX-Advise

functional design forum.

For now, working in Writer, only capability is the manual insertion of a
graphic as separator, or using text entry to format the paragraph style to
include a paragraph boundary marking on the bottom edge.

That is done, while completing a paragraph, by immediate keyboard entry of
a triplet of: - (dash), _ (underscore), = (equal), * (asterisk) ,
~ (tilde) or # (hash). And each will apply direct formatting creating a
bottom edge border for the paragraph.

--
View this message in context:
http://nabble.documentfoundation.org/Horizontal-lines-rules-disappeared-from-Insert-menu-tp4063114p4063122.html
Sent from the Users mailing list archive at Nabble.com.

No, the command is missing in 4.0.4. Instead, just type ---

John

Thanks for answers, should checked bugs.freedesktop.org first. I was
thinking about downgrading to 3.6, but since it can be done with
asterisk and dash, I'll bare with 4.0.4.

Kruno

--
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] Horizontal lines (rules) disappeared from Insert menu

2013-06-26 Thread Krunoslav Šebetić

I have to insert a horizontal rule to separate document content - but 
the horizontal rule disappeared from menu. I checked in Help file and it 
should go like this: Insert > Horizontal rule (> plain), but there is no 
Horizontal rule under Insert menu.


Probably doing something wrong...

Debian Squeeze, LO 4.0.4.2

--
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] advanced notes question

2013-06-25 Thread Krunoslav Šebetić

If /Microsnot/ actually means /Microsoft/ maybe it just can't be done 
with LO?


I received a document (OpenOffice format) from someone who edited it 
using Microsnot software and inserted notes into the document.



On 06/25/2013 10:54 PM, Dave Liesse wrote:
Is the document opening in read-only mode?  If you opened it directly 
from an email it might be -- this happens to me all the time.  If 
that's the case, you'll want to save it first and then (re)open it.



On 6/25/2013 12:31, Mirosław Zalewski wrote:

On 25/06/2013 at 18:04, Brian Barker  wrote:


Found it. Thanks. Unfortunately, it's greyed out, which I presume
means that LibreOffice isn't detecting the comments in the document.
Am I right?

I think not.  Now you need to tick Tools | Options... | LibreOffice
Writer | View | Display | Comments.  Then the menu item should become
active.
My simple test shows that both these options (in menu and in Tools → 
Options)
do the same. So if menu item is grayed out, then LO is unaware of any 
comments

in file.
I would consider it a bug.






--
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: [libreoffice-users] Re: [libreoffice-users] Re: [libreoffice-users] Re: [libreoffice-users] Προτάσεις βελτίωση Libre Ofice

2013-06-18 Thread Krunoslav Šebetić

On 06/18/2013 09:30 PM, Δημήτριος Δεσύλλας wrote:

Στις 13/06/2013 01:01 μμ, ο/η Simos Xenitellis έγραψε:

Thanks Tom!

I am forwarding to the us...@el.libreoffice.org mailing list and also
replying inline.

2013/6/13 Tom Davies

Hi :)
I used "Quick Translate" to try to work out what the chap said.
It's all

Greek to me.

Is anyone able to point him to the Greek Users List?

Regards from
Tom :)

"Γεια σας :)
Η συνήθιζα "Quick Μετάφραση" να προσπαθήσουμε να μάθουμε τι το σκάσιμο
είπε. Είναι όλα τα ελληνικά μου.
Η Είναι κανείς σε θέση να επισημάνει τον στην ελληνική λίστα χρηστών;
Regards
από Tom :)"

"Kalispera, [= hello]
I, Dimitio Desylas, of the Greek LoCo community for Ubuntu would
like to
help my LibreOffice to become better platform. Reason is that I
want to
promote the free, open source software companies organizations and
schools

to ordinary users. (eg my sister)

So I suggest to add these features. These features reason I suggest the
following comparison libre office impress (the last stable version)
with MS
powerpoint course in Microsoft WINDOWS 7 has the H / PC where you do
not
practice the LibreOffice the I use in Ubuntu linux 12.04.02 I use
home.:

* Improved color palette: In MS office powerpoint noticed that I can
add
custom font color. How simply words can be identified and mine color
values
beyond some defaults. ie I define my own values in r, g, b as
the font

color and background color - fill a shape and generally where I have to
choose color. If he has, is good to have and the corresponding
option and

buttons that it font color and click th is for color filling.

A feature to be able to specify a custom font color.
This would require a search at the LibreOffice bugzilla in case it is
already filed.
I am not sure if LibreOffice uses the OS palette widget, which in
this case

it would be an issue to enable in that palette the ability to select a
custom color.

* Ability to select multiple images Admission: Once I Insert image from
Impress allow me to introduce only a picture. The corresponding
choice of
MS office gives me can choose more than one insert images. In
LibreOffice

need to enter one by one while ms office I can Enter all together

A feature to multi-select images when inserting an image to a
document. I

think this should be an easy-hack. If there is no bug report already on
this, a feature request should be filed first. Again, it should be an
issue

of enabling the multiple-file selection for FileOpen, and adjust
LibreOffice to accept multiple images into the document.

Where I do feature request?

* standards may be stored in the "closed format": When becomes a
presentation of the standards has preset the Impress when stored in.
Pptx
then some points such size and position of objects and presentation
buttets
alloionontai and not stored properly so that the text is in the wrong
place
and some bullets do not look good when you re open the Impress.
Which does

not help either document sharing and either in migration in LibreOffice.

This is a request for compatibility with the presentation templates
(.ppx),

which in some cases they are not rendered correctly in LibreOffice. Here
there should be a bug report (or more) on specific issues on .ppx files
which are not used properly in LibreOffice. The bug report should
specify a

.ppx, and how it is used wrongly in LibreOffice.

Where I do report the bug?
* Ability to save as image: At the Ms office Powerpoint noticed that
I can

select text or an object and save it as a picture thing to do a group
picture along with other images
and text and save it as an image thing that helps especially do logos on
site. It would have been and this feature the LibreOffice Impress.

This is a feature request to be able to save a selection from a
document,
into an image. The selection would either be a paragraph or text
along with

images or other objects.
I think this could be implemented through an addon.

Personally i do not blame Impress. I just want the LibreOffice be
worthy
replacement for MS Office because I believe in the idea of free
and open
source and I want to contribute. If there some of them would like
to tell

me where to Impress. Still will like if some of the above features are
developed for future versions LibreOffice."

In all these issues, I think Dimitris can search the LibreOffice
bugzilla
and try to identify existing reports. If there is no report already,
a new

report can be filed for each.
Then, post the URLs for those reports to the list in order for the
rest of

us to subscribe and discuss further.

Simos

Where is the bugzila?

Hope this will help:

https://www.libreoffice.org/bugzilla/
https://wiki.documentfoundation.org/BugReport

[libreoffice-users] Impress 4.0.3.3 doesn't show anything in Handout view

2013-06-08 Thread Krunoslav Šebetić


Hello,

I have a problem with Impress 4.0.3.3 on Debina Squeeze. Had the same 
problem on LO 3.6 too. Handout view doesn't show anything in Impress, I 
see six blank boxes witch represents slides. Handout can be printed to 
file, and that printed file shows my presentation normaly. It's hard to 
print to file every time I make a change. Normal view, Outline view, 
Notes view, and Slide Sorter works just fine.


Thanks,

Kruno

--
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] Some issues about Writer

2013-06-02 Thread Krunoslav Šebetić


On 06/02/2013 11:02 PM, Steve Edmonds wrote:


On 2013-06-03 04:58, NickKolok wrote:


Greetings from Russia, comrads!
I've installed Fedora and LibreOffice onto my girlfriend's computer. 
She started to use them some months ago and now we have some 
questions to you, dear developers.
1) There was a moment when LibreOffice alerted message like 
"LibreOffice can't save important internal information" (or smth like 
this). She couldn't close that messasge as well as save her work. We 
have been trying many things for ~2 hours, but the solution was to 
close Firefox. So, if such situations are possible, maybe it's worth 
to add tips to that message?
2) She finds unability to crop images visually in Writer very 
unconvenient. I mean that there is no tool "Crop" is available in 
Writer but there is such a tool in Draw (with scissorson icon). 
Moreover, there IS such a toll in Impress! So, can we wait and hope 
than once it will appear in Writer, too? Or there is a high reason 
for this fact, e.g. unix-way?

Thank you for your attention and excuse me for my quite bad English.


Hi.
There is the ability to crop the image in writer. Insert the image, 
right click and select picture. In that dialogue there is a tab crop. 
You enter the dimensions that the cropping will occur from each 
outside edge.

Steve



Is it possible to do it with key combination, e.g. Alt+L+5 should crop 
left margin by 5 default LO units, combination Alt+R+3 should crop right 
margin by 3 default LO units and so on? It's hard to work with dialog 
boxes if you have a lot of cropping to do...


Thanks

--
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] Summing a cell value by a background color cell style

On 03/26/2013 12:05 PM, Tom Davies wrote:

Hi :)
I would definitely use more columns for this.  Possibly in groups of 3 
perhaps with an extra column as an empty gap to make it easier to 
read.  Perhaps change "Page layout" to 'landscape' instead of 
'portrait' in case i needed to print it out.

So, something like
Column A = time, for it's heading i would use the date or the 
day-of-the-week
Column B = value, for it's heading i would say something like 
"Imported data"  (perhaps turned sideways or something?)
Column C = calculated code (instead of colour), for it's heading i 
would say "code"
Column D = calculated value, for it's heading i would say something 
like "Result"
Column E = blank but narrowed to half width or less.  It's often handy 
to have an extra column "just in case" but it's main purpose is to 
split the groups of columns up

Column F = time, for it's heading i would use the date or the 
day-of-the-week
Column G = value, for it's heading i would say something like 
"Imported data"  (perhaps turned sideways or something?)
Column H = calculated code (instead of colour), for it's heading i 
would say "code"
Column I = calculated value, for it's heading i would say something 
like "Result"
Column J = blank but narrowed to half width or less.  It's often handy 
to have an extra column "just in case" but it's main purpose is to 
split the groups of columns up

I will try that in Calc.

The currently uploaded file's layout looks a bit random so it might 
help to make it more formal even though that takes a bit of the magic 
out of it, as does losing the colours and replacing with "Code".

Regards from
Tom :)

Well, it is rondom, it a scheme for demonstration purpos.

*From:* Krunoslav Šebetić 

*

*
> Hi.
> From the example on Nabble I can see what you are doing but not
how it relates to your example above. There are 3 columns and not
5, is this 3 times a day. There is no date or time, is it to be
assumed that all data in column A is at the same time and each
line is a new day.
>
> Steve

Well that ods file is just example, as I mentioned before. I do
not have document created. This is just a preparation and because
of that file from nabble is a scheme. Thats the reasen Im using
this mailing list. Just wonna know is posible add values/numbers
based on cell background color.

We can say that Column A is one day and column B is another. We
can say thats needed the rows represents time of the day (morning,
noon, evening). So, first I need to fill column A and rows
respective to the column, and another day rows resprective to
column B.

This weather thing is the closest to what Im doing, and i really
doubt I could explain it on the real project. Is it possible do
edit xml file or something and do it with some find/repleca - if
in xml file founded line "background color:red"  "devide by 2.7"
and put that number betwen string x and string y?

Thanks for your time!

--
For unsubscribe instructions e-mail to: users+h...@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] Summing a cell value by a backgroud color cell style


On 03/26/2013 12:00 PM, Regina Henschel wrote:

Hi Kruno,

Krunoslav Šebetić schrieb:

Hello,

I need to make a Calc table. Table is "structured" verticly. Tables sums
number values from collums in the last row of table. Every collum stands
for itself, and has nothing do do with oder collums.

But values are enterd in collum by different variables. I have set
different cell background color for every variable. Is there a way to
tell Calc to sum, devide or multiply values by the cell style color?


No, there is no build-in function to get the color of a cell. You need 
to write a macro. The background color is the property 
"CellBackColor". It is set, when you color the cell directly and when 
you color it by style as well.


You can use macro functions in nearly the same way as the build-in 
functions.




I can not enter summed, devidded or multiplied values directly to collum
because I need to initials values summed (for each collum) so I want to
set some kinde of formula to a different place in sheet with modified
values. Maybe it can be done with sumif?

Maybe I am doing it wrong, maybe it can be done different way?


I would not put such information as color to the cell, but I would use 
a separate, parallel column, which only contains these flags; not as 
color but as values, which you can use directly in a build-in function.


Kind regards
Regina



Nice - I really could use numbers in different collumn insted of colors 
- thats practicly it.


--
For unsubscribe instructions e-mail to: users+h...@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] Problem with First Page header in Master


On 03/26/2013 09:46 AM, Agustin Lobo wrote:

I'm making a master document with several existing documents as sub-documents.
The problem I have is that the heading in the first page of the
master, which I want to design as a Title page,
gets reproduced in the first page of each subdocument. Is there any
way to avoid this?
I have the First page of the master defined as First page, cannot find
the way of defining it as Title page,
so that its header is not automatically reproduced on each first page
of the subdocuments.

Thanks



Make new page styles. Make one (e.g) "first_in_master", and rest of them 
put as "first_page". The header for style "first_in_master" should be 
presented only in that one, not on first pages of sub-documents.


I assume you are making master with documents which are made from 
different tamplates. Best way to do master is make one template, 
reorganize all sub-documents and than make master. Master formating 
applays will re-redit document formating if called the same name. If 
first page of master documents has page style "first_page", and first 
page of sub-document is called "first_page" those will have "first_page" 
header.


Hopes this will work.

--
For unsubscribe instructions e-mail to: users+h...@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] Summing a cell value by a background color cell style


On 03/26/2013 04:56 AM, Brian Barker wrote:

At 23:30 25/03/2013 +0100, Krunoslav Šebetic wrote:

Let's say I am collecting weather temperature (but I'm not) values ...


So let's not say that, then!  Why not tell us what you are doing - or 
just call them "values"?



Need to messure voltage and staff from battery. But I tend to connect 
various additions to it. With every addition the expected average value 
is different. Collum A is actuali addition 1, collum B is addition 2 and 
so on...




... and I'm doing it five time a day. Let's say that every time (of 
five) I need to know is that (entered) value above or below the 
average for this time a day, month and year. In that case I would 
have three type of (I call them) values which can not be predicted ...


If - as is now evident - the calculations you want to do require 
knowledge of those averages, they also need to be included in the 
spreadsheet as a separate table.  Then you can leave your calculations 
to the spreadsheet - which is the whole idea of them, of course.


... and thus I doubt I can set a second - or the second one would be 
bigger and far more complex that the primary one.


Sorry: I don't understand this bit.



Values for the secend table can expand - start with 5 average values, in 
2 months there can be 12 values, or the original five can change. New 
values needs to replace old ones for coresponding condition but should 
not erese or recalculate values calculated with old (original) 5. :D





Now, imagine you need sum only the values (temperature) that is above 
average for this time of the year and below average of that month. 
[...] So I must say that I am now sure if sumif can handle that.


Provided you have the various average values listed in the 
spreadsheet, the SUMIF() function can easily achieve what you need.



I do not need sum numbers higher or lower from x, ...


Er what's "x", please?



X is rondom number.




... I need sum number collected from the real world and those are 
quite random.


You are tying yourself in knots here: no-one is suggesting that your 
values should not be "random", as you put it.  But if you need to do 
calculations that depend on certain values, those values (in this case 
your averages) need to appear in your spreadsheet.  Otherwise you are 
asking Calc to read your mind!


At 00:32 26/03/2013 +0100, Krunoslav Šebetic wrote:

I have hard time explaining such complicated thing in English ..


You shouldn't underplay your skills in English: what you have 
explained is quite understandable (although there are some things that 
you haven't said).



... and seems the weather thing is a bad example.


Yes: why not just describe what you are *actually* doing?!  (There is 
no need to divulge anything confidential.)


Tom uploaded file I sent him ... . [...] But if the value is higher 
then the year average and smaller then month average I put it green, 
if the value is lower then the year average and higher the month 
average I put in red, if the value is equal to year average and month 
average I put it blue.


A quick look at this confirms, I think, what I suggested in a previous 
message.  What you are doing is to compare your input values to other 
values - not currently in the spreadsheet - and to colour the cells 
according to the result of your mental arithmetic.  That comparison is 
something that spreadsheets do easily and reliably but humans less 
so.  So that is a bad move: let the spreadsheet do this for you.  You 
are also choosing to encode the result of these comparisons as colours 
of cells - something that is immediately meaningful to the human eye 
but very difficult for the spreadsheet to use!


Now, if cell is colored red, I divide it by 2. If the cell is blue i 
multiply that value (in blue) with 1.5, and if green I do plus 
operation (x(blue) + y).


I can't see these aspects in the sample spreadsheet you submitted.  Do 
you mean that you applied these calculations *before* you entered the 
data?  (I hope not.)


Here is what I suggest:
o Enter all your raw data into the spreadsheet.  This includes the 
averages (or whatever they are) that you are currently using (in your 
head) to determine which colour the cells should have.
o Evaluate what you currently have as colours within the spreadsheet, 
either within other formulae or as values in additional columns.
o You appear to need the sum of a series of products to calculate what 
you need, so SUMIF() is probably not the best way.  Instead, you may 
find SUMPRODUCT() useful, but this depends on exactly how you design 
your sheet.


Note that these suggestions do not need you to colour the cells at 
all.  If you still decide to colour them, I recommend that you do so 
using "conditional formatting" (found in the Format menu), based on 
values you will now have in the spreadsheet.  This will be more 
reliable that manual formatting.


Note also that, if you don't want to see all the additional values 
either on scree

Re: [libreoffice-users] Summing a cell value by a background color cell style


On 03/26/2013 01:05 AM, Steve Edmonds wrote:


On 2013-03-26 12:32, Krunoslav Šebetić wrote:

On 03/25/2013 11:55 PM, Steve Edmonds wrote:


On 2013-03-26 11:30, Krunoslav Šebetić wrote:

On 03/25/2013 11:08 PM, Brian Barker wrote:

At 15:16 25/03/2013 +0100, Krunoslav ŠebetiÄ‡ wrote:
I need to make a Calc table. Table is "structured" vertically. 
Tables sums number values from columns in the last row of table. 
Every column stands for itself, and has nothing to do with other 
columns.  But values are entered in column by different 
variables. I have set different cell background color for every 
variable. Is there a way to tell Calc to sum, divide or multiply 
values by the cell style color?


Not that I know of.  But there is an easier way.  I'm guessing 
that you have set the background colours manually. Instead of 
doing that, why not create another column to indicate the 
condition (I'm not sure what you mean by "entered ... by different 
variables")?  You can then use the values in the new column to 
control the SUMIF() to form your selective sums. But you can also 
use the values in the new column in "conditional formatting" to 
set the background colours of the cells in the first place.  This 
is a much more reliable technique.


Lets say I am collecting wether temperature (but Im not) values and 
Im doing it five time a day. 
Does this mean that you add 5 new lines each day. Do you add the 
date/time and the temperature 5 times a day. Do you ad 1 line each 
day with 5 temperatures in each line that are added during the day.
Are the times consistent real times or do you just call them time1 
...time5. (breakfast, morning tea, lunch, afternoon tea, dinner)



I have hard time explaining such complicated thing in english and 
seems the wehter thing is a bad exemple. Tom uploaded file I sent him 
(http://nabble.documentfoundation.org/file/n4046112/example.ods). All 
enteries are changeble - I enter one line (cell in collumn) per day. 
But if the value is higher then the year average and smaller then 
month average I put it green, if the value is lower then the year 
average and higher the month average I put in red, if the value is 
equal to year average and month average I put it blue. Now, if cell 
is colord red, I devide it by 2. If the cell is blue i multiply that 
value (in blue) with 1.5, and if green I do plus operation (x(blue) + 
y). There is no sorting in table, green cells are not on top, and 
blue ones are not at the bottom. If cell is (from exemple) colord 
green it still can be higher or lower then one in blue, so sumif 
_can_ do it wrang way.


The problem is that in my case there is now juist "year" and "month" 
plus permutations with "lower" and "higher", its match more complex 
than that. Coloring the cell background and posibillity do 
manipulating data based on that would make job lot more easyer.







Lets say that every time (of five) I need to know is that (enterd) 
value above or bellow the average for this time a day, month and year.
So is the idea of the background colour is to show if that (enterd) 
value above or bellow the average for this time a day, month and 
year. This is 1 condition or 3 conditions



If below from average of this time a the day, month and year - color 
x. If above from average of this time a the day, month and year - 
color y. If below of this time a day but higher of average of month 
and higher of average of the year - color z. If below of this time a 
day but higher of average of month and _this time_ lower than the 
average of the year - color a


Hope this helps.


(above the average for this time of day AND above the average for 
this time of month AND above the average for this time of year)=Y
(below the average for this time of day AND below the average for 
this time of month AND below the average for this time of year)=N


or
(above the average for this time of day)Y/N
(above the average for this time of month )Y/N
(above the average for this time of year)Y/N

In that case I would have three type of (I call them) values which 
can not be predicted and thus i doubt I can set a secend - or the 
secend one would be bigger and far more complex that the primary one.


Now, imagine you need sum only the values (temperature) that is 
above average for this time of the year and belove average of that 
month. 
Is that summing from the 5 values for that day or summing all the 
history



Its summing values colored with color x in cell A1, summing values 
colored with color y in cell A2 ... and finaly summing all together 
in B1 (color x + color y + color z...)



What is above the average of the year is not nessery below the 
average of the month and vice verse. So I must say that I am now 
shure if sumif can handle that. I do not need sum numbers higher or 
lower from x, I need sum number collected from the real world and 
those are quite rondom.




If you wis

Re: [libreoffice-users] Summing a cell value by a background color cell style


On 03/25/2013 11:55 PM, Steve Edmonds wrote:


On 2013-03-26 11:30, Krunoslav Šebetić wrote:

On 03/25/2013 11:08 PM, Brian Barker wrote:

At 15:16 25/03/2013 +0100, Krunoslav ŠebetiÄ‡ wrote:
I need to make a Calc table. Table is "structured" vertically. 
Tables sums number values from columns in the last row of table. 
Every column stands for itself, and has nothing to do with other 
columns.  But values are entered in column by different variables. 
I have set different cell background color for every variable. Is 
there a way to tell Calc to sum, divide or multiply values by the 
cell style color?


Not that I know of.  But there is an easier way.  I'm guessing that 
you have set the background colours manually.  Instead of doing 
that, why not create another column to indicate the condition (I'm 
not sure what you mean by "entered ... by different variables")?  
You can then use the values in the new column to control the SUMIF() 
to form your selective sums. But you can also use the values in the 
new column in "conditional formatting" to set the background colours 
of the cells in the first place.  This is a much more reliable 
technique.


Lets say I am collecting wether temperature (but Im not) values and 
Im doing it five time a day. 
Does this mean that you add 5 new lines each day. Do you add the 
date/time and the temperature 5 times a day. Do you ad 1 line each day 
with 5 temperatures in each line that are added during the day.
Are the times consistent real times or do you just call them time1 
...time5. (breakfast, morning tea, lunch, afternoon tea, dinner)



I have hard time explaining such complicated thing in english and seems 
the wehter thing is a bad exemple. Tom uploaded file I sent him 
(http://nabble.documentfoundation.org/file/n4046112/example.ods). All 
enteries are changeble - I enter one line (cell in collumn) per day. But 
if the value is higher then the year average and smaller then month 
average I put it green, if the value is lower then the year average and 
higher the month average I put in red, if the value is equal to year 
average and month average I put it blue. Now, if cell is colord red, I 
devide it by 2. If the cell is blue i multiply that value (in blue) with 
1.5, and if green I do plus operation (x(blue) + y). There is no sorting 
in table, green cells are not on top, and blue ones are not at the 
bottom. If cell is (from exemple) colord green it still can be higher or 
lower then one in blue, so sumif _can_ do it wrang way.


The problem is that in my case there is now juist "year" and "month" 
plus permutations with "lower" and "higher", its match more complex than 
that. Coloring the cell background and posibillity do manipulating data 
based on that would make job lot more easyer.







Lets say that every time (of five) I need to know is that (enterd) 
value above or bellow the average for this time a day, month and year.
So is the idea of the background colour is to show if that (enterd) 
value above or bellow the average for this time a day, month and year. 
This is 1 condition or 3 conditions



If below from average of this time a the day, month and year - color x. 
If above from average of this time a the day, month and year - color y. 
If below of this time a day but higher of average of month and higher of 
average of the year - color z. If below of this time a day but higher of 
average of month and _this time_ lower than the average of the year - 
color a


Hope this helps.


(above the average for this time of day AND above the average for this 
time of month AND above the average for this time of year)=Y
(below the average for this time of day AND below the average for this 
time of month AND below the average for this time of year)=N


or
(above the average for this time of day)Y/N
(above the average for this time of month )Y/N
(above the average for this time of year)Y/N

In that case I would have three type of (I call them) values which 
can not be predicted and thus i doubt I can set a secend - or the 
secend one would be bigger and far more complex that the primary one.


Now, imagine you need sum only the values (temperature) that is above 
average for this time of the year and belove average of that month. 

Is that summing from the 5 values for that day or summing all the history



Its summing values colored with color x in cell A1, summing values 
colored with color y in cell A2 ... and finaly summing all together in 
B1 (color x + color y + color z...)



What is above the average of the year is not nessery below the 
average of the month and vice verse. So I must say that I am now 
shure if sumif can handle that. I do not need sum numbers higher or 
lower from x, I need sum number collected from the real world and 
those are quite rondom.




If you wish, the extra columns can be hidden or displaced to another 
part of the sheet or even to another

Re: [libreoffice-users] Re: Summing a cell value by a backgroud color cell style


On 03/25/2013 11:24 PM, Tom wrote:

Hi :)
Here is the uploaded file

example.ods 

I am also adding a screen-shot of how Nabble looked, with my mouse just
beside the "More" button so you can see if IceWeasel really is misbehaving
30.png 
Normally i would make it into an indexed Gif and crop&resize it to make it
smaller but i'm right in the middle of a LiveCd session and don't have room
for Gimp here.
Apols and regards from
Tom :)



Thanks for the upload and screenshot, I got it all white white, nothing 
to click. Again, its not Nabble, its my browser and operating system.




--
View this message in context: 
http://nabble.documentfoundation.org/Summing-a-cell-value-by-a-backgroud-color-cell-style-tp4046007p4046112.html
Sent from the Users mailing list archive at Nabble.com.




--
For unsubscribe instructions e-mail to: users+h...@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] Summing a cell value by a background color cell style


On 03/25/2013 11:08 PM, Brian Barker wrote:

At 15:16 25/03/2013 +0100, Krunoslav ŠebetiÄ‡ wrote:
I need to make a Calc table. Table is "structured" vertically. Tables 
sums number values from columns in the last row of table. Every 
column stands for itself, and has nothing to do with other columns.  
But values are entered in column by different variables. I have set 
different cell background color for every variable. Is there a way to 
tell Calc to sum, divide or multiply values by the cell style color?


Not that I know of.  But there is an easier way.  I'm guessing that 
you have set the background colours manually.  Instead of doing that, 
why not create another column to indicate the condition (I'm not sure 
what you mean by "entered ... by different variables")?  You can then 
use the values in the new column to control the SUMIF() to form your 
selective sums.  But you can also use the values in the new column in 
"conditional formatting" to set the background colours of the cells in 
the first place.  This is a much more reliable technique.


Lets say I am collecting wether temperature (but Im not) values and Im 
doing it five time a day. Lets say that every time (of five) I need to 
know is that (enterd) value above or bellow the average for this time a 
day, month and year. In that case I would have three type of (I call 
them) values which can not be predicted and thus i doubt I can set a 
secend - or the secend one would be bigger and far more complex that the 
primary one.


Now, imagine you need sum only the values (temperature) that is above 
average for this time of the year and belove average of that month. What 
is above the average of the year is not nessery below the average of the 
month and vice verse. So I must say that I am now shure if sumif can 
handle that. I do not need sum numbers higher or lower from x, I need 
sum number collected from the real world and those are quite rondom.




If you wish, the extra columns can be hidden or displaced to another 
part of the sheet or even to another sheet, so they do not need to be 
immediately visible or to print along with the values you do need to 
see.  It may not even be necessary to create new columns, if the 
conditions they need to contain could be derived directly from 
whatever is their source.


I trust this helps.

Brian Barker




It helps, thank you. This sure is the way to go but it can get quite 
complicated with time.


--
For unsubscribe instructions e-mail to: users+h...@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: Summing a cell value by a backgroud color cell style

On 03/25/2013 09:25 PM, Tom wrote:

Hi :)
If you want to upload the file so that everyone can see it then Nabble is a
good place. When you are in the right thread in Nabble click on "Reply".
Above where you can type in are a few buttons. The "More" button's top
option is "Upload file" which works roughly the same as uploading an
attachment to an email except that it puts an html link into the message
box. You can move the link around to place it sensibly if you want.
Regards from
Tom :)

--
View this message in context:
http://nabble.documentfoundation.org/Summing-a-cell-value-by-a-backgroud-color-cell-style-tp4046007p4046071.html
Sent from the Users mailing list archive at Nabble.com.

Have problem with Nabble, or should I say problem with Firefox
(Iceweasel as packed with Debian Linux) - can not see field to register
and I can not see some other text in the page. Think is nothing wrong
with Nabble because I have this problem for a while. But I will send the
example file to you, so maybe you could upload it to Nabble.

Let me now if you got the attachment - simple 11 kb ods file. Hope that
with file the whole question makes more sense.

--
For unsubscribe instructions e-mail to: users+h...@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] Summing a cell value by a backgroud color cell style