date:20120525

On 05/25/2012 08:55 PM, webmaster-Kracked_P_P wrote:
>
>
>
> Font formatting issue
>
> You highlight your text, then right-click
>
> The you choose the "Font" option.
>
> For me, when I go down the list, I do not go out of the A's for the
> font names.
>
> How many fonts is that list designed to deal with?
>
> With all of the variations [bold, italic, bold italic, etc.] of the
> fonts and their file names, I have over 500 fonts installed on my
> default desktop computer.
>
> So I was wondering about how to show more fonts in that list.  For
> people that have a lot of fonts installed on their desktop, it looks
> like you are not able to see all of their font names in that shortened
> list.
>
> So, it there some reason there is a shortened ability there when the
> Font list "pull down box" allows all of the fonts I have does show
> up?  It seems like there is a possible problem here for some people. 
> It can cause me problems if I follow the instructions for doing font
> formatting in certain ways.  That right-click options show some
> options for font displaying, like overlines and other non-standard
> things that are not shown in the taskbar options for font formatting. 
> So if one part of that formatting system is limited, then can I trust
> that the other options will not cause issues later on for my
> documents?  I did find that if I formatted a text with the
> right-clicked overline and shadowed, I need to use the same
> right-clicking to remove it instead of using the normal taskbar
> formatting options.
>
>
>
I confirm this behavior using Ubuntu 12.04 and LO 3.5.4.2. I get some
B's to show. My guess is that only first `50 or so is shown.

-- 
Jay Lozier
jsloz...@gmail.com


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

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread drew jensen

On Fri, 2012-05-25 at 19:02 -0700, Girvin R. Herr wrote:
> 
> drew jensen wrote:
> 8><...
> >
> > Hi Tom
> >
> > Really - you seem to know a lot, are you writing a manual?
> >
> > @Girvin - there is no place that I've seen the report builder be that
> > slow and not have an installation problem - not saying it is impossible
> > but sounds really odd. 1500 records in a tabular report, 49 seconds is a
> > long time for that actually. There is one exception to that, graphics -
> > is your report including graphics stored in data fields?
> >
> > On the other hand Calc, as has been pointed out, might be your preferred
> > path.
> >
> > Best,
> >
> > //drew
> >
> >   
> 8><...
> 
> Hello Drew,
> I understand what you are saying, but I installed the LO 3.5.2 binary 
> (RPM) packages from the LO website.  I repackaged them for Slackware, 
> but that does not change the 1s and 0s, just unpacks the RPMs and 
> re-packages the files into a Slackware package for installation.  
> Therefore, if there is an installation problem, it seems to be in the LO 
> packages.  Note that I am using the Report Builder bundled into LO, not 
> the version from the extensions website.  I do believe the newest is 
> 1.2.1 rev 2, and the one in LO is still 1.0-something.  I have not tried 
> to replace the bundled version with the 1.2 version.
> 
> I could live with 49 _"seconds"_.  However, it is taking 49 _minutes_ 
> for my report.  My database is nothing special, just text and integer 
> values.  Nine elements plus the key per record.  No graphics.  So, yes, 
> this problem does sound unusual.  However, I have not been able to pin 
> down the problem yet.  In the meantime, I am looking into using Calc to 
> print my data.  It looks good and will do until I can get RB working.
> 
> BTW: The report is a simple text page header, Detail, and page footer, 
> no graphics there either.  I do have the date and time fields in the 
> header, but that shouldn't bring it down.  Actually, I do have some 
> separator lines inserted at the bottom of the header and the bottom of 
> each Detail line.  Page number at the bottom of the footer.  That's it.
> Thanks for the help.
Hi Girvin

Sounds like it aught to run lickity-split...hmm

Anyway - looks like you are off to use Cacl.

You might want to do this.

When you open the data window under Calc, instead of copy/paste from the
data grid - grad, drag and drop the actual query name from the left side
of the data window. This will create a named range, you can set options
on the range to _not_ save the data in the spreadsheet, jut the
connection information...then when you open the spreadsheet again it
will re-run the query and update the data anew..

Best wishes,

//drew


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

Re: [libreoffice-users] modifying existing labels/cards

2012-05-25 Thread Don Myers


Hi Joep,

The standard label formats included with LibreOffice and OpenOffice are 
the same type as Microsoft uses with fixed blocks. These tend to not to 
be accurate if the card/label is relatively full as you get toward the 
bottom of the page, even in Microsoft. There are also table style 
templates available (or at least used to be available) as an extension 
for OpenOffice. I have found them very easy to adjust, and they print 
perfectly for both business cards and labels for me. They are available at:
http://www.worldlabel.com/Pages/openoffice-template.htm or probably as 
an extension for OpenOffice.


Don

On 05/25/2012 05:45 PM, Joep L. Blom wrote:

On 25-05-12 15:12, Jay Lozier wrote:

Joep

On 05/25/2012 06:48 AM, Joep L. Blom wrote:

AFAIK your business cards form should print correctly on any printer
that has a large enough printing area. I have found the typical tweaks I
need are to adjust the margins of the text slightly so it does not print
on the edge.

I would print a set on plain paper and visually inspect to see if the
output looks correct. Then I would make any changes and repeat the test
page. Finally, when I think I have it correct I would print 1 set out
and see if there are any small problems.


Planas,
Thanks for your reply. However, the problem is you cannot make any 
changes. You cannot change the layout, only when you make a new 
business card sheet. How would you make the changes?

Joep





--

*~~*
Don C. Myers
e-PRO Certified by the National Association of Realtors
Manager, Farm and Rural Property Division
*Coldwell Banker University Realty
*126 East Foster Avenue, State College, PA 16801
Phone: 814-237-6543 Fax: 814-237-6502
Visit the Farm and Rural Property Division Website at 
www.cbur-ruralproperty.com _

_View Don's farm website: www.myersfarm.com 
*~~*


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

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Girvin R. Herr




drew jensen wrote:
8><...


Hi Tom

Really - you seem to know a lot, are you writing a manual?

@Girvin - there is no place that I've seen the report builder be that
slow and not have an installation problem - not saying it is impossible
but sounds really odd. 1500 records in a tabular report, 49 seconds is a
long time for that actually. There is one exception to that, graphics -
is your report including graphics stored in data fields?

On the other hand Calc, as has been pointed out, might be your preferred
path.

Best,

//drew

  

8><...

Hello Drew,
I understand what you are saying, but I installed the LO 3.5.2 binary 
(RPM) packages from the LO website.  I repackaged them for Slackware, 
but that does not change the 1s and 0s, just unpacks the RPMs and 
re-packages the files into a Slackware package for installation.  
Therefore, if there is an installation problem, it seems to be in the LO 
packages.  Note that I am using the Report Builder bundled into LO, not 
the version from the extensions website.  I do believe the newest is 
1.2.1 rev 2, and the one in LO is still 1.0-something.  I have not tried 
to replace the bundled version with the 1.2 version.


I could live with 49 _"seconds"_.  However, it is taking 49 _minutes_ 
for my report.  My database is nothing special, just text and integer 
values.  Nine elements plus the key per record.  No graphics.  So, yes, 
this problem does sound unusual.  However, I have not been able to pin 
down the problem yet.  In the meantime, I am looking into using Calc to 
print my data.  It looks good and will do until I can get RB working.


BTW: The report is a simple text page header, Detail, and page footer, 
no graphics there either.  I do have the date and time fields in the 
header, but that shouldn't bring it down.  Actually, I do have some 
separator lines inserted at the bottom of the header and the bottom of 
each Detail line.  Page number at the bottom of the footer.  That's it.

Thanks for the help.
Girvin


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

Re: [libreoffice-users] right-clicking Font list options not showing all my installed fonts

2012-05-25 Thread Steve Edmonds




On 2012-05-26 12:55, webmaster-Kracked_P_P wrote:




Font formatting issue

You highlight your text, then right-click

The you choose the "Font" option.

For me, when I go down the list, I do not go out of the A's for the 
font names.


How many fonts is that list designed to deal with?

With all of the variations [bold, italic, bold italic, etc.] of the 
fonts and their file names, I have over 500 fonts installed on my 
default desktop computer.


So I was wondering about how to show more fonts in that list.  For 
people that have a lot of fonts installed on their desktop, it looks 
like you are not able to see all of their font names in that shortened 
list.


So, it there some reason there is a shortened ability there when the 
Font list "pull down box" allows all of the fonts I have does show 
up?  It seems like there is a possible problem here for some people.  
It can cause me problems if I follow the instructions for doing font 
formatting in certain ways.  That right-click options show some 
options for font displaying, like overlines and other non-standard 
things that are not shown in the taskbar options for font formatting.  
So if one part of that formatting system is limited, then can I trust 
that the other options will not cause issues later on for my 
documents?  I did find that if I formatted a text with the 
right-clicked overline and shadowed, I need to use the same 
right-clicking to remove it instead of using the normal taskbar 
formatting options.



Hi.
I get an arrow (triangle wedge) at the bottom of the list to scroll 
down, like firefox bookmarks down arrow.

steve

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

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Girvin R. Herr




Dan Lewis wrote:



 Yes, you can link to a Base query with Calc. With Cal open, use the
F4 key to open the Data Source window. (You will have to register the
database before it will appear in this window.) The left side is the
name of the registered databases. Click the arrow in front of the
database to see that you can get data from from a table or query. When
you select one of these, its data appears in table form on the right
side.

--Dan



  

Dan,
Wow!  That worked fine.  Thanks.
However, I had to copy and paste the database data from the Data Source 
window into the Calc spreadsheet.  Is there a way to dynamically get the 
current data to the spreadsheet so I don't have to cut and paste every 
time I have new data?
If so, it would be a lot less error-prone (and easier).  However, I can 
see that not being able to do so, is not a show-stopper for using Calc 
to do my reports.
Note that the data copy, although it took a little time, was *much* 
faster than Report Builder!  :-)

I am going to have to play with this some more...
Thanks very much.
Girvin



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

[libreoffice-users] right-clicking Font list options not showing all my installed fonts

2012-05-25 Thread webmaster-Kracked_P_P





Font formatting issue

You highlight your text, then right-click

The you choose the "Font" option.

For me, when I go down the list, I do not go out of the A's for the font 
names.


How many fonts is that list designed to deal with?

With all of the variations [bold, italic, bold italic, etc.] of the 
fonts and their file names, I have over 500 fonts installed on my 
default desktop computer.


So I was wondering about how to show more fonts in that list.  For 
people that have a lot of fonts installed on their desktop, it looks 
like you are not able to see all of their font names in that shortened list.


So, it there some reason there is a shortened ability there when the 
Font list "pull down box" allows all of the fonts I have does show up?  
It seems like there is a possible problem here for some people.  It can 
cause me problems if I follow the instructions for doing font formatting 
in certain ways.  That right-click options show some options for font 
displaying, like overlines and other non-standard things that are not 
shown in the taskbar options for font formatting.  So if one part of 
that formatting system is limited, then can I trust that the other 
options will not cause issues later on for my documents?  I did find 
that if I formatted a text with the right-clicked overline and shadowed, 
I need to use the same right-clicking to remove it instead of using the 
normal taskbar formatting options.




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

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread drew jensen

On Fri, 2012-05-25 at 15:47 -0700, Girvin R. Herr wrote:
> 
> Tom Davies wrote:
> > Hi :)
> > I have just done a bit of digging around.
> >
> > Looking back through Andreas' answers
> > http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodes&user=254826&i=80
> >
> > I found this but i'm not sure it's much help for you 
> > http://nabble.documentfoundation.org/database-td3926217i20.html#a3928210
> >
> > This one seems to expand on the useful line at the end there
> > http://nabble.documentfoundation.org/Base-3-5-2-2-hangs-td3910280.html#a3911654
> >
> > This one is a bit of an overview with nothing specific but might be useful 
> > to skim through for ideas
> > http://nabble.documentfoundation.org/Address-Books-td3829696.html#a3832514
> >
> > This one looks brilliant to me
> > http://nabble.documentfoundation.org/Base-and-new-Report-Builder-in-3-5-td3817159.html#a3819387
> >
> > There is some documentation at 
> > https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
> > and an FAQ (translated from the French team's) at 
> > https://wiki.documentfoundation.org/Faq
> >
> > Sadly most of the people that know a lot about the ins-and-outs of Base are 
> > unwilling to help write the Base guide so it's down to 1 person who is 
> > desperately busy with a lot of other projects.  
> >

Hi Tom

Really - you seem to know a lot, are you writing a manual?

@Girvin - there is no place that I've seen the report builder be that
slow and not have an installation problem - not saying it is impossible
but sounds really odd. 1500 records in a tabular report, 49 seconds is a
long time for that actually. There is one exception to that, graphics -
is your report including graphics stored in data fields?

On the other hand Calc, as has been pointed out, might be your preferred
path.

Best,

//drew

> >
> >   
> >
> Tom,
> Your "brilliant" link looks interesting.  I knew Calc and Base have some 
> similarities internally, but I wasn't aware that my data could be 
> imported into Calc from my MySQL server.  All of my reports are tabular 
> in format anyway, so Calc could be an option, if it could get my data.  
> One limit to using Calc would be Calc's row limit.  I think I read that 
> LO just raised the maximum rows, but if there are more database records 
> than available Calc rows, then...
> Can Calc be linked to a Base query to get its data?
> If so, then all my sorting can be done in the query.  I do not do any 
> grouping in my reports at this time.
> 
> As an update to my problem with Report Builder, my 1500+ record database 
> takes 94 pages of a Report Builder / Writer document.  I put on my 
> patience hat and timed how long it takes to format the report, ready for 
> printing.  As a baseline, it takes about 49 minutes to create the 
> original document.  I cleared my preferences and re-entered them, using 
> mostly defaults and timed it again: 49 minutes.  So it is not preference 
> corruption from previous versions.  I then updated my java to 1.6u30 and 
> timed it again: 49 minutes.  So, it doesn't look like Java is the 
> problem.  I then went back to my original use of SQL from when I created 
> the report with the wizard, rather than using a query for the data and 
> timed it: 49 minutes!  No matter what I do, it takes about the same 
> excruciatingly long time to build my report.  What is really frustrating 
> is that there is no status popup to inform me of what it is doing.  It 
> just goes out to lunch.  Actually, it seems to initially create 128 
> pages with header and footer, but no data, at the end of the first 
> "sleep".  When the page status at the bottom of the writer window drops 
> to 94 pages, I know it is done.  Every so many pages, it does come back 
> alive for a second or two and then goes out to lunch again for several 
> minutes.  Each time it returns, a few more pages are populated with data.
> Girvin
> 
> 
> 



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

[libreoffice-users] Re: is there an Open office equivalent to Visio 2000

2012-05-25 Thread Marc Paré


Le 2012-05-25 12:06, Custfold a écrit :

The loss of my access to a PC with Visio and Visio 2000 on it has left
me with .vsd files that I cannot work on, and its beginning to get a bit
of a problem.

a) is there an open source program that can open these files, and

b) can I use it to work with the files for future drawings.

DH


http://www.libreoffice.org/download/3-5-new-features-and-fixes/

Visio import is now possible in LibreOffice 3.5. There is a mention at 
the top of the page and also 2/3 down that page with screenshots.


Cheers,

Marc


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

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Dan Lewis

On Fri, 2012-05-25 at 15:47 -0700, Girvin R. Herr wrote:
> 
> Tom Davies wrote:
> > Hi :)
> > I have just done a bit of digging around.
> >
> > Looking back through Andreas' answers
> > http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodes&user=254826&i=80
> >
> > I found this but i'm not sure it's much help for you 
> > http://nabble.documentfoundation.org/database-td3926217i20.html#a3928210
> >
> > This one seems to expand on the useful line at the end there
> > http://nabble.documentfoundation.org/Base-3-5-2-2-hangs-td3910280.html#a3911654
> >
> > This one is a bit of an overview with nothing specific but might be useful 
> > to skim through for ideas
> > http://nabble.documentfoundation.org/Address-Books-td3829696.html#a3832514
> >
> > This one looks brilliant to me
> > http://nabble.documentfoundation.org/Base-and-new-Report-Builder-in-3-5-td3817159.html#a3819387
> >
> > There is some documentation at 
> > https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
> > and an FAQ (translated from the French team's) at 
> > https://wiki.documentfoundation.org/Faq
> >
> > Sadly most of the people that know a lot about the ins-and-outs of Base are 
> > unwilling to help write the Base guide so it's down to 1 person who is 
> > desperately busy with a lot of other projects.  
> >
> > Regards from
> > Tom :) 
> >
> >   
> >
> Tom,
> Your "brilliant" link looks interesting.  I knew Calc and Base have some 
> similarities internally, but I wasn't aware that my data could be 
> imported into Calc from my MySQL server.  All of my reports are tabular 
> in format anyway, so Calc could be an option, if it could get my data.  
> One limit to using Calc would be Calc's row limit.  I think I read that 
> LO just raised the maximum rows, but if there are more database records 
> than available Calc rows, then...
> Can Calc be linked to a Base query to get its data?
> If so, then all my sorting can be done in the query.  I do not do any 
> grouping in my reports at this time.
> 
> As an update to my problem with Report Builder, my 1500+ record database 
> takes 94 pages of a Report Builder / Writer document.  I put on my 
> patience hat and timed how long it takes to format the report, ready for 
> printing.  As a baseline, it takes about 49 minutes to create the 
> original document.  I cleared my preferences and re-entered them, using 
> mostly defaults and timed it again: 49 minutes.  So it is not preference 
> corruption from previous versions.  I then updated my java to 1.6u30 and 
> timed it again: 49 minutes.  So, it doesn't look like Java is the 
> problem.  I then went back to my original use of SQL from when I created 
> the report with the wizard, rather than using a query for the data and 
> timed it: 49 minutes!  No matter what I do, it takes about the same 
> excruciatingly long time to build my report.  What is really frustrating 
> is that there is no status popup to inform me of what it is doing.  It 
> just goes out to lunch.  Actually, it seems to initially create 128 
> pages with header and footer, but no data, at the end of the first 
> "sleep".  When the page status at the bottom of the writer window drops 
> to 94 pages, I know it is done.  Every so many pages, it does come back 
> alive for a second or two and then goes out to lunch again for several 
> minutes.  Each time it returns, a few more pages are populated with data.
> Girvin

 Yes, you can link to a Base query with Calc. With Cal open, use the
F4 key to open the Data Source window. (You will have to register the
database before it will appear in this window.) The left side is the
name of the registered databases. Click the arrow in front of the
database to see that you can get data from from a table or query. When
you select one of these, its data appears in table form on the right
side.

--Dan



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

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Girvin R. Herr

Tom Davies wrote:

Hi :)
I have just done a bit of digging around.

Looking back through Andreas' answers
http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodes&user=254826&i=80

I found this but i'm not sure it's much help for you
http://nabble.documentfoundation.org/database-td3926217i20.html#a3928210

This one seems to expand on the useful line at the end there
http://nabble.documentfoundation.org/Base-3-5-2-2-hangs-td3910280.html#a3911654

This one is a bit of an overview with nothing specific but might be useful to
skim through for ideas
http://nabble.documentfoundation.org/Address-Books-td3829696.html#a3832514

This one looks brilliant to me
http://nabble.documentfoundation.org/Base-and-new-Report-Builder-in-3-5-td3817159.html#a3819387

There is some documentation at
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
and an FAQ (translated from the French team's) at
https://wiki.documentfoundation.org/Faq

Sadly most of the people that know a lot about the ins-and-outs of Base are unwilling to help write the Base guide so it's down to 1 person who is desperately busy with a lot of other projects.

Regards from
Tom :)

Tom,
Your "brilliant" link looks interesting. I knew Calc and Base have some
similarities internally, but I wasn't aware that my data could be
imported into Calc from my MySQL server. All of my reports are tabular
in format anyway, so Calc could be an option, if it could get my data.
One limit to using Calc would be Calc's row limit. I think I read that
LO just raised the maximum rows, but if there are more database records
than available Calc rows, then...

Can Calc be linked to a Base query to get its data?
If so, then all my sorting can be done in the query. I do not do any
grouping in my reports at this time.

As an update to my problem with Report Builder, my 1500+ record database
takes 94 pages of a Report Builder / Writer document. I put on my
patience hat and timed how long it takes to format the report, ready for
printing. As a baseline, it takes about 49 minutes to create the
original document. I cleared my preferences and re-entered them, using
mostly defaults and timed it again: 49 minutes. So it is not preference
corruption from previous versions. I then updated my java to 1.6u30 and
timed it again: 49 minutes. So, it doesn't look like Java is the
problem. I then went back to my original use of SQL from when I created
the report with the wizard, rather than using a query for the data and
timed it: 49 minutes! No matter what I do, it takes about the same
excruciatingly long time to build my report. What is really frustrating
is that there is no status popup to inform me of what it is doing. It
just goes out to lunch. Actually, it seems to initially create 128
pages with header and footer, but no data, at the end of the first
"sleep". When the page status at the bottom of the writer window drops
to 94 pages, I know it is done. Every so many pages, it does come back
alive for a second or two and then goes out to lunch again for several
minutes. Each time it returns, a few more pages are populated with data.

Girvin

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

Re: [libreoffice-users] Documents do strange things

On 05/25/2012 05:55 PM, Wanda Moore wrote:
> I use the right click menu or edit in the toolbar.  I've never used styles
> or templates, as I don't really understand them, and just want to be able
> to take notes and write things down for myself and my kids.  (I homeschool,
> so I'm always writing something and printing them out.)
>
> I have LO 3.4.4 and Mac OS X  10.6.8Hope this helps.
Wanda you can set the default fonts for LO documents using
TOOLS>OPTIONS>LibreOffice Writer>Basic Fonts (Western). You can select
any installed Western font as the default font.

If you are pasting from the another document which has its own font,
etc. try using EDIT>PASTE SPECIAL and select unformatted text. LO will
use the document default for the text formatting. When you use the
normal PASTE LO assumes the formatting of the text to be pasted should
override the document defaults.

We like to know version and OS for reference and in case the issue is
specific to a version or OS; normally the issues are not.
> Wanda
>
> On Fri, May 25, 2012 at 2:34 PM, Jay Lozier  wrote:
>
>> Wanda
>>
>> On 05/25/2012 04:36 PM, Wanda Moore wrote:
>>> I write simple documents all the time, but my preferences don't seem to
>>> matter to LO.  I choose a font, but it changes on me.  I cut or copy and
>>> paste, and the font changes, even though I copy the exact same thing.
>>> Times New Roman seems to be the dictator here.  And the size always
>>> changes.  Lines will suddenly become a 24 pt rather than 11 that I
>> usually
>>> use.
>> What paste method are you using?
>>> The spaces between lines and paragraphs will change, and I can't change
>>> them back.  Most of the time I can't even use the backspace to move a
>> word
>>> up to the last line.  And I can't move the first word (indent it).  If I
>>> click on a word that starts in the wrong place, there are no little
>>> triangles up in the top ruler, so I can't move the line or paragraph.
>>> There are other things, too, but if you can help with this, maybe all
>> will
>>> be fixed.
>> You may want to modify the styles used and update the default template
>>> I understand that I may have done something unawares, so I thank you
>>> beforehand.
>>>
>>> Wanda Moore
>>>
>> Just for reference please advise the LO version and your OS.
>>
>> --
>> Jay Lozier
>> jsloz...@gmail.com
>>
>>
>>
>>


-- 
Jay Lozier
jsloz...@gmail.com


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

Re: [libreoffice-users] Re: Python and Tkinter

2012-05-25 Thread webmaster-Kracked_P_P


On 05/25/2012 03:15 PM, Andreas Säger wrote:

Am 25.05.2012 21:00, Andreas Säger wrote:

Am 24.05.2012 19:39, SuneOskar wrote:

Is Tkinter supported ?

--
View this message in context:
http://nabble.documentfoundation.org/Python-and-Tkinter-tp3985866.html
Sent from the Users mailing list archive at Nabble.com.



help> modules Tkinter

Here is a list of matching modules. Enter any module name to get more 
help.


idlelib.CallTipWindow - A CallTip window class for Tkinter/IDLE.
idlelib.MultiCall - MultiCall - a class which inherits its methods from
a Tkinter widget (Text, for
idlelib.keybindingDialog - Dialog for building Tkinter accelerator key
bindings
idlelib.tabbedpages - An implementation of tabbed pages using only
standard Tkinter.
Tkdnd - Drag-and-drop support for Tkinter.
Tkinter - Wrapper functions for Tcl/Tk.






>>> import Tkinter
Traceback (most recent call last):
  File "", line 1, in 
  File 
"/opt/libreoffice3.5/program/python-core-2.6.1/lib/lib-tk/Tkinter.py", 
line 39, in 
import _tkinter # If this fails your Python may not be configured 
for Tk

ImportError: No module named _tkinter


I remember someone told me that it would be a good thing if I learned 
Tkinter as soon as I was up to speed on learning Python.  But, I was not 
looking into Python so deeply to need the programming aides that Tkinter 
would give me.  But that, and some other module/library packages help a 
lot of people with larger and complex software creation.  If I wanted to 
create a package that needs a WYSIWYG editing ability or image/graphics 
displaying, I would really need such a programming aide.




,

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

Re: [libreoffice-users] Documents do strange things

2012-05-25 Thread Wanda Moore

I use the right click menu or edit in the toolbar.  I've never used styles
or templates, as I don't really understand them, and just want to be able
to take notes and write things down for myself and my kids.  (I homeschool,
so I'm always writing something and printing them out.)

I have LO 3.4.4 and Mac OS X  10.6.8Hope this helps.
Wanda

On Fri, May 25, 2012 at 2:34 PM, Jay Lozier  wrote:

> Wanda
>
> On 05/25/2012 04:36 PM, Wanda Moore wrote:
> > I write simple documents all the time, but my preferences don't seem to
> > matter to LO.  I choose a font, but it changes on me.  I cut or copy and
> > paste, and the font changes, even though I copy the exact same thing.
> > Times New Roman seems to be the dictator here.  And the size always
> > changes.  Lines will suddenly become a 24 pt rather than 11 that I
> usually
> > use.
> What paste method are you using?
> >
> > The spaces between lines and paragraphs will change, and I can't change
> > them back.  Most of the time I can't even use the backspace to move a
> word
> > up to the last line.  And I can't move the first word (indent it).  If I
> > click on a word that starts in the wrong place, there are no little
> > triangles up in the top ruler, so I can't move the line or paragraph.
> > There are other things, too, but if you can help with this, maybe all
> will
> > be fixed.
> You may want to modify the styles used and update the default template
> >
> > I understand that I may have done something unawares, so I thank you
> > beforehand.
> >
> > Wanda Moore
> >
> Just for reference please advise the LO version and your OS.
>
> --
> Jay Lozier
> jsloz...@gmail.com
>
>
>
>

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

Re: [libreoffice-users] Connecting libreoffice calc to existing sqlite database file

2012-05-25 Thread Joep L. Blom


On 25-05-12 16:16, Jonathan Ryshpan wrote:

I have been attempting to send this posting for a while, and have only
recently noticed that the list does not accept attachments.  This has
(apparently) caused it to be silently rejected.  I have appended what
had been attached to the end of this posting.

Sorry for the delay.

On Mon, 2012-05-21 at 14:40 -0700, Jonathan Ryshpan wrote:

... the database doesn't look like what I had expected it to: sqlite
databases contain within themselves the names and data types of all
the entries, but when libreOffice opens the database, there is no such
data visible.  Am I missing something.  A dump of the database using
"$ sqlite3.sdb .dump" looks fine.  Is this what I should expect,
or is something wrong, or am I missing something? On Tue, 2012-05-22




Jonathan,
Your table looks suspiciously like the table I use getting the data from 
WeatherDisplay, using their wdmysql-exe program (in windows). I have 
this table in a mysql database and that is perfectly well to  handle 
using "Mysql Query Browser (a Linux program) but I assume there are 
several Windows programs doing the same I assume you use Windows)..

Joep

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

Re: [libreoffice-users] is there an Open office equivalent to Visio 2000

2012-05-25 Thread webmaster-Kracked_P_P


On 05/25/2012 01:58 PM, Jay Lozier wrote:

On 05/25/2012 12:06 PM, Custfold wrote:

The loss of my access to a PC with Visio and Visio 2000 on it has left
me with .vsd files that I cannot work on, and its beginning to get a
bit of a problem.

a) is there an open source program that can open these files, and

b) can I use it to work with the files for future drawings.

DH


I assume you use Windows. I did not see that Draw could open vsd files.
You might check Dia (https://live.gnome.org/Dia), which has a Windows
version. Dia can open the newer Visio files but I am uncertain of the
older ones.



I think I have used Dia on some old[er] Visio files that I had, but I do 
not remember which Visio version they were made from.


I know that the 3.5.x line is "advertised" in the "Release info" section 
to be able to open Visio files.  So if you try 3.5.3 and Dia, one should 
be able to open your Visio files.


Soon, hopefully, LO will open Publisher files and then with Visio, LO 
will be able to open a file format from all of MS Office "modules" 
instead of just the "normal" business one like word processing, 
spreadsheet, and presentations.  I saw something about work on a 
Publisher importing filter being worked on by someone/somewhere.




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

Re: [libreoffice-users] modifying existing labels/cards

2012-05-25 Thread Joep L. Blom


On 25-05-12 15:12, Jay Lozier wrote:

Joep

On 05/25/2012 06:48 AM, Joep L. Blom wrote:

AFAIK your business cards form should print correctly on any printer
that has a large enough printing area. I have found the typical tweaks I
need are to adjust the margins of the text slightly so it does not print
on the edge.

I would print a set on plain paper and visually inspect to see if the
output looks correct. Then I would make any changes and repeat the test
page. Finally, when I think I have it correct I would print 1 set out
and see if there are any small problems.


Planas,
Thanks for your reply. However, the problem is you cannot make any 
changes. You cannot change the layout, only when you make a new business 
card sheet. How would you make the changes?

Joep



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

Re: [libreoffice-users] Documents do strange things

Wanda

On 05/25/2012 04:36 PM, Wanda Moore wrote:
> I write simple documents all the time, but my preferences don't seem to
> matter to LO.  I choose a font, but it changes on me.  I cut or copy and
> paste, and the font changes, even though I copy the exact same thing.
> Times New Roman seems to be the dictator here.  And the size always
> changes.  Lines will suddenly become a 24 pt rather than 11 that I usually
> use.
What paste method are you using?
>
> The spaces between lines and paragraphs will change, and I can't change
> them back.  Most of the time I can't even use the backspace to move a word
> up to the last line.  And I can't move the first word (indent it).  If I
> click on a word that starts in the wrong place, there are no little
> triangles up in the top ruler, so I can't move the line or paragraph.
> There are other things, too, but if you can help with this, maybe all will
> be fixed.
You may want to modify the styles used and update the default template
>
> I understand that I may have done something unawares, so I thank you
> beforehand.
>
> Wanda Moore
>
Just for reference please advise the LO version and your OS.

-- 
Jay Lozier
jsloz...@gmail.com


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

[libreoffice-users] Documents do strange things

2012-05-25 Thread Wanda Moore

I write simple documents all the time, but my preferences don't seem to
matter to LO.  I choose a font, but it changes on me.  I cut or copy and
paste, and the font changes, even though I copy the exact same thing.
Times New Roman seems to be the dictator here.  And the size always
changes.  Lines will suddenly become a 24 pt rather than 11 that I usually
use.

The spaces between lines and paragraphs will change, and I can't change
them back.  Most of the time I can't even use the backspace to move a word
up to the last line.  And I can't move the first word (indent it).  If I
click on a word that starts in the wrong place, there are no little
triangles up in the top ruler, so I can't move the line or paragraph.
There are other things, too, but if you can help with this, maybe all will
be fixed.

I understand that I may have done something unawares, so I thank you
beforehand.

Wanda Moore

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

[libreoffice-users] Re: Is "^" different in Mac??

2012-05-25 Thread Tinkerer

Yes, but what is the difference?
Macro basic or Calc formula.
Either way, you still need to use the correct syntax.

Tink.


--
View this message in context: 
http://nabble.documentfoundation.org/Is-different-in-Mac-tp3985712p3986075.html
Sent from the Users mailing list archive at Nabble.com.

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

[libreoffice-users] Re: Python and Tkinter


Am 25.05.2012 21:00, Andreas Säger wrote:

Am 24.05.2012 19:39, SuneOskar wrote:

Is Tkinter supported ?

--
View this message in context:
http://nabble.documentfoundation.org/Python-and-Tkinter-tp3985866.html
Sent from the Users mailing list archive at Nabble.com.



help> modules Tkinter

Here is a list of matching modules. Enter any module name to get more help.

idlelib.CallTipWindow - A CallTip window class for Tkinter/IDLE.
idlelib.MultiCall - MultiCall - a class which inherits its methods from
a Tkinter widget (Text, for
idlelib.keybindingDialog - Dialog for building Tkinter accelerator key
bindings
idlelib.tabbedpages - An implementation of tabbed pages using only
standard Tkinter.
Tkdnd - Drag-and-drop support for Tkinter.
Tkinter - Wrapper functions for Tcl/Tk.






>>> import Tkinter
Traceback (most recent call last):
  File "", line 1, in 
  File 
"/opt/libreoffice3.5/program/python-core-2.6.1/lib/lib-tk/Tkinter.py", 
line 39, in 
import _tkinter # If this fails your Python may not be configured 
for Tk

ImportError: No module named _tkinter


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

[libreoffice-users] Re: Python and Tkinter


Am 24.05.2012 19:39, SuneOskar wrote:

Is Tkinter supported ?

--
View this message in context: 
http://nabble.documentfoundation.org/Python-and-Tkinter-tp3985866.html
Sent from the Users mailing list archive at Nabble.com.



help> modules Tkinter

Here is a list of matching modules.  Enter any module name to get more help.

idlelib.CallTipWindow - A CallTip window class for Tkinter/IDLE.
idlelib.MultiCall - MultiCall - a class which inherits its methods from 
a Tkinter widget (Text, for
idlelib.keybindingDialog - Dialog for building Tkinter accelerator key 
bindings
idlelib.tabbedpages - An implementation of tabbed pages using only 
standard Tkinter.

Tkdnd - Drag-and-drop support for Tkinter.
Tkinter - Wrapper functions for Tcl/Tk.



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

[libreoffice-users] Re: Python and Tkinter

2012-05-25 Thread SuneOskar

Visit wiki.python.org/moin/TkInter

--
View this message in context: 
http://nabble.documentfoundation.org/Python-and-Tkinter-tp3985866p3986063.html
Sent from the Users mailing list archive at Nabble.com.

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

Re: [libreoffice-users] Re: Is "^" different in Mac??

2012-05-25 Thread Mirosław Zalewski

On 25/05/2012 at 18:03, Tinkerer  wrote:

> Enter 3^2 does not work.
> The correct syntax is "=3^2".

You seem to be talking about LO Calc formula, while this thread is about 
ooBasic (macro language). Or I have missed something important here.
-- 
Best regards
Mirosław Zalewski

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

[libreoffice-users] Re: Python and Tkinter

2012-05-25 Thread Larry Gusaas


On 2012-05-25 2:17 AM  Tom Davies wrote:

Who is TKinter?


http://www.google.com/search?q=TKinter&ie=utf-8&oe=utf-8

--
_

Larry I. Gusaas
Moose Jaw, Saskatchewan Canada
Website: http://larry-gusaas.com
"An artist is never ahead of his time but most people are far behind theirs." - 
Edgard Varese



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

Re: [libreoffice-users] is there an Open office equivalent to Visio 2000

On 05/25/2012 12:06 PM, Custfold wrote:
> The loss of my access to a PC with Visio and Visio 2000 on it has left
> me with .vsd files that I cannot work on, and its beginning to get a
> bit of a problem.
>
> a) is there an open source program that can open these files, and
>
> b) can I use it to work with the files for future drawings.
>
> DH
>
I assume you use Windows. I did not see that Draw could open vsd files.
You might check Dia (https://live.gnome.org/Dia), which has a Windows
version. Dia can open the newer Visio files but I am uncertain of the
older ones.

-- 
Jay Lozier
jsloz...@gmail.com


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

[libreoffice-users] Re: Calc: Search & Replace Within A Column


Am 25.05.2012 15:14, Rich Shepard wrote:

On Fri, 25 May 2012, Andreas Säger wrote:


Turn on menu:View>Highlight Values [Ctrl+F8]. What is the font color
of X99? A blue color proves that X99 is a number. Text appears black.


Other than column A (site names), every other cell is blue.

I'm going to write an awk script that will change the zeros to the
appropriate reporting limit. That'll be quicker than my trying to
understand
what's happening in Calc.

Thanks, Andreas,

Rich




So you don't have any spreadsheet document. You are talking about a 
plain text file. Right?
Loading plain text tables (csv) into spreadsheet is a very common, 
nevertheless bad idea, particularly when you do not know anything about 
spreadsheets.



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

[libreoffice-users] Re: Calc: Search & Replace Within A Column


Am 25.05.2012 16:31, Rich Shepard wrote:

On Fri, 25 May 2012, Mirosław Zalewski wrote:


Can you post your document somewhere on the web? I think that there are
users who are just curious what's so special about your data that neither
of tips have worked for you.


Mirosław,

It's client data so I cannot distribute it.

Rich




Simply clear all text data so the remaining figures become meaningless. 
I can not understand what is going on in your spreadsheet.



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

[libreoffice-users] Re: Is "^" different in Mac??

2012-05-25 Thread Tinkerer

>Doesn't "=3^2" just give the equation rather than the answer?  Weird!  It
sounds like Mac is good fun to get used to. 
Regards from
Tom :)  

No Tom =3^2 gives the result, 9.

--
View this message in context: 
http://nabble.documentfoundation.org/Is-different-in-Mac-tp3985712p3986041.html
Sent from the Users mailing list archive at Nabble.com.

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

Re: [libreoffice-users] is there an Open office equivalent to Visio 2000

Hi :)
Have you tried Draw in LibreOffice 3.5.3?  I know it can handle some Visio Files
Regards from
Tom :) 


--- On Fri, 25/5/12, Custfold  wrote:

From: Custfold 
Subject: [libreoffice-users] is there an Open office equivalent to Visio 2000
To: users@global.libreoffice.org
Date: Friday, 25 May, 2012, 17:06

The loss of my access to a PC with Visio and Visio 2000 on it has left me with 
.vsd files that I cannot work on, and its beginning to get a bit of a problem.

a) is there an open source program that can open these files, and

b) can I use it to work with the files for future drawings.

DH

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


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

[libreoffice-users] Re: Extremely Slow Base Report Builder


Am 25.05.2012 10:04, Tom Davies wrote:


Sadly most of the people that know a lot about the ins-and-outs of Base are 
unwilling to help write the Base guide so it's down to 1 person who is 
desperately busy with a lot of other projects.



How would you write a guide for hammer, chisel, plow, saw and file? 
There is nothing special with Base. It is a simple tool set to do 
something with databases. "Simple" means the opposite of "easy".



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

[libreoffice-users] is there an Open office equivalent to Visio 2000

2012-05-25 Thread Custfold

The loss of my access to a PC with Visio and Visio 2000 on it has left 
me with .vsd files that I cannot work on, and its beginning to get a bit 
of a problem.


a) is there an open source program that can open these files, and

b) can I use it to work with the files for future drawings.

DH

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

Re: [libreoffice-users] Re: Is "^" different in Mac??

Hi :)
Doesn't "=3^2" just give the equation rather than the answer?  Weird!  It 
sounds like Mac is good fun to get used to.  
Regards from
Tom :)  


--- On Fri, 25/5/12, Tinkerer  wrote:

From: Tinkerer 
Subject: [libreoffice-users] Re: Is "^" different in Mac??
To: users@global.libreoffice.org
Date: Friday, 25 May, 2012, 17:03

I have a Mac.  System 10.7.4
Libre O, 3.5.4.2
The ^ is Shift 6 and it works perfectly.
Enter 3^2 does not work.
The correct syntax is "=3^2".


Tink.

--
View this message in context: 
http://nabble.documentfoundation.org/Is-different-in-Mac-tp3985712p3986029.html
Sent from the Users mailing list archive at Nabble.com.

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


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

[libreoffice-users] Re: Is "^" different in Mac??

2012-05-25 Thread Tinkerer

I have a Mac.  System 10.7.4
Libre O, 3.5.4.2
The ^ is Shift 6 and it works perfectly.
Enter 3^2 does not work.
The correct syntax is "=3^2".


Tink.

--
View this message in context: 
http://nabble.documentfoundation.org/Is-different-in-Mac-tp3985712p3986029.html
Sent from the Users mailing list archive at Nabble.com.

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

Re: [libreoffice-users] Re: Calc: Search & Replace Within A Column

Hi :)
Sometimes it's possible to replace all the confidential info in a file with 
random jumbles but in this case i think it would be 
1.  difficult to do
2.  almost impossible to work out how to help

I think you solved this a gnu&linux way already anyway so it's all good now :)
Regards from
Tom :)


--- On Fri, 25/5/12, Mirosław Zalewski  wrote:

From: Mirosław Zalewski 
Subject: Re: [libreoffice-users] Re: Calc: Search & Replace Within A Column
To: users@global.libreoffice.org
Date: Friday, 25 May, 2012, 15:18

On 25/05/2012 at 15:14, Rich Shepard  wrote:

>  I'm going to write an awk script that will change the zeros to the
> appropriate reporting limit. That'll be quicker than my trying to
> understand what's happening in Calc.

It may be.
Can you post your document somewhere on the web? I think that there are users 
who are just curious what's so special about your data that neither of tips 
have worked for you.
-- 
Best regards
Mirosław Zalewski

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

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

[libreoffice-users] Using LibreOffice with whitelisting applications in Windows

2012-05-25 Thread Matthew Ames


Hi,

In our company, we use whitelisting software which compares SHA hashes 
of files with a database full of them. Any .dll or .exe file which does 
not have a whitelisted hash is not allowed to run on our windows systems.


We are trying to roll out LibreOffice to update our current OpenOffice 
install base, however we have found a problem whitelisting LibreOiffce.


I have installed LibreOffice on multiple windows xp machines, but each 
time I do, a large number of dlls come out with different hashes. This 
means that it's impossible to whitelist the application.


Is it possible that there is a way around this? I imagine that we can 
install it, but call our install overwrite the files which have a 
different hash to that on the server with a known good version, but this 
seems a little ridiculous.


It would certainly be preferable to have the installer ensure all 
installs are exactly the same, in terms of files saved to the disk.


Regards,

Matthew.
--
Matthew Ames
Systems Support Analyst

Direct: +44 (0)20 7608 5324 Team: +44 (0)20 7608 7444

Email: ma...@integrafin.co.uk  Web: 
www.transact-online.co.uk 


Address: Domain House, 5-7 Singer Street, London EC2A 4BQ

Transact

Please consider the environment before printing this email

This message is intended only for the addressee and may contain 
confidential information. Unless you are that person, you may not 
disclose its contents or use it in any way and are requested to delete 
the message along with any attachments and notify us immediately. 
"Transact" is operated by Integrated Financial Arrangements plc. Domain 
House, 5-7 Singer Street, London EC2A 4BQ. Tel: (020) 7608 4900 Fax: 
(020) 7608 1200. (Registered office: as above; Registered in England and 
Wales under number: 3727592). Authorised and regulated by the Financial 
Services Authority (entered on the FSA Register; number: 190856)


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

[libreoffice-users] Re: Connecting libreoffice calc to existing sqlite database file

2012-05-25 Thread Alexander Thurgood

Le 25/05/12 16:16, Jonathan Ryshpan a écrit :

Hi Jon,

> If oobase has connected properly to the database, it is useless for my 
> purpose and I will give up on it and do what needs done with a bunch of 
> shell scripts. If oobase has not opened the database properly, I will 
> persevere.
> 

I took your dump, copied, and saved it to a text file with an sql
extension then imported it via the browser based SQLiteManager scripts
on my MAMP stack (Mac OSX). This gave me a table called "archive" and I
can see your data just fine using this technique.

My next step will be to try and set up and ODBC entry for use via LO on
the Mac. Will keep you posted.

I noticed that most of your fields are defined as REAL, however, I'm not
entirely sure how those are dealt with via ODBC, and particularly,
within the context of LibreOffice.

Which objects/fields in particular are you not seeing in your tables via
LO ?

Alex


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

Re: [libreoffice-users] Re: Calc: Search & Replace Within A Column

2012-05-25 Thread MiguelAngel


El 25/05/12 16:52, Rich Shepard escribió:

On Fri, 25 May 2012, Mirosław Zalewski wrote:


Sorry we could not solve your problem, then.


That's OK. awk, sed, grep, cut, and sort do the job very quickly. :-)

Thanks to all for the suggesions,

Rich




Maybe the mistake is in search for 0.000, it can't be found, because a 
0.000 is always saved as 0, nonsignificant zeroes to the right/left of 
decimal point are never saved.


Miguel Ángel

 * Inglés - detectado
 * Inglés
 * Español
 * Gallego
 * Italiano

 * Inglés
 * Español
 * Gallego
 * Italiano

 

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

Re: [libreoffice-users] Re: Calc: Search & Replace Within A Column

2012-05-25 Thread Rich Shepard


On Fri, 25 May 2012, Mirosław Zalewski wrote:


Sorry we could not solve your problem, then.


  That's OK. awk, sed, grep, cut, and sort do the job very quickly. :-)

Thanks to all for the suggesions,

Rich


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

Re: [libreoffice-users] Re: Calc: Search & Replace Within A Column

2012-05-25 Thread Mirosław Zalewski

On 25/05/2012 at 16:31, Rich Shepard  wrote:

>   It's client data so I cannot distribute it.

I was afraid that's the case.

Sorry we could not solve your problem, then.
-- 
Best regards
Mirosław Zalewski

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

[libreoffice-users] Re: Is "^" different in Mac??

2012-05-25 Thread Alexander Thurgood

Le 25/05/12 10:10, Tom Davies a écrit :

Hi Tom,

> or is it something weird about fonts and choosing the 'wrong' symbol somehow? 
>  Is the ^ on the top of the 6 key or is it selected as a  special character?
> Regards from

On a Macbook, the circumflex character appears on a key to the right of
the letter 'P'.

Alex


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

Re: [libreoffice-users] Re: Calc: Search & Replace Within A Column

2012-05-25 Thread Rich Shepard


On Fri, 25 May 2012, Mirosław Zalewski wrote:


Can you post your document somewhere on the web? I think that there are
users who are just curious what's so special about your data that neither
of tips have worked for you.


Mirosław,

  It's client data so I cannot distribute it.

Rich



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

Re: [libreoffice-users] Re: Calc: Search & Replace Within A Column

2012-05-25 Thread Mirosław Zalewski

On 25/05/2012 at 15:14, Rich Shepard  wrote:

>  I'm going to write an awk script that will change the zeros to the
> appropriate reporting limit. That'll be quicker than my trying to
> understand what's happening in Calc.

It may be.
Can you post your document somewhere on the web? I think that there are users 
who are just curious what's so special about your data that neither of tips 
have worked for you.
-- 
Best regards
Mirosław Zalewski

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

Re: [libreoffice-users] Connecting libreoffice calc to existing sqlite database file

2012-05-25 Thread Jonathan Ryshpan

I have been attempting to send this posting for a while, and have only
recently noticed that the list does not accept attachments.  This has
(apparently) caused it to be silently rejected.  I have appended what 
had been attached to the end of this posting.

Sorry for the delay.

On Mon, 2012-05-21 at 14:40 -0700, Jonathan Ryshpan wrote:
> ... the database doesn't look like what I had expected it to: sqlite
> databases contain within themselves the names and data types of all
> the entries, but when libreOffice opens the database, there is no such
> data visible.  Am I missing something.  A dump of the database using 
> "$ sqlite3 .sdb .dump" looks fine.  Is this what I should expect,
> or is something wrong, or am I missing something? On Tue, 2012-05-22

On Tue, 22 May 2012 at 00:43 +0200, Andreas Säger wrote:
> Am 21.05.2012 23:40, Jonathan Ryshpan wrote:
> >
> >blah
> >
> 
> Ask your question on a SQLite forum with some _technical_ information 
> about your operating system, SQLite version of the creating application, 
> driver version, configuration file, connection URL of the client (Base 
> menu:Edit>Database>Properties).

Wow!  This is enough to singe my beard.  Nevertheless I am grateful for
all replies, even beard singeing ones.

I fear that I put in too much technical detail, rather than too little.
As you see, I am a complete newbie to LibreOffice base (oobase), and am
only trying to find out whether I have succeeded in getting oobase to
open my database properly.  I don't think a posting to an sqlite forum
would be useful, since this is really a question about oobase.  

If oobase has connected properly to the database, it is useless for my 
purpose and I will give up on it and do what needs done with a bunch of 
shell scripts. If oobase has not opened the database properly, I will 
persevere.

Here is the technical info that Mr. Säger desires:

All my systems run Fedora-16.  The database was generated on an i686
system.  LibreOffice runs on an x86_64 system.  The database is
contained in a file named wview-archive.sdb generated on the i686 
system and copied to the x86_64 system.

The database was generated by wview, which can be downloaded at
http://www.wviewweather.com/
My running version of wview is accessible (in case you want to know
the weather here) at:
http://oaklandweather.no-ip.org/index.html/
The archive file is not visible from the web, but extracts from it 
are at:
http://oaklandweather.no-ip.org/index.html/Archive
The version of sqlite is included in 
sqlite-devel-3.7.7.1-1.fc16.<..>.rpm
The library is:
/usr/lib/libsqlite3.so.0.8.6
The drivers are in:
unixODBC-2.2.14-13.fc15.x86_64
and as specified in its initialization file (which follows)
$ cat ~/.odbc
[ODBC Data Sources]
mysqlitedb=SQLite

[mysqlitedb]
Driver=/usr/lib64/libsqlite3odbc.so
Description=My SQLite test database
Database=/home/jonrysh/src/wview/archive/nullWindSpeed/wview-archive.sdb
# optional lock timeout in milliseconds
Timeout=2000
The start of a dump of the database is appended to this message. 
I.e. the output of
$ sqlite3 archive.sdb .dump

If anyone else wants to know more about my struggles with oobase and 
sqlite, email me or post to the list.

All the best - jon

=== archive.txt ===
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE archive (
dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY,
usUnits INTEGER NOT NULL,
interval INTEGER NOT NULL,
barometer REAL,
pressure REAL,
altimeter REAL,
inTemp REAL,
outTemp REAL,
inHumidity REAL,
outHumidity REAL,
windSpeed REAL,
windDir REAL,
windGust REAL,
windGustDir REAL,
rainRate REAL,
rain REAL,
dewpoint REAL,
windchill REAL,
heatindex REAL,
ET REAL,
radiation REAL,
UV REAL,
extraTemp1 REAL,
extraTemp2 REAL,
extraTemp3 REAL,
soilTemp1 REAL,
soilTemp2 REAL,
soilTemp3 REAL,
soilTemp4 REAL,
leafTemp1 REAL,
leafTemp2 REAL,
extraHumid1 REAL,
extraHumid2 REAL,
soilMoist1 REAL,
soilMoist2 REAL,
soilMoist3 REAL,
soilMoist4 REAL,
leafWet1 REAL,
leafWet2 REAL,
rxCheckPercent REAL,
txBatteryStatus REAL,
consBatteryVoltage REAL,
hail REAL,
hailRate REAL,
heatingTemp REAL,
heatingVoltage REAL,
supplyVoltage REAL,
referenceVoltage REAL,
windBatteryStatus REAL,
rainBatteryStatus REAL,
outTempBatteryStatus REAL,
inTempBatteryStatus REAL
);
INSERT INTO "archive" 
VALUES(1337285700,1,5,29.903,29.903,29.89414,70.08,64.33,47.0,64.0,NULL,NULL,0.0,NULL,0.0,0.0,51.855492,NULL,64.33,0.0,947.0,8.0

Re: [libreoffice-users] Re: Calc: Search & Replace Within A Column

2012-05-25 Thread Rich Shepard


On Fri, 25 May 2012, Andreas Säger wrote:

Turn on menu:View>Highlight Values [Ctrl+F8]. What is the font color of X99? 
A blue color proves that X99 is a number. Text appears black.


  Other than column A (site names), every other cell is blue.

  I'm going to write an awk script that will change the zeros to the
appropriate reporting limit. That'll be quicker than my trying to understand
what's happening in Calc.

Thanks, Andreas,

Rich


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

Re: [libreoffice-users] modifying existing labels/cards

Joep

On 05/25/2012 06:48 AM, Joep L. Blom wrote:
> I have a simple question:
> I have a sheet with business cards (made with the correct template,
> etc.) but as I have a different printer I want to adjust the
> dimensions as to fit them perfectly. How is that done?
> I can not find a modify button anywhere and page formatting is not the
> correct way (it completely changes all dimensions).
> I'm still working with 3.4 (but will only change to 3.5 when it is
> reasonably bug-free.
> Thanks in advance,
> Joep
>
AFAIK your business cards form should print correctly on any printer
that has a large enough printing area. I have found the typical tweaks I
need are to adjust the margins of the text slightly so it does not print
on the edge.

I would print a set on plain paper and visually inspect to see if the
output looks correct. Then I would make any changes and repeat the test
page. Finally, when I think I have it correct I would print 1 set out
and see if there are any small problems.

-- 
Jay Lozier
jsloz...@gmail.com


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

Re: [libreoffice-users] Re: LibreOffice is listed as an educational software for math

On 05/25/2012 04:16 AM, Tom Davies wrote:
> Hi :)
> First time i went up to Manchester the university had just completed building 
> a huge building that had been designed to fit the latest best machine of the 
> day.  
>
> Unfortunately by the time the building work was done a better machine was 
> small enough to fit on one of the desks in one of the rooms.  I'm not quite 
> sure if that says more about the speed of computer development or the 
> slowness of English builders!  
> Regards from
> Tom :)  
Slowness of any government contractor, it is just as bad in the US
>
> --- On Thu, 24/5/12, webmaster-Kracked_P_P  wrote:
>
> From: webmaster-Kracked_P_P 
> Subject: Re: [libreoffice-users] Re: LibreOffice is listed as an educational 
> software for math
> To: users@global.libreoffice.org
> Date: Thursday, 24 May, 2012, 19:30
>
> On 05/24/2012 12:14 PM, Joep L. Blom wrote:
>> On 24-05-12 16:06, Tony Sumner wrote:
>>> On May 24, 2012, Jay Lozier wrote:
>>>
 This trip down memory lane makes one feeil old. Anyone remember
 teletypes with punched tape?
>>> Of course. My favourite paper tape story. At AEE, Winfrith, we did
>>> serious computing on the IBM704 at Risley in Lancashire. We would type
>>> the program onto paper tape and run it though a teletype to send it by
>>> phone to Risley. At their end they would punch it out and to check that
>>> it was ok they would send it back. At the Winfrith end we then had the
>>> original tape and a copy and we would hold these up to the light to
>>> check for errors. If there were none we'd phone Risley and say yes ok
>>> go ahead.  This was a communication protocol, yes? Later we installed a
>>> punched card system so we could put the program on cards and fly them
>>> to Risley by plane.
>>>
>>> Tony
>>>
>>>
>> I assume you never worked with the folded papertape used with the DEC PDP-8! 
>> coded in ASCII. Years before we used an  Electrologica X-1 with papertape 
>> coded in EBSDIC!You could edit the tapes with a manual punch and 
>> nontransparent sellotape. We thought punched cards were old-fashioned!.
>> Joep
>>
>>
> DEC PDP 11 and similar was most of my main-frame and mini-main-frame work 
> back in the 80's and early 90's.  I used  IBM main-frames in the late 70's 
> bunch cards and dumb terminals in then in late 90's with terminals dumb and 
> smart.  In the mid 70's I used a teletype style printer/terminal connected 
> via phone to a computer 50+ miles way, for my first coding experience, then 
> went to punch cards before I ever got to use a dumb terminal CRT display and 
> text editor to type in and edit program code for COBOL, FORTRAN, BASIC, 
> RPG-II/III, Assembly, and a few other languages.   Now people use PCs with 
> "smart" color coded editors to help them code, edit, and debug their programs.
>
> I wrote an RPG-III coding editor so it would be easier to line up the cryptic 
> codes in their proper columns.  It was well received at that place that used 
> RPG-II/III.  It took half the time to type in the programs in the dumb 
> terminals.
>
> I started my computer work experience when most computers I had "terminal" 
> access to, or had to load tapes for, were bigger than all my apartment rooms 
> combined, and then some.  I worked a terminal with one that used more floor 
> space than a basketball court.  I remember when a college put up a Bulletin 
> Board System [via phone modems] that had a brand new 10 MEG of drive space 
> and the people could not think of why it needed so much space to store files. 
>  10 MEG was too large to imagine using.  Those were the days when floppies 
> were floppy.
>
> ---
>
> Well we really went off thread topic with this one.
>
> As I stated in the original post, it was interesting that LO was listed under 
> free Math software.
>
> Now it seems we are talking about the "grand old days" of computers before 
> they could fit on a desk.
>
> I still know many people who do not have the money to buy a computer or if 
> they have one be able to get online with broadband.  In the '50 it was 
> thought there was no need for more than 50 to 100 computers in the whole USA. 
>  Now there are millions of them in the USA, with people like me having 
> several desktops/laptops running side by side when needed.  Then add their 
> smart phones, tablet phones, and the wifi reader/tablet non-phones that 
> people [and kids] thing are a requirement it their lives.  Well, this 
> generation does not appreciate what their fathers and grandfathers had to 
> deal with when they were working with computers in those early years when the 
> smallest computer was the size of a stove or refrigerator.
>
>


-- 
Jay Lozier
jsloz...@gmail.com


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
Al

[libreoffice-users] Re: Extremely Slow Base Report Builder


Am 25.05.2012 09:35, Tom Davies wrote:

Hi :)
I think there is another way to build reports?  I think Andreas uses a 
different way inside Base.  Other people seem to start with the report builder 
and then hack it around.  It might be worth search the archives to find how 
Andreas does reports!
Regards from
Tom :)



Somebody shouting: "Hi, Andreas! I need last year's figures of Item X 
but only the batch numbers used by myself"


Me shouting back: "Don't you remember the form 'Item Filter' and its 
print button?"


The print button on form 'Item Filter' points to spreadsheet template 
file:///Z:/Shared/ItemDB/Item_Filter.ots
That template keeps 2 unsaved import ranges. One import range shows the 
filter criteria that have been stored by the calling form. The other 
range pulls the resulting data from a prepared parameter query bound to 
the filter criteria and the involved data tables.
A new spreadsheet from template loads with a message: "This document 
contains unsaved links to data sources. Do you want to update the 
links?". I told my people to always hit "Yes"(Enter) in this case. The 
user can print the resulting report and he may or may not save a copy of 
the new file. All this works like a charm without a single line of macro 
code.

[Example #1] Filter/Search with Forms (leveraging SubForms):

http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=42845


In some cases where my nifty form does not apply, I need to create a 
query from scratch or copy/paste/adapt an existing one, drag the query 
icon into a spreadsheet template (or create a pivot table), apply some 
cell styles, send the result to some printer or PDF. Sometimes Calc's 
pivot tables provide the best reporting engine for the task.
Drag&Drop works with a blank Writer document as well. Unfortunately, we 
can not link the resulting text tables to the imported record set.


My database is for internal use only. Nobody cares when the print 
margins, orientations or number formats are not perfect.


I used the Sun Report Builder exactly once when it was particularly 
important to impress a bankster. I have a rough idea what it could do 
for me. I think Calc can do the same more easily except for pictures.



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

[libreoffice-users] modifying existing labels/cards

2012-05-25 Thread Joep L. Blom


I have a simple question:
I have a sheet with business cards (made with the correct template, 
etc.) but as I have a different printer I want to adjust the dimensions 
as to fit them perfectly. How is that done?
I can not find a modify button anywhere and page formatting is not the 
correct way (it completely changes all dimensions).
I'm still working with 3.4 (but will only change to 3.5 when it is 
reasonably bug-free.

Thanks in advance,
Joep

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

[libreoffice-users] Re: [3.5.3/XP/Write] Items with arrows?

2012-05-25 Thread Gilles

Thanks everyone, it worked. Another application I use simply pastes the new
object on top of the previous one, so I was used to this and expected
LibreOffice to do the same. Copying the original object, unselecting it,
then pasting the new object works.

Considering how often we write use that type of layout when taking lecture
notes, it'd be cool if LibreOffice somehow offered a way to automate that
task.

Thank you.

--
View this message in context: 
http://nabble.documentfoundation.org/3-5-3-XP-Write-Items-with-arrows-tp3985656p3985959.html
Sent from the Users mailing list archive at Nabble.com.

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

Re: [libreoffice-users] Python and Tkinter

Hi :)
Who is TKinter?
Regards from
Tom ;)


--- On Thu, 24/5/12, SuneOskar  wrote:

From: SuneOskar 
Subject: [libreoffice-users] Python and Tkinter
To: users@global.libreoffice.org
Date: Thursday, 24 May, 2012, 18:39

Is Tkinter supported ? 

--
View this message in context: 
http://nabble.documentfoundation.org/Python-and-Tkinter-tp3985866.html
Sent from the Users mailing list archive at Nabble.com.

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


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

Re: [libreoffice-users] Re: LibreOffice is listed as an educational software for math

Hi :)
First time i went up to Manchester the university had just completed building a 
huge building that had been designed to fit the latest best machine of the 
day.  

Unfortunately by the time the building work was done a better machine was small 
enough to fit on one of the desks in one of the rooms.  I'm not quite sure if 
that says more about the speed of computer development or the slowness of 
English builders!  
Regards from
Tom :)  

--- On Thu, 24/5/12, webmaster-Kracked_P_P  wrote:

From: webmaster-Kracked_P_P 
Subject: Re: [libreoffice-users] Re: LibreOffice is listed as an educational 
software for math
To: users@global.libreoffice.org
Date: Thursday, 24 May, 2012, 19:30

On 05/24/2012 12:14 PM, Joep L. Blom wrote:
> On 24-05-12 16:06, Tony Sumner wrote:
>> On May 24, 2012, Jay Lozier wrote:
>> 
>>> This trip down memory lane makes one feeil old. Anyone remember
>>> teletypes with punched tape?
>> 
>> Of course. My favourite paper tape story. At AEE, Winfrith, we did
>> serious computing on the IBM704 at Risley in Lancashire. We would type
>> the program onto paper tape and run it though a teletype to send it by
>> phone to Risley. At their end they would punch it out and to check that
>> it was ok they would send it back. At the Winfrith end we then had the
>> original tape and a copy and we would hold these up to the light to
>> check for errors. If there were none we'd phone Risley and say yes ok
>> go ahead.  This was a communication protocol, yes? Later we installed a
>> punched card system so we could put the program on cards and fly them
>> to Risley by plane.
>> 
>> Tony
>> 
>> 
> I assume you never worked with the folded papertape used with the DEC PDP-8! 
> coded in ASCII. Years before we used an  Electrologica X-1 with papertape 
> coded in EBSDIC!You could edit the tapes with a manual punch and 
> nontransparent sellotape. We thought punched cards were old-fashioned!.
> Joep
> 
> 
DEC PDP 11 and similar was most of my main-frame and mini-main-frame work back 
in the 80's and early 90's.  I used  IBM main-frames in the late 70's bunch 
cards and dumb terminals in then in late 90's with terminals dumb and smart.  
In the mid 70's I used a teletype style printer/terminal connected via phone to 
a computer 50+ miles way, for my first coding experience, then went to punch 
cards before I ever got to use a dumb terminal CRT display and text editor to 
type in and edit program code for COBOL, FORTRAN, BASIC, RPG-II/III, Assembly, 
and a few other languages.   Now people use PCs with "smart" color coded 
editors to help them code, edit, and debug their programs.

I wrote an RPG-III coding editor so it would be easier to line up the cryptic 
codes in their proper columns.  It was well received at that place that used 
RPG-II/III.  It took half the time to type in the programs in the dumb 
terminals.

I started my computer work experience when most computers I had "terminal" 
access to, or had to load tapes for, were bigger than all my apartment rooms 
combined, and then some.  I worked a terminal with one that used more floor 
space than a basketball court.  I remember when a college put up a Bulletin 
Board System [via phone modems] that had a brand new 10 MEG of drive space and 
the people could not think of why it needed so much space to store files.  10 
MEG was too large to imagine using.  Those were the days when floppies were 
floppy.

---

Well we really went off thread topic with this one.

As I stated in the original post, it was interesting that LO was listed under 
free Math software.

Now it seems we are talking about the "grand old days" of computers before they 
could fit on a desk.

I still know many people who do not have the money to buy a computer or if they 
have one be able to get online with broadband.  In the '50 it was thought there 
was no need for more than 50 to 100 computers in the whole USA.  Now there are 
millions of them in the USA, with people like me having several 
desktops/laptops running side by side when needed.  Then add their smart 
phones, tablet phones, and the wifi reader/tablet non-phones that people [and 
kids] thing are a requirement it their lives.  Well, this generation does not 
appreciate what their fathers and grandfathers had to deal with when they were 
working with computers in those early years when the smallest computer was the 
size of a stove or refrigerator.

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

Re: [libreoffice-users] Re: Is "^" different in Mac??

Hi :)
Could it be a problem with the user profile?
https://wiki.documentfoundation.org/Documentation/UserProfile
It's often good to start by renaming the User Profile just to see if whatever 
weirdness vanishes after doing that.  You might end-up copying the user profile 
back, or chunks of it back but renaming the profile is a good way of "getting 
back to factory defaults".  

or is it something weird about fonts and choosing the 'wrong' symbol somehow?  
Is the ^ on the top of the 6 key or is it selected as a  special character?
Regards from
Tom :)  

--- On Thu, 24/5/12, Alexander Thurgood  wrote:

From: Alexander Thurgood 
Subject: [libreoffice-users] Re: Is "^" different in Mac??
To: users@global.libreoffice.org
Date: Thursday, 24 May, 2012, 19:49

Le 24/05/12 20:37, Andreas Säger a écrit :

Hi Andreas,

> Sub Main
> print 3^2
> End Sub

Yes, that's what I thought, but it works fine on my Mac OSX 10.6.8 :

LibreOffice 3.5.3.2
Version ID : 235ab8a-3802056-4a8fed3-2d66ea8-e241b80

Alex

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

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

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

Hi :)
I have just done a bit of digging around.

Looking back through Andreas' answers
http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodes&user=254826&i=80

I found this but i'm not sure it's much help for you 
http://nabble.documentfoundation.org/database-td3926217i20.html#a3928210

This one seems to expand on the useful line at the end there
http://nabble.documentfoundation.org/Base-3-5-2-2-hangs-td3910280.html#a3911654

This one is a bit of an overview with nothing specific but might be useful to 
skim through for ideas
http://nabble.documentfoundation.org/Address-Books-td3829696.html#a3832514

This one looks brilliant to me
http://nabble.documentfoundation.org/Base-and-new-Report-Builder-in-3-5-td3817159.html#a3819387

There is some documentation at 
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
and an FAQ (translated from the French team's) at 
https://wiki.documentfoundation.org/Faq

Sadly most of the people that know a lot about the ins-and-outs of Base are 
unwilling to help write the Base guide so it's down to 1 person who is 
desperately busy with a lot of other projects.  

Regards from
Tom :) 


--- On Thu, 24/5/12, Girvin R. Herr  wrote:

From: Girvin R. Herr 
Subject: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder
To: users@global.libreoffice.org
Date: Thursday, 24 May, 2012, 20:01



Andreas Säger wrote:
> With LibO 3.5 under Linux I can use any recent Java version without any 
> issues. I tested 1.6.22, 1.6.31 and 1.7. Any of these simply work with my 
> Java databases.
> I avoid the report builder like illness. If you feel the need to dance with 
> this software diva then you should do all calculations, filtering, grouping 
> and sorting in SQL leaving the only good looking stuff up to the beast.
> 
> 
Andreas,
Thanks for your reply.  Report Builder (RB) has always been a "beast" to me 
too, but it is the only option I know of for printing my database data in a 
human readable form.  So, I have to live with it, at least until I find 
something better.  Before Base, I was using Rekall, which had some nice 
features.  But that Open Source version is no longer supported, so that option 
is dead.
I am using a SQL query to sort and provide all the data to Report Builder.  I 
am not using any RB grouping or filtering either.  It is just a "flat" data set 
for RB to pretty up for printing.  That is why I don't see why it is so slow.  
All the real time consumers, such as sorting, are being done by MySQL.  Also, 
after writer displays my first page or two, it goes out to lunch again, as if 
it is recalculating everything all over again.  That is frustrating, since it 
locks up and I have to wait several more minutes for another couple-second 
window where I can scroll or kill it before it goes off again.
I will certainly take your experience to heart and your recommendation to 
update my Java.
Thanks again.
Girvin


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


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

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder