Re: [libreoffice-users] Re: Sequentially numberted tickets...

[David Love]

Hi Nino

Nino Novak  wrote:

> Am 08.08.2013 06:53, schrieb David Love:
> > I have been asked to design and print numbered tickets for an event
> > being organised by a Club to which my wife belongs.
> 
> How I'd do it (it's from memory, so bear with me for little glitches):

Thank you for the prompt reply and my apologies for the delay in replying to
you.

> 1. Set up a Calc spreadsheet and enter a header (e.g."number") and the
> desired numbers (1 to 150 or even 001 to 150 by chosing a custom number
> format with two preceeding zeroes) into a column

Did that without problems.

> 2. design a nice text page with all 4 tickets in it (you could also try
> going with labels but for just 4 tickts per page I'd rather go with
> copy&paste instead of fumbling with labels)

O.K. Although I did have some trouble grouping all elements.

> 3. assign the spreadsheet from #1 as data source (for later use as
> mailmerge, from memory: File > New > Database > connect to existing >
> spreadsheet)

Perfect!

> 4. on your above designed ticket page, press F4 to open the spreadsheet
> from above as data source

No problem.  

> 5. enter (simply drag&drop) column header field into the appropriate place
> in stub and repeat this for the ticket

Went without a hitch.

> 6. after every SECOND field enter "next record" switch (Insert > field >
> others > database > next record) but NOT after the fourth ticket (as a
> page break always triggers a next record switch)

This is where I've gone wrong and I cannot figure out how.  As I understood
it, on the stub and ticket of tickets number 2, 3, 4, I do what you suggest
above.  Is that correct?

and then, as it will be a new page, the numbering will continue in sequence
until we reach the end of the records.  Is that correct

> 7. Print as mailmerge (or form letter or whatever it's called) into 1
> document

I do this by Printing to file.  The first ticket is correct.  Tickets number
2, 3 and 4 are not numbered.  It then goes to the next page where the first
ticket is numbered 2 and the other three are not numbered.  And so it goes
on until the end of the records.  Each page is the next number.

I notice that when I have Next Record highlighted and click Insert, all that
happens is a thin grey vertical line appears where I click.  I would have
thought the words  would have appeared.  Am I wrong?

> 8. review the document and if necessary correct&repeat some of the above
> steps

I am at a loss as to what I should do next.

> 9. print the merged documents,
> 
> 10. enter perforation (I use a sewing machine, works perfectly if you use
> a thin needle and adjust the step width appropriately)
> 
> 11. cut tickets apart :-)
> 
> Enjoy learning ;-)
 
My enjoyment is leading to "grinding of teeth in frustration"

David

-- 
David Love
A "running mate" is a husband who dared to talk back

-- 
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 can I make Tab and Shift+Tab tab multiple lines.

[Tim Deaton]

There are also "Increase Indent" and "Decrease Indent" selections 
available on the "Formatting" toolbar.


From the menu, select "View", "Toolbars", and make sure "Formatting" is 
checked.   I don't remember if the "Increase Indent" and "Decrease 
Indent" icons are visible by default or not.  (The pictures are both a 
triangle arrowhead beside several lines representing text.)  If you 
don't see them, then again select "View", "Toolbars", then "Customize".  
From the toolbar dropdown list, select "Formatting".  Then, in the 
"Commands" box, scroll down not quite to the bottom to find "Increase 
Indent" and "Decrease Indent", and put a checkmark beside them.


Each time you hit "Increase Indent", it indents the current paragraph by 
the distance of one tab stop.  As you continue typing and hitting 
"Enter" to start the next paragraph, that indention stays in effect 
until you change it again.


I use these a lot when I'm typing up informal notes.

-- Tim
===

On 8/20/2013 4:00 PM, Brian Barker wrote:

At 12:10 20/08/2013 -0700, Wyatt Biker wrote:
The Tab key indents single lines only. But when I highlight a few 
lines and press Tab I would like it if a tab was added to every line. 
Also Shift+Tab should delete the tab.


Whenever you use software, you need to play along with it, not fight 
with it to try to achieve what you need.  Are you perhaps thinking of 
your word processor as a glorified typewriter?  If you add a tab 
character at the beginning of a number of lines of a paragraph, you 
would get a mess: what had previously been at the start of each line 
would no longer be so and your new gaps would be in unpredictable 
places, not at the beginning of lines.  In any case, when you later 
modified the text of the paragraph, once again a mess would ensue.


The few lines you want to indent will probably be a paragraph.
o Put the cursor into the paragraph and go to Format | Paragraph... | 
Indents & Spacing | Indent (or right-click | Paragraph... | Indents & 
Spacing | Indent.)

o Increase "Before text" to a suitable value.

Alternatively you can modify not the paragraph but the paragraph 
style, by going to right-click | Edit Paragraph Style... | Indents & 
Spacing | Indent instead.  This will affect all paragraphs with the 
same style, and you can easily apply the style at a stroke to other 
paragraphs as required later.


There is a default paragraph style called "Text body indent" which may 
serve your purpose.
o Go to Format | Styles and Formatting or press the Styles and 
Formatting button in the Formatting toolbar or press F11.

o Select the Paragraph Styles button in the Styles and Formatting window.
o Put the cursor in the relevant paragraph and double-click "Text body 
indent".
You can easily modify this style if the amount of indent doesn't serve 
your purpose.


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

Re: [libreoffice-users] A neat feature (base and related font sizes)

[Tim Deaton]

Sounds interesting.  But where do you set the BASE font size?

-- Tim
===

On 8/20/2013 1:37 PM, Virgil Arrington wrote:
I always enjoy finding a new feature in LO, one that I never knew 
existed. That recently happened to me as was playing with paragraph 
styles.


One of the features I have always liked about LaTeX is the way in 
which the size of its headings fonts is tied to its base font with 
designations such as "Large" "Larger" and "Huge." If you increase the 
size of the base font, the size of the headings increases 
correspondingly.


I never thought this could be done with LO as font sizes are expressed 
in exact point sizes. Thus, if I increased the size of my default font 
from 11 to 12 points, I thought I had to increase my headings, say, 
from 16 to 18 points.


But...

I recently discovered that the font sizes of heading styles can 
expressed, not only in points, but as a percentage of the default font 
size.


Let's say the base font size of your text font is 11 points and you 
want your headings to be twice the size. Instead of setting the 
headings style to 22 points, you can actually type 200% in the point 
size box. It will then always be twice the size of your base font size 
no matter what size you set the base font. (Make sure you do this in 
the Styles formatting dialogs and not in the direct formatting dialogs.)


I often change between fonts, some of which look best at 11 points 
(Century, Palatino) and some at 12  points (Times, Goudy Old Style). 
Now, I can change the base font size knowing that my headings will 
change correspondingly.


Just thought I'd share this for others who may be interested in a 
feature that may go unnoticed.


Virgil






--
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: Can't find setting

[Paul]

On Tue, 20 Aug 2013 20:01:57 -0400
Virgil Arrington  wrote:

> I think there is a difference between a style for submitting a 
> manuscript to a publisher and a style for final publication. I 
> understand many publishers want manuscripts submitted in double
> spaced type, which they would never use when actually publishing the
> book. Our discussion has been more about good final product than
> initial submissions.

True, but with that we've moved quite far from the discussion about
what LO can and cannot do. As far as I can see, these
standards/conventions are about:
   font size
   line spacing
   margins
   paragraph indentation
   inter-word and inter-sentance spacing.

I realise LO can't be all things to all people, but what I've
understood so far as that LO can do all but the last point. With
justified text that last point may not be relevant, and it may not be a
good convention for final product, but for some people it will still be
relevant, and they should ideally have the choice. Is this something
that can be added to LO? Should there be an enhancement request for
this? Are there other points that need to be addressed in addition to
those listed so far? Has someone tested a regex search/replace for this
as a workaround (I think someone tried something that didn't work, but
it wasn't a regex)?

Just my R0.02

Paul

-- 
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: Can't find setting

[Virgil Arrington]

On 08/20/2013 06:01 PM, William Wells wrote:

While there is no ISO or equivalent, there are a lot of
wannabe:

In the US:  The "real" expert (in the US) on this subject
seems to be
the Chicago Manual of Style.  It sets forth what Publishers
desire/want/will not accept unless it complies with
regarding submissions.

Brits have The Cambridge Handbook for Editors, Authors and
Publishers among others, and the EU has its own Style Manual

Oh, and for students, there is the "Elements of Style".


There are Academic Styles, Styles for Medical writing ad
nauseum.


So, the devs could lose many hours sleep trying to
generate a program to cover all eventualities.
   




I think there is a difference between a style for submitting a 
manuscript to a publisher and a style for final publication. I 
understand many publishers want manuscripts submitted in double spaced 
type, which they would never use when actually publishing the book. Our 
discussion has been more about good final product than initial submissions.


Virgil

--
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 and Linux/KDE shutdown

[Girvin R. Herr]

Greetings.
LO 3.6.6.2, Slackware 14.0, KDE 4.8.5, Linux k3.2.29.

In the past, with KDE3, I was able to leave LO and many files open when 
I shut down the desktop for the day.  Then when I started up the next 
time, LO ran and opened all the files I left open when I shut down.  
This was very handy for keeping oft-used files active on the desktop.  
Once in a while, when starting up, the restore manager would insist on 
restoring these files, but it wasn't the norm.


I have upgraded to KDE4 and ever since, *every* time I start up again, 
the restore manager wants to "restore" all these once-open files, which 
can take a while to process, since some are a bit lengthy.  I just tried 
to "cancel" the restoration, since I knew all of the files were saved 
when I shut down.  In the past, this worked and LO continued to open the 
files as when they were shut down. However, this time, none of the files 
were opened and I had to manually go through the list in my mind and 
open them.  Hopefully, I didn't miss any.


It seems to be connected with the auto-save process, since starting up, 
shutting down immediately, and restarting, does not bring up the restore 
manager.  That implies that some time must elapse before the restore 
manager "flag" is set, which is probably one or more auto-saves.  The 
most obvious possible solution is to disable the auto-save process.  But 
that seems radical for such a worthwhile process.


Is this a configuration issue, a known problem, a bug with KDE4, or what?

Thanks in advance.
Girvin Herr


--
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] print drivers?

[Girvin R. Herr]

LO 3.6.7, Slackware 14.0, KDE 4.8.5, Linux k3.2.29.

I have never seen the "quickstarter" installed.  However, in the past, I 
have left LO running with many open files when I shut down for the day.  
The next time I start up, LO and the left-open files were reloaded as it 
was when I shut down.  This may be a KDE thing.


That said, I am now having a problem with this "feature" and am going to 
open a new thread on it to see if anyone on this forum has an idea how 
to solve it.

Girvin Herr



On 08/20/2013 12:32 PM, Tom Davies wrote:

Hi :)
The Microsquish thing is "Quick Launcher" and i think they copied it from KDE.  
Could be wrong though.

The Quick Starter puts OpenOffice/LibreOffice open in the system tray (in Windows). 
 Not completely sure what, if anything, it does in Gnu&Linux or Mac

Regards from
Tom :)







From: Robert Holtzm 
To: users@global.libreoffice.org
Sent: Tuesday, 20 August 2013, 20:06
Subject: Re: [libreoffice-users] print drivers?


On Tue, Aug 20, 2013 at 03:16:25PM +0100, Tom Davies wrote:

Hi :)
Yes, LO can be installed alongside AOO but not by a straight forwards install 
of both.


You need to make sure the QuickStarter is switched off and that they are not 
opened at the same time as each other.  Various other technical issues also 
need to be taken care of.

QuickStarter? Isn't that M$ or am I wrong?



There is a guide

https://wiki.documentfoundation.org/Installing_in_parallel

Much obliged for the link.

--
Bob Holtzman
Your mail is being read by tight lipped
NSA agents who fail to see humor in Doctor
Strangelove
Key ID 8D549279

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

[libreoffice-users] how to stop text resizing with window

[Dave Howorth]

I just imported and opened a CSV file into calc. When I resize the
window, instead of being able to see more columns, the text displayed in
the cells increases in size and I see exactly the same columns. I've
never seen this happen before. How/why did it happen and how do I make
it keep the font size constant and show me more columns? Looking in the
help and searching the web haven't helped me.

TIA, Dave


-- 
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: Can't find setting

[William Wells]

While there is no ISO or equivalent, there are a lot of 
wannabe:  

In the US:  The "real" expert (in the US) on this subject 
seems to be 
the Chicago Manual of Style.  It sets forth what Publishers 
desire/want/will not accept unless it complies with 
regarding submissions.  

Brits have The Cambridge Handbook for Editors, Authors and 
Publishers among others, and the EU has its own Style Manual

Oh, and for students, there is the "Elements of Style".


There are Academic Styles, Styles for Medical writing ad 
nauseum.  


So, the devs could lose many hours sleep trying to 
generate a program to cover all eventualities.  
  



-- 
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] Package libobasis4.1-ogltrans-4.1.0.4-4.i586.rpm is not signed

[Tim Lloyd]

Hi Francesca,

Wow - Fedora 12. Any particular reason for using that version? It is 
getting a bit old :)


I gather*"yum --nogpgcheck install *.rpm"* should work around this. No 
personal experience just what linuxquestions.org told me.


As Tom points out, you don't need to hop down to desktop-integration 
with 4.1. The rpm should be in the same folder as the other RPMs. The 
doco is out of date


Cheers


On 08/20/2013 11:06 PM, Francesca Milanini wrote:

Hi, on Fedora 12, when I try to install LibreOffice

[user@hostname RPMS]$ su -c 'yum install *.rpm'

returns

" Package libobasis4.1-ogltrans-4.1.0.4-4.i586.rpm is not signed "

So I cannot continue: (cd desktop-integration...).
Could you give suggestion? Thank you, Francesca




--
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 can I make Tab and Shift+Tab tab multiple lines.

[Brian Barker]

At 12:10 20/08/2013 -0700, Wyatt Biker wrote:
The Tab key indents single lines only. But when I highlight a few 
lines and press Tab I would like it if a tab was added to every 
line. Also Shift+Tab should delete the tab.


Whenever you use software, you need to play along with it, not fight 
with it to try to achieve what you need.  Are you perhaps thinking of 
your word processor as a glorified typewriter?  If you add a tab 
character at the beginning of a number of lines of a paragraph, you 
would get a mess: what had previously been at the start of each line 
would no longer be so and your new gaps would be in unpredictable 
places, not at the beginning of lines.  In any case, when you later 
modified the text of the paragraph, once again a mess would ensue.


The few lines you want to indent will probably be a paragraph.
o Put the cursor into the paragraph and go to Format | Paragraph... | 
Indents & Spacing | Indent (or right-click | Paragraph... | Indents & 
Spacing | Indent.)

o Increase "Before text" to a suitable value.

Alternatively you can modify not the paragraph but the paragraph 
style, by going to right-click | Edit Paragraph Style... | Indents & 
Spacing | Indent instead.  This will affect all paragraphs with the 
same style, and you can easily apply the style at a stroke to other 
paragraphs as required later.


There is a default paragraph style called "Text body indent" which 
may serve your purpose.
o Go to Format | Styles and Formatting or press the Styles and 
Formatting button in the Formatting toolbar or press F11.

o Select the Paragraph Styles button in the Styles and Formatting window.
o Put the cursor in the relevant paragraph and double-click "Text body indent".
You can easily modify this style if the amount of indent doesn't 
serve your purpose.


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

Re: [libreoffice-users] print drivers?

[Tom Davies]

Hi :)
The Microsquish thing is "Quick Launcher" and i think they copied it from KDE.  
Could be wrong though.  

The Quick Starter puts OpenOffice/LibreOffice open in the system tray (in 
Windows).  Not completely sure what, if anything, it does in Gnu&Linux or Mac

Regards from 
Tom :)  





>
> From: Robert Holtzm 
>To: users@global.libreoffice.org 
>Sent: Tuesday, 20 August 2013, 20:06
>Subject: Re: [libreoffice-users] print drivers?
> 
>
>On Tue, Aug 20, 2013 at 03:16:25PM +0100, Tom Davies wrote:
>> Hi :)
>> Yes, LO can be installed alongside AOO but not by a straight forwards 
>> install of both.  
>> 
>> 
>> You need to make sure the QuickStarter is switched off and that they are not 
>> opened at the same time as each other.  Various other technical issues also 
>> need to be taken care of.  
>
>QuickStarter? Isn't that M$ or am I wrong?
>
>> 
>> 
>> There is a guide 
>> 
>> https://wiki.documentfoundation.org/Installing_in_parallel
>
>Much obliged for the link.
>
>-- 
>Bob Holtzman
>Your mail is being read by tight lipped 
>NSA agents who fail to see humor in Doctor 
>Strangelove 
>Key ID 8D549279
>
>-- 
>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

[libreoffice-users] How can I make Tab and Shift+Tab tab multiple lines.

[wyattbiker]

The Tab key indents single lines only. But when I highlight a few lines and
press Tab I would like it if a tab was added to every line. Also Shift+Tab
should delete the tab. 


Thanks!



--
View this message in context: 
http://nabble.documentfoundation.org/How-can-I-make-Tab-and-Shift-Tab-tab-multiple-lines-tp4070836.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] print drivers?

[Robert Holtzm]

On Tue, Aug 20, 2013 at 03:16:25PM +0100, Tom Davies wrote:
> Hi :)
> Yes, LO can be installed alongside AOO but not by a straight forwards install 
> of both.  
> 
> 
> You need to make sure the QuickStarter is switched off and that they are not 
> opened at the same time as each other.  Various other technical issues also 
> need to be taken care of.  

QuickStarter? Isn't that M$ or am I wrong?

> 
> 
> There is a guide 
> 
> https://wiki.documentfoundation.org/Installing_in_parallel

Much obliged for the link.

-- 
Bob Holtzman
Your mail is being read by tight lipped 
NSA agents who fail to see humor in Doctor 
Strangelove 
Key ID 8D549279

-- 
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: how do I contact thelist owner?

[anne-ology]

   Send your question to users@global.libreoffice.org



On Tue, Aug 20, 2013 at 1:21 PM, Dave Howorth  wrote:

On Tue, 2013-08-20 at 12:58 -0500, anne-ology wrote:
> >#1 - you're subscribed to this list - otherwise, you're e-mails
> > would not be posted;
>
> Hi, thanks for replying. I'm sending this message (and the previous one)
> to both you and to users+ow...@global.libreoffice.org  because I not
> able to subscribe to users@global.libreoffice.org  But I just got a
> rejection message from users+ow...@global.libreoffice.org with the
> subject "Post to users@global.libreoffice.org denied: Re: how do I
> contact thelist owner?". But I didn't send any message to
> users@global.libreoffice.org ??
>
> So when you say "you're subscribed to this list", which list do you
> mean? The users list or the owners list? And what are subscribers to
> that list seeing, since I just get
>
> "The message from  with subject "Re: how do I
> contact thelist owner?" was unable to be delivered to the list"
>
> >#2 - what error messages?; I only respond to those I think I
> > can help - all other messages, I skip over -
> > although at times I will read to learn more re. these
> > machines;
>
> I want to post to users@global.libreoffice.org about a problem I'm
> having with libreoffice. I don't really want to post that question until
> I'm subscribed to the correct list so everybody will see it.
>
> >#3 - this list is composed of volunteers who appreciate this
> > program(s) and are willing to help each other;
> >
> > some are paid with various computer companies, but ...
> >
> >#4 - Just use nice language and someone in the know should
> > respond to you anon;
>
> Right, yes, I understand how this all works (if I can get it to work). I
> spend time on the opensuse lists helping out.
>
> > if no one does, then it's probably a question no one
> > knows  ;-)
>
> Well, hopefully somebody knows how to subscribe. And hopefully somebody
> will be able to answer my real question. I just need to subscribe!
>
> Is there an archive?
>
> Cheers, Dave
>
>

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

What does it take to become an LO dev; was: Fw: [libreoffice-users] Re: Battle of the Office Suites: Microsoft Office and LibreOffice Compared

[Tom Davies]

Hi :)
I feel like singing something from "Gilbert and Sullivan" (prolly mis-seplt 
that)  "and is the very model of an ..." or the lumberjacks song from Monty 
Python.  


Luckily voice doesn't carry very well over text-based communications and also 
luckily i can't remember many (or any?) of the words.  


I think it's fairly easy to join the devs but there is some support for noobs, 
such as the "Easy Hacks" page so people can try out a bit of coding first and 
then get advice from a mentor.  If the code is good enough it might be put 
forwards but it might take a few times before the noobs writes code that is 
really good enough for that.  Once put forwards the wider group is likely to be 
able to have a look and make comments if they feel the need.  Then there are 
various testing phases before the coding gets into the main branch and if the 
coding makes it through all that then there are various stages of alpha and 
then beta testing.  


So the question is less about what are the requirements of the person and more 
about what are the requirements for the quality of the code they write.  


Anyone can become an LO dev but only the truly heroic can get their coding into 
common usage.  

Regards from 
Tom :)  







>
>       What are the requirements to become an LO developer?
>
>
>       I don't know about LO, but with R (www.r-project.org), anyone can 
>contribute a package to enhance the basic language.  If you want to 
>change a feature of the core language, you need to work with the core 
>developers, convince at least one of them that your proposed change 
>would be an enhancement, and that it's worth that person's time to 
>implement it.  The latter can be facilitated by providing working code 
>that passes all the standard checks.
>
>
-- 
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] A neat feature

[Virgil Arrington]

I always enjoy finding a new feature in LO, one that I never knew 
existed. That recently happened to me as was playing with paragraph styles.


One of the features I have always liked about LaTeX is the way in which 
the size of its headings fonts is tied to its base font with 
designations such as "Large" "Larger" and "Huge." If you increase the 
size of the base font, the size of the headings increases correspondingly.


I never thought this could be done with LO as font sizes are expressed 
in exact point sizes. Thus, if I increased the size of my default font 
from 11 to 12 points, I thought I had to increase my headings, say, from 
16 to 18 points.


But...

I recently discovered that the font sizes of heading styles can 
expressed, not only in points, but as a percentage of the default font size.


Let's say the base font size of your text font is 11 points and you want 
your headings to be twice the size. Instead of setting the headings 
style to 22 points, you can actually type 200% in the point size box. It 
will then always be twice the size of your base font size no matter what 
size you set the base font. (Make sure you do this in the Styles 
formatting dialogs and not in the direct formatting dialogs.)


I often change between fonts, some of which look best at 11 points 
(Century, Palatino) and some at 12  points (Times, Goudy Old Style). 
Now, I can change the base font size knowing that my headings will 
change correspondingly.


Just thought I'd share this for others who may be interested in a 
feature that may go unnoticed.


Virgil



--
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] Impress: Sound Links

[Dave Liesse]

Thanks, Joaquin.  I did look at the Guide, but it must have been a 
different version; the instructions weren't as specific.  Or, looking 
again at your quote, it might have been in a different section 
(principle is the same, but I'm doing a transition, not inserting a 
media file -- the section on transitions does talk about linking to the 
files, but doesn't say anything about putting them in the same directory).


Brian, I had some issues with testing -- trust me, I did try!  Had to do 
with available machines more than anything else (and the fact that I was 
doing it at home while all my disks are at the office).


Dave


On 8/20/2013 02:56, Joaquín Lameiro wrote:

Hi.

I have excerpt this parragraph from the LibreOffice Impress Guide at 
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Impress_Guide:


"Impress
only links media files and does not embed a media file into a
presentation. Therefore if a presentation is moved to a different
computer, any links will be broken and the media files will not play.
To prevent this from happening:
1. Place any media files which are included in a presentation in the 
same folder where the presentation is stored.
2. Insert the media file in the presentation.
3. Send both the presentation and any media files to the computer which is 
to be used for the presentation and place both files in the same folder on that 
computer."

So, it works as both Brian and Dave had already deduced. As long as you keep 
everything in the same folder (or in the root of the CD), there should be no 
problem. I suppose you also can put the sound files in a sub-folder, so 
everything would be more tidy.
Regards,
Joaquín




  De: Brian Barker 
Para: users@global.libreoffice.org
Enviado: Martes 20 de agosto de 2013 8:25
Asunto: Re: [libreoffice-users] Impress: Sound Links
  


At 22:37 19/08/2013 -0700, Dave Liesse wrote:

Well, it was a kick in the teeth to learn that sounds are only
linked instead of being imbedded in the presentation, but at least
that'll keep the size down.  My question, though, is whether the
links use absolute or relative paths.

It's a simple job to test this, of course - and the answer appears to
be relative.


I put together a presentation that's for distribution via DVD, and
of course I have no idea in advance what drive letter any given
recipient will have.  I have no problem with putting the sound files
on the disk, but need to know what type of pathing is being
used.  If it's relative, I'm already in good shape; if it's
absolute, then I'm hosed.

This kinda makes it impossible to distribute a slide show
electronically, as well, if you want sound with it.

Surely all you need to do is to put your audio file in the same
folder as your presentation when you insert it, and to require your
correspondents to have both files in the same folder - wherever that
might be - before attempting to use them?

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

Re: [libreoffice-users] Problems with line color in Writer

[Tom Davies]

Hi :)
Search&replace (doubt it will work but one never knows).  There is an Extension 
that adds a lot of functionality tot he default search&replace (or completely 
replaces it i'm not sure).  

How about 

Tools - Options - Appearance

Does it appear to have the same colour as the new lines in one of the options?  
Does changing that change the colours back?  

How about renaming your User Profile?  
https://wiki.documentfoundation.org/UserProfile

Regards from 
Tom :)  







>
> From: jnrigg 
>To: users@global.libreoffice.org 
>Sent: Monday, 19 August 2013, 8:37
>Subject: [libreoffice-users] Problems with line color in Writer
> 
>
>I have an older document that has worked well for years. It is a listing of
>Library book titles of authors that I am interested in. As I check out a
>book I use the "line" function to draw a line through the book title.
>
>The line (in a sense I am using it as an "overstrike") has always been
>black. My pages now have several hundred book titles with lines drawn
>through them (and many more that are, as yet, unread and thus have no line).
>
>Recently when I opened the document, all of the lines have changed from
>black to a light blue color. I do not know why they have changed from black
>to blue. I know that I can change the line color back to black but, so far,
>I have only found how to do it one line at a time. Since there are hundreds
>of titles with lines drawn through them, it will take me weeks to return all
>of the drawn lines to black.
>
>Is there some way to convert *all* of the lines back to black in one easy
>process?
>
>jnr 
>
>
>
>--
>View this message in context: 
>http://nabble.documentfoundation.org/Problems-with-line-color-in-Writer-tp4070575.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] Silent install with only Writer and Calc

[Tom Davies]

Hi :)
I don't think it's really possible.  If you do manage it then the saving on 
drive-space and other resources is almost minimal.  LibreOffice is much more 
tightly integrated than MS Office and really doesn't work the same way at all.  

It's not a collection of different programs but is instead a central core with 
different surfaces added on top.  When using the different surfaces we think of 
them as different programs.  We call the different surfaces "modules" and one 
module is "Writer".  

If you want 2 programs that are compatible with LibreOffice and use both the 
Doc/DocX type formats of MSO and the ODFs of everyone else (plus recent 
versions of MSO now) then you might like "Gnome Office"
http://www.abisource.com/
https://projects.gnome.org/gnumeric/
Note that both together might have a smaller foot-print than LO or anything 
else but Gnumeric is possibly better than Excel or Calc in many ways.  
Operating Systems designed for tiny or ancient machines often include them 
instead of LO but so do OSes that want to be very fast and light.  

Regards from 
Tom :)  






>
> From: jmsms 
>To: users@global.libreoffice.org 
>Sent: Tuesday, 20 August 2013, 17:07
>Subject: [libreoffice-users] Silent install with only Writer and Calc
> 
>
>Hi,
>
>I'm trying to do a silent install (on Windows) with only Writer and Calc but
>I can't find anything to do that.
>When I tried to add the command line REMOVE=gm_p_Draw_bin to
>msiexec /i  "c:\LibreOffice_4.0.4_Win_x86.msi" ADDLOCAL=ALL
>REMOVE=gm_p_Draw_bin /passive
>it does not work.
>I also tried to remove the components I don't want in the msi file with ORCA
>program but a feature error appears installing it.
>
>Is anyone  made it?
>
>JM
>
>
>
>--
>View this message in context: 
>http://nabble.documentfoundation.org/Silent-install-with-only-Writer-and-Calc-tp4070814.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] Re: treatment of blank cells

[Tom]

Hi :)
The list doesn't accept attachments so i have uploaded the screen-shot to
Nabble
Screenshot.png
  

So, it's an Xfce "Desktop Environment" so probably a Gnu&Linux (rather than
Bsd or Mac) and we know the LO version is 3.4.5.  

Errr, i'm stuck now!  
Regards from 
Tom :)  



--
View this message in context: 
http://nabble.documentfoundation.org/treatment-of-blank-cells-tp4070670p4070816.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] Silent install with only Writer and Calc

[jmsms]

Hi,

I'm trying to do a silent install (on Windows) with only Writer and Calc but
I can't find anything to do that.
When I tried to add the command line REMOVE=gm_p_Draw_bin to
 msiexec /i  "c:\LibreOffice_4.0.4_Win_x86.msi" ADDLOCAL=ALL
REMOVE=gm_p_Draw_bin /passive
 it does not work.
I also tried to remove the components I don't want in the msi file with ORCA
program but a feature error appears installing it.

Is anyone  made it?

JM



--
View this message in context: 
http://nabble.documentfoundation.org/Silent-install-with-only-Writer-and-Calc-tp4070814.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] LO Calc crashes

[Tom Davies]

Hi :)
I wouldn't say that either is "best".  It entirely depends on situations and 
specific requirements.  

Both covers the large middle ground really well but each has it's niche areas 
where it's marginally better than the other.  

Apache OpenOffice develops more slowly so known bugs stay longer and fewer new 
surprises occur.  So, once you find a bug there you can be fairly sure it will 
be in the next several releases.  That means AOO is "more stable".  One 
advantage with that is that if you know a work-around for some annoyance then 
that keeps working too.  

LO just fixes a lot of those problems but doing so might sometimes create new 
ones (which also then largely get fixed).  However, that does mean there might 
be some surprises.  To get around that LO actively develops 2 branches.  One 
"more stable" and the other with more new features.  


In both the 3rd digit in the version number is roughly the same as the "Service 
Pack" number in MS software, except that we go a lot higher.  

So i have most machines at work on a x.x.5 (ish) and wont install anything 
earlier than a x.x.3.  My own 2  work machines keep leapfrogging each other but 
soemtimes return to a previous version or to the one installed on the other 
machines.  I keep meaning to test-drive the very earliest releases of new 
branches but rarely do and even if i do never find any problems because i just 
don't need anything even vaguely advanced.  

My dad now lives on  a boat which is often out of range of "the internet" so i 
would probably give him AOO, or an LO version such as "higher than x.x.5"

Regards from 
Tom :)  





>
> From: Kunwar Shivpal Singh 
>To: "users@global.libreoffice.org"  
>Sent: Tuesday, 20 August 2013, 13:35
>Subject: Re: [libreoffice-users] LO Calc crashes
> 
>
>Thanks for putting all doubts to rest.
>
>Shifted from MS Office to Open Office in 2010 & then a friend of mine 
>suggested LO said better than OO.
>
>Working on LO now since 2011 - 12. Never faced any problem till date. 
>Few petty ones (to do with settings) which I could manage through help & 
>minor adjustments.
>
>Thanks.
>
>Waiting for the next launch.
>
>regards
>
>
>
>On 20-08-2013 17:07, Tom Davies wrote:
>> Hi :)
>> LibreOffice develops so fast that by the time most other software 
>> would be releasing updates and patches LO is releasing a new version.  
>> The next version in the same branch tends to be just bug-fixes but in 
>> the newer branch you get bug-fixes and new features (although those 
>> new features may have introduced unexpected new problems or unearthed 
>> old ones that had previously been hidden.
>>
>> So although you don't get a splattering of bug-fixes, patches and 
>> security patches you do get a very much smoother of the entire program.
>> Regards from
>> Tom :)
>>
>>
>>     
>>     *From:* Dave Barton 
>>     *To:* users@global.libreoffice.org
>>     *Cc:* Kunwar Shivpal Singh 
>>     *Sent:* Tuesday, 20 August 2013, 11:39
>>     *Subject:* Re: [libreoffice-users] LO Calc crashes
>>
>>     Please address any reply to the users@global.libreoffice.org
>>      list, not
>>     directly to me. There are many knowledgeable subscribers to this list,
>>     who may be able to provide better answers than myself.
>>
>>     My responses are given in-line with your original message.
>>
>>      Original Message 
>>     From: Kunwar Shivpal Singh >     >
>>     To: Dave Barton mailto:d...@tasit.net>>
>>     Date: Tue, 20 Aug 2013 11:11:07 +0530
>>     > Thanks Dave,
>>     >
>>     > but as already mentioned in my mail, I am just a user not very tech
>>     > savvy to understand all this. I feel it is ultimately users like me
>>     > who will count & are the final segment where LO has to be
>>     propogated.
>>
>>     Other than being subscribed to this mailing list (see:
>>    https://www.libreoffice.org/get-help/mailing-lists/), my status is no
>>     different to yours (ie. an ordinary user of the software).
>>
>>     > I request if you could guide me on how to fix this problem.
>>
>>     At this time there is no work-around (what you call "fix") for this
>>     issue, that I could suggest to you.
>>
>>     > Went to the link given in your mail. From there to another which
>>     said
>>     > fixed by Coalan Mcnamara, but could make head or tail of all that.
>>
>>     The link to "Bugzilla" gave you, is where the project records and
>>     monitors software issues and RFE (Requests For Enhancement). Coalan is
>>     one of the project's leading developers and the "fixed" tag indicates
>>     that he has worked on and resolved this issue. After "peer review" the
>>     "fix" will be included in the next update/release of the software.
>>
>>     > Does'nt Lo send updates to set such things right or anything which
>>     > ordinary users 

Re: [libreoffice-users] Re: treatment of blank cells

[Gregory Smith - Oracle Sparc Verification]

TomThanks for trying to help out.I have attached a screen grab of
  my Formula sub-menu that just doesn't have the option you refer
  to.I have went through every menu of the options for calc and
  found nothing about this!gsOn 08/20/13 10:10, Tom Davies wrote:
Hi :)Err are you using a Mac?If so the menus are very different.It'sLibreOffice 
- Preferences - blahinstead ofTools - Options - blahHmmm, on Ubuntu 12.04 with 
LO 4.0.2 I only get theTools - Options - LibreOffice Calcoption if i have a 
spreadsheet open in LibreOffice.A blank
"new" spreadsheet is fine.Then i have to click the "Detail"
button in the middle section of the "Formula" page to get the
option to tick the "Treat empty string as zero" line.There's
only 2 lines in that pop-up so it's not easy to get it wrong!
;)It seems like a bit of a faff trying to find the place but i'm
not sure if there is anywhere that would be better.I get the
feeling that either they are going to add more options in there
or else that section is going to be merged with something.Change is 
likely in future releases but which way is unclear
from the UI right now.Regards fromTom :)
From:Gregory Smith - Oracle Sparc 
Verificationgreg.a.smith@oracle.comTo:mariosvmariosv@miguelangel.mobiCc:users@global.libreoffice.orgSent:Tuesday,
 20 August 2013, 15:14Subject:Re: [libreoffice-users] Re: treatment of blank 
cells
that sounds like it would work, but my options menu
  does not have thatsetting!I am using v3.4.5gsOn 08/19/13 
15:51, mariosv wrote:Maybe this option can help:Menu/Tools/Options/LibreOffice
  calc/Formula/Detailed calculationsettings/Custom/Treat empty 
string as zero--View this message in 
context:http://nabble.documentfoundation.org/treatment-of-blank-cells-tp4070670p4070674.htmlSent
 from the Users mailing list archive at
  Nabble.com.--To unsubscribe e-mail to: 
users+unsubscribe@global.libreoffice.orgProblems?http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/Posting
 guidelines + more:http://wiki.documentfoundation.org/NetiquetteList 
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] Old zoom with mouse wheel bug

[Tom Davies]

Hi :)
Even better if 1 single comment can give a number of different versions where 
it doesn't work.  

From reading the QA page ages ago i vaguely remember there is something 
contra-intuitive about what the devs find most helpful.  Intuitively i would 
have thought that the first occurrence of the regression is the most useful 
version to know of.  However, giving them both lets them sort it out or at 
least helps them get closer.  

Regards from 
Tom :)  





>
> From: Krunoslav Šebetić 
>To: 
>Cc: "users@global.libreoffice.org"  
>Sent: Tuesday, 20 August 2013, 13:54
>Subject: Re: [libreoffice-users] Old zoom with mouse wheel bug
> 
>
>https://bugs.freedesktop.org/show_bug.cgi?id=54047
>
>It's affecting 4.0.4.2 too...
>
>On 08/20/2013 02:46 PM, Tom Davies wrote:
>> Hi :)
>> Yes, a comment would help.
>>
>> Generally, if the bug has not already been confirmed it might help to 
>> add a new comment saying that you can reproduce the bug.  Let them 
>> know the version of LO (4.2.0 alpha?) and the OS (eg Xp, Win7, Ubuntu 
>> 12.04, or whatever).
>>
>> With the early stages of a new branch it is incredibly useful to add a 
>> comment in bug reports if a regression has occurred.  The earlier the 
>> better as it might help the devs deal with it quickly while the code 
>> that caused it is still fresh.
>>
>> Regards from
>> Tom :)
>>
>>
>>
>>
>>     
>>     *From:* Krunoslav Šebetić 
>>     *To:* users@global.libreoffice.org
>>     *Sent:* Tuesday, 20 August 2013, 12:58
>>     *Subject:* [libreoffice-users] Old zoom with mouse wheel bug
>>
>>     Hi,
>>
>>     I still can reproduce bug at
>>    https://bugs.freedesktop.org/show_bug.cgi?id=54047#add_comment on
>>     LO 4.2.0.0.alpha0+ Build ID:
>>     784cfa382be438240dfc936b7551c5012aada9ae; and it bugs me :) Should
>>     bug on that link be changed, or new one should be reported?
>>
>>     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
>>
>>
>
>
>-- 
>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

[Solved] Re: [libreoffice-users] LO WRITER BASIC : inserting a table using the dispatcher

[Tom Davies]

Hi :)
WoooHooo!!  Congrats on solving this one and thanks for posting the answer back 
to the list!  That might well help other people in the future or at least make 
the answer a bit easier to find.  


Thanks, congrats and regards from
Tom :)  






>
> From: Alain Van Utterbeeck 
>To: users@global.libreoffice.org 
>Sent: Tuesday, 20 August 2013, 14:18
>Subject: Re: [libreoffice-users] LO WRITER BASIC : inserting a table using the 
>dispatcher
> 
>
>I googled for a couple of hours to find this for a similar problem:
>'probably this is due to the sometimes asynchroneous nature of the 
>dispatch calls, try inserting a wait command'
>
>So I changed the start of the code to:
>
>                 if chapters.getBoolean(6) then
>                     wait(120)
>                     args4(0).Name = "TableName"
>                     ...
>
>and that solved my problem !
>
>Thanks to all that helped me in getting my macro to work,
>
>Greetings,
>Alain
>
>
>On 20-08-13 11:56, Alain Van Utterbeeck wrote:
>> Hello,
>>
>> I have the following code in a macro:
>>
>>                 if chapters.getBoolean(6) then
>>                     args4(0).Name = "TableName"
>>                     args4(0).Value = "Tabel1"
>>                     args4(1).Name = "Columns"
>>                     args4(1).Value = 3
>>                     args4(2).Name = "Rows"
>>                     args4(2).Value = 2
>>                     args4(3).Name = "Flags"
>>                     args4(3).Value = 11
>>                     dispatcher.executeDispatch(document, 
>> ".uno:InsertTable", "", 0, args4())
>>                     args1(0).Name = "Text"
>>                     args1(0).Value = "Product"
>>                     dispatcher.executeDispatch(document, 
>> ".uno:InsertText", "", 0, args1())
>>                     dispatcher.executeDispatch(document, 
>> ".uno:JumpToNextCell", "", 0, Array())
>>                     args1(0).Name = "Text"
>>                     args1(0).Value = "Hoev."
>>                     dispatcher.executeDispatch(document, 
>> ".uno:InsertText", "", 0, args1())
>>                     dispatcher.executeDispatch(document, 
>> ".uno:JumpToNextCell", "", 0, Array())
>>                     args1(0).Name = "Text"
>>                     args1(0).Value = "Prijs"
>>                     dispatcher.executeDispatch(document, 
>> ".uno:InsertText", "", 0, args1())
>>                     sale_order_lines=DBsql4.executeQuery("SELECT name, 
>> product_uom_qty, " + _
>>                                         "(product_uom_qty * 
>> price_unit) AS amount, " + _
>>                                         "(SELECT seq_document from 
>> product_product where product_product.id = sale_order_line.product_id) 
>> AS seq " + _
>>                                         " FROM sale_order_line WHERE " 
>> + _
>>                                         "order_id = " + sale_order_id 
>> + " ORDER BY seq")
>>
>>                     While sale_order_lines.next
>>                         naam=sale_order_lines.getString(1)
>>                         qty=sale_order_lines.getString(2)
>>                         amount=sale_order_lines.getString(3)
>>                         args1(0).Name = "Text"
>>                         args1(0).Value = naam
>>                         dispatcher.executeDispatch(document, 
>> ".uno:JumpToNextCell", "", 0, Array())
>>                         dispatcher.executeDispatch(document, 
>> ".uno:InsertText", "", 0, args1())
>>                         args1(0).Name = "Text"
>>                         args1(0).Value = qty
>>                         dispatcher.executeDispatch(document, 
>> ".uno:JumpToNextCell", "", 0, Array())
>>                         dispatcher.executeDispatch(document, 
>> ".uno:InsertText", "", 0, args1())
>>                         dispatcher.executeDispatch(document, 
>> ".uno:NumberFormatDecimal", "", 0, Array())
>>                         args1(0).Name = "Text"
>>                         args1(0).Value = amount
>>                         dispatcher.executeDispatch(document, 
>> ".uno:JumpToNextCell", "", 0, Array())
>>                         dispatcher.executeDispatch(document, 
>> ".uno:InsertText", "", 0, args1())
>>                         dispatcher.executeDispatch(document, 
>> ".uno:NumberFormatDecimal", "", 0, Array())
>>                     Wend
>>                     mCurs.gotoEnd(False)
>>                 end if
>>
>> The result that I get is:
>>
>>
>>
>> Does anybody have an idea why the dispatcher.executeDispatch(document, 
>> ".uno:JumpToNextCell", "", 0, Array()) is not working?
>>
>> The crazy thing is that if I put a breakpoint on the first line of 
>> this code, and go through it step by step, it works fine  and I get :
>>
>>
>> Another strange thing is that the third column containing the price is 
>> set to 0 while in the first screenprint, if you look closely at the 
>> contents that is completely in the first cell, the prices are not 0 !!!
>>
>> Any ideas ple

Re: [libreoffice-users] Re: Calc =MONTH problem

[Brian Barker]

At 01:10 20/08/2013 -0700, Graham Lovatt wrote:

Eventually got what I wanted by using =TEXT(CG4,"MMM")


Interestingly, this gives a different result from the formatting 
option.  The results look the same, but mine was a formatted date 
(which will be right-aligned by default) and this is an actual text 
string (which will be left-aligned).  But any further calculations on 
these values will differ.  And they will sort differently: January 
dates come before February ones, but "Feb" comes before "Jan".


Horses for courses.

Brian Barker


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

Re: [libreoffice-users] Re: treatment of blank cells

[Tom Davies]

Hi :)
Err are you using a Mac?  If so the menus are very different.  It's 

LibreOffice - Preferences - blah 

instead of 

Tools - Options - blah

Hmmm, on Ubuntu 12.04 with LO 4.0.2 I only get the 

Tools - Options - LibreOffice Calc 

option if i have a spreadsheet open in LibreOffice.  A blank "new" spreadsheet 
is fine.  Then i have to click the "Detail" button in the middle section of the 
"Formula" page to get the option to tick the "Treat empty string as zero" line. 
 There's only 2 lines in that pop-up so it's not easy to get it wrong! ;)  

It seems like a bit of a faff trying to find the place but i'm not sure if 
there is anywhere that would be better.  I get the feeling that either they are 
going to add more options in there or else that section is going to be merged 
with something.  Change is likely in future releases but which way is unclear 
from the UI right now.  

Regards from 
Tom :)  





>
> From: Gregory Smith - Oracle Sparc Verification 
>To: mariosv  
>Cc: users@global.libreoffice.org 
>Sent: Tuesday, 20 August 2013, 15:14
>Subject: Re: [libreoffice-users] Re: treatment of blank cells
> 
>
>that sounds like it would work, but my options menu does not have that 
>setting!  I am using v3.4.5
>
>gs
>On 08/19/13 15:51, mariosv wrote:
>> Maybe this option can help:
>> Menu/Tools/Options/LibreOffice calc/Formula/Detailed calculation
>> settings/Custom/Treat empty string as zero
>>
>>
>>
>> --
>> View this message in context: 
>> http://nabble.documentfoundation.org/treatment-of-blank-cells-tp4070670p4070674.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

[libreoffice-users] Re: Can't find setting

[Denis J Navas]

I mean "can not" and the substitution of which I spoke is what is made by 
the autocorrect feature. 




--
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] Package libobasis4.1-ogltrans-4.1.0.4-4.i586.rpm is not signed

[Tom Davies]

Hi :)  
Is it only the desktop integration packages that you are having trouble with?  

If so then don't bother with them any more!  They have been pulled into the 
main installer! :)  The devs found a way to combine the 2 different ones that 
used to be offered into a single chunk of code so that they could pull it in 
and reduce confusion.  

Regards from 
Tom :)  






>
> From: Francesca Milanini 
>To: users@global.libreoffice.org 
>Sent: Tuesday, 20 August 2013, 14:06
>Subject: [libreoffice-users] Package libobasis4.1-ogltrans-4.1.0.4-4.i586.rpm 
>is not signed
> 
>
>Hi, on Fedora 12, when I try to install LibreOffice
>
>[user@hostname RPMS]$ su -c 'yum install *.rpm'
>
>returns
>
>" Package libobasis4.1-ogltrans-4.1.0.4-4.i586.rpm is not signed "
>
>So I cannot continue: (cd desktop-integration...).
>Could you give suggestion? Thank you, Francesca
>
>-- 
>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] treatment of blank cells

[Tom Davies]

Hi :)
I have quite a few machines on a really old version too but really should 
upgrade soon.  I downloaded the 4.0.4 but now might as well do the 4.0.5 
instead.  

Regards from 

Tom :)  





>
> From: Gregory Smith - Oracle Sparc Verification 
>To: Steve Edmonds  
>Cc: Virgil Arrington ; users@global.libreoffice.org 
>Sent: Tuesday, 20 August 2013, 15:27
>Subject: Re: [libreoffice-users] treatment of blank cells
> 
>
>Sorry, my version is 3.4.5.
>On 08/20/13 04:02, Steve Edmonds wrote:
>> If I put 5,4,,,3,,2,1 in afile.csv and open it in LO3.6 I can then put 
>> the equation =b1*c1 in an empty cell and the result is 0.
>>
>> Do you not get that. What version of LO.
>> steve
>> On 2013-08-20 15:07, greg.a.sm...@oracle.com wrote:
>>> So the cells are the result of opening a .csv file where the string 
>>> has nothing between commas such as
>>>
>>> 5,4,,,3,,2,1
>>> between the consecutive commas is nothing, so the cell should be made 
>>> totally empty.
>>>
>>> gs
>>>
>>> On 8/19/2013 8:22 PM, Steve Edmonds wrote:

 On 2013-08-20 13:02, Virgil Arrington wrote:
> On 08/19/2013 03:10 PM, Gregory Smith - Oracle Sparc Verification 
> wrote:
>>  I am disappointed that Libre Office does not treat blank cells as 
>> a zero in math calculations. I have a dozen spreadsheets from 
>> Excel and Open Office that take advantage of this fact.  Now I get 
>> errors with Libre Office. Going back and retrofitting n(cell 
>> reference) to achieve the translation is a ton of extra work.  Am 
>> I missing something.
>>
>> gs
>>
>>
>
> I'm not sure what you're missing, but my LO spreadsheets always 
> treat blank cells as zeros. I'm not that well versed in 
> spreadsheets, but I've never had the problem you describe.
>
> Virgil 
 I have just tried in LO 3.6 and a blank cell is treated as zero. A 
 cell with text in it such as a space causes an error in 
 calculations. Do you mean that Excel and Open Office treat white 
 space characters as zero.
 Steve

>>>
>>
>>
>
>
>-- 
>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] treatment of blank cells

[Gregory Smith - Oracle Sparc Verification]

Sorry, my version is 3.4.5.
On 08/20/13 04:02, Steve Edmonds wrote:
If I put 5,4,,,3,,2,1 in afile.csv and open it in LO3.6 I can then put 
the equation =b1*c1 in an empty cell and the result is 0.


Do you not get that. What version of LO.
steve
On 2013-08-20 15:07, greg.a.sm...@oracle.com wrote:
So the cells are the result of opening a .csv file where the string 
has nothing between commas such as


5,4,,,3,,2,1
between the consecutive commas is nothing, so the cell should be made 
totally empty.


gs

On 8/19/2013 8:22 PM, Steve Edmonds wrote:


On 2013-08-20 13:02, Virgil Arrington wrote:
On 08/19/2013 03:10 PM, Gregory Smith - Oracle Sparc Verification 
wrote:
 I am disappointed that Libre Office does not treat blank cells as 
a zero in math calculations. I have a dozen spreadsheets from 
Excel and Open Office that take advantage of this fact.  Now I get 
errors with Libre Office. Going back and retrofitting n(cell 
reference) to achieve the translation is a ton of extra work.  Am 
I missing something.


gs




I'm not sure what you're missing, but my LO spreadsheets always 
treat blank cells as zeros. I'm not that well versed in 
spreadsheets, but I've never had the problem you describe.


Virgil 
I have just tried in LO 3.6 and a blank cell is treated as zero. A 
cell with text in it such as a space causes an error in 
calculations. Do you mean that Excel and Open Office treat white 
space characters as zero.

Steve









--
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] treatment of blank cells

[Gregory Smith - Oracle Sparc Verification]

No I don't get zero I get a  or #VALUE! error message.

gs
On 08/20/13 04:02, Steve Edmonds wrote:
If I put 5,4,,,3,,2,1 in afile.csv and open it in LO3.6 I can then put 
the equation =b1*c1 in an empty cell and the result is 0.


Do you not get that. What version of LO.
steve
On 2013-08-20 15:07, greg.a.sm...@oracle.com wrote:
So the cells are the result of opening a .csv file where the string 
has nothing between commas such as


5,4,,,3,,2,1
between the consecutive commas is nothing, so the cell should be made 
totally empty.


gs

On 8/19/2013 8:22 PM, Steve Edmonds wrote:


On 2013-08-20 13:02, Virgil Arrington wrote:
On 08/19/2013 03:10 PM, Gregory Smith - Oracle Sparc Verification 
wrote:
 I am disappointed that Libre Office does not treat blank cells as 
a zero in math calculations. I have a dozen spreadsheets from 
Excel and Open Office that take advantage of this fact.  Now I get 
errors with Libre Office. Going back and retrofitting n(cell 
reference) to achieve the translation is a ton of extra work.  Am 
I missing something.


gs




I'm not sure what you're missing, but my LO spreadsheets always 
treat blank cells as zeros. I'm not that well versed in 
spreadsheets, but I've never had the problem you describe.


Virgil 
I have just tried in LO 3.6 and a blank cell is treated as zero. A 
cell with text in it such as a space causes an error in 
calculations. Do you mean that Excel and Open Office treat white 
space characters as zero.

Steve









--
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] Package libobasis4.1-ogltrans-4.1.0.4-4.i586.rpm is not signed

[Francesca Milanini]

Hi, on Fedora 12, when I try to install LibreOffice

[user@hostname RPMS]$ su -c 'yum install *.rpm'

returns

" Package libobasis4.1-ogltrans-4.1.0.4-4.i586.rpm is not signed "

So I cannot continue: (cd desktop-integration...).
Could you give suggestion? Thank you, Francesca

--
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: treatment of blank cells

[Gregory Smith - Oracle Sparc Verification]

that sounds like it would work, but my options menu does not have that 
setting!  I am using v3.4.5


gs
On 08/19/13 15:51, mariosv wrote:

Maybe this option can help:
Menu/Tools/Options/LibreOffice calc/Formula/Detailed calculation
settings/Custom/Treat empty string as zero



--
View this message in context: 
http://nabble.documentfoundation.org/treatment-of-blank-cells-tp4070670p4070674.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] Re: Can't find setting

[Virgil Arrington]

On 08/19/2013 11:05 PM, Ken Springer wrote:


Hi, Vigil,

So, if I read your message correctly, there is no official "body" that 
sets typographic standards, only general conventions used by most, but 
may not be the best for end user/reader.  Would that be correct?





Not quite.

I agree there is no official body that sets typographic standards, at 
least none of which I am aware. I also agree that there are general 
conventions that are used by most professional typographers. I do *not* 
agree that these conventions "may not be best for the end user/reader."


I honestly believe that one word space between sentences is best for the 
reader. I honestly believe it facilitates the smooth flow of reading.


It might surprise you, but I was a slow convert to the "one space 
between sentences" convention. Like many here, I learned to type on an 
Underwood, with all the conventions that grew up with the typewriter. I 
learned to use 12-point Pica type, set one-inch page margins, indent 
paragraphs one half inch, double space my text, and put two spaces 
between sentences.


When I graduated to a Windows word processor with proportionally spaced 
type, I kept using all of these conventions. After all, after 25 years 
of typing everything the same way, it "looked" right. I then came across 
a series of typography articles that stated that these typing 
conventions were actually deviations from typographic standards. They 
grew as concessions to the fixed-width type of the typewriter and 
letter-sized paper. But, professional typesetters using proportionally 
spaced type typically didn't use the same conventions. When was the last 
time you saw a book set in 12 point type, double spaced lines with 
one-half inch indents?


I started examining the books I read with great reading comfort. *All* 
of them had type smaller than 12 points. *None* of them had double 
spaced lines or half-inch indents. They were *all* single spaced with 
paragraph indents of less than one half inch. And most of them, 
especially those printed after I was born, had only one word space after 
sentence ending punctuation.


So, if everything I learned in typing class was "right," how was it that 
all of these professionally published books got it wrong? More 
importantly, how was it that I was able to read all these books without 
stumbling over the words? They all looked just as "right" as my own 
papers that had been typed using typewriter conventions.


I learned that the typewriter standards were based on the fact that we 
were using letter-sized paper and fixed-width type. You'll notice books 
tend to have much smaller pages. Larger paper means longer text lines, 
which means larger type, and wider line spacing. Fixed-width type also 
requires more definition between paragraphs and sentences, hence 
half-inch indents and two spaces between sentences.


But, now we're beyond the Underwood technology. We're now using 
technology that mimics that of Gutenberg. It's time we left behind the 
shackles of the typewriter and embraced the better technology we can obtain.


For my work, I now use 11-point type, single space my text and use 
paragraph indents of no more than 1/3 inch (2 picas). I set my left and 
right margins at about 1.75 inches (9.5 to 10.5 picas), specifically to 
increase white space in the margins and shorten the length of my lines. 
And, following the example of decades and decades of professionally 
printed books, I put only one word space between sentences.


At first, my new practice looked weird. But, I found that my work now 
resembled that found in a book, instead of that typed on the typewriter. 
Once I began using typesetting standards instead of typewriter 
standards, my eyes grew accustomed to reading text that was properly 
set, with only one space between paragraphs. My eyes adjusted to a 
reading flow that was not interrupted by too much white space after a 
period.


So, while I can appreciate that those accustomed to reading text with 
two sentence ending spaces might resist change, I cannot agree that 
their habits are actually "best" for the reader.


To quote a very old Alka Seltzer commercial, "Try it, you'll like it!"

Virgil

--
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] LO WRITER BASIC : inserting a table using the dispatcher

[Alain Van Utterbeeck]

I googled for a couple of hours to find this for a similar problem:
'probably this is due to the sometimes asynchroneous nature of the 
dispatch calls, try inserting a wait command'


So I changed the start of the code to:

if chapters.getBoolean(6) then
wait(120)
args4(0).Name = "TableName"
...

and that solved my problem !

Thanks to all that helped me in getting my macro to work,

Greetings,
Alain


On 20-08-13 11:56, Alain Van Utterbeeck wrote:

Hello,

I have the following code in a macro:

if chapters.getBoolean(6) then
args4(0).Name = "TableName"
args4(0).Value = "Tabel1"
args4(1).Name = "Columns"
args4(1).Value = 3
args4(2).Name = "Rows"
args4(2).Value = 2
args4(3).Name = "Flags"
args4(3).Value = 11
dispatcher.executeDispatch(document, 
".uno:InsertTable", "", 0, args4())

args1(0).Name = "Text"
args1(0).Value = "Product"
dispatcher.executeDispatch(document, 
".uno:InsertText", "", 0, args1())
dispatcher.executeDispatch(document, 
".uno:JumpToNextCell", "", 0, Array())

args1(0).Name = "Text"
args1(0).Value = "Hoev."
dispatcher.executeDispatch(document, 
".uno:InsertText", "", 0, args1())
dispatcher.executeDispatch(document, 
".uno:JumpToNextCell", "", 0, Array())

args1(0).Name = "Text"
args1(0).Value = "Prijs"
dispatcher.executeDispatch(document, 
".uno:InsertText", "", 0, args1())
sale_order_lines=DBsql4.executeQuery("SELECT name, 
product_uom_qty, " + _
"(product_uom_qty * 
price_unit) AS amount, " + _
"(SELECT seq_document from 
product_product where product_product.id = sale_order_line.product_id) 
AS seq " + _
" FROM sale_order_line WHERE " 
+ _
"order_id = " + sale_order_id 
+ " ORDER BY seq")


While sale_order_lines.next
naam=sale_order_lines.getString(1)
qty=sale_order_lines.getString(2)
amount=sale_order_lines.getString(3)
args1(0).Name = "Text"
args1(0).Value = naam
dispatcher.executeDispatch(document, 
".uno:JumpToNextCell", "", 0, Array())
dispatcher.executeDispatch(document, 
".uno:InsertText", "", 0, args1())

args1(0).Name = "Text"
args1(0).Value = qty
dispatcher.executeDispatch(document, 
".uno:JumpToNextCell", "", 0, Array())
dispatcher.executeDispatch(document, 
".uno:InsertText", "", 0, args1())
dispatcher.executeDispatch(document, 
".uno:NumberFormatDecimal", "", 0, Array())

args1(0).Name = "Text"
args1(0).Value = amount
dispatcher.executeDispatch(document, 
".uno:JumpToNextCell", "", 0, Array())
dispatcher.executeDispatch(document, 
".uno:InsertText", "", 0, args1())
dispatcher.executeDispatch(document, 
".uno:NumberFormatDecimal", "", 0, Array())

Wend
mCurs.gotoEnd(False)
end if

The result that I get is:



Does anybody have an idea why the dispatcher.executeDispatch(document, 
".uno:JumpToNextCell", "", 0, Array()) is not working?


The crazy thing is that if I put a breakpoint on the first line of 
this code, and go through it step by step, it works fine  and I get :



Another strange thing is that the third column containing the price is 
set to 0 while in the first screenprint, if you look closely at the 
contents that is completely in the first cell, the prices are not 0 !!!


Any ideas please?

Thanks in advance for any help...

Greetings,
Alain





--
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] Old zoom with mouse wheel bug

[Krunoslav Šebetić]

https://bugs.freedesktop.org/show_bug.cgi?id=54047

It's affecting 4.0.4.2 too...

On 08/20/2013 02:46 PM, Tom Davies wrote:

Hi :)
Yes, a comment would help.

Generally, if the bug has not already been confirmed it might help to 
add a new comment saying that you can reproduce the bug.  Let them 
know the version of LO (4.2.0 alpha?) and the OS (eg Xp, Win7, Ubuntu 
12.04, or whatever).


With the early stages of a new branch it is incredibly useful to add a 
comment in bug reports if a regression has occurred.  The earlier the 
better as it might help the devs deal with it quickly while the code 
that caused it is still fresh.


Regards from
Tom :)





*From:* Krunoslav Šebetić 
*To:* users@global.libreoffice.org
*Sent:* Tuesday, 20 August 2013, 12:58
*Subject:* [libreoffice-users] Old zoom with mouse wheel bug

Hi,

I still can reproduce bug at
https://bugs.freedesktop.org/show_bug.cgi?id=54047#add_comment on
LO 4.2.0.0.alpha0+ Build ID:
784cfa382be438240dfc936b7551c5012aada9ae; and it bugs me :) Should
bug on that link be changed, or new one should be reported?

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





--
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] LO Calc crashes

[Kunwar Shivpal Singh]

Thanks for putting all doubts to rest.

Shifted from MS Office to Open Office in 2010 & then a friend of mine 
suggested LO said better than OO.


Working on LO now since 2011 - 12. Never faced any problem till date. 
Few petty ones (to do with settings) which I could manage through help & 
minor adjustments.


Thanks.

Waiting for the next launch.

regards



On 20-08-2013 17:07, Tom Davies wrote:

Hi :)
LibreOffice develops so fast that by the time most other software 
would be releasing updates and patches LO is releasing a new version.  
The next version in the same branch tends to be just bug-fixes but in 
the newer branch you get bug-fixes and new features (although those 
new features may have introduced unexpected new problems or unearthed 
old ones that had previously been hidden.


So although you don't get a splattering of bug-fixes, patches and 
security patches you do get a very much smoother of the entire program.

Regards from
Tom :)



*From:* Dave Barton 
*To:* users@global.libreoffice.org
*Cc:* Kunwar Shivpal Singh 
*Sent:* Tuesday, 20 August 2013, 11:39
*Subject:* Re: [libreoffice-users] LO Calc crashes

Please address any reply to the users@global.libreoffice.org
 list, not
directly to me. There are many knowledgeable subscribers to this list,
who may be able to provide better answers than myself.

My responses are given in-line with your original message.

 Original Message 
From: Kunwar Shivpal Singh mailto:info.aac...@gmail.com>>
To: Dave Barton mailto:d...@tasit.net>>
Date: Tue, 20 Aug 2013 11:11:07 +0530
> Thanks Dave,
>
> but as already mentioned in my mail, I am just a user not very tech
> savvy to understand all this. I feel it is ultimately users like me
> who will count & are the final segment where LO has to be
propogated.

Other than being subscribed to this mailing list (see:
https://www.libreoffice.org/get-help/mailing-lists/), my status is no
different to yours (ie. an ordinary user of the software).

> I request if you could guide me on how to fix this problem.

At this time there is no work-around (what you call "fix") for this
issue, that I could suggest to you.

> Went to the link given in your mail. From there to another which
said
> fixed by Coalan Mcnamara, but could make head or tail of all that.

The link to "Bugzilla" gave you, is where the project records and
monitors software issues and RFE (Requests For Enhancement). Coalan is
one of the project's leading developers and the "fixed" tag indicates
that he has worked on and resolved this issue. After "peer review" the
"fix" will be included in the next update/release of the software.

> Does'nt Lo send updates to set such things right or anything which
> ordinary users like me could download & install & that settles the
> issue.
>
> regards
> Kr. Shivpal Singh

Your closing commentary insinuates that project members (including the
developers) do not care about us "ordinary users". Nothing could be
further from the truth.

Yes LO does provide updates and on a much more frequent and regular
schedule than other similar software. What you need to understand is
that the developers are resolving many issues (like this one) and
adding
improvements every day, and it would be impossible to update/release a
new version every time a single issue was resolved.

According to this page https://wiki.documentfoundation.org/ReleasePlan
the next update/release (which should include the "fix" for your
issue)
is due in a matter of days.

Regards
Dave

> On 20-08-2013 00:24, Dave Barton wrote:
>> Kunwar Shivpal Singh wrote:
>>> Hi ALL
>>>
>>> I am just a user & ardent fan of LO.
>>>
>>> I came across a problem in LO - cant say whether its with my
computer or
>>> LO. Version i have is the latest 4.1.
>>>
>>> Spelled check in Calc & the moment opted for the suggested
correction
>>> Calc crashed.
>>>
>>> The file was recovered, tried the same thing again with the
same result.
>>> did this atleast 5 - 6 times with the same result - crash &
recovery
>>> with the word not getting replaced.
>>>
>>> Hope you can suggest the shortcomings in my computer if the
problem is
>>> due to this. If it is due to some shortcoming in LO request
you to pls
>>> fix it.
>>>
>>> Thanks
>>> Kr. Shivpal Singh
>> It is a known issue. Please see:
>> https://bugs.freedesktop.org/show_bug.cgi?id=68220
>>
>> Regards
>> Dave
>>
>>
>>



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


Problems?

Re: [libreoffice-users] Old zoom with mouse wheel bug

[Tom Davies]

Hi :)
Yes, a comment would help.  

Generally, if the bug has not already been confirmed it might help to add a new 
comment saying that you can reproduce the bug.  Let them know the version of LO 
(4.2.0 alpha?) and the OS (eg Xp, Win7, Ubuntu 12.04, or whatever).  

With the early stages of a new branch it is incredibly useful to add a comment 
in bug reports if a regression has occurred.  The earlier the better as it 
might help the devs deal with it quickly while the code that caused it is still 
fresh.  

Regards from 
Tom :)  







>
> From: Krunoslav Šebetić 
>To: users@global.libreoffice.org 
>Sent: Tuesday, 20 August 2013, 12:58
>Subject: [libreoffice-users] Old zoom with mouse wheel bug
> 
>
>Hi,
>
>I still can reproduce bug at 
>https://bugs.freedesktop.org/show_bug.cgi?id=54047#add_comment on
>LO 4.2.0.0.alpha0+ Build ID: 784cfa382be438240dfc936b7551c5012aada9ae; and it 
>bugs me :) Should bug on that link be changed, or new one should be reported?
>
>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
>
>
>
-- 
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] treatment of blank cells

[Tom Davies]

Hi :)
If you need to put 0s in between commas then it might be possible without even 
opening the file, and might be fairly easy to apply to a shed load of files all 
very quickly after each other.  

In Gnu&Linux i suspect something like 

cp file-name.csv | grep(?) (replace ",," with ",0," > file-name-0s.csv

although as you can see i'm not sure grep is right or what would follow it.  

Stars instead of parts of the file-name would act as wild-cards meaning it 
would act on all such files that kinda match.  

I'm more of a point&click user so the command line is usually a bit 
of a mystery but i think it might be perfect for doing that sort of 
thing very quickly.  
Regards from 
Tom :)  







>
> From: "greg.a.sm...@oracle.com" 
>To: Steve Edmonds  
>Cc: Virgil Arrington ; users@global.libreoffice.org 
>Sent: Tuesday, 20 August 2013, 4:07
>Subject: Re: [libreoffice-users] treatment of blank cells
> 
>
>So the cells are the result of opening a .csv file where the string has 
>nothing between commas such as
>
>5,4,,,3,,2,1
>between the consecutive commas is nothing, so the cell should be made 
>totally empty.
>
>gs
>
>On 8/19/2013 8:22 PM, Steve Edmonds wrote:
>>
>> On 2013-08-20 13:02, Virgil Arrington wrote:
>>> On 08/19/2013 03:10 PM, Gregory Smith - Oracle Sparc Verification wrote:
  I am disappointed that Libre Office does not treat blank cells as a 
 zero in math calculations.  I have a dozen spreadsheets from Excel 
 and Open Office that take advantage of this fact.  Now I get errors 
 with Libre Office. Going back and retrofitting n(cell reference) to 
 achieve the translation is a ton of extra work.  Am I missing 
 something.

 gs


>>>
>>> I'm not sure what you're missing, but my LO spreadsheets always treat 
>>> blank cells as zeros. I'm not that well versed in spreadsheets, but 
>>> I've never had the problem you describe.
>>>
>>> Virgil 
>> I have just tried in LO 3.6 and a blank cell is treated as zero. A 
>> cell with text in it such as a space causes an error in calculations. 
>> Do you mean that Excel and Open Office treat white space characters as 
>> zero.
>> Steve
>>
>
>
>-- 
>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

[libreoffice-users] Old zoom with mouse wheel bug

[Krunoslav Šebetić]

Hi,

I still can reproduce bug at 
https://bugs.freedesktop.org/show_bug.cgi?id=54047#add_comment on
LO 4.2.0.0.alpha0+ Build ID: 784cfa382be438240dfc936b7551c5012aada9ae; 
and it bugs me :) Should bug on that link be changed, or new one should 
be reported?


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] LO Calc crashes

[Tom Davies]

Hi :)
LibreOffice develops so fast that by the time most other software would be 
releasing updates and patches LO is releasing a new version.  The next version 
in the same branch tends to be just bug-fixes but in the newer branch you get 
bug-fixes and new features (although those new features may have introduced 
unexpected new problems or unearthed old ones that had previously been hidden.  

So although you don't get a splattering of bug-fixes, patches and security 
patches you do get a very much smoother of the entire program.  
Regards from 
Tom :)  





>
> From: Dave Barton 
>To: users@global.libreoffice.org 
>Cc: Kunwar Shivpal Singh  
>Sent: Tuesday, 20 August 2013, 11:39
>Subject: Re: [libreoffice-users] LO Calc crashes
> 
>
>Please address any reply to the users@global.libreoffice.org list, not
>directly to me. There are many knowledgeable subscribers to this list,
>who may be able to provide better answers than myself.
>
>My responses are given in-line with your original message.
>
> Original Message 
>From: Kunwar Shivpal Singh 
>To: Dave Barton 
>Date: Tue, 20 Aug 2013 11:11:07 +0530
>> Thanks Dave,
>>
>> but as already mentioned in my mail, I am just a user not very tech
>> savvy to understand all this. I feel it is ultimately users like me
>> who will count & are the final segment where LO has to be propogated.
>
>Other than being subscribed to this mailing list (see:
>https://www.libreoffice.org/get-help/mailing-lists/), my status is no
>different to yours (ie. an ordinary user of the software).
>
>> I request if you could guide me on how to fix this problem.
>
>At this time there is no work-around (what you call "fix") for this
>issue, that I could suggest to you.
>
>> Went to the link given in your mail. From there to another which said
>> fixed by Coalan Mcnamara, but could make head or tail of all that.
>
>The link to "Bugzilla" gave you, is where the project records and
>monitors software issues and RFE (Requests For Enhancement). Coalan is
>one of the project's leading developers and the "fixed" tag indicates
>that he has worked on and resolved this issue. After "peer review" the
>"fix" will be included in the next update/release of the software.
>
>> Does'nt Lo send updates to set such things right or anything which
>> ordinary users like me could download & install & that settles the
>> issue.  
>>
>> regards
>> Kr. Shivpal Singh
>
>Your closing commentary insinuates that project members (including the
>developers) do not care about us "ordinary users". Nothing could be
>further from the truth.
>
>Yes LO does provide updates and on a much more frequent and regular
>schedule than other similar software. What you need to understand is
>that the developers are resolving many issues (like this one) and adding
>improvements every day, and it would be impossible to update/release a
>new version every time a single issue was resolved.
>
>According to this page https://wiki.documentfoundation.org/ReleasePlan
>the next update/release (which should include the "fix" for your issue)
>is due in a matter of days.
>
>Regards
>Dave
>
>> On 20-08-2013 00:24, Dave Barton wrote:
>>> Kunwar Shivpal Singh wrote:
 Hi ALL

 I am just a user & ardent fan of LO.

 I came across a problem in LO - cant say whether its with my computer or
 LO. Version i have is the latest 4.1.

 Spelled check in Calc & the moment opted for the suggested correction
 Calc crashed.

 The file was recovered, tried the same thing again with the same result.
 did this atleast 5 - 6 times with the same result - crash & recovery
 with the word not getting replaced.

 Hope you can suggest the shortcomings in my computer if the problem is
 due to this. If it is due to some shortcoming in LO request you to pls
 fix it.

 Thanks
 Kr. Shivpal Singh
>>> It is a known issue. Please see:
>>> https://bugs.freedesktop.org/show_bug.cgi?id=68220
>>>
>>> Regards
>>> Dave
>>>
>>>
>>>
>
>
>
>-- 
>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] LO Calc crashes

[Dave Barton]

Please address any reply to the users@global.libreoffice.org list, not
directly to me. There are many knowledgeable subscribers to this list,
who may be able to provide better answers than myself.

My responses are given in-line with your original message.

 Original Message 
From: Kunwar Shivpal Singh 
To: Dave Barton 
Date: Tue, 20 Aug 2013 11:11:07 +0530
> Thanks Dave,
>
> but as already mentioned in my mail, I am just a user not very tech
> savvy to understand all this. I feel it is ultimately users like me
> who will count & are the final segment where LO has to be propogated.

Other than being subscribed to this mailing list (see:
https://www.libreoffice.org/get-help/mailing-lists/), my status is no
different to yours (ie. an ordinary user of the software).

> I request if you could guide me on how to fix this problem.

At this time there is no work-around (what you call "fix") for this
issue, that I could suggest to you.

> Went to the link given in your mail. From there to another which said
> fixed by Coalan Mcnamara, but could make head or tail of all that.

The link to "Bugzilla" gave you, is where the project records and
monitors software issues and RFE (Requests For Enhancement). Coalan is
one of the project's leading developers and the "fixed" tag indicates
that he has worked on and resolved this issue. After "peer review" the
"fix" will be included in the next update/release of the software.

> Does'nt Lo send updates to set such things right or anything which
> ordinary users like me could download & install & that settles the
> issue.   
>
> regards
> Kr. Shivpal Singh

Your closing commentary insinuates that project members (including the
developers) do not care about us "ordinary users". Nothing could be
further from the truth.

Yes LO does provide updates and on a much more frequent and regular
schedule than other similar software. What you need to understand is
that the developers are resolving many issues (like this one) and adding
improvements every day, and it would be impossible to update/release a
new version every time a single issue was resolved.

According to this page https://wiki.documentfoundation.org/ReleasePlan
the next update/release (which should include the "fix" for your issue)
is due in a matter of days.

Regards
Dave

> On 20-08-2013 00:24, Dave Barton wrote:
>> Kunwar Shivpal Singh wrote:
>>> Hi ALL
>>>
>>> I am just a user & ardent fan of LO.
>>>
>>> I came across a problem in LO - cant say whether its with my computer or
>>> LO. Version i have is the latest 4.1.
>>>
>>> Spelled check in Calc & the moment opted for the suggested correction
>>> Calc crashed.
>>>
>>> The file was recovered, tried the same thing again with the same result.
>>> did this atleast 5 - 6 times with the same result - crash & recovery
>>> with the word not getting replaced.
>>>
>>> Hope you can suggest the shortcomings in my computer if the problem is
>>> due to this. If it is due to some shortcoming in LO request you to pls
>>> fix it.
>>>
>>> Thanks
>>> Kr. Shivpal Singh
>> It is a known issue. Please see:
>> https://bugs.freedesktop.org/show_bug.cgi?id=68220
>>
>> Regards
>> Dave
>>
>>
>>



-- 
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 WRITER BASIC : inserting a table using the dispatcher

[Alain Van Utterbeeck]

Hello,

I have the following code in a macro:

if chapters.getBoolean(6) then
args4(0).Name = "TableName"
args4(0).Value = "Tabel1"
args4(1).Name = "Columns"
args4(1).Value = 3
args4(2).Name = "Rows"
args4(2).Value = 2
args4(3).Name = "Flags"
args4(3).Value = 11
dispatcher.executeDispatch(document, 
".uno:InsertTable", "", 0, args4())

args1(0).Name = "Text"
args1(0).Value = "Product"
dispatcher.executeDispatch(document, 
".uno:InsertText", "", 0, args1())
dispatcher.executeDispatch(document, 
".uno:JumpToNextCell", "", 0, Array())

args1(0).Name = "Text"
args1(0).Value = "Hoev."
dispatcher.executeDispatch(document, 
".uno:InsertText", "", 0, args1())
dispatcher.executeDispatch(document, 
".uno:JumpToNextCell", "", 0, Array())

args1(0).Name = "Text"
args1(0).Value = "Prijs"
dispatcher.executeDispatch(document, 
".uno:InsertText", "", 0, args1())
sale_order_lines=DBsql4.executeQuery("SELECT name, 
product_uom_qty, " + _
"(product_uom_qty * price_unit) 
AS amount, " + _
"(SELECT seq_document from 
product_product where product_product.id = sale_order_line.product_id) 
AS seq " + _

" FROM sale_order_line WHERE " + _
"order_id = " + sale_order_id + 
" ORDER BY seq")


While sale_order_lines.next
naam=sale_order_lines.getString(1)
qty=sale_order_lines.getString(2)
amount=sale_order_lines.getString(3)
args1(0).Name = "Text"
args1(0).Value = naam
dispatcher.executeDispatch(document, 
".uno:JumpToNextCell", "", 0, Array())
dispatcher.executeDispatch(document, 
".uno:InsertText", "", 0, args1())

args1(0).Name = "Text"
args1(0).Value = qty
dispatcher.executeDispatch(document, 
".uno:JumpToNextCell", "", 0, Array())
dispatcher.executeDispatch(document, 
".uno:InsertText", "", 0, args1())
dispatcher.executeDispatch(document, 
".uno:NumberFormatDecimal", "", 0, Array())

args1(0).Name = "Text"
args1(0).Value = amount
dispatcher.executeDispatch(document, 
".uno:JumpToNextCell", "", 0, Array())
dispatcher.executeDispatch(document, 
".uno:InsertText", "", 0, args1())
dispatcher.executeDispatch(document, 
".uno:NumberFormatDecimal", "", 0, Array())

Wend
mCurs.gotoEnd(False)
end if

The result that I get is:



Does anybody have an idea why the dispatcher.executeDispatch(document, 
".uno:JumpToNextCell", "", 0, Array()) is not working?


The crazy thing is that if I put a breakpoint on the first line of this 
code, and go through it step by step, it works fine  and I get :



Another strange thing is that the third column containing the price is 
set to 0 while in the first screenprint, if you look closely at the 
contents that is completely in the first cell, the prices are not 0 !!!


Any ideas please?

Thanks in advance for any help...

Greetings,
Alain


--
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] Impress: Sound Links

[Joaquín Lameiro]

Hi.

I have excerpt this parragraph from the LibreOffice Impress Guide at 
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Impress_Guide:


"Impress
only links media files and does not embed a media file into a
presentation. Therefore if a presentation is moved to a different
computer, any links will be broken and the media files will not play.
To prevent this from happening:
1. Place any media files which are included in a presentation in the 
same folder where the presentation is stored.
2. Insert the media file in the presentation.
3. Send both the presentation and any media files to the computer which 
is to be used for the presentation and place both files in the same folder on 
that computer."

So, it works as both Brian and Dave had already deduced. As long as you keep 
everything in the same folder (or in the root of the CD), there should be no 
problem. I suppose you also can put the sound files in a sub-folder, so 
everything would be more tidy.
Regards,
Joaquín




 De: Brian Barker 
Para: users@global.libreoffice.org 
Enviado: Martes 20 de agosto de 2013 8:25
Asunto: Re: [libreoffice-users] Impress: Sound Links
 

At 22:37 19/08/2013 -0700, Dave Liesse wrote:
>Well, it was a kick in the teeth to learn that sounds are only 
>linked instead of being imbedded in the presentation, but at least 
>that'll keep the size down.  My question, though, is whether the 
>links use absolute or relative paths.

It's a simple job to test this, of course - and the answer appears to 
be relative.

>I put together a presentation that's for distribution via DVD, and 
>of course I have no idea in advance what drive letter any given 
>recipient will have.  I have no problem with putting the sound files 
>on the disk, but need to know what type of pathing is being 
>used.  If it's relative, I'm already in good shape; if it's 
>absolute, then I'm hosed.
>
>This kinda makes it impossible to distribute a slide show 
>electronically, as well, if you want sound with it.

Surely all you need to do is to put your audio file in the same 
folder as your presentation when you insert it, and to require your 
correspondents to have both files in the same folder - wherever that 
might be - before attempting to use them?

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
-- 
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] treatment of blank cells

[Steve Edmonds]

If I put 5,4,,,3,,2,1 in afile.csv and open it in LO3.6 I can then put 
the equation =b1*c1 in an empty cell and the result is 0.


Do you not get that. What version of LO.
steve
On 2013-08-20 15:07, greg.a.sm...@oracle.com wrote:
So the cells are the result of opening a .csv file where the string 
has nothing between commas such as


5,4,,,3,,2,1
between the consecutive commas is nothing, so the cell should be made 
totally empty.


gs

On 8/19/2013 8:22 PM, Steve Edmonds wrote:


On 2013-08-20 13:02, Virgil Arrington wrote:
On 08/19/2013 03:10 PM, Gregory Smith - Oracle Sparc Verification 
wrote:
 I am disappointed that Libre Office does not treat blank cells as 
a zero in math calculations. I have a dozen spreadsheets from Excel 
and Open Office that take advantage of this fact.  Now I get errors 
with Libre Office. Going back and retrofitting n(cell reference) to 
achieve the translation is a ton of extra work.  Am I missing 
something.


gs




I'm not sure what you're missing, but my LO spreadsheets always 
treat blank cells as zeros. I'm not that well versed in 
spreadsheets, but I've never had the problem you describe.


Virgil 
I have just tried in LO 3.6 and a blank cell is treated as zero. A 
cell with text in it such as a space causes an error in calculations. 
Do you mean that Excel and Open Office treat white space characters 
as zero.

Steve






--
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: Calc =MONTH problem

[IGraham]

Hello and thanks for looking at the problem

So my understanding and logic was wrong - again I have learnt a smidgen more

Eventually got what I wanted by using =TEXT(CG4,"MMM")
I had thought of using an array but It seemed a big way of solving a small
problem - plus I'd never used one before ?? Maybe I should have just for the
'smidgen more'

Again, thanks for the help



-
IGraham

W764  LibreOffice 4.1.0.4
--
View this message in context: 
http://nabble.documentfoundation.org/Calc-MONTH-problem-tp4070686p4070715.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