[libreoffice-users] Re: Marching ants, Calc, Xorg, CPU usage, Ubuntu

[chimak111]

chimak111 wrote
> 
> ...
> Does LibreOffice have an alternative to the use of marching ants at least
> for Linux?
> 
Turning off anti-aliasing helps. I came across this workaround here:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/462487
(comment #13).

I'll have to keep a watch for what the downside is, if any.



--
View this message in context: 
http://nabble.documentfoundation.org/Marching-ants-Calc-Xorg-CPU-usage-Ubuntu-tp3996853p3997050.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] auto-complete font style

[e-letter]

Readers,

Is it possible to configure LO writer auto-complete function such that
the font style is maintained?

For example, the word 'explanation'. If the caps-lock is activated,
the auto-complete offers to complete word in lower case:

EXPLAnation

It would be better if the auto-complete function maintained the same
font-style when completing a word.

Is this a legitimate feature request?

-- 
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] Migrating from Windows; take it slow

[Don Parris]

>
> On 07/22/2012 11:05 AM, Tom Davies wrote:
>
>> Hi :)
>> Ok, so i have posted 'a few' anti-MS posts but not everyone is ready to
>> suddenly jump into the alien world of the scary sounding GNu&Linux or
>> unix-based OSes.  Windows is supplied on almost every machine bought
>> anywhere in the world so why change at all?!
>>
>>
>> 

On that note, Some here might enjoy my now ancient LXer article on this
subject:
http://lxer.com/module/newswire/view/47135/index.html

I was sharing my experience of being without Windows for a full year back
in 2005.  I agree with Tom and KrackedPress on the general gist of changing
systems.  Take it slow and easy.  I did.  There is much less to worry about
with hardware issues these days, but the adjustment to little differences
in the desktops can be frustrating for some, until they are actually
adjusted.  :-)

My wife is now becoming more of a Linux user herself.  It has taken her a
while, but she is beginning to catch on.  She is a complete computer
novice, and had only a little experience with Windows before we met.  She
has this feeling of Windows as somehow more "user friendly", which was the
opposite of my experience.  At first she was excited, and later grew a bit
frustrated.  Now she seems to be enjoying her system a bit more.

I grew increasingly frustrated with Windows over the years and finally
managed to "kick the habit".  Even though I experience frustrations with
GNU & Linux-based systems, I prefer those frustrations over my experiences
with Windows any day of the week.

I would add that, if you are considering migrating a business, church or
non-profit organization from whatever to any of the GNU & Linux-based
systems, I really recommend hiring someone with some experience in
migrations (or at least knows how to go about it) to help you think through
the process.  There are a great many details that need to be worked
through.  It might cost a leg, but that's better than an arm and two legs -
not to mention the mutiny from users when the migration falls apart.  A
slow, gradual approach is best here as well - albeit even more so.

Regards,
Don
-- 
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
http://dcparris.net/

GPG Key ID: F5E179BE

-- 
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] Microsoft Core Fonts

[webmaster-Kracked_P_P]

It is spelled with uppercases when I open them and see its name in the 
window's title box.


But either way, I use it more than the Software Center.

With my stroked-out typing skills, at times it is much safer to install 
anything either from a package manager or the software center than it 
would be typing the commands via the Terminal.


--

Actually, have anyone lately see all of the TTF font package that are in 
the package manager for Ubuntu?  I have not looked at the 12.04 version 
with this in mind, but the first time I saw what was in 10.04's distro, 
the more I wondered.


I wish I could get a full list of these fonts outside of the 
installation.  Some of the packages are full with too many of them.  I 
would rather pick and choose the ones I would like to use and leave the 
rest out.  Also, it would be nice to not have to wade though all the 
non-English or non-Latin fonts if I could choose to.  But at least there 
are enough for a person to get a taste of what might be out there.  The 
only problem would be accidentally deleting a needed font.  Did that 
once and had to reinstall 10.04 to correct that problem that stopped my 
ability to read menus and some displayed text.


Still, it would be nice to know what are Ubuntu's core needed fonts so 
someone does not do what I did and delete one or three from the 
installed font list.


Of course with the Core Fonts idea, maybe someone should start comparing 
fonts and maybe start a table/list of font names and similar ones win 
the different OSs.  Take a font name and list what is the closest font 
that is installed, be default, in Windows [XP, Vista, Win7], MaxOSX, and 
different Linux distros.  Then list popular fonts by name and paid and 
free fonts that are similar enough to be replacements for them.


There are some list out there, but since LO is a package for creating 
documents, we would do well to have a list of free fonts to replace paid 
ones, like LO is replacing a paid office package. Any takers?


I could search for some of my old comparison lists, and maybe start it 
going, but I could use people to help fill it in.  We could make a WIKI 
page out of this so anyone could contribute to it.  Good idea?


On 07/22/2012 04:09 PM, Jay Lozier wrote:

On 07/22/2012 02:36 PM, Dan wrote:
I believe that the correct spelling is synaptic. (It is spelled this 
way for my Ubuntu 11.10.)
You are correct, I tend to capitalize names even when they are not 
capitalized.


Jay Lozier wrote:

On 07/22/2012 01:04 AM, Johnny Rosenberg wrote:

2012/7/21 Anthony Easthope :

Hi

I was wondering what would be considered the core fonts on Microsoft.
After ages fruitless searching I was wondering if anybody could 
help me

on what they would consider to be core fonts.
I backed up my fonts folder from windows 7 before the change to 
ubuntu
so I had all of them problem is I can not be bothered installing 
every

single one of them!

If you search for ttf-mscorefonts in Synpatic you might find them
already installed. Also, you can install a font installer via Synaptic
or the Software Center to install the fonts you backed up from 
Windows 7.

The quickest way, if you want to install those mss TTF core fonts from
the repositories, is from a terminal. Just copy this line into a
terminal and hit Enter. Note that the keyboard shortcut for Paste is
Ctrl+Shift+v, if you didn't edit those yourself:

sudo apt-get install ms-corefonts-installer

The package contains:
Andale
Arial Black
Arial
Comic Sans
Courier New
Georgia
Impact
Times New Roman
Trebuchet
Verdana
Webdings

If you only want to use Arial, Times New Roman and Courier New, it's
recommended that you use the free fonts from the package
fonts-liberation instead (probably already installed on your system.
Those are called something like Liberation Sans (looks like Arial) and
so on.



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ




--

antiso...@myopera.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] Microsoft Core Fonts

[Jay Lozier]

On 07/22/2012 02:36 PM, Dan wrote:
I believe that the correct spelling is synaptic. (It is spelled this 
way for my Ubuntu 11.10.)
You are correct, I tend to capitalize names even when they are not 
capitalized.


Jay Lozier wrote:

On 07/22/2012 01:04 AM, Johnny Rosenberg wrote:

2012/7/21 Anthony Easthope :

Hi

I was wondering what would be considered the core fonts on Microsoft.
After ages fruitless searching I was wondering if anybody could 
help me

on what they would consider to be core fonts.
I backed up my fonts folder from windows 7 before the change to ubuntu
so I had all of them problem is I can not be bothered installing every
single one of them!

If you search for ttf-mscorefonts in Synpatic you might find them
already installed. Also, you can install a font installer via Synaptic
or the Software Center to install the fonts you backed up from 
Windows 7.

The quickest way, if you want to install those mss TTF core fonts from
the repositories, is from a terminal. Just copy this line into a
terminal and hit Enter. Note that the keyboard shortcut for Paste is
Ctrl+Shift+v, if you didn't edit those yourself:

sudo apt-get install ms-corefonts-installer

The package contains:
Andale
Arial Black
Arial
Comic Sans
Courier New
Georgia
Impact
Times New Roman
Trebuchet
Verdana
Webdings

If you only want to use Arial, Times New Roman and Courier New, it's
recommended that you use the free fonts from the package
fonts-liberation instead (probably already installed on your system.
Those are called something like Liberation Sans (looks like Arial) and
so on.



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ




--

antiso...@myopera.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











--
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: Labeling in Calc

[Tom Davies]

Hi :)
I think that no you have an answer there is no need to continue to pursue this 
or deal with ongoing discussion about it.  It's fine to just walk away from 
it.  

That was a good point about "You've absorbed the cost of your own time and 
pegged it's value at zero.".  Base might be a better tool and might be able to 
read data directly from a website but it would need someone that knows how to 
use it.  

Also i'm not convinced that Base is yet worth investing a lot of time in unless 
you are prepared to go all the way to programming and developing it.  Calc is 
more mature and stable as more devs work on it.  Anyway, just my 2cents again
Regards from
Tom :)  


--- On Sun, 22/7/12, Andrew Brager  wrote:

From: Andrew Brager 
Subject: Re: [libreoffice-users] Re: Labeling in Calc
To:
 users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 19:40

On 7/22/2012 10:34 AM, Andreas Säger wrote:
> 
> Enter raw data into a spreadsheet (Excel, Gnumeric, Calc, whatever), a text 
> editor, some dBase application, a true database, whatever.
> Connect a Base document to the tabular data source and design a report.

But that's the point isn't it.  I've got to enter data into the spreadsheet.  
We're in agreement.

Why must I take the time, expense and trouble to "design a report" when I can 
get satisfactory results with a bare minimum of time, expense and trouble using 
Calc?

Clearly, you know Base and designing said report is no big deal for you.  I 
think I may have opened Base once, and I simply don't have the time to learn 
it, nor the money to pay someone else to do the work for me.  Especially not 
when a solution presents itself in Calc so
 readily.

Yes, your solution is elegant, ideal and based in academia where people have 
all the time in the world to learn applications and techniques and then design 
dream or "best practice" solutions.  In the world of business it's about 
simplicity, speed, expense and return on investment.  I can hire a virtual 
assistant from a third world country for less than $2 an hour, who already 
knows how to use a spreadsheet (not that cut & pasting requires much 
knowledge), whereas to hire a programmer to design a report would cost in 
excess of $8 an hour (and everytime I need a change I either have to go find 
that same contractor who now charges more, or start the interview process all 
over again; a time consuming task) - plus I still need to hire the assistant 
that ends up doing just about the exact same (busy) work anyway.  So where is 
the economical benefit to your solution?

Your solution works for you because you have not
 considered the real cost of implementing it.  It may be "best practice" from 
an academic, engineering and/or scientific standpoint, but from a SMALL 
business perspective it makes little sense.  You've absorbed the cost of your 
own time and pegged it's value at zero.  I'm taking real dollars out of my own 
pocket and paying someone to do the work.  It's the same reason why people hire 
housekeepers - if the cost of the housekeeper were more than the employers 
income they couldn't afford to pay the housekeeper for long and would 
eventually have to clean their own house.  You're cleaning your own house and 
that works for you.  Great!  I prefer to pay someone so I'm free to focus my 
time on what I hope are more profitable endeavors.

> As a matter of fact, database forms (even Base forms) provide much faster and 
> less error prone ways of data entry. In the last 2 years I replaced a dozend 
> of useless spreadsheet lists
 with simple databases because "my users" never really got used to spreadsheet 
editing (navigation, dates, numbers, clear, delete, ...). Spreadsheets are too 
versatile for untrained users. Wrong data yield wrong results. My databases 
collect a thousand of manually entered records per month on a local network.

So really you're trying to apply a one-size-fits-all approach.  My users (1 or 
2 assistants) already know how to use spreadsheets so technically they're not 
"untrained", whereas your users do not know how.  You collect thousands of 
MANUALLY entered records per month. I might have maybe a thousand or so records 
total, which can be cut & pasted from website to spreadsheet.  My needs are 
different than yours.  Any solution needs to take the customer's needs and 
unique situation into account and in this case I'm the customer.


-- 
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: Filter rows of certain dates, LibreOffice Calc

[Andreas Säger]

Am 22.07.2012 19:31, Johnny Rosenberg wrote:


Thanks for the suggestion. However, I failed making it work. I tried a
few different variations on that and either nothing happened at all,
or I got an error message saying that there are no valid filter
parameters in that range of cells.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ




The "advanced filter" is documented. It reads filter criteria from cells 
rather than dialog or drop-downs.
It uses the exact same type of criteria ranges as the database functions 
(DSUM, DCOUNT etc). You may refer to the filter documentation or 
D-function reference.


Example file of mine: http://www.mediafire.com/view/?6vkfs9qq1qg666x


--
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] Date format macro.

[rhubarbpieguy]

On 07/21/12 18:46, Dave Barton wrote:

 Original Message  
From: rhubarbpie...@gmail.com
To: Dave Barton 
Date: Sat, 21 Jul 2012 12:59:52 -0500


On 07/21/12 00:45, Dave Barton wrote:

 Original Message  
From: rhubarbpie...@gmail.com
To: users@global.libreoffice.org
Date: Fri, 20 Jul 2012 20:33:27 -0500


On 07/20/12 02:16, Dave Barton wrote:

 Original Message  
From: rhubarbpie...@gmail.com
To: users@global.libreoffice.org
Date: Thu, 19 Jul 2012 16:48:53 -0500


I'd like to create a macro for a user-defined date format
(H:MMa/p).  As
examples, 7:00 AM would display as 7:00a and 3:33 PM as 3:33p.  I can
create the format manually, but I understand the LibreOffice format
can't save user-defined formats.  So my thought is to create a macro
which creates the format each time the spreadsheet is opened.  The
user-defined Format Code is for a saved Style.

The macro records without incident and the date format is correct.
However, running the saved macro doesn't change the format.  It seems
this should work.  Thoughts?  The recorded macro is as follows:


8<-- code snip for brevity -->8

Sorry I can't help with your macro, but I like your idea.
An alternative approach I use, is to add my user defined date format to
my Calc default template.

Dave



Thank you for responding; I admire your style. I manually changed the
date format of my spreadsheet, saved , then coded it as the default
template. The default template took, but unfortunately, again the
user-defined date format wasn't saved.


Do I understand you can save a user-defined date format in the default
template and it takes? I'm sure a macro would work and I can wade
through the code, but if there's an easier way I'm interested.

I am not sure what you mean by "coded it as the default  template".
If you follow this procedure:
http://user.services.openoffice.org/en/forum/viewtopic.php?t=1161
the ".ots" (Calc template) file will include your date format, as would
be the case for any ODF file.
I am sending you (off-list) an example template which has a DD.MM.
date format, which is not included in standard list of date formats.
Open it and you will find 31.12.1999 at the end of the Format => Date ->
Category format list.

HTH

Dave

.


Thank you again for responding.  However, I think we're talking apples
and oranges.  I opened your template and the DD.MM. user-defined
format works.  My problem is I can't get the H:MMa/p user-defined Format
Code to take.  While the document is opened I can change 1:11PM to 1:11p
for instance.  However, after saving, closing, and reopening the
document the time appears as 1:11PM, not 1:11p, which is the format code
I wanted saved.  I've always been able to save the user-defined code, I
just can't get the lower-case a/p to take.  It does work with other file
formats.

That happens regardless of whether I save as an .ods or .ots file. I do
see the user-defined Format Code, but it always comes up as H:MMAM/PM
even though I save it as H:MMa/p.  I believe I originally created a
default template correctly, but just redid the process with your
instructions.  The same thing happens if I save the format in your
attached template.

So, can you successfully save the H:MMa/p format code?  That would
address the apples/oranges question.  I'd appreciate your testing that
if possible.  If it works for you I'm doing something wrong. It's not a
huge deal to manually change AM/PM to a/p each time I open the
spreadsheet, but not having to do so would be better.

Your "apples & oranges" analogy is correct. I was misled by your
original reference to "Date" format and although you spelled it out
quite clearly I overlooked the fact that your issue was with "Time" format.

I have now done some testing on this issue, with the following results:
* Saving from LO in ODF (".ods" or ".ots") format does not preserve the
user defined time format you want. (As you have already established.)
* Saving from LO in Excel (".xls") format and reopening it LO does
preserve the format. (As suggested by Pedro in another post to this thread.)

It may or may not be of importance to you, but opening the files saved
from LO and opening them in Excel 2010 I found:
* XLS File: Partially preserves the time format (ie. H:MM), but the
lower case p/m is becomes upper case P/M. The user defined cells are
"locked" (MS terminology) and "unlocking" them the format changes to
whatever MS deems to be appropriate.
* ODF File: Generates an error, which Excel generously offers to fix,
with the same result as for unlocking the cells in the XLS file.

Unless someone with a better knowledge of Star Basic than myself can
offer a solution to your macro problem, I suggest you file a bug/RFE
issue. https://www.libreoffice.org/get-help/bug/

Dave



I understand your confusion as I should have titled the post "Time 
format macro."  Sloppy labeling on my part.


I have reported this as Bug 50923.  That's why I believed it was/is an 
.od

Re: [libreoffice-users] Re: Labeling in Calc

[Andrew Brager]

On 7/22/2012 10:34 AM, Andreas Säger wrote:


Enter raw data into a spreadsheet (Excel, Gnumeric, Calc, whatever), a 
text editor, some dBase application, a true database, whatever.

Connect a Base document to the tabular data source and design a report.


But that's the point isn't it.  I've got to enter data into the 
spreadsheet.  We're in agreement.


Why must I take the time, expense and trouble to "design a report" when 
I can get satisfactory results with a bare minimum of time, expense and 
trouble using Calc?


Clearly, you know Base and designing said report is no big deal for 
you.  I think I may have opened Base once, and I simply don't have the 
time to learn it, nor the money to pay someone else to do the work for 
me.  Especially not when a solution presents itself in Calc so readily.


Yes, your solution is elegant, ideal and based in academia where people 
have all the time in the world to learn applications and techniques and 
then design dream or "best practice" solutions.  In the world of 
business it's about simplicity, speed, expense and return on 
investment.  I can hire a virtual assistant from a third world country 
for less than $2 an hour, who already knows how to use a spreadsheet 
(not that cut & pasting requires much knowledge), whereas to hire a 
programmer to design a report would cost in excess of $8 an hour (and 
everytime I need a change I either have to go find that same contractor 
who now charges more, or start the interview process all over again; a 
time consuming task) - plus I still need to hire the assistant that ends 
up doing just about the exact same (busy) work anyway.  So where is the 
economical benefit to your solution?


Your solution works for you because you have not considered the real 
cost of implementing it.  It may be "best practice" from an academic, 
engineering and/or scientific standpoint, but from a SMALL business 
perspective it makes little sense.  You've absorbed the cost of your own 
time and pegged it's value at zero.  I'm taking real dollars out of my 
own pocket and paying someone to do the work.  It's the same reason why 
people hire housekeepers - if the cost of the housekeeper were more than 
the employers income they couldn't afford to pay the housekeeper for 
long and would eventually have to clean their own house.  You're 
cleaning your own house and that works for you.  Great!  I prefer to pay 
someone so I'm free to focus my time on what I hope are more profitable 
endeavors.


As a matter of fact, database forms (even Base forms) provide much 
faster and less error prone ways of data entry. In the last 2 years I 
replaced a dozend of useless spreadsheet lists with simple databases 
because "my users" never really got used to spreadsheet editing 
(navigation, dates, numbers, clear, delete, ...). Spreadsheets are too 
versatile for untrained users. Wrong data yield wrong results. My 
databases collect a thousand of manually entered records per month on 
a local network.


So really you're trying to apply a one-size-fits-all approach.  My users 
(1 or 2 assistants) already know how to use spreadsheets so technically 
they're not "untrained", whereas your users do not know how.  You 
collect thousands of MANUALLY entered records per month. I might have 
maybe a thousand or so records total, which can be cut & pasted from 
website to spreadsheet.  My needs are different than yours.  Any 
solution needs to take the customer's needs and unique situation into 
account and in this case I'm the customer.




--
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] Microsoft Core Fonts

[Dan]

I believe that the correct spelling is synaptic. (It is spelled this way 
for my Ubuntu 11.10.)


Jay Lozier wrote:

On 07/22/2012 01:04 AM, Johnny Rosenberg wrote:

2012/7/21 Anthony Easthope :

Hi

I was wondering what would be considered the core fonts on Microsoft.
After  ages fruitless searching I was wondering if anybody could help me
on what they would consider to be core fonts.
I backed up my fonts folder from windows 7 before the change to ubuntu
so I had all of them problem is I can not be bothered installing every
single one of them!

If you search for ttf-mscorefonts in Synpatic you might find them
already installed. Also, you can install a font installer via Synaptic
or the Software Center to install the fonts you backed up from Windows 7.

The quickest way, if you want to install those mss TTF core fonts from
the repositories, is from a terminal. Just copy this line into a
terminal and hit Enter. Note that the keyboard shortcut for Paste is
Ctrl+Shift+v, if you didn't edit those yourself:

sudo apt-get install ms-corefonts-installer

The package contains:
Andale
Arial Black
Arial
Comic Sans
Courier New
Georgia
Impact
Times New Roman
Trebuchet
Verdana
Webdings

If you only want to use Arial, Times New Roman and Courier New, it's
recommended that you use the free fonts from the package
fonts-liberation instead (probably already installed on your system.
Those are called something like Liberation Sans (looks like Arial) and
so on.



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ




--

   antiso...@myopera.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] Microsoft Core Fonts

[webmaster-Kracked_P_P]

I try to keep the same set of "core fonts" - not just MS core web fonts 
- on all of my computers whether they are Windows or Ubuntu systems.  I 
tend to have over 100 fonts installed on these systems for greater 
flexability on the look of my documents printer/exported to PDF for 
distribution.  LO's Export to PDF, CUPS PDF printing for Linux, or doPDF 
PDF printing for Windows.


The font installer, and other fonts software, is a good place to look at 
specialty fonts that might be used for your documents.  I used to use 
some really "special" ones from time to time, like letters made out of 
bone or other holiday related fonts.


The core fonts that come with most MS systems, or the MS core font 
package for Linux, is just a start.  You really need to look at all of 
your options for typography of your documents.  Then using a PDF 
creation method, that embeds those fonts into your document, will make 
sure that your readers/users of those documents will see your work the 
way you want it to be seen.  LO does a good job with some of the popular 
fonts, but not as good on the decorative ones I tend to use.  That is 
where CUPS PDF and doPDF "PDF printer software" comes into play.  They 
will embed all of your specialty fonts into your documentation.  One day 
LO's Export to PDF will do that job as good as they do.


As someone who download over 100,000 fonts from free font sites, I can 
tell you that there are many great looking fonts out there for your text 
and "special" documents that can be better than the MS core fonts.  All 
you have to do is take the time to look, download, and test some of them 
side to side with the MS core fonts.


On 07/22/2012 01:50 PM, Jay Lozier wrote:

On 07/22/2012 01:04 AM, Johnny Rosenberg wrote:

2012/7/21 Anthony Easthope :

Hi

I was wondering what would be considered the core fonts on Microsoft.
After  ages fruitless searching I was wondering if anybody could 
help me

on what they would consider to be core fonts.
I backed up my fonts folder from windows 7 before the change to ubuntu
so I had all of them problem is I can not be bothered installing every
single one of them!
If you search for ttf-mscorefonts in Synpatic you might find them 
already installed. Also, you can install a font installer via Synaptic 
or the Software Center to install the fonts you backed up from Windows 7.

The quickest way, if you want to install those mss TTF core fonts from
the repositories, is from a terminal. Just copy this line into a
terminal and hit Enter. Note that the keyboard shortcut for Paste is
Ctrl+Shift+v, if you didn't edit those yourself:

sudo apt-get install ms-corefonts-installer

The package contains:
Andale
Arial Black
Arial
Comic Sans
Courier New
Georgia
Impact
Times New Roman
Trebuchet
Verdana
Webdings

If you only want to use Arial, Times New Roman and Courier New, it's
recommended that you use the free fonts from the package
fonts-liberation instead (probably already installed on your system.
Those are called something like Liberation Sans (looks like Arial) and
so on.



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ




--

   antiso...@myopera.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] LibreOffice pause during startup

[Jay Lozier]

On 07/21/2012 07:24 PM, anne-ology wrote:

CCleaner is not necessarily a registry cleaner ... it can do that;
but it mainly is used to clean out the caches.

And there are more than this one listed on this site - Gizmo's
Freeware Utilities .
Igor at Dedoimedo.com had post 
(http://www.dedoimedo.com/computers/linux-cleaning.html) about the need 
for using cleaning tools in Linux. His opinion is their use is not as 
critical as similar tools are for Windows, in fact he believes they are 
not that valuable for many users. Many of these tools are available in 
various repositories so you do not need to look for them.


Most browsers can be set to automatically clean their caches and limit 
how much information is stored.




--
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] Microsoft Core Fonts

[Jay Lozier]

On 07/22/2012 01:04 AM, Johnny Rosenberg wrote:

2012/7/21 Anthony Easthope :

Hi

I was wondering what would be considered the core fonts on Microsoft.
After  ages fruitless searching I was wondering if anybody could help me
on what they would consider to be core fonts.
I backed up my fonts folder from windows 7 before the change to ubuntu
so I had all of them problem is I can not be bothered installing every
single one of them!
If you search for ttf-mscorefonts in Synpatic you might find them 
already installed. Also, you can install a font installer via Synaptic 
or the Software Center to install the fonts you backed up from Windows 7.

The quickest way, if you want to install those mss TTF core fonts from
the repositories, is from a terminal. Just copy this line into a
terminal and hit Enter. Note that the keyboard shortcut for Paste is
Ctrl+Shift+v, if you didn't edit those yourself:

sudo apt-get install ms-corefonts-installer

The package contains:
Andale
Arial Black
Arial
Comic Sans
Courier New
Georgia
Impact
Times New Roman
Trebuchet
Verdana
Webdings

If you only want to use Arial, Times New Roman and Courier New, it's
recommended that you use the free fonts from the package
fonts-liberation instead (probably already installed on your system.
Those are called something like Liberation Sans (looks like Arial) and
so on.



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ




--

   antiso...@myopera.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




--
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] Migrating from Windows; take it slow

[webmaster-Kracked_P_P]

I went into using Ubuntu 9.10 for my default system when I bought my 
current desktop.  I still use 10.04 on it.  I had run other version of 
Linux before going to Ubuntu, but Ubuntu was the only Live CD/DVD that 
allow the sound system to work properly on my HP AMD64 CPU laptop that I 
used for testing.  I did not have this desktop then, but an old IBM 
server and a Dell laptop, along with the HP laptop.


I still use Windows from time to time.  The HP Laptop is back running 
XP/pro [32-bit] and my Dell laptop dual boots Vista [32 bit] and 64 bit 
Ubuntu 12.04 with MATE as its desktop environment so it works closely 
like my [generic custom built quad] desktop's 10.04/GNOME 2.xx system.


There are some software I still have not found a good Linux version for 
and there are some USB hardware that I have not found a good Linux 
driver for.  So I still need Windows once in a while.  I have people 
that need help with their Windows systems, mostly laptops, so I need to 
be able to boot up a Windows system to help them out.  One day I hope to 
replace the Vista OS with Win7 on my dual boot Dell laptop.  My HP 
laptop does not have enough free hard drive space to do a dual booting 
system.


ALSO
I have 2 USB drives for backing up my desktop, and also sharing media 
file with my Blu-ray player and other systems that require Windows-based 
drive formats.  SO, I need a Windows system to defrag those USB drives.  
I have a 1 TB and a 2 TB USB external drive, so they can easily become 
fragmented when I update them with my files/folders that need to be 
backed up - I copy the file onto the external drives - from my desktop 
to the external ones. I have a 1 TB and a 2 TB internal drives on my 
Ubuntu desktop.


SO I still need Windows for some things.

YET, with using Ubuntu [GNOME or MATE] for several years now as my 
default OS, I still do not know all the ins and outs I use to know with 
the Windows systems.  I still have not figured out all of the things I 
could do with my XP or Vista systems.  I still am not completely 
comfortable with the Terminal and all of its uses.  I know there are 
many, many, more things I could do with the Terminal that I never really 
learned.  I still forget how to install LO on a Ubuntu system - sudo 
dpkg -i *.deb - sometimes. There are install options and other commands 
that people using Ubuntu, and other Linux distros, know how to do much 
better than I.  I do not get into Ubuntu as much as I use to in the 
early days when I supported XP and Vista systems for others.  I do not 
do even half of the things I use to do in the late '90's to mid 2000's 
with a computer.  So I never really learned how to do some of the things 
I could do with my Linux systems.


SO
Anyone who really wants to learn how to use Linux as a replacement for 
Windows, try dual booting a system if you do not have a spare one to try 
Linux with as its only OS.


I started using Linux for the simple reason that I needed a package to 
convert AVI and MPEG video files into a TV DVD movie disc.  My Windows 
software crashed and I could not longer get it working even with a 
re-install.  So I found that the Linux software DeVeDe worked well.  Now 
it comes with a Windows version, but not when I started using it on an 
P4 CPU IBM server made in 2000 and burned it on a USB DVD burner.


That was when I started looking at all the free software that Linux 
offered to its users.  With a fixed income and the need to get a lot of 
different software, and many costing a lot for my Windows computers, I 
decided to look into using Linux - Ubuntu 9.10 for a few months till 
10.04 came out - when I had the money to buy a quad CPU desktop.


Now I get to learn a new Linux-based OS - Android 4.0 Ice Cream Sandwich 
- since now I have a 7-inch tablet costing about $100. It is not the 
best 7 inch tablet on the market, but it was what I could afford on my 
fixed income.


So, the short is:
Linux is a good OS to use, but you may still need to have a Windows 
system from time to time.


Another reason for keeping a Windows system available - testing:
K3b burns a great data disc, but the default "Windows and Linux" disc 
format does not work well for making a web-based DVD.  It messes with 
the file names sometimes.  I found that out the hard way when I tested 
the DVD on my Windows system.  Now I use "Rock Ridge" file system for my 
DVD.   There are other "default" CD/DVD burners, but K3b was the only 
one that I could easily define the CD's / DVD's file system.  So I found 
out that way, that I needed to keep a Windows system to check that my 
DVDs will work on Windows.  I do not have a MacOSX system, so I cannot 
check that OS out.



On 07/22/2012 11:05 AM, Tom Davies wrote:

Hi :)
Ok, so i have posted 'a few' anti-MS posts but not everyone is ready to suddenly 
jump into the alien world of the scary sounding GNu&Linux or unix-based OSes.  
Windows is supplied on almost every machine bought anywhere in the world so why 
chang

[libreoffice-users] Re: Labeling in Calc

[Andreas Säger]

Am 22.07.2012 16:19, Tom Davies wrote:

Hi :)
That is true.  So why not use the fastest route to get the required result and stick with 
spreadsheeting for now?  Definitely a good idea to start vaguely thinking about moving to a 
database program when time&resources permits.  Base is not yet ready for masses and does 
take some fairly considerable expertise "to get it right".  Set-up is not trivial 
even if some people find it easy.
Regards from
Tom :)


--- On Sun, 22/7/12, Andreas Säger  wrote:



Please ignore Tom. He is very kind but totally ignorant towards LibreOffice 
Base which can read spreadsheet data as if they were database data.





Tom, you will never get it because your engagement is entirely 
idealistic. You do not use LibreOffice more than a beginner.


Enter raw data into a spreadsheet (Excel, Gnumeric, Calc, whatever), a 
text editor, some dBase application, a true database, whatever.

Connect a Base document to the tabular data source and design a report.
The report will read the raw unsorted data and present them in any 
wanted order with any grouping you want. The very same report will 
always reflect the current status of the raw, unfiltered, unsorted data.
Both, the data source and the report may be spreadsheets. A sheet report 
can have some conditional formatting to hide values when they are equal 
to the preceeding value.


All I try to explain over and over again: In any case you should 
strictly separate the raw data storage from calculated, sorted, 
filtered, grouped and formatted output. This is best practice for 
spreadsheets and databases enforce this separation anyway.


As a matter of fact, database forms (even Base forms) provide much 
faster and less error prone ways of data entry. In the last 2 years I 
replaced a dozend of useless spreadsheet lists with simple databases 
because "my users" never really got used to spreadsheet editing 
(navigation, dates, numbers, clear, delete, ...). Spreadsheets are too 
versatile for untrained users. Wrong data yield wrong results. My 
databases collect a thousand of manually entered records per month on a 
local network.



--
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: Filter rows of certain dates, LibreOffice Calc

[Johnny Rosenberg]

2012/7/22 Andreas Säger :
> Am 22.07.2012 13:27, Johnny Rosenberg wrote:
>>
>> I searched for Standard Filter examples and the only thing I found had
>> a string or a number in the Value fields. I want to use an expression
>> instead, but that doesn't seem possible, or maybe I'm just doing it
>> wrong.
>> For example:
>>
>> Column A>=   Today()-7
>>
>> Doesn't work at all. The only thing that happens is that rows not
>> containing a date at all in Column A are hidden. In this case I only
>> want to hide those rows older than a week. I guess I am just not doing
>> it right, right?
>>
>>
>>
>> Kind regards
>>
>> Johnny Rosenberg
>> ジョニー・ローゼンバーグ
>>
>
>
> Data>Filter>Advanced Filter...
> Point to a 2-cell range with column label and calculated value.
>
> Cell #1: =$A$1
> Cell #2: =">="&TODAY()-7

Thanks for the suggestion. However, I failed making it work. I tried a
few different variations on that and either nothing happened at all,
or I got an error message saying that there are no valid filter
parameters in that range of cells.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
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] Microsoft Core Fonts

[Johnny Rosenberg]

2012/7/22 webmaster-Kracked_P_P :
>
> The key was to find the core fonts package first.
>
> Yes, I see your point with using the terminal for doing the installation of
> packages, but you need to know what those packages are.
>
> Also, if you use a package manager, or the Software Center, you can search
> for the packages and install them from there without needing to get the
> "spelling" of the package correct.  Some people, like me, can have problems
> typing at times.  My fingers do not always work correctly and I rely on my
> spell checker to catch things.  So with a package manager or software
> center, you do no need to worry about typing in a command in the terminal
> correctly.

If you get a line to type from a forum or a mailing list like this
one, you don't need to type much:
Highlight the text that you want to type → Ctrl+c → Open a terminal
(by clicking its icon somewhere, or maybe you have a keyboard shortcut
for it, like Super+t in my case, or maybe you start it up with
Gnome-do or similar) → Ctrl+Shift+v (unless you set another shortcut
for pasting in your favourite terminal emulator).
So, as you see, not much typing involved and no risc for spelling
errors, unless the person who gave you the line typed it wrong, of
course.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

>
> Then there are the differences with the desktop environments.  For 12.04 I
> have used Unity, GNOME 3, and MATE for desktop environments.  I prefer MATE.
> IT works more like the GNOME DE that in used by Ubuntu 10.04, better than
> the options in GNOME 3.
>
> So once the OP knew that he could use a single package to install the "small
> core" of MS fonts, and then know what it is, it is up to the user to decide
> what if the easiest way to install it.  When I search for a package, it is
> easier for me to install it with the package manager or the software center,
> instead of using that info and type the proper commands in the terminal.
>
> IF I am given a terminal command where I can cut/paste [say from a web page
> or an email], then it can be easy for me to use the terminal option.
> cut/paste was how I "typed in" the commands to install MATE on my 12.04
> laptop.
>
> This link that was in a posting
> https://launchpad.net/ubuntu/precise/+package/ttf-mscorefonts-installer
> was listed as the core fonts for the web.
>
> This list has a few other fonts in their list of MS core fonts for the web.
> http://en.wikipedia.org/wiki/Core_fonts_for_the_Web
>
> This link shows which core fonts are on both MS systems and Mac systems.
> http://web.nickshanks.com/fonts/microsoft-core-web-fonts
>
> So that means that there many be more "core fonts" that MS Win7 uses that
> the user might want to install.
>
> He seem to state that he did not want to do all the work to install all of
> the fonts he had in his font folder.  Well as far as I an thinking, it is
> really easy to install a block of fonts. All you need to do is place them in
> a folder, highlight them like you we going to copy them to another folder,
> then just do a right-click and open them with the default font viewer.  Then
> just click on the "install" button for each font.  I is an easy way to get
> them installed properly in the .fonts hidden folder.  At least it is the
> easiest way I found.
>
> The real kicker is for the user, any user, to install the fonts that he/she
> needs for the work he/she need to do.
>
> As stated before, by me and others, you can get free fonts that are very
> similar to the paid ones of a specific name.  All you have to do is look.
> BUT, if that person is required to work with a specific font for an
> employer, or other person of authority, then they will have to see if they
> have those fonts somewhere that they can use for their Ubuntu/Linux work
> instead of Windows work.
>
> When I take a laptop/desktop and replace the Windows OS that came with it, I
> copy the fonts that came with the system and then reinstall them when I have
> Ubuntu installed.  That way, I use the fonts that came with the computer.
> Personally, I feel that if the laptop has the fonts installed, then those
> fonts can stay installed on the system no matter what the OS changes to.
>
>
>
>
> On 07/22/2012 08:11 AM, Tom Davies wrote:
>>
>> Hi :)
>> I found the name for Ubuntu 10.04, so the command would be:
>>
>> sudo apt-get install ttf-mscorefonts-installer
>>
>> and installing Synaptic Package Manager would be:
>>
>> sudo apt-get install synaptic
>>
>> but i agree with Johnny that it sounds like Ubuntu 12.04 and i suspect he
>> has checked the exactly right name already.  Generally i find Synaptic
>> useful for looking up things when i am not totally sure of the name of the
>> thing.  It searches in package descriptions as well as titles so you can be
>> pretty vague with searches.  Then it's easy to pick and choose (although
>> probably ignore all the packages starting with "lib..." so just scroll
>> through them fast).
>>
>> The command-line is easiest when giv

Re: [libreoffice-users] Re: Chart Office compatibility issue

[Regina Henschel]

Hi Andreas,

Andreas Säger schrieb:

Am 22.07.2012 18:10, Regina Henschel wrote:


A first step might be to add a request to LO bugzilla.

But I personally liked more, when named ranges would be possible.

Kind regards
Regina




Named ranges are named formula expressions. Formula expressions would
include constant arrays.



Named ranges can be implemented in a "small" way, with a textual 
exchange, when the chart needs recalculating. Then constant arrays are 
still not supported. Of cause, a "large" solution would integrate array 
constants and other expressions, which result in a proper range, too.


Kind regards
Regina



--
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: Labeling in Calc

[Andrew Brager]

Exactly Tom.  With Calc, setup cost and time is next to zero, with data 
entry not much more.  With Base setup cost and time is non-negligible 
and data entry is much more time (and therefore real dollar cost) 
consuming as each field needs to be filled in by hand when using a 
form.  With a spreadsheet I can actually cut & paste the info. from a 
website directly into Calc.  Can that be done with Base?


Seems to me that the best solution even if using a database is to first 
enter into a spreadsheet where it can then be saved as a file of CSV and 
then imported into a database should I find the need.


Bottom line is it's already done in Calc - took about a minute - while 
doing it in Base requires sitting down and spending time and money on 
first creating a schema with forms and further, one needs to be a master 
of SQL which most people including myself are not. (Inner joins, outer 
joins, left right... haven't a clue.  Cut & paste?  click, drag, 
shift-click, click, done, repeat as needed - no higher brain power 
required.)


In theory a database is more elegant and conceptually appealing, but in 
practice a spreadsheet IMHO wins the day.  YMMV.



On 7/22/2012 7:19 AM, Tom Davies wrote:

Hi :)
That is true.  So why not use the fastest route to get the required result and stick with 
spreadsheeting for now?  Definitely a good idea to start vaguely thinking about moving to a 
database program when time&resources permits.  Base is not yet ready for masses and does 
take some fairly considerable expertise "to get it right".  Set-up is not trivial 
even if some people find it easy.
Regards from
Tom :)


--- On Sun, 22/7/12, Andreas Säger  wrote:



Please ignore Tom. He is very kind but totally ignorant towards LibreOffice 
Base which can read spreadsheet data as if they were database data.







--
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: Chart Office compatibility issue

[Andreas Säger]

Am 22.07.2012 18:10, Regina Henschel wrote:


A first step might be to add a request to LO bugzilla.

But I personally liked more, when named ranges would be possible.

Kind regards
Regina




Named ranges are named formula expressions. Formula expressions would 
include constant arrays.



--
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: Chart Office compatibility issue

[Regina Henschel]

Hi,

davews schrieb:


Regina Henschel wrote


Hi,

davews schrieb:

I have received an xls spreadsheet created in Office which contains
charts.
But the charts appear blank - there are bars/columns on sheet 2 and
graphs/lines on sheet 3.  You can find the spreadsheet
http://www.btinternet.com/~dsergeant/cadismay.xls here

(because of the nature of the file,  I cannot upload it to here and will
delete it soon).

The file displays properly in MS Excel viewer.


The chart is based on a constant matrix. That is not possible in LO. LO
needs a reference to a range or an embedded table.

Kind regards
Regina




Many thanks, at least we now know why it doesn't display. Are there any
plans to add this functionality to LO?


No. The problem is known in AOO bugzilla 
https://issues.apache.org/ooo/show_bug.cgi?id=64821


A first step might be to add a request to LO bugzilla.

But I personally liked more, when named ranges would be possible.

Kind regards
Regina

--
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] LibreOffice 3.5 with Lubuntu

[Tom Davies]

Hi :)
Perhaps rename your User Profile to "get back to factory defaults"?
http://wiki.documentfoundation.org/Documentation/UserProfile
Regards from
Tom :)  


--- On Sun, 22/7/12, Peter Hillier-Brook  wrote:

From: Peter Hillier-Brook 
Subject: [libreoffice-users] LibreOffice 3.5 with Lubuntu
To: users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 13:41

I'm running LO 3.5 under Lubuntu 12.04 and, until recently the relevant icons 
appeared under "Office" in the menu system. Now they don't and I have to start 
the program via the command line. Any ideas anyone?

For information the installation is the "real" LO installed via dpkg, not the 
Ubuntu build with its attendant problems. :-)

Peter HB

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

Package managers, was Fw: Re: [libreoffice-users] Microsoft Core Fonts

[Tom Davies]

Hi :)
It doesn't matter which package manager you use.  They all keep track of 
anything done in any of the others by keeping 1 central database of what is on 
your system which each package manager then uses and just presents the 
information differently.  Possibly dpkg is a little different.  There's always 
1 that has to be different!  Lol

The apt-get instruction was: 

sudo apt-get install synaptic

but i tend to prefer a gui front-end such as the software center.  
Regards from
Tom :)  



--- On Sat, 21/7/12, Anthony Easthope  wrote:

From: Anthony Easthope 
Subject: Re: [libreoffice-users] Microsoft Core Fonts
To: users@global.libreoffice.org
Date: Saturday, 21 July, 2012, 22:41

Synaptics package manager is available from the software center or is
there a suitable "sudo get-apt install" code?

on the amount of fonts you have that's insane! that must be close to
10gb worth of them!

On Sat, 21 Jul 2012, at 05:36 PM, webmaster-Kracked_P_P wrote:
> 
> Each version of Windows had a different set of "core" fonts.  I am a 
> "font person" so I should know this.  I have over 100,000 of them in my 
> collection.
> 
> Do you want to install the core fonts on  you Ubuntu system?  I run both 
> 10.04 and 12.04.
> 
> If you go to the Synaptic Package Manager and type in "ms core fonts", 
> you get something like
> 
> "ttf-mscorefonts-installer"
> 
> That is what shows on my 10.04 system I use as my default one, which I 
> am typing from here.
> 
> Install that and you get the "core" fonts that seem to be used by most 
> of the Windows versions from XP to Win7.  Since I tend to have 200+ 
> fonts installed on both my Windows and Ubuntu systems, I have lost track 
> of the names of the current "core fonts".  There are references to them 
> in lists, along with the core fonts for MacOSX, but you do not need to 
> know those names and matching fonts between systems unless you do some 
> font choosing in a web site's CSS theme.  I use to do that.
> 
> SO,
> if you want to have your Ubuntu system include the "core" fonts that MS 
> thinks you need, then install that "ttf-mscorefonts-installer" package.  
> It is all you may need as far as MS is concerned.  BUT, if you really 
> need some decorative fonts of specialty ones, I may have most of the 
> free ones that were available as of 2-3 years back.  I really have not 
> looked for many new ones lately.
> 
> 
> 
> On 07/21/2012 05:23 PM, Anthony Easthope wrote:
> > Hi
> >
> > I was wondering what would be considered the core fonts on Microsoft.
> > After  ages fruitless searching I was wondering if anybody could help me
> > on what they would consider to be core fonts.
> > I backed up my fonts folder from windows 7 before the change to ubuntu
> > so I had all of them problem is I can not be bothered installing every
> > single one of them!
> >   
> >
> 
> 
> -- 
> 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
> 


-- 
  
  antiso...@myopera.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] Migrating from Windows; take it slow

[Tom Davies]

Hi :)
Ok, so i have posted 'a few' anti-MS posts but not everyone is ready to 
suddenly jump into the alien world of the scary sounding GNu&Linux or 
unix-based OSes.  Windows is supplied on almost every machine bought anywhere 
in the world so why change at all?!  

If you have realised why then how to go about it?  

Many first-timers fail because they try to "burn their bridges" and completely 
suddenly switch without much planning, or perhaps with too much planning.  

A frequently successfully route that many have followed (often as a 2nd attempt 
to get into it) is often found to be to  first familiarised yourself with the 
programs that run on both Windows and Gnu&Linux: programs such as Firefox 
(instead of IE), Thunderbird or Evolution instead of Outlook, Gimp instead of 
Photoshop, LibreOffice instead of MS Office.  That way once you arrive at "the 
big switch" you have familiar 'friends' on your desktop and in 
forums/mailing-lists.  Documentation can help pull you through too.  

A good next step is to resurrect some ancient machine from a junk heap or 
cupboard and try as a "Live Cd" (booting straight from the Cd without 
installign anything) and then next is to install as a dual-boot.  Chances are 
that first time you try to do a dual-boot it goes wrong even though it's the 
default for almsot every distro and basically requires you do the equivalent of 
just clicking "Next".  If it's an old machine anyway then you don't lose much 
AND you get to learn how to do it properly before risking yoru main machine.  

I was really quite keen  but oddly reluctant to escape from MS but it took me 
about 2 years between the time i got my neighbour to install a dual-boot of 
Mandriva alongside my Windows.  At first i booted mostly into Windows but about 
1/month might boot into Mandriva by mistake.  by the end of the 2 years it had 
become more and more often and more deliberately especially after i found a 
decent game and then found i really could work from it too.  

To be fair i had an impression that Gnu&Linux was like Unix and therefore big, 
scary and all based on the command-line.  I'm still a little intimidated by the 
command-line so i was glad to find that actually even back then Mandriva was 
almost entirely point&click.  Then Wolvix and Ubuntu seemed to take that 
further and now i am mostly in Ubuntu nearly all the time but even now i do use 
Windows from time-to-time.  

Once i had made the switch i found myself getting irrationally angry about all 
the odd things that i had been forced to do unnecessarily over the years to 
maintain Windows.  A bit like a hostage released from captivity after long-term 
imprisonment.  All the slow-downs, antivirus, sudden forced reboots, forced 
updates, pop-ups grabbing focus and generally being slave to the machine.  All 
of which vanished with Gnu&Linux (weirdly the grabbing focus thing seems to 
have been added to Ubuntu since then).  i became obsessed with freeing people 
who didn't want to be freed.  I guess that is roughly where Andreas is now with 
Base but has been stuck there a while.  Really there is no need.  

Nowadays i can mostly sit back and just laugh at the ridiculous things people 
put themselves through with Windows and then claim that Windows is easier as 
though they have tried anything else when they clearly haven't even picked up 
an iAnything.  

It's not easy to avoid trying to help especially when a little help can often 
go a long way.  

The mistake a lot of people make when they are new to Gnu&Linux is trying to 
force other people to use it.  This earns a bad reputation and really there is 
no need for it.  if people would rather dig with a spoon than a shovel then let 
them.  Just smile wisely and move on to help a person that does appreciate it.  

Regards from
Tom :)  

-- 
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: Labeling in Calc

[Tom Davies]

Hi :)
That is true.  So why not use the fastest route to get the required result and 
stick with spreadsheeting for now?  Definitely a good idea to start vaguely 
thinking about moving to a database program when time&resources permits.  Base 
is not yet ready for masses and does take some fairly considerable expertise 
"to get it right".  Set-up is not trivial even if some people find it easy.  
Regards from
Tom :)  


--- On Sun, 22/7/12, Andreas Säger  wrote:



Please ignore Tom. He is very kind but totally ignorant towards LibreOffice 
Base which can read spreadsheet data as if they were database data. 



-- 
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] Microsoft Core Fonts

[Tom Davies]

Hi :)
+1
Searching is easier in a nice gui package manager such as Synaptic but if you 
have a good guide to follow it's easier to copy&paste stuff.  I would tend to 
use the "--help" command before following anyone's guidance tho uless i'm happy 
to hose the system and reinstall the OS.  For example 

apt-get --help

would reassure me but 

sudo --help 

might have me worried so i would then have to find out more about the advice.  

Which is better?  Command-line or nice gui?  My answer would have to be that i 
prefer each of them for different circumstances and use both reasonably often.  
I prefer using a point&click gui if i can find one reasonably quickly.  
Probably each person has their own preferences and none are wrong.  

Regards from
Tom :)  


--- On Sun, 22/7/12, webmaster-Kracked_P_P  wrote:

From: webmaster-Kracked_P_P 
Subject: Re: [libreoffice-users] Microsoft Core Fonts
To: users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 14:44


The key was to find the core fonts package first.

Yes, I see your point with using the terminal for doing the installation of 
packages, but you need to know what those packages are.

Also, if you use a package manager, or the Software Center, you can search for 
the packages and install them from there without needing to get the "spelling" 
of the package correct.  Some people, like me, can have problems typing at 
times.  My fingers do not always work correctly and I rely on my spell checker 
to catch things.  So with a package manager or software center, you do no need 
to worry about typing in a command in the terminal correctly.

Then there are the differences with the desktop environments.  For 12.04 I have 
used Unity, GNOME 3, and MATE for desktop environments.  I prefer MATE.  IT 
works more like the GNOME DE that in used by Ubuntu 10.04, better than the 
options in GNOME 3.

So once the OP knew that he could use a single package to install the "small 
core" of MS fonts, and then know what it is, it is up to the user to decide 
what if the easiest way to install it.  When I search for a package, it is 
easier for me to install it with the package manager or the software center, 
instead of using that info and type the proper commands in the terminal.

IF I am given a terminal command where I can cut/paste [say from a web page or 
an email], then it can be easy for me to use the terminal option.  cut/paste 
was how I "typed in" the commands to install MATE on my 12.04 laptop.

This link that was in a posting
https://launchpad.net/ubuntu/precise/+package/ttf-mscorefonts-installer
was listed as the core fonts for the web.

This list has a few other fonts in their list of MS core fonts for the web.
http://en.wikipedia.org/wiki/Core_fonts_for_the_Web

This link shows which core fonts are on both MS systems and Mac systems.
http://web.nickshanks.com/fonts/microsoft-core-web-fonts

So that means that there many be more "core fonts" that MS Win7 uses that the 
user might want to install.

He seem to state that he did not want to do all the work to install all of the 
fonts he had in his font folder.  Well as far as I an thinking, it is really 
easy to install a block of fonts. All you need to do is place them in a folder, 
highlight them like you we going to copy them to another folder, then just do a 
right-click and open them with the default font viewer.  Then just click on the 
"install" button for each font.  I is an easy way to get them installed 
properly in the .fonts hidden folder.  At least it is the easiest way I found.

The real kicker is for the user, any user, to install the fonts that he/she 
needs for the work he/she need to do.

As stated before, by me and others, you can get free fonts that are very 
similar to the paid ones of a specific name.  All you have to do is look.  BUT, 
if that person is required to work with a specific font for an employer, or 
other person of authority, then they will have to see if they have those fonts 
somewhere that they can use for their Ubuntu/Linux work instead of Windows work.

When I take a laptop/desktop and replace the Windows OS that came with it, I 
copy the fonts that came with the system and then reinstall them when I have 
Ubuntu installed.  That way, I use the fonts that came with the computer.  
Personally, I feel that if the laptop has the fonts installed, then those fonts 
can stay installed on the system no matter what the OS changes to.



On 07/22/2012 08:11 AM, Tom Davies wrote:
> Hi :)
> I found the name for Ubuntu 10.04, so the command would be:
> 
> sudo apt-get install ttf-mscorefonts-installer
> 
> and installing Synaptic Package Manager would be:
> 
> sudo apt-get install synaptic
> 
> but i agree with Johnny that it sounds like Ubuntu 12.04 and i suspect he has 
> checked the exactly right name already.  Generally i find Synaptic useful for 
> looking up things when i am not totally sure of the name of the thing.  It 
> searches in package descriptions as well as titles so y

Re: [libreoffice-users] LibreOffice pause during startup

[Tom Davies]

Hi :)
Errr, i think the paging file = pagefile.sys?  Probably changed name in Vista 
and Win7.  The pagefile.sys used to be the name of the Windows virtual memory.  

The registry is something completely different that MS kept trying to get rid 
of but couldn't in order to retain backwards compatibility with older programs 
that may need to be installed on newer systems.  

Gnu&Linux routinely throws out garbage once it has stopped being useful.  
Occasionally that means upgrading a few sub-packages in order to keep a few 
main programs working but then everything is OpenSource so it's reasonably easy 
for people to go in and do that without necessarily having to contact the 
organisation that owns the copyright.  Often a few changes to one sub-package 
will fix it for all programs.  

Consequentaly Gnu&Linux has managed to retain greater backwards compatibility 
with both hardware and software as it works on smaller and lighter systems 
while Windows programs, drivers and other packages have often needed complete 
re-writes due to trivial issues.  

I really hope there hasn't been a post about security or antivirus in the last 
few days!!  Lol
Regards from
Tom :)  


--- On Sat, 21/7/12, Anthony Easthope  wrote:

From: Anthony Easthope 
Subject: Re: [libreoffice-users] LibreOffice pause during startup
To: users@global.libreoffice.org
Date: Saturday, 21 July, 2012, 23:05

 If there is no registry or temporary paging system within the OS then
 how does that work? It is a curiosity within itself 
:D
On Sat, 21 Jul 2012, at 05:57 PM, Don C. Myers wrote:
> Hi,
> 
> I run Ubuntu. As I understand it, Linux (including Ubuntu) doesn't use a 
> registry, therefore you don't need to have a registry cleaner.
> 
> Don
> 
> 
> On 07/21/2012 05:50 PM, Anthony Easthope wrote:
> > Infact your workaround could work in theory, the problem is finding a
> > ccleaner equivalent for debian
> >
> > On Sat, 21 Jul 2012, at 11:48 PM, Anthony Easthope wrote:
> >> Anne that work around works on windows but as the gentlemen said he was
> >> using debian squeze which is a variation of linux. I am curious as to
> >> why it is hanging to - by rights it should not be.
> >>
> >> On Fri, 20 Jul 2012, at 09:15 PM, anne-ology wrote:
> >>>         If you're referring to it getting hung-up, then this has happened
> >>>         to
> >>> me a few times -
> >>>             my solution is to shut it down -> clear out the caches
> >>>             [CCleaner
> >>> is good] -> re-start the computer;
> >>>                 when it re-starts, OO/LO works great again.
> >>>
> >>>         One of the problems with OO/LO is its immense size; if there were
> >>> some way to reduce its size then this might not occur, but then it might
> >>> not be as good a program as it is  ;-)
> >>>
> >>>         Mine is not caused by 'calling home or anywhere' since my machine
> >>> only allows 'cookies', etc. which I accept and only at the time I accept
> >>> them; in fact, each time I've tested my machine, it's invisible to these
> >>> robotic eyes  :-)
> >>>
> >>>
> >>>
> >>> On Fri, Jul 20, 2012 at 1:44 AM, Robert Mesibov
> >>> wrote:
> >>>
> >>> I'm running LibreOffice 3.4.6 OOO340m1 (Build:602) on Debian Squeeze.
>  The progress bar on the splash screen stops part-way during startup for
>  about 10 seconds. During this time LO sends a request of some sort over 
>  the
>  network connection (lights flash on router) every 2 seconds, 5 times in
>  all. LO then completes startup.
> 
>  This happens
>  - with the splash screen turned off in /etc/libreoffice/sofficerc (the
>  pause and network requesting still happen)
>  - when launching LO by itself, or when opening a Writer or other LO
>  document through a file manager
>  - with Java RE option on or off
> 
>  With an LO document already open, there is no pause when opening a second
>  LO document. The pause only occurs during startup.
> 
>  How to stop LO from sending requests over the network on startup, so that
>  it opens without the 10-second pause?
> 
> 
> >>> -- 
> >>> 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
> >>>
> >>
> >> -- 
> >>    
> >>    antiso...@myopera.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] Which template categories are built-in, how to name custom ones?

[Regina Henschel]

Hi Friedrich,

Friedrich W. H. Kossebau schrieb:

Hi,

Am Dienstag, 10. Juli 2012, 09:04:54 schrieb Friedrich W. H. Kossebau:

I need help with understanding how the naming of the template categories is
done, especially for custom categories. I have basically 2 questions, listed
at the end.

I found
http://wiki.documentfoundation.org/images/b/b1/Non-coding_extensions-
final.odp from the LO Conference in Paris last year, from which I learnt
that these are the built-in (as in: translated) categories:

officorr → “Business Correspondence”
offimisc → “Other Business Documents”
personal → “Personal Correspondence and Documents”
forms → “Forms and Contracts”
finance → “Finances”
educate → “Education”
layout → “Presentation Backgrounds”
presnt → “Presentations”
misc → “Miscellaneous”


Yes, those are defined in 
http://opengrok.libreoffice.org/xref/core/sfx2/source/doc/doctempl.src

They are translated via the normal translation process via po-file.



And to give custom categories nice names, one should put into the language
or "common" directory a file .nametranslation.table which has "folder=Name"
entries for all the custom category folders.


There has also been a file groupuinames.xml in the template folder.



Tried that but without success: I added a custom folder in
/usr/share/templates/libreoffice/de named "nametest", added a few templates
there and put a file .nametranslation.table in
/usr/share/templates/libreoffice/de, with this content
--- 8< ---
[TRANSLATIONNAMES]
nametest=Naming Test
--- 8< ---

But as you can see in the attached screenshot, the folder only appears as
"nametest", not "Naming Test".

Q1: What am I doing wrong here? (LibreOffice 3.5.3.2 on openSUSE Tumbleweed)


openSUSE by default also installed a package with labels, libreoffice-
templates-labels-a4, which are placed in common/labels, so for the
non-built- in category "labels". Still the templates dialog has a full
translated name for it, "Etiketten".

Q2: How does the custom category folder "labels" get its translation
"Etiketten"?


Have you already searched for "Etiketten"? That should find only few 
file candidates.




No one here any clue? Do I better ask on the developer list?


Yes. I guess you will deploy such a template package.

If only you want a nice name, do not use the way to generate a new 
category via File > Templates > Organize. But simply create a sub-folder 
in the templates folder. It will be recognized when restart. The folder 
name is directly used as template category, at least on WinXP. Keep in 
mind, that sub-sub-folder is not possible.


Kind regards
Regina

--
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] Microsoft Core Fonts

[webmaster-Kracked_P_P]

The key was to find the core fonts package first.

Yes, I see your point with using the terminal for doing the installation 
of packages, but you need to know what those packages are.


Also, if you use a package manager, or the Software Center, you can 
search for the packages and install them from there without needing to 
get the "spelling" of the package correct.  Some people, like me, can 
have problems typing at times.  My fingers do not always work correctly 
and I rely on my spell checker to catch things.  So with a package 
manager or software center, you do no need to worry about typing in a 
command in the terminal correctly.


Then there are the differences with the desktop environments.  For 12.04 
I have used Unity, GNOME 3, and MATE for desktop environments.  I prefer 
MATE.  IT works more like the GNOME DE that in used by Ubuntu 10.04, 
better than the options in GNOME 3.


So once the OP knew that he could use a single package to install the 
"small core" of MS fonts, and then know what it is, it is up to the user 
to decide what if the easiest way to install it.  When I search for a 
package, it is easier for me to install it with the package manager or 
the software center, instead of using that info and type the proper 
commands in the terminal.


IF I am given a terminal command where I can cut/paste [say from a web 
page or an email], then it can be easy for me to use the terminal 
option.  cut/paste was how I "typed in" the commands to install MATE on 
my 12.04 laptop.


This link that was in a posting
https://launchpad.net/ubuntu/precise/+package/ttf-mscorefonts-installer
was listed as the core fonts for the web.

This list has a few other fonts in their list of MS core fonts for the web.
http://en.wikipedia.org/wiki/Core_fonts_for_the_Web

This link shows which core fonts are on both MS systems and Mac systems.
http://web.nickshanks.com/fonts/microsoft-core-web-fonts

So that means that there many be more "core fonts" that MS Win7 uses 
that the user might want to install.


He seem to state that he did not want to do all the work to install all 
of the fonts he had in his font folder.  Well as far as I an thinking, 
it is really easy to install a block of fonts. All you need to do is 
place them in a folder, highlight them like you we going to copy them to 
another folder, then just do a right-click and open them with the 
default font viewer.  Then just click on the "install" button for each 
font.  I is an easy way to get them installed properly in the .fonts 
hidden folder.  At least it is the easiest way I found.


The real kicker is for the user, any user, to install the fonts that 
he/she needs for the work he/she need to do.


As stated before, by me and others, you can get free fonts that are very 
similar to the paid ones of a specific name.  All you have to do is 
look.  BUT, if that person is required to work with a specific font for 
an employer, or other person of authority, then they will have to see if 
they have those fonts somewhere that they can use for their Ubuntu/Linux 
work instead of Windows work.


When I take a laptop/desktop and replace the Windows OS that came with 
it, I copy the fonts that came with the system and then reinstall them 
when I have Ubuntu installed.  That way, I use the fonts that came with 
the computer.  Personally, I feel that if the laptop has the fonts 
installed, then those fonts can stay installed on the system no matter 
what the OS changes to.




On 07/22/2012 08:11 AM, Tom Davies wrote:

Hi :)
I found the name for Ubuntu 10.04, so the command would be:

sudo apt-get install ttf-mscorefonts-installer

and installing Synaptic Package Manager would be:

sudo apt-get install synaptic

but i agree with Johnny that it sounds like Ubuntu 12.04 and i suspect he has checked the 
exactly right name already.  Generally i find Synaptic useful for looking up things when 
i am not totally sure of the name of the thing.  It searches in package descriptions as 
well as titles so you can be pretty vague with searches.  Then it's easy to pick and 
choose (although probably ignore all the packages starting with "lib..." so 
just scroll through them fast).

The command-line is easiest when giving advice to people because it's pretty 
much identical across all the different distros although some 
families-of-distros use alternatives to apt-get.  I think those alternatives 
use similar tags and, of course, the package names tend to be the same, for 
example libreoffice is called the same thing in all afaik.

Regards from
Tom :)


--- On Sun, 22/7/12, Johnny Rosenberg  wrote:

From: Johnny Rosenberg 
Subject: Re: [libreoffice-users] Microsoft Core Fonts
To: users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 12:32

2012/7/22 Tom Davies :

Hi :)
There is always at least 1 distro that renames things a bit.  In this case i 
think it's Ubuntu so it might be worth searching your package manager to get 
the right fonts
Regards from
Tom :)

Well, t

Re: [libreoffice-users] Restore Separate Navigator Window?

[Tom Davies]

Hi :)
Brilliant!!  Nicely fixed :))
Congrats and regards from
Tom :)  


--- On Sun, 22/7/12, Jonathan Levi  wrote:

From: Jonathan Levi 
Subject: Re: [libreoffice-users] Restore Separate Navigator Window?
To: users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 13:37


 Tom: your grab-and-drag solution worked. Brian: So did your 
control-doubleclick toggle, except for MacOS X I had to use command 
(Apple-key)-doubleclick instead. Thanks to you both,

Jonathan

 

 

-Original Message-
From: Tom Davies 
To: users 
Sent: Sun, Jul 22, 2012 8:13 am
Subject: Re: [libreoffice-users] Restore Separate Navigator Window?


Hi :)
Can't you just grab it and drag it loose?
Regards from
Tom :)  


--- On Sun, 22/7/12, Brian Barker  wrote:

From: Brian Barker 
Subject: Re: [libreoffice-users] Restore Separate Navigator Window?
To: users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 13:09

At 07:14 22/07/2012 -0400, Jonathan Levi wrote:
> My document's Navigator has somehow gone from being its own window to a pane 
in the main document. I need the first behavior, because I'm writing a script 
based on a separate Navigator window. Can anyone tell me how to restore it? 
Using LibreOffice 3.4.1, MacOS X 10.4.11.

I think this depends a bit on your operating system, and I don't have MacOS 
here 
to try.  But try either of these techniques:

o Hold down the Ctrl key and double-click on an empty grey area of the window.  
That's not on the title bar or on a button, but somewhere on the grey area 
around the buttons and around the main panel - between the buttons or around 
the 
edge.

o With focus on the Navigator window, press Ctrl+Shift+F10.

Both these techniques should toggle the window between floating and docked.

I trust this helps.

Brian Barker


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




 


 

-- 
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] LibreOffice pause during startup

[Tom Davies]

Hi :)
It is the files on the drive (or rather, partition) that get fragmented.  Not 
the partition itself.  

Ntfs tries to cramp all the files onto the beginning of the drive.  When you 
add things to a file then it can no longer fill the space comfortably so a 
chunk of the file needs to be written further along.  Once you have added 
things to quite a few files there is a bit of a mess which Ntfs then has 
trouble in tracking and the read/write head bounces backwards and frowards all 
around the partition collect all the parts of the file.  

Ext2, 3 and 4 all leave comfortable gaps after the ends of files and if the 
file still wont fit into the extra space that has been reserved for it then it 
just tries to write the entire file elsewhere or maybe (rarely) shift a few 
other files around to make space.  Files do occasionally get fragmented but not 
quite as often and usually only when some fool has nearly filled their 
hard-drive.  

Then i get a bit lost because although Ext2, 3 and 4 carefully avoid 
fragmentation they use the "inode" system for keeping track so that even if 
files do get fragmented the OS doesn't suffer.  So why bother to avoid 
fragmentation?  What is inode?  

The clincher is that most Windows defraggers (or at least the official MS ones) 
can't defrag system files (or at least not well and not easily), critically the 
"virtual memory" (which gets called "swap" in Gnu&Linux).  

Since virtual memory was so crucial to a system one might have expected it to 
be set to avoid letting it fragment ever.  On Windows systems it's reasonably 
easy but very fiddly to set virtual memory to a fixed amount and that 
significantly stops any further slow-down.  You still get some due to the 
registry kludge and other mis-management of key resources but the major 
difference seems to happen when you defrag and fix the virtual memory.  

On Gnu&Linux systems the Swap is often given it's own 'drive' (really a 
partition on a drive) so that it doesn't have a chance of getting fragmented, 
ever.  Again this can be done in Windows but it's never the default.  Also 
Swap/Virtual-memory in Gnu&Linux can be set to be a file instead of a partition 
and that might be easier for people who only need a swap in the unlikely event 
they hibernate.  Again it's weird that Gnu&Linux takes an extra unneeded 
precaution against something it 'shouldn't' ever suffer from but the one 
platform that does suffer from it doesn't do anything to protect against it.  

It's just one example that makes me wonder if Windows is deliberately set-up in 
order to force users to buy new hardware and a whole new system every couple of 
years.  

Regards from
Tom :)  


--- On Sat, 21/7/12, Don C. Myers  wrote:

From: Don C. Myers 
Subject: Re: [libreoffice-users] LibreOffice pause during startup
To: users@global.libreoffice.org
Date: Saturday, 21 July, 2012, 23:13

I've been running Ubuntu for three years. I'm quite proficient at using it. 
I've done a lot of reading about Linux and Ubuntu on line. I've read that you 
don't need to defrag the hard drive since Linux does not fragment a hard drive. 
Also that Linux doesn't use a registry, therefore it doesn't get corrupted like 
a registry in Windows does. That is why Linux doesn't slow down with time since 
nothing gets corrupted. But I'm not enough of a Linux expert to explain further 
details. Hopefully someone else can.

On 07/21/2012 06:05 PM, Anthony Easthope wrote:
>   If there is no registry or temporary paging system within the OS then
>   how does that work? It is a curiosity within itself
> :D
> On Sat, 21 Jul 2012, at 05:57 PM, Don C. Myers wrote:
>> Hi,
>> 
>> I run Ubuntu. As I understand it, Linux (including Ubuntu) doesn't use a
>> registry, therefore you don't need to have a registry cleaner.
>> 
>> Don
>> 
>> 
>> On 07/21/2012 05:50 PM, Anthony Easthope wrote:
>>> Infact your workaround could work in theory, the problem is finding a
>>> ccleaner equivalent for debian
>>> 
>>> On Sat, 21 Jul 2012, at 11:48 PM, Anthony Easthope wrote:
 Anne that work around works on windows but as the gentlemen said he was
 using debian squeze which is a variation of linux. I am curious as to
 why it is hanging to - by rights it should not be.
 
 On Fri, 20 Jul 2012, at 09:15 PM, anne-ology wrote:
>          If you're referring to it getting hung-up, then this has happened
>          to
> me a few times -
>              my solution is to shut it down -> clear out the caches
>              [CCleaner
> is good] -> re-start the computer;
>                  when it re-starts, OO/LO works great again.
> 
>          One of the problems with OO/LO is its immense size; if there were
> some way to reduce its size then this might not occur, but then it might
> not be as good a program as it is  ;-)
> 
>          Mine is not caused by 'calling home or anywhere' since my machine
> only allows 'cookies', etc. which I acc

[libreoffice-users] Re: Labeling in Calc

[Andreas Säger]

Am 22.07.2012 01:48, Andrew Brager wrote:

On 7/21/2012 10:47 AM, Andreas Säger wrote:

Am 20.07.2012 23:50, Andrew Brager wrote:

Nevermind, I figured it out.

In case anyone else has a similar desire and wants to know...  I simply
select all the rows I want to belong to a group, add a border around it
all, and insert a row above the box I just made. The inserted box
contains the label I want; I make sure to turn off word wrapping for
that one cell.




The component is named "Calc" because it is a calculator in the first
place. It is not a table editor nor database although many people use
it that way.
Base reports can turn raw, unsorted table data into grouped reports.



Thanks for your input.  As you say "many people use it that way".
Since my intent is to have assistants work with it, I'm stuck with what


Spreadsheets are extremely difficult to maintain by untrained users. We 
all use input forms on top of databases all day long online and offline 
without even noticing it. Professional tools online and on the desktop 
are built on top of databases. No professional would ever build such 
things on top on spreadsheets.
What you try to do is unprofessional because you mix layout, formatting 
and data on the same sheet. The whole thing relies on careful data input 
in the right order.


Please ignore Tom. He is very kind but totally ignorant towards 
LibreOffice Base which can read spreadsheet data as if they were 
database data. Therefore you can generate professional reports from 
spreadsheet data. You don't need to "convert" anything. Nevertheless, a 
true database would be so much easier to maintain, particularly by 
untrained users.



--
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] now can Purchase a NA-DVD

[Tom Davies]

Hi again (sorry for the double-posting)  :)

The issue about New Zealand's connection to the rest of the world cropped up 
years ago in Ubuntu.  I think either Universities there or the authorities or 
someone ran a big hosting site to mirror "the essentials" and somehow Ubuntu 
managed to get mirrored on that.  Server-to-server 'up'-loading (or is it 
downloading or cross-loading?) should be far faster than going through a 
domestic route!  

I think the Ubuntu crowd discussed posting physical media to get the bulk done 
more easily.  
Regards from
Tom :)  


--- On Sat, 21/7/12, webmaster-Kracked_P_P  wrote:

From: webmaster-Kracked_P_P 
Subject: Re: [libreoffice-users] now can Purchase a NA-DVD
To: users@global.libreoffice.org
Date: Saturday, 21 July, 2012, 23:18


DO you have a broadband Internet connection?  The .iso file is listed here.
http://www.libreoffice.org/download/?type=box&version=3.5.5
If you do not have broadband connection, there should be a way for you to get a 
copy from some source.  I have shipped one to Malta from the USA, but do not 
like to spend my own money on shipping, most of the time.

--

Here is a link to the Online version of the DVD. [actually to the Install page]
http://libreoffice-na.us/English-3.5-installs/install.html

Browse this site and you will find all of the files and such on the DVD.  The 
online site tends to get updated more often than the physical media or the .iso 
file does, but still it will give you a look at the DVD.

Right now, the only real updates to the online version [same as the physical 
one really] is the fact that there are 2 more chapters in Draw online than the 
one that can be bought or the .iso file to be downloaded.

Mostly there are the documentation, the 180+ dictionaries, the extensions, 
templates, artwork, the extra free packages, etc., etc..  I did not fee that a 
DVD should contain only the basic install files for LibreOffice.  That would be 
a waste of a DVD. So it got filled with a lot of things that I [and others] 
thought a user might want to have with him/her on a DVD so that they did not 
have to go looking for it elsewhere.  I must have 99% of the dictionaries that 
can work with LibreOffice, unless you get them via any language packages, like 
you need for a Linux install.


On 07/21/2012 05:44 PM, Anthony Easthope wrote:
> I am curious as to what the 2gb of extras contain! I am considering
> purchasing a dvd but not sure if it is able to be shipped to New Zealand
> if it could that would be great!
> 
> On Sat, 21 Jul 2012, at 04:07 AM, Fabian Rodriguez wrote:
>> On 07/20/2012 10:08 AM, webmaster-Kracked_P_P wrote:
>>> Thanks to Drew, we now have a service that will "print-on-demand" a
>>> copy of the LibreOffice North American Community DVD - version 3.5.5.
>>> 
>>> Here is a link for a direct retail page:
>>> http://kunaki.com/sales.asp?PID=PX00B1FF2L
>>> **Kunaki handles all the payment collection.**
>>> 
>> [...]
>> 
>> Well done, Drew! I had been researching manufacturers, this is the same
>> used by Raphael Hertzog to distribute his Debian remix:
>> http://raphaelhertzog.com/products/debian-cd-dvd/
>> 
>> I had that in my personal ToDo for a while
>> (http://wiki.documentfoundation.org/User:MagicFab/LibODVD#ToDo), glad
>> you're validating it. If/when you have a sample of what they ship, it'd
>> be important to have pictures. I'll order one to carry it and use as a
>> demo. I plan to finish my local design and use the same ship by
>> september.
>> 
>> Cheers,
>> 
>> Fabian Rodriguez
>> http://libreoffice.magicfab.ca
>> 
>> 
>> -- 
>> 
>> 
>> -- 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


-- 
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] now can Purchase a NA-DVD

[Tom Davies]

Hi :)
Most places have no qualms about adding an extra amount to the purchase price 
to cover postage&packing.  

The problem is that people try to get away with paying for as little as 
possible and try to give a sob-story so you have to be very straight-forwards 
sometimes and just insist on it.  I think the Malta case did have a very 
positive effect for the whole project though so it is appreciated.  
Regards from
Tom :)  


--- On Sat, 21/7/12, webmaster-Kracked_P_P  wrote:

From: webmaster-Kracked_P_P 
Subject: Re: [libreoffice-users] now can Purchase a NA-DVD
To: users@global.libreoffice.org
Date: Saturday, 21 July, 2012, 23:18


DO you have a broadband Internet connection?  The .iso file is listed here.
http://www.libreoffice.org/download/?type=box&version=3.5.5
If you do not have broadband connection, there should be a way for you to get a 
copy from some source.  I have shipped one to Malta from the USA, but do not 
like to spend my own money on shipping, most of the time.

--

Here is a link to the Online version of the DVD. [actually to the Install page]
http://libreoffice-na.us/English-3.5-installs/install.html

Browse this site and you will find all of the files and such on the DVD.  The 
online site tends to get updated more often than the physical media or the .iso 
file does, but still it will give you a look at the DVD.

Right now, the only real updates to the online version [same as the physical 
one really] is the fact that there are 2 more chapters in Draw online than the 
one that can be bought or the .iso file to be downloaded.

Mostly there are the documentation, the 180+ dictionaries, the extensions, 
templates, artwork, the extra free packages, etc., etc..  I did not fee that a 
DVD should contain only the basic install files for LibreOffice.  That would be 
a waste of a DVD. So it got filled with a lot of things that I [and others] 
thought a user might want to have with him/her on a DVD so that they did not 
have to go looking for it elsewhere.  I must have 99% of the dictionaries that 
can work with LibreOffice, unless you get them via any language packages, like 
you need for a Linux install.


On 07/21/2012 05:44 PM, Anthony Easthope wrote:
> I am curious as to what the 2gb of extras contain! I am considering
> purchasing a dvd but not sure if it is able to be shipped to New Zealand
> if it could that would be great!
> 
> On Sat, 21 Jul 2012, at 04:07 AM, Fabian Rodriguez wrote:
>> On 07/20/2012 10:08 AM, webmaster-Kracked_P_P wrote:
>>> Thanks to Drew, we now have a service that will "print-on-demand" a
>>> copy of the LibreOffice North American Community DVD - version 3.5.5.
>>> 
>>> Here is a link for a direct retail page:
>>> http://kunaki.com/sales.asp?PID=PX00B1FF2L
>>> **Kunaki handles all the payment collection.**
>>> 
>> [...]
>> 
>> Well done, Drew! I had been researching manufacturers, this is the same
>> used by Raphael Hertzog to distribute his Debian remix:
>> http://raphaelhertzog.com/products/debian-cd-dvd/
>> 
>> I had that in my personal ToDo for a while
>> (http://wiki.documentfoundation.org/User:MagicFab/LibODVD#ToDo), glad
>> you're validating it. If/when you have a sample of what they ship, it'd
>> be important to have pictures. I'll order one to carry it and use as a
>> demo. I plan to finish my local design and use the same ship by
>> september.
>> 
>> Cheers,
>> 
>> Fabian Rodriguez
>> http://libreoffice.magicfab.ca
>> 
>> 
>> -- 
>> 
>> 
>> -- 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


-- 
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] Libre Office on an iPad.

[Tom Davies]

Hi :)
This sounds brilliant!  I think it's got to be worth beta testing just to see 
how well it works.  Definitely a good way forwards for those people with a good 
internet connection.  
Regards from
Tom :)  


--- On Sat, 21/7/12, Dan  wrote:

From: Dan 
Subject: Re: [libreoffice-users] Libre Office on an iPad.
To: users@global.libreoffice.org
Date: Saturday, 21 July, 2012, 23:44

Tinkerer wrote:
> This offers you Libre Office, but without hosting.
> You load it into the Cloud and with almost anything else, so it says.
> Has anyone any experience of this?
>
> https://www.rollapp.com/libreoffice
>
> Tink.
>
>
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Libre-Office-on-an-iPad-tp3996895.html
> Sent from the Users mailing list archive at Nabble.com.
>
The top of this website says that it is BETA. So, there could be some 
possible problems until the bugs are worked out. It might be something 
to look forward to for those who use things like this.

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


-- 
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] LibreOffice pause during startup

[Tom Davies]

Hi :)
The devs are doing a "code clean up" as part of the whole process.  The whole 
code has been reduced by somewhere around 30% last time i heard.  

Even before the code-clean-up started, and AOO at the moment, are still far 
tinier than MS Office.  For something really tiny you might having a quick go 
with Gnome Office, that is AbiWord (word-processor) and Gnumeric 
(spreadsheets).  Neither have the type of integration that LO has with all it's 
other modules, such as Impress or Draw but i think Gnumeric manages to have 
some very nice features squeezed into it's tiny size.  AbiWord can be a bit of 
a pain as it lacks many of the nice features we seldom use in Writer.  For me 
the annoying thing was not being able to set it to default to saving everything 
in MS formats which i rarely do nowadays anyway.  Another option if you are 
looking for smaller&lighter is google-docs although that kinda requires a 
decent internet connection.  

Anyway, the size is coming down and becoming more compact but the delay in 
start-up might be something the devs could solve if a bug-report was posted 
about the 2 different issues; 
1.  clearing the caches
2.  stopping so many network calls at start-up
I doubt they can do much about 1 but maybe 2 is fixable?

Regards from
Tom :)  


--- On Sun, 22/7/12, anne-ology  wrote:

From: anne-ology 
Subject: Re: [libreoffice-users] LibreOffice pause during startup
To: users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 0:16

       Well, when you uncover the solution, ... ... ...

           well, I'll be watching for a solution to this 'bug' whenever  ;-)



On Sat, Jul 21, 2012 at 4:48 PM, Anthony Easthope wrote:

Anne that work around works on windows but as the gentlemen said he was
> using debian squeze which is a variation of linux. I am curious as to
> why it is hanging to - by rights it should not be.
>
> On Fri, 20 Jul 2012, at 09:15 PM, anne-ology wrote:
> >        If you're referring to it getting hung-up, then this has happened
> >        to
> > me a few times -
> >            my solution is to shut it down -> clear out the caches
> >            [CCleaner
> > is good] -> re-start the computer;
> >                when it re-starts, OO/LO works great again.
> >
> >        One of the problems with OO/LO is its immense size; if there were
> > some way to reduce its size then this might not occur, but then it might
> > not be as good a program as it is  ;-)
> >
> >        Mine is not caused by 'calling home or anywhere' since my machine
> > only allows 'cookies', etc. which I accept and only at the time I accept
> > them; in fact, each time I've tested my machine, it's invisible to these
> > robotic eyes  :-)
> >
> >
> >
> > On Fri, Jul 20, 2012 at 1:44 AM, Robert Mesibov
> > wrote:
> >
> > I'm running LibreOffice 3.4.6 OOO340m1 (Build:602) on Debian Squeeze.
> > >
> > > The progress bar on the splash screen stops part-way during startup for
> > > about 10 seconds. During this time LO sends a request of some sort
> over the
> > > network connection (lights flash on router) every 2 seconds, 5 times in
> > > all. LO then completes startup.
> > >
> > > This happens
> > > - with the splash screen turned off in /etc/libreoffice/sofficerc (the
> > > pause and network requesting still happen)
> > > - when launching LO by itself, or when opening a Writer or other LO
> > > document through a file manager
> > > - with Java RE option on or off
> > >
> > > With an LO document already open, there is no pause when opening a
> second
> > > LO document. The pause only occurs during startup.
> > >
> > > How to stop LO from sending requests over the network on startup, so
> that
> > > it opens without the 10-second pause?
> > >
>

-- 
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] LibreOffice 3.5 with Lubuntu

[Peter Hillier-Brook]

I'm running LO 3.5 under Lubuntu 12.04 and, until recently the relevant 
icons appeared under "Office" in the menu system. Now they don't and I 
have to start the program via the command line. Any ideas anyone?


For information the installation is the "real" LO installed via dpkg, 
not the Ubuntu build with its attendant problems. :-)


Peter HB

--
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] Restore Separate Navigator Window?

[Jonathan Levi]

 Tom: your grab-and-drag solution worked. Brian: So did your 
control-doubleclick toggle, except for MacOS X I had to use command 
(Apple-key)-doubleclick instead. Thanks to you both,

Jonathan

 

 

-Original Message-
From: Tom Davies 
To: users 
Sent: Sun, Jul 22, 2012 8:13 am
Subject: Re: [libreoffice-users] Restore Separate Navigator Window?


Hi :)
Can't you just grab it and drag it loose?
Regards from
Tom :)  


--- On Sun, 22/7/12, Brian Barker  wrote:

From: Brian Barker 
Subject: Re: [libreoffice-users] Restore Separate Navigator Window?
To: users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 13:09

At 07:14 22/07/2012 -0400, Jonathan Levi wrote:
> My document's Navigator has somehow gone from being its own window to a pane 
in the main document. I need the first behavior, because I'm writing a script 
based on a separate Navigator window. Can anyone tell me how to restore it? 
Using LibreOffice 3.4.1, MacOS X 10.4.11.

I think this depends a bit on your operating system, and I don't have MacOS 
here 
to try.  But try either of these techniques:

o Hold down the Ctrl key and double-click on an empty grey area of the window.  
That's not on the title bar or on a button, but somewhere on the grey area 
around the buttons and around the main panel - between the buttons or around 
the 
edge.

o With focus on the Navigator window, press Ctrl+Shift+F10.

Both these techniques should toggle the window between floating and docked.

I trust this helps.

Brian Barker


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




 


 

-- 
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] LibreOffice pause during startup

[Tom Davies]

Hi :)
In Ubuntu i try to use "The Janitor" occasionally or from the grub-boot-menu 
choose "recovery mode" and then "Clear some space".  I think some other distros 
offer that 2nd option but i don#'t know how to or even if i would want to risk 
trying the janitor in other distros.  
Regards from
Tom :)  


--- On Sun, 22/7/12, anne-ology  wrote:

From: anne-ology 
Subject: Re: [libreoffice-users] LibreOffice pause during startup
To: users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 0:24

       CCleaner is not necessarily a registry cleaner ... it can do that;
but it mainly is used to clean out the caches.

       And there are more than this one listed on this site - Gizmo's
Freeware Utilities .



On Sat, Jul 21, 2012 at 4:57 PM, Don C. Myers wrote:

Hi,
>
> I run Ubuntu. As I understand it, Linux (including Ubuntu) doesn't use a
> registry, therefore you don't need to have a registry cleaner.
>
> Don
>
>
>
> On 07/21/2012 05:50 PM, Anthony Easthope wrote:
>
>>   In factyour workaround could work in theory, the problem is finding a
>> ccleaner equivalent for debian
>>
>> On Sat, 21 Jul 2012, at 11:48 PM, Anthony Easthope wrote:
>>
>>> Anne that work around works on windows but as the gentlemen said he was
>>> using debian squeze which is a variation of linux. I am curious as to
>>> why it is hanging to - by rights it should not be.
>>>
>>> On Fri, 20 Jul 2012, at 09:15 PM, anne-ology wrote:
>>>
         If you're referring to it getting hung-up, then this has
 happened
         to
 me a few times -
             my solution is to shut it down -> clear out the caches
             [CCleaner
 is good] -> re-start the computer;
                 when it re-starts, OO/LO works great again.

         One of the problems with OO/LO is its immense size; if there
 were
 some way to reduce its size then this might not occur, but then it might
 not be as good a program as it is  ;-)

         Mine is not caused by 'calling home or anywhere' since my
 machine
 only allows 'cookies', etc. which I accept and only at the time I accept
 them; in fact, each time I've tested my machine, it's invisible to these
 robotic eyes  :-)



 On Fri, Jul 20, 2012 at 1:44 AM, Robert Mesibov
 **wrote:

 I'm running LibreOffice 3.4.6 OOO340m1 (Build:602) on Debian Squeeze.

> The progress bar on the splash screen stops part-way during startup for
> about 10 seconds. During this time LO sends a request of some sort
> over the
> network connection (lights flash on router) every 2 seconds, 5 times in
> all. LO then completes startup.
>
> This happens
> - with the splash screen turned off in /etc/libreoffice/sofficerc (the
> pause and network requesting still happen)
> - when launching LO by itself, or when opening a Writer or other LO
> document through a file manager
> - with Java RE option on or off
>
> With an LO document already open, there is no pause when opening a
> second
> LO document. The pause only occurs during startup.
>
> How to stop LO from sending requests over the network on startup, so
> that
> it opens without the 10-second pause?
>
>

-- 
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: Labeling in Calc

[Tom Davies]

Hi :)
+1
Your solution sounded like the most visually appealing too, which helps! :)  
There is always the possibility of migrating it to a database later on if it 
grows and becomes unweildy or if the assistants skill level turn out to be 
higher than expected.  

Regards from
Tom :)  


--- On Sun, 22/7/12, Andrew Brager  wrote:

From: Andrew Brager 
Subject: Re: [libreoffice-users] Re: Labeling in Calc
To: users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 0:48

On 7/21/2012 10:47 AM, Andreas Säger wrote:
> Am 20.07.2012 23:50, Andrew Brager wrote:
>> Nevermind, I figured it out.
>> 
>> In case anyone else has a similar desire and wants to know...  I simply
>> select all the rows I want to belong to a group, add a border around it
>> all, and insert a row above the box I just made. The inserted box
>> contains the label I want; I make sure to turn off word wrapping for
>> that one cell.
>> 
>> 
> 
> The component is named "Calc" because it is a calculator in the first place. 
> It is not a table editor nor database although many people use it that way.
> Base reports can turn raw, unsorted table data into grouped reports.
> 

Thanks for your input.  As you say "many people use it that way".  Since my 
intent is to have assistants work with it, I'm stuck with what the vast 
majority of average people know.  They know Excel (the MS equivalent as you 
know).  Sadly, they do NOT know Base or any other database application.  To 
learn it would require they be trained and that probably means hiring a 
computer scientist instead of an assistant, which makes the cost prohibitive.  
Either that or I design a bunch of forms and predetermined sql statements or 
hire someone else to do so just so I can hire a secretary.  Seems to me that's 
the long way around when all I need is to group the rows, set a border and add 
a label.  Sure, a database would be the best solution, but it boils down to 
expediency, convenience and cost so Calc wins out on all 3.



-- 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] Which template categories are built-in, how to name custom ones?

[Tom Davies]

Hi :)
I think the Docs Team discussed the issue a couple of years ago but i think 
changing it would be tons of hard work for very little gain.  

I think the names grew almost organically over the previous decade so i don't 
think there is a coherent and consistent decision about the names chosen.  I 
can't really imagine the devs list being particularly interested or if they are 
their new choices might not be brilliant either.  

It might be worth contacting the devs list to find out how to change the names 
and then perhaps join the docs team to find out if they have good naming 
schemes or even just a few good general ideas

Just my 2cents as it sounds like you have a good plan already.  
Regards from
Tom :)


--- On Sun, 22/7/12, Friedrich W. H. Kossebau  wrote:

From: Friedrich W. H. Kossebau 
Subject: Re: [libreoffice-users] Which template categories are built-in, how to 
name custom ones?
To: users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 0:58

Hi,

Am Dienstag, 10. Juli 2012, 09:04:54 schrieb Friedrich W. H. Kossebau:
> I need help with understanding how the naming of the template categories is
> done, especially for custom categories. I have basically 2 questions, listed
> at the end.
> 
> I found
> http://wiki.documentfoundation.org/images/b/b1/Non-coding_extensions-
> final.odp from the LO Conference in Paris last year, from which I learnt
> that these are the built-in (as in: translated) categories:
> 
> officorr → “Business Correspondence”
> offimisc → “Other Business Documents”
> personal → “Personal Correspondence and Documents”
> forms → “Forms and Contracts”
> finance → “Finances”
> educate → “Education”
> layout → “Presentation Backgrounds”
> presnt → “Presentations”
> misc → “Miscellaneous”
> 
> And to give custom categories nice names, one should put into the language
> or "common" directory a file .nametranslation.table which has "folder=Name"
> entries for all the custom category folders.
> 
> Tried that but without success: I added a custom folder in
> /usr/share/templates/libreoffice/de named "nametest", added a few templates
> there and put a file .nametranslation.table in
> /usr/share/templates/libreoffice/de, with this content
> --- 8< ---
> [TRANSLATIONNAMES]
> nametest=Naming Test
> --- 8< ---
> 
> But as you can see in the attached screenshot, the folder only appears as
> "nametest", not "Naming Test".
> 
> Q1: What am I doing wrong here? (LibreOffice 3.5.3.2 on openSUSE Tumbleweed)
> 
> 
> openSUSE by default also installed a package with labels, libreoffice-
> templates-labels-a4, which are placed in common/labels, so for the
> non-built- in category "labels". Still the templates dialog has a full
> translated name for it, "Etiketten".
> 
> Q2: How does the custom category folder "labels" get its translation
> "Etiketten"?

No one here any clue? Do I better ask on the developer list?

Cheers
Friedrich

-- 
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] Restore Separate Navigator Window?

[Tom Davies]

Hi :)
Can't you just grab it and drag it loose?
Regards from
Tom :)  


--- On Sun, 22/7/12, Brian Barker  wrote:

From: Brian Barker 
Subject: Re: [libreoffice-users] Restore Separate Navigator Window?
To: users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 13:09

At 07:14 22/07/2012 -0400, Jonathan Levi wrote:
> My document's Navigator has somehow gone from being its own window to a pane 
> in the main document. I need the first behavior, because I'm writing a script 
> based on a separate Navigator window. Can anyone tell me how to restore it? 
> Using LibreOffice 3.4.1, MacOS X 10.4.11.

I think this depends a bit on your operating system, and I don't have MacOS 
here to try.  But try either of these techniques:

o Hold down the Ctrl key and double-click on an empty grey area of the window.  
That's not on the title bar or on a button, but somewhere on the grey area 
around the buttons and around the main panel - between the buttons or around 
the edge.

o With focus on the Navigator window, press Ctrl+Shift+F10.

Both these techniques should toggle the window between floating and docked.

I trust this helps.

Brian Barker


-- 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: Filter rows of certain dates, LibreOffice Calc

[Andreas Säger]

Am 22.07.2012 13:27, Johnny Rosenberg wrote:

I searched for Standard Filter examples and the only thing I found had
a string or a number in the Value fields. I want to use an expression
instead, but that doesn't seem possible, or maybe I'm just doing it
wrong.
For example:

Column A>=   Today()-7

Doesn't work at all. The only thing that happens is that rows not
containing a date at all in Column A are hidden. In this case I only
want to hide those rows older than a week. I guess I am just not doing
it right, right?



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ




Data>Filter>Advanced Filter...
Point to a 2-cell range with column label and calculated value.

Cell #1: =$A$1
Cell #2: =">="&TODAY()-7




--
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] Microsoft Core Fonts

[Tom Davies]

Hi :)
I found the name for Ubuntu 10.04, so the command would be:

sudo apt-get install ttf-mscorefonts-installer

and installing Synaptic Package Manager would be:  

sudo apt-get install synaptic

but i agree with Johnny that it sounds like Ubuntu 12.04 and i suspect he has 
checked the exactly right name already.  Generally i find Synaptic useful for 
looking up things when i am not totally sure of the name of the thing.  It 
searches in package descriptions as well as titles so you can be pretty vague 
with searches.  Then it's easy to pick and choose (although probably ignore all 
the packages starting with "lib..." so just scroll through them fast).  

The command-line is easiest when giving advice to people because it's pretty 
much identical across all the different distros although some 
families-of-distros use alternatives to apt-get.  I think those alternatives 
use similar tags and, of course, the package names tend to be the same, for 
example libreoffice is called the same thing in all afaik.  

Regards from
Tom :)  


--- On Sun, 22/7/12, Johnny Rosenberg  wrote:

From: Johnny Rosenberg 
Subject: Re: [libreoffice-users] Microsoft Core Fonts
To: users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 12:32

2012/7/22 Tom Davies :
> Hi :)
> There is always at least 1 distro that renames things a bit.  In this case i 
> think it's Ubuntu so it might be worth searching your package manager to get 
> the right fonts
> Regards from
> Tom :)

Well, the OP said he had Ubuntu, but not which version. I assumed
12.04 since he also asked how to install Synaptic. I think (but I'm
not 100% sure) that 12.04 is the first Ubuntu that doesn't come with
Synaptic pre-installed.

Some older versions of Ubuntu have a different name of that package,
and I think a few fonts were missing as well.



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

>
>
> --- On Sun, 22/7/12, Johnny Rosenberg  wrote:
>
> From: Johnny Rosenberg 
> Subject: Re: [libreoffice-users] Microsoft Core Fonts
> To: users@global.libreoffice.org
> Date: Sunday, 22 July, 2012, 6:04
>
> 2012/7/21 Anthony Easthope :
>> Hi
>>
>> I was wondering what would be considered the core fonts on Microsoft.
>> After  ages fruitless searching I was wondering if anybody could help me
>> on what they would consider to be core fonts.
>> I backed up my fonts folder from windows 7 before the change to ubuntu
>> so I had all of them problem is I can not be bothered installing every
>> single one of them!
>
> The quickest way, if you want to install those mss TTF core fonts from
> the repositories, is from a terminal. Just copy this line into a
> terminal and hit Enter. Note that the keyboard shortcut for Paste is
> Ctrl+Shift+v, if you didn't edit those yourself:
>
> sudo apt-get install ms-corefonts-installer
>
> The package contains:
> Andale
> Arial Black
> Arial
> Comic Sans
> Courier New
> Georgia
> Impact
> Times New Roman
> Trebuchet
> Verdana
> Webdings
>
> If you only want to use Arial, Times New Roman and Courier New, it's
> recommended that you use the free fonts from the package
> fonts-liberation instead (probably already installed on your system.
> Those are called something like Liberation Sans (looks like Arial) and
> so on.
>
>
>
> Kind regards
>
> Johnny Rosenberg
> ジョニー・ローゼンバーグ
>
>
>>
>>
>> --
>>
>>   antiso...@myopera.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
>
> --
> 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

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www

Re: [libreoffice-users] Restore Separate Navigator Window?

[Brian Barker]

At 07:14 22/07/2012 -0400, Jonathan Levi wrote:
My document's Navigator has somehow gone from being its own window 
to a pane in the main document. I need the first behavior, because 
I'm writing a script based on a separate Navigator window. Can 
anyone tell me how to restore it? Using LibreOffice 3.4.1, MacOS X 10.4.11.


I think this depends a bit on your operating system, and I don't have 
MacOS here to try.  But try either of these techniques:


o Hold down the Ctrl key and double-click on an empty grey area of 
the window.  That's not on the title bar or on a button, but 
somewhere on the grey area around the buttons and around the main 
panel - between the buttons or around the edge.


o With focus on the Navigator window, press Ctrl+Shift+F10.

Both these techniques should toggle the window between floating and docked.

I trust this helps.

Brian Barker


--
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] Can I populate a whole row in Spreadsheet by importing from Database into only one cell?

[Johnny Rosenberg]

2012/7/22 Brian Barker :
> At 17:35 21/07/2012 -0700, Kuuga Noname wrote:
>>
>> I want to, in the weapon and armor tables, be able to populate the whole
>> row with relevant data simply by selecting an item in the Name columns. For
>> example, if I enter Broadsword in the weapon name column I want it to
>> automatically fill the rest of the row with its damage, size, reach and so
>> on.
>
>
> This can be done fairly easily with the VLOOKUP() function.  In your
> example, I gave the name "Weapons" to the array of weapons values on the
> "Weapon list" sheet.  Then in cell C3 of the weapons table on the Equipment
> sheet (the first row of the Damage column), I entered
> =VLOOKUP($A3;Weapons;COLUMN()-1;0)

Thanks for the information (I'm not the OP, but thankful anyway…); I
didn't know that you can use COLUMN() that way. I thought there always
needs to be a parameter inside the parentheses. Now knowing that's not
needed, it will make things somewhat easier for me from now on…



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

> Then I filled this formula down the column and across the table.
>
> How does this work?  The VLOOKUP() function searches the first column of the
> Weapons array for the value in A3, A4 etc.  When it finds a match, it
> returns the corresponding value from the same row but a different column in
> the array.  The expression COLUMN()-1 defines this column as one fewer than
> the column containing the formula.  The final parameter - FALSE or 0 -
> indicates that the values being searched in the first column of the array
> are not necessarily in order and that an exact match (or an error condition)
> is required.
>
>
>> Another thing I want to do, but isn't really necessary, is make the sheet
>> to automatically subtract your total bonus skill points as you assign them
>> to skills; I simply can't figure out a way to accomplish this.
>
>
> I'm not exactly sure how you want this to appear.  But you will want to have
> a cell (or table) somewhere with the initial values.  This might be on a
> separate sheet or even in hidden cells.  Then your visible cell (or table)
> for these values will contain a formula summing the assigned values and
> subtracting the result from the original (fixed) value in the other table.
> This way, the cell(s) will show running totals as points are assigned.
>
> I trust this helps.
>
> Brian Barker
>
>
>
> --
> 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] Microsoft Core Fonts

[Don Myers]

If you type in
mscorefonts
in the software center search block, it is available there.


On 07/22/2012 07:32 AM, Johnny Rosenberg wrote:

2012/7/22 Tom Davies :

Hi :)
There is always at least 1 distro that renames things a bit.  In this case i 
think it's Ubuntu so it might be worth searching your package manager to get 
the right fonts
Regards from
Tom :)

Well, the OP said he had Ubuntu, but not which version. I assumed
12.04 since he also asked how to install Synaptic. I think (but I'm
not 100% sure) that 12.04 is the first Ubuntu that doesn't come with
Synaptic pre-installed.

Some older versions of Ubuntu have a different name of that package,
and I think a few fonts were missing as well.



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ



--- On Sun, 22/7/12, Johnny Rosenberg  wrote:

From: Johnny Rosenberg 
Subject: Re: [libreoffice-users] Microsoft Core Fonts
To: users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 6:04

2012/7/21 Anthony Easthope :

Hi

I was wondering what would be considered the core fonts on Microsoft.
After  ages fruitless searching I was wondering if anybody could help me
on what they would consider to be core fonts.
I backed up my fonts folder from windows 7 before the change to ubuntu
so I had all of them problem is I can not be bothered installing every
single one of them!

The quickest way, if you want to install those mss TTF core fonts from
the repositories, is from a terminal. Just copy this line into a
terminal and hit Enter. Note that the keyboard shortcut for Paste is
Ctrl+Shift+v, if you didn't edit those yourself:

sudo apt-get install ms-corefonts-installer

The package contains:
Andale
Arial Black
Arial
Comic Sans
Courier New
Georgia
Impact
Times New Roman
Trebuchet
Verdana
Webdings

If you only want to use Arial, Times New Roman and Courier New, it's
recommended that you use the free fonts from the package
fonts-liberation instead (probably already installed on your system.
Those are called something like Liberation Sans (looks like Arial) and
so on.



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ




--

   antiso...@myopera.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

--
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] Microsoft Core Fonts

[Don Myers]

Here is the page for ms core fonts for Ubuntu 12.04:
https://launchpad.net/ubuntu/precise/+package/ttf-mscorefonts-installer
Synaptic needed to be manually installed starting about 11.04.

Don


On 07/22/2012 07:32 AM, Johnny Rosenberg wrote:

2012/7/22 Tom Davies :

Hi :)
There is always at least 1 distro that renames things a bit.  In this case i 
think it's Ubuntu so it might be worth searching your package manager to get 
the right fonts
Regards from
Tom :)

Well, the OP said he had Ubuntu, but not which version. I assumed
12.04 since he also asked how to install Synaptic. I think (but I'm
not 100% sure) that 12.04 is the first Ubuntu that doesn't come with
Synaptic pre-installed.

Some older versions of Ubuntu have a different name of that package,
and I think a few fonts were missing as well.



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ



--- On Sun, 22/7/12, Johnny Rosenberg  wrote:

From: Johnny Rosenberg 
Subject: Re: [libreoffice-users] Microsoft Core Fonts
To: users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 6:04

2012/7/21 Anthony Easthope :

Hi

I was wondering what would be considered the core fonts on Microsoft.
After  ages fruitless searching I was wondering if anybody could help me
on what they would consider to be core fonts.
I backed up my fonts folder from windows 7 before the change to ubuntu
so I had all of them problem is I can not be bothered installing every
single one of them!

The quickest way, if you want to install those mss TTF core fonts from
the repositories, is from a terminal. Just copy this line into a
terminal and hit Enter. Note that the keyboard shortcut for Paste is
Ctrl+Shift+v, if you didn't edit those yourself:

sudo apt-get install ms-corefonts-installer

The package contains:
Andale
Arial Black
Arial
Comic Sans
Courier New
Georgia
Impact
Times New Roman
Trebuchet
Verdana
Webdings

If you only want to use Arial, Times New Roman and Courier New, it's
recommended that you use the free fonts from the package
fonts-liberation instead (probably already installed on your system.
Those are called something like Liberation Sans (looks like Arial) and
so on.



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ




--

   antiso...@myopera.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

--
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] Can I populate a whole row in Spreadsheet by importing from Database into only one cell?

[Tom Davies]

Hi :)
This is exactly the sort of thing that would be best done as a relational 
database.  

You have many tables each with a specific type of focus.  For example, 
something like
Table 1 = Weapons
Table 2 = Armour
Table 3 = Character types
Table 4 = Skills and abilities

Then you can have a main table that just looks-up data stored in those tables.  
For example line 1 in Main Table might look roughly the equivalent of

Vorak, weapon1 =  table1 item1, bonus = +2, weapon2 = table1 item5, bonus = +1, 
armour = table2 item5, bonus = 0, character type = table 3 item4, skill = 
table4 item1

So the main table itself contains very little data and so it's easy to process 
quickly to get to the right line.  File size is kept small because data is not 
being constantly repeated and also errors are kept down.  No accidentally 
making one individual's katana completely useless in hand-to-hand as katana 
would be listed once only and everyone would have the same characteristics for 
the same weapon.  I added the bonus columns just to add a bit of flexibility to 
account for an individual's unique prowess.  

Regards from
Tom :)  



--- On Sun, 22/7/12, Brian Barker  wrote:

From: Brian Barker 
Subject: Re: [libreoffice-users] Can I populate a whole row in Spreadsheet by 
importing from Database into only one cell?
To: users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 3:58

At 17:35 21/07/2012 -0700, Kuuga Noname wrote:
> I want to, in the weapon and armor tables, be able to populate the whole row 
> with relevant data simply by selecting an item in the Name columns. For 
> example, if I enter Broadsword in the weapon name column I want it to 
> automatically fill the rest of the row with its damage, size, reach and so on.

This can be done fairly easily with the VLOOKUP() function.  In your example, I 
gave the name "Weapons" to the array of weapons values on the "Weapon list" 
sheet.  Then in cell C3 of the weapons table on the Equipment sheet (the first 
row of the Damage column), I entered
=VLOOKUP($A3;Weapons;COLUMN()-1;0)
Then I filled this formula down the column and across the table.

How does this work?  The VLOOKUP() function searches the first column of the 
Weapons array for the value in A3, A4 etc.  When it finds a match, it returns 
the corresponding value from the same row but a different column in the array.  
The expression COLUMN()-1 defines this column as one fewer than the column 
containing the formula.  The final parameter - FALSE or 0 - indicates that the 
values being searched in the first column of the array are not necessarily in 
order and that an exact match (or an error condition) is required.

> Another thing I want to do, but isn't really necessary, is make the sheet to 
> automatically subtract your total bonus skill points as you assign them to 
> skills; I simply can't figure out a way to accomplish this.

I'm not exactly sure how you want this to appear.  But you will want to have a 
cell (or table) somewhere with the initial values.  This might be on a separate 
sheet or even in hidden cells.  Then your visible cell (or table) for these 
values will contain a formula summing the assigned values and subtracting the 
result from the original (fixed) value in the other table.  This way, the 
cell(s) will show running totals as points are assigned.

I trust this helps.

Brian Barker


-- 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] Microsoft Core Fonts

[Johnny Rosenberg]

2012/7/22 Tom Davies :
> Hi :)
> There is always at least 1 distro that renames things a bit.  In this case i 
> think it's Ubuntu so it might be worth searching your package manager to get 
> the right fonts
> Regards from
> Tom :)

Well, the OP said he had Ubuntu, but not which version. I assumed
12.04 since he also asked how to install Synaptic. I think (but I'm
not 100% sure) that 12.04 is the first Ubuntu that doesn't come with
Synaptic pre-installed.

Some older versions of Ubuntu have a different name of that package,
and I think a few fonts were missing as well.



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

>
>
> --- On Sun, 22/7/12, Johnny Rosenberg  wrote:
>
> From: Johnny Rosenberg 
> Subject: Re: [libreoffice-users] Microsoft Core Fonts
> To: users@global.libreoffice.org
> Date: Sunday, 22 July, 2012, 6:04
>
> 2012/7/21 Anthony Easthope :
>> Hi
>>
>> I was wondering what would be considered the core fonts on Microsoft.
>> After  ages fruitless searching I was wondering if anybody could help me
>> on what they would consider to be core fonts.
>> I backed up my fonts folder from windows 7 before the change to ubuntu
>> so I had all of them problem is I can not be bothered installing every
>> single one of them!
>
> The quickest way, if you want to install those mss TTF core fonts from
> the repositories, is from a terminal. Just copy this line into a
> terminal and hit Enter. Note that the keyboard shortcut for Paste is
> Ctrl+Shift+v, if you didn't edit those yourself:
>
> sudo apt-get install ms-corefonts-installer
>
> The package contains:
> Andale
> Arial Black
> Arial
> Comic Sans
> Courier New
> Georgia
> Impact
> Times New Roman
> Trebuchet
> Verdana
> Webdings
>
> If you only want to use Arial, Times New Roman and Courier New, it's
> recommended that you use the free fonts from the package
> fonts-liberation instead (probably already installed on your system.
> Those are called something like Liberation Sans (looks like Arial) and
> so on.
>
>
>
> Kind regards
>
> Johnny Rosenberg
> ジョニー・ローゼンバーグ
>
>
>>
>>
>> --
>>
>>   antiso...@myopera.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
>
> --
> 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] Filter rows of certain dates, LibreOffice Calc

[Johnny Rosenberg]

I searched for Standard Filter examples and the only thing I found had
a string or a number in the Value fields. I want to use an expression
instead, but that doesn't seem possible, or maybe I'm just doing it
wrong.
For example:

Column A>=   Today()-7

Doesn't work at all. The only thing that happens is that rows not
containing a date at all in Column A are hidden. In this case I only
want to hide those rows older than a week. I guess I am just not doing
it right, right?



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
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] Restore Separate Navigator Window?

[Jonathan Levi]

My document's Navigator has somehow gone from being its own window to a pane in 
the main document. I need the first behavior, because I'm writing a script 
based on a separate Navigator window. Can anyone tell me how to restore it? 
Using LibreOffice 3.4.1, MacOS X 10.4.11.

Jonathan

-- 
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] Microsoft Core Fonts

[Tom Davies]

Hi :)
There is always at least 1 distro that renames things a bit.  In this case i 
think it's Ubuntu so it might be worth searching your package manager to get 
the right fonts
Regards from
Tom :)  


--- On Sun, 22/7/12, Johnny Rosenberg  wrote:

From: Johnny Rosenberg 
Subject: Re: [libreoffice-users] Microsoft Core Fonts
To: users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 6:04

2012/7/21 Anthony Easthope :
> Hi
>
> I was wondering what would be considered the core fonts on Microsoft.
> After  ages fruitless searching I was wondering if anybody could help me
> on what they would consider to be core fonts.
> I backed up my fonts folder from windows 7 before the change to ubuntu
> so I had all of them problem is I can not be bothered installing every
> single one of them!

The quickest way, if you want to install those mss TTF core fonts from
the repositories, is from a terminal. Just copy this line into a
terminal and hit Enter. Note that the keyboard shortcut for Paste is
Ctrl+Shift+v, if you didn't edit those yourself:

sudo apt-get install ms-corefonts-installer

The package contains:
Andale
Arial Black
Arial
Comic Sans
Courier New
Georgia
Impact
Times New Roman
Trebuchet
Verdana
Webdings

If you only want to use Arial, Times New Roman and Courier New, it's
recommended that you use the free fonts from the package
fonts-liberation instead (probably already installed on your system.
Those are called something like Liberation Sans (looks like Arial) and
so on.



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


>
>
> --
>
>   antiso...@myopera.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

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