[libreoffice-users] Re: Font names

[Zak McKracken]

Am 07.03.2011, 13:50 Uhr, schrieb webmaster for Kracked Press Productions  
:




Zak
What I know about fonts and the way it SHOULD be displayed in a menu is  
this:
Every font file name should be listed in the "window" showing the font  
name.  If you have Frutiger 45 Light and Frutiger 55 Roman as font names  
in your font folder [Windows or Linux], then each font should be  
displayed separately, not grouped together under one name Frutiger.  I  
know that could sounds wrong.  If you have Arial "plain", Italic, Bold,  
Bold Italic, etc., you get one listing for Arial and you can make use of  
all those styles.  But you are using Frutiger 45 and 55 which are two  
different fonts.  I have Caslon 224 and Caslon 540.  These are two  
different fonts.  The "45" and "55" are telling you that they are  
different fonts, and they should be listed separately.


The thing is that lots of fonts come with separate files for the reagular  
and bold, and italic, and bold italic variety.
So if someone saw fit to add another weight, (and this is not a different  
font, just a different weight, because there's also "Frutiger 46 light  
italic" and so on in mix. So usually every software will group the bold,  
italic and bold/italic variety together, but not others.


Alright, if this is the standard (and Im not learned in these things) I'm  
gonna go along (haha, as if I had a choice).


But I'd feel it'd be easier not only for me but in general if a font with  
multiple weights would not be displayed as seperate fonts but as one.  
Would unclutter the font list, too. Would of course also be difficult it  
work reliably (if there are just the four standard weights, use those, if  
there are more use those, too, if there are fewer, gernerate the standard  
set yourself, but what to do if there's a non-standard weight of some font  
and the font is switched?), and if it's against the standard, that'd be a  
problem for sure. I can see that.



I hope I did not confuse you completely.

No, don't worry :)
Dealing with some designer's ideas of creating 25 version of the same  
font that look 95% the same, gives me headaches.  I deal with a font  
project sorting out over 100,000 fonts where too many of the serif fonts  
looked like all the other serif fonts and if you overlap them, you get  
almost the same positions of the lines.


You have my sympathy. I'm writing technical stuff, but I still want it to  
look decent, and keep wondering why these complications have to get in the  
way and subtract from the time I have to deal with other complications  
completely unrelated to typesetting.


However, at least from my view it was easier the way OOo 3.2 handled it.  
Although even worse than either way is to change it every other version,  
so I guess I'll have to live with it now. Or should there be an option in  
the settings somewhere?


 Zak


--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] No mail.

[Howard Barr]

Hi, I am subscribed to this list but since the 11 of March I have not 
received any emails. I'm based in Chiba, Japan (south-east of Tokyo) but 
I doubt if that has anything to do with not receiving email. Regards, 
Howard.


--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Re: toolbars - not able to resize-not showing

[vw-libre]

Thank you very much for 

"Tools > Options > Language Settings > Languages
Enhanced language support
[X] Enabled for complex text layout (CTL) "

Prob lem now solved.



--
View this message in context: 
http://nabble.documentfoundation.org/toolbars-not-able-to-resize-not-showing-tp2701546p2705560.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] File saving integrity

[Steve Edmonds]

Hi.
I was following the discussion on sharepoint.
I am developing some guidelines for our users for use of LO to minimise 
loss of data.


How does LO handle and store files across networks, what happens if the 
network goes out partway during a save.

When the file is opened is the whole file cached locally for editing
Is the file saved as file.odt.part and mv file.odt at the end or is the 
file held open and written by block.
What happens with a time save backup, is that local or remote (although 
no good for .docs as it doesn't work)


I am presently apprehensive about editing a file across the internet 
that may sit open, especially a largish file and tend to recommend.

Opening files on the local server for editing and saving is ok.
Files to be edited from a server remote across the internet should be 
copied to your local HD, edited and copied back across the internet.


Does the sharepoint extension being discussed address these issues and 
would it be applicable to any Webdav server. (I have no intention to 
connect to a sharepoint server but could be interested in a webdav situation


Cheers,
steve

--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Zeros when linking cells between sheets

[John Kennedy]

I have a spreadsheet with 3 sheets. I want sheets 1 (Phone) and 2 (Network),
when edited, to update sheet 3 (All) which is the master view.
I have linked each of the needed cells (e.g. cell a3 on the All reads
"=Phone.a3").
If "Phone.a3" is empty then "All.a3" has a 0 (zero). I would prefer, for
readability, for the cell to be blank like the referenced cell.
Is there a way to do this?
Thanks,
John
-- 
 John Kennedy

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] How to select a rectangle area and export only content (and not whole page) as *.png in Draw?

[Helmar]

If the objects you want to export can be selected with the selection tool
(entirely) so it´s easy.
Select the objetcs and go to Export... then mark the box "Selection" just
below the "automatic extension" box

But if the area you want to export it comprehends part of one or more object
and you can´t simply select the entire objects I think that may be an option
creating a rectangle over that area and use the "intersection" to create a
selection from it so you can select it the usual way as a single object.

Helmar Fernandes
===
Ubuntu Maverick Meerkat user
www.aquahobby.com
www.penguim.net/pocosdecaldas



On 21 March 2011 03:42, benxs  wrote:

> Assume I draw some objects with Draw. Now I want to export them as a *.png
> picture file into a local directory.
> When I do this then currently the WHole page is always exported (with a lot
> of white uninteresting space around it).
>
> So I need somehow to selected only a part of the page.
>
> How can I do this in detail?
>
> How can I select e.g. a rectangel area with the objects 1,2, 5 and 11 and
> an
> additional white space of 10 pixel around them and export only this
> rectangle area?
>
> Ben
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/How-to-select-a-rectangle-area-and-export-only-content-and-not-whole-page-as-png-in-Draw-tp2709003p2709003.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> Unsubscribe instructions: E-mail to users+h...@libreoffice.org
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***
>
>

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] No mail.

[Helmar]

I can copy you here from Brazil Howard.
Replying to you and to the list.
Can you copy both replies?

Helmar Fernandes
===
Ubuntu Maverick Meerkat user
www.aquahobby.com
www.penguim.net/pocosdecaldas



On 20 March 2011 01:18, Howard Barr  wrote:

> Hi, I am subscribed to this list but since the 11 of March I have not
> received any emails. I'm based in Chiba, Japan (south-east of Tokyo) but I
> doubt if that has anything to do with not receiving email. Regards, Howard.
>
> --
> Unsubscribe instructions: E-mail to users+h...@libreoffice.org
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***
>

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] No mail.

[Howard Barr]

On 21/03/2011 21:13, Helmar wrote:

I can copy you here from Brazil Howard.
Replying to you and to the list.
Can you copy both replies?

Helmar Fernandes
===
Ubuntu Maverick Meerkat user
www.aquahobby.com 
www.penguim.net/pocosdecaldas 



On 20 March 2011 01:18, Howard Barr > wrote:


Hi, I am subscribed to this list but since the 11 of March I have
not received any emails. I'm based in Chiba, Japan (south-east of
Tokyo) but I doubt if that has anything to do with not receiving
email. Regards, Howard.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org


List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***



Hi Helmar,

replying to all. Do you think I should subscribe again?

Howard

--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Zeros when linking cells between sheets

[Stefan Weigel]

Hi John,

Am 21.03.2011 12:07, schrieb John Kennedy:

> If "Phone.a3" is empty then "All.a3" has a 0 (zero). I would prefer, for
> readability, for the cell to be blank like the referenced cell.
> Is there a way to do this?

Tools | Options... | LibreOffice Calc | View | Zero values

Stefan
-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Zeros when linking cells between sheets

[John Kennedy]

On Mon, Mar 21, 2011 at 13:32, Stefan Weigel <
stefan.wei...@bildungskreis.org> wrote:

> Hi John,
>
> Am 21.03.2011 12:07, schrieb John Kennedy:
>
> > If "Phone.a3" is empty then "All.a3" has a 0 (zero). I would prefer, for
> > readability, for the cell to be blank like the referenced cell.
> > Is there a way to do this?
>
> Tools | Options... | LibreOffice Calc | View | Zero values
>
> Stefan


Stefan,
Just what I needed.
Thanks,
John

-- 
 John Kennedy

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] What happened to the delete row/column icons?

[bill purvis]

I have recently converted to LibreOffice from OpenOffice. I have a minor
quibble - OpenOffice Calc had toolbar items to delete rows and columns
but I can't find these in LibreOffice. I found the insert rows and columns
Ok and have added them to the toolbar, but miss those for deleting.
I could do without the insert cells icons.

Bill
-- 
+---+
| Bill Purvis, Model Engineer   |
|  email: b...@billp.org|
+---+

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] What happened to the delete row/column icons?

[Andy Brown]

bill purvis wrote:

I have recently converted to LibreOffice from OpenOffice. I have a minor
quibble - OpenOffice Calc had toolbar items to delete rows and columns
but I can't find these in LibreOffice. I found the insert rows and columns
Ok and have added them to the toolbar, but miss those for deleting.
I could do without the insert cells icons.

Bill


I was not aware of either icon.  I have always inserted/deleted by right 
clicking on the headers, row or column, and select delete/insert 
row/column.  Seems faster to me.


Andy

--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] What happened to the delete row/column icons?

[Stefan Weigel]

Hi Bill,

Am 21.03.2011 15:13, schrieb bill purvis:

> OpenOffice Calc had toolbar items to delete rows and columns
> but I can't find these in LibreOffice. I found the insert rows and columns
> Ok and have added them to the toolbar, but miss those for deleting.

When look at

Tools | Customize... | Toolbars | Add... | Edit

I can see an icon for "Delete Columns" as well as an icon for
"Delete Rows".

I am using LibreOffice 3.3.1 on Ubuntu Linux 10.10.

Stefan

-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Word Count Progress Bar

[Michael Redman]

I'm looking for a functionality in Writer:  a word count progress bar.

Set the number of words that is your target, and somewhere in the writer
window the program displays the progress real-time.

Any ideas?

Regards,

Mike Redman

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Word Count Progress Bar

[Steven Shelton]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
 
On 3/21/2011 11:31 AM, Michael Redman wrote:
> I'm looking for a functionality in Writer: a word count progress
> bar.
>
> Set the number of words that is your target, and somewhere in the
> writer window the program displays the progress real-time.
>
> Any ideas?

I think there's an OOo plug-in for this that should work with LibO.
Look at the OOo extensions site.


- -- 
Steven Shelton
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.12 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
 
iEYEARECAAYFAk2HdwgACgkQXUonIzCvpdNKTgCaAvr9ECby1r5GVp3LigQ7Q4Q5
Wd4An1c2HkRQ/ErXRnL6prsAU+JSKa4z
=Ucql
-END PGP SIGNATURE-


-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Word Count Progress Bar

[Manfred J. Krause]

Hi,

On Mon, Mar 21, 2011 at 16:31, Michael Redman wrote:
> I'm looking for a functionality in Writer:  a word count progress bar.
>
> Set the number of words that is your target, and somewhere in the writer
> window the program displays the progress real-time.
>
> Any ideas?

Maybe "wc.py":
[Solved+Issue] No visible word count in OpenOffice Writer
http://user.services.openoffice.org/en/forum/viewtopic.php?f=7&t=22555&start=0

That works fine for me with LibO 3.3.1 / 3.3.2 RC.

mjk

-- 
Macroprogramming with Python
http://lodahl.blogspot.com/2011/03/macroprogramming-with-python.html

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] What happened to the delete row/column icons?

[bill purvis]

On Monday 21 March 2011, Stefan Weigel wrote:
> Hi Bill,
> 
> Am 21.03.2011 15:13, schrieb bill purvis:
> > OpenOffice Calc had toolbar items to delete rows and columns
> > but I can't find these in LibreOffice. I found the insert rows and
> > columns Ok and have added them to the toolbar, but miss those for
> > deleting.
> 
> When look at
> 
> Tools | Customize... | Toolbars | Add... | Edit
> 
> I can see an icon for "Delete Columns" as well as an icon for
> "Delete Rows".
> 
> I am using LibreOffice 3.3.1 on Ubuntu Linux 10.10.
> 
> Stefan
Great! Thanks a lot. I was sure that it must be somewhere but
I've obviously not learned how to find my way round it.

Bill
-- 
+---+
| Bill Purvis, Model Engineer   |
|  email: b...@billp.org|
+---+

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Word Count Progress Bar

[Michael Redman]

Yep - it works...thanks!

Now I just have to make it more user-friendly to start/autostart for my
wifeperhaps a button.

On Mon, Mar 21, 2011 at 12:07 PM, Manfred J. Krause <
courrier.oou.fr@googlemail.com> wrote:

> Hi,
>
> On Mon, Mar 21, 2011 at 16:31, Michael Redman wrote:
> > I'm looking for a functionality in Writer:  a word count progress bar.
> >
> > Set the number of words that is your target, and somewhere in the writer
> > window the program displays the progress real-time.
> >
> > Any ideas?
>
> Maybe "wc.py":
> [Solved+Issue] No visible word count in OpenOffice Writer
>
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=7&t=22555&start=0
>
> That works fine for me with LibO 3.3.1 / 3.3.2 RC.
>
> mjk
>
> --
> Macroprogramming with Python
> http://lodahl.blogspot.com/2011/03/macroprogramming-with-python.html
>
> --
> Unsubscribe instructions: E-mail to users+h...@libreoffice.org
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***
>



-- 
Take care,



Mike Redman
Visionmanager, Creatrix Transformational Solutions Inc
www.kimredmannlp.com
c.905-716-4854

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Word Count Progress Bar

[Michael Redman]

Yep, a buttoncreated a custom toolbar and then added a button that
pointed to the script.  My wife will think I'm a god!

Thanks!

On Mon, Mar 21, 2011 at 12:26 PM, Michael Redman wrote:

> Yep - it works...thanks!
>
> Now I just have to make it more user-friendly to start/autostart for my
> wifeperhaps a button.
>
>
> On Mon, Mar 21, 2011 at 12:07 PM, Manfred J. Krause <
> courrier.oou.fr@googlemail.com> wrote:
>
>> Hi,
>>
>> On Mon, Mar 21, 2011 at 16:31, Michael Redman wrote:
>> > I'm looking for a functionality in Writer:  a word count progress bar.
>> >
>> > Set the number of words that is your target, and somewhere in the writer
>> > window the program displays the progress real-time.
>> >
>> > Any ideas?
>>
>> Maybe "wc.py":
>> [Solved+Issue] No visible word count in OpenOffice Writer
>>
>> http://user.services.openoffice.org/en/forum/viewtopic.php?f=7&t=22555&start=0
>>
>> That works fine for me with LibO 3.3.1 / 3.3.2 RC.
>>
>> mjk
>>
>> --
>> Macroprogramming with Python
>> http://lodahl.blogspot.com/2011/03/macroprogramming-with-python.html
>>
>> --
>> Unsubscribe instructions: E-mail to users+h...@libreoffice.org
>> List archive: http://listarchives.libreoffice.org/www/users/
>> *** All posts to this list are publicly archived for eternity ***
>>
>
>
>
> --
> Take care,
>
>
>
> Mike Redman
> Visionmanager, Creatrix Transformational Solutions Inc
> www.kimredmannlp.com
> c.905-716-4854
>



-- 
Take care,



Mike Redman
Visionmanager, Creatrix Transformational Solutions Inc
www.kimredmannlp.com
c.905-716-4854

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Word Count Progress Bar

[Leif Lodahl]

Hi Michael,
Funny but I implemented just these two features this weekend ;-)

Take a look at this
https://bitbucket.org/yawaramin/oo.o-live-word-count/overview/ and this
http://lodahl.blogspot.com/2011/03/macroprogramming-with-python.html


Cheers,
Leif Lodahl



2011/3/21 Michael Redman 

> I'm looking for a functionality in Writer:  a word count progress bar.
>
> Set the number of words that is your target, and somewhere in the writer
> window the program displays the progress real-time.
>
> Any ideas?
>
> Regards,
>
> Mike Redman
>
> --
> Unsubscribe instructions: E-mail to users+h...@libreoffice.org
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***
>
>

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Convert formulae to actual

[James Wilde]

I have a calc sheet with full names in one column, thus:

John Smith
Jane Smollett

I want to create a column with forenames and one with surnames.  I've created 
an extra column with the position of the space between first name and last name 
(in the cases above, it's five in each case), and two other columns in one of 
which I place the first x-1 characters where x is the position of the space) 
and in the other I place the right end of the name field from the x+1 character 
to the end.

What I'd now like todo is to change the contents of the first name column from 
left(1;x-1) to John or Jane, and the last name column likewise, from being a 
formula which displays as a name to being a name.

Can't find it anywhere.

TIA

//James
-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Convert formulae to actual

[Jean-Francois Nifenecker]

Le 21/03/2011 17:59, James Wilde a écrit :


What I'd now like todo is to change the contents of the first name
column from left(1;x-1) to John or Jane, and the last name column
likewise, from being a formula which displays as a name to being a
name.


Select, then Copy Special at the same place with Formula option unchecked.

--
Jean-Francois Nifenecker, Bordeaux


--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] LO Calc very slow and freezes

[Thomas Bouchard]

Hi
I have a simple sheet with lots of lines (>30), a graph on 2 columns 
only but no formulas.
LO struggles to open it, freezes all the time, so it's impossible to 
work with it.


My laptop runs correctly (Intel centrino duo with Xubuntu 10.04), memory 
and cpu are under 50% of use.
Is there some special memory settings to make *calc* work flawlessly, or 
is it a performance problem?


Regards

/Thomas


--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Re: LO Calc very slow and freezes

[plino]

It is a performance problem. If you are using an xlsx file you can decrease
loading time by 2/3 if you save it to ODS.

See this topic

http://nabble.documentfoundation.org/Why-is-LO-OOo-so-slow-loading-a-spreadsheet-td2006665.html

HTH

--
View this message in context: 
http://nabble.documentfoundation.org/LO-Calc-very-slow-and-freezes-tp2710811p2710975.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: LO Calc very slow and freezes

[Thomas Bouchard]

Thanks for the quick answer.
My file is ODS, but gnumeric can't open it, maybe because of the line 
number.


Le 21/03/2011 18:51, plino a écrit :

It is a performance problem. If you are using an xlsx file you can decrease
loading time by 2/3 if you save it to ODS.

See this topic

http://nabble.documentfoundation.org/Why-is-LO-OOo-so-slow-loading-a-spreadsheet-td2006665.html

HTH

--
View this message in context: 
http://nabble.documentfoundation.org/LO-Calc-very-slow-and-freezes-tp2710811p2710975.html
Sent from the Users mailing list archive at Nabble.com.



--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Convert formulae to actual

[James Wilde]

On Mar 21, 2011, at 18:10 , Jean-Francois Nifenecker wrote:

> 
> Le 21/03/2011 17:59, James Wilde a écrit :
>> 
>> What I'd now like todo is to change the contents of the first name
>> column from left(1;x-1) to John or Jane, and the last name column
>> likewise, from being a formula which displays as a name to being a
>> name.
> 
> Select, then Copy Special at the same place with Formula option unchecked.
> 

Sorry, Jean-Francois.  There is no Copy Special.  Only Paste Special.  And 
Paste Special does not have a Formula option.

//J


-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Convert formulae to actual

[Charles Marcus]

On 2011-03-21 4:14 PM, James Wilde wrote:
> Sorry, Jean-Francois.  There is no Copy Special.  Only Paste Special.  And 
> Paste Special does not have a Formula option.

sure it does, I use it all the time...

-- 

Best regards,

Charles

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Convert formulae to actual

[Jean-Francois Nifenecker]

Le 21/03/2011 21:14, James Wilde a écrit :


Sorry, Jean-Francois.  There is no Copy Special.  Only Paste Special.  And 
Paste Special does not have a Formula option.


Ooops! Yes, it should read Paste special, sorry for the typo. And I 
confirm there *is* a Formula option :)


--
Jean-Francois Nifenecker, Bordeaux


--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Convert formulae to actual

[James Wilde]

On Mar 21, 2011, at 21:46 , Jean-Francois Nifenecker wrote:

> 
> Le 21/03/2011 21:14, James Wilde a écrit :
>> 
>> Sorry, Jean-Francois.  There is no Copy Special.  Only Paste Special.  And 
>> Paste Special does not have a Formula option.
> 
> Ooops! Yes, it should read Paste special, sorry for the typo. And I confirm 
> there *is* a Formula option :)

Ah, thanks.  I didn't realise that, by select, you meant I had to copy the 
cells in question.  When I copied them first, it worked exactly as you said.

Thanks for the help.

//James
-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Convert formulae to actual

[Stefan Weigel]

Hi,

Am 21.03.2011 17:59, schrieb James Wilde:

> I have a calc sheet with full names in one column, thus:
> 
> John Smith
> Jane Smollett
> 
> I want to create a column with forenames and one with surnames.

No need for formulae.

Have a look at: "Data | Text to Columns..."

See: http://help.libreoffice.org/Calc/Text_to_Columns

Stefan

-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Re: Word Count Progress Bar

[aqualung]

Great, I hope you make this into a .oxt extension and upload it to the
extensions repository!

--
View this message in context: 
http://nabble.documentfoundation.org/Word-Count-Progress-Bar-tp2710396p2711100.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Re: LO Calc very slow and freezes

[plino]

Gnumeric supports up to 16777216 lines (yes, 16 million...)

Maybe you are using an older version. The current build is 1.10.13

--
View this message in context: 
http://nabble.documentfoundation.org/LO-Calc-very-slow-and-freezes-tp2710811p2712956.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***