[libreoffice-users] Re: Sorting Called Data

[mcbad]

Thanks, this works.

On Wed, Sep 28, 2011 at 11:43 PM, Brian Barker [via Document Foundation Mail
Archive]  wrote:

> At 04:59 28/09/2011 -0700, Nobody Noname wrote:
>
> >When I go to sort data from a column that contains data from other
> >spreadsheets, it messes up my equations and called cells.  How do I
> >get these to stay in place while sorting?
> >
> >I'll use Tunisia as an example... before the sort its cell is defined as
> >='file:///C:/Users/ajax/Desktop/teamrankings/2010.ods'#$FIBAWC.B24
> >and then after I sort it its all of a sudden:
> >='file:///C:/Users/ajax/Desktop/teamrankings/2010.ods'#$FIBAWC.B#REF!
> >(its trying to call a cell that is not there in another
> >spreadsheet).  Why is it changing my formula when I was it to be
> >2010.ods'#$FIBAWC.B24?
> >
> >Another example is Italy, I want it and have it to be
> >='file:///C:/Users/ajax/Desktop/teamrankings/2010.ods'#$FIFAWC.B26
> >and then after I sort it goes to
> >='file:///C:/Users/ajax/Desktop/teamrankings/2010.ods'#$FIFAWC.B19
> >
> >http://nabble.documentfoundation.org/file/n3375803/before.png
> >http://nabble.documentfoundation.org/file/n3375803/after.png
>
> When you sort formulae, the sorting is performed on the results of
> the formulae - the numbers or text values (or whatever) that you
> see.  But sorting consists of moving data from cell to cell, and -
> just as when you copy and paste formulae - the row and column
> references in formulae are modified according to the displacement that
> occurs.
>
> It's not entirely clear from your "after" picture which rows the data
> ends up in, but it appears from the formulae you quote that the
> "after" picture starts in row 1, not row 16, like the "before"
> picture.  This means that Italy, which starts in row 21, ends up in
> row 14 - seven rows higher - so the "B26" in its formula is properly
> converted to "B19".  This no longer refers to Italy's data in the
> source file, of course - which is your problem.
>
> By the same token, Tunisia starts in row 43 and ends up in row 1 -
> forty-two rows higher.  The "B24" in its formula would need to be
> converted to "B-18", suggesting a non-existent row off the top of the
> sheet, so it appears as "B#REF!".
>
> The solution, which has already been suggested, is to make your row
> references absolute: "B$26" and "B$24" would not be modified in the
> way you notice.  You can make this change to your formulae easily
> using Find & Replace if you select Formulas for "Search in" (in More
> Options).
>
> I trust this helps.
>
> Brian Barker
>
>
> --
> For unsubscribe instructions e-mail to: [hidden 
> email]
> 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
>
>
>
> --
>  If you reply to this email, your message will be added to the discussion
> below:
>
> http://nabble.documentfoundation.org/Sorting-Called-Data-tp3375803p3378285.html
>  To unsubscribe from Sorting Called Data, click 
> here.
>
>


--
View this message in context: 
http://nabble.documentfoundation.org/Sorting-Called-Data-tp3375803p3378417.html
Sent from the Users mailing list archive at Nabble.com.
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: How to make dbase engine work in LO Base

[Andreas Säger]

Am 28.09.2011 23:54, planas wrote:


You could open them in Calc and then save them as a spreadsheet. In
Base, select the connect to existing database and scroll down to
spreadsheet. Follow the wizard and should import the file into Base.



When you do that, you sacrify the database. A spreadsheet is not a 
sufficient replacement.



--
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: How to make dbase engine work in LO Base

[Andreas Säger]

Am 29.09.2011 07:43, Aleksey wrote:

I described my operation a bit obscure. I have done the mentioned procedure (I mean "Connect to 
existing database"->"dbase"->  other procedures mentioned above) and after that I
saw a database without any tables. My question: is there anyone who have seen 
that connection to dbase databases work in LO Base 3.4?




You might have another dBase connection already.

- In Writer or Calc hit F4.
- Right-click the "Bibliography"
- Choose "Edit database"

The status bar indicates that this example database is in dBase.
See menu:Edit>Database for more details.


--
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: How to make dbase engine work in LO Base

[Aleksey]

Andreas Säger wrote:

> 
> Base never opens any files other than the .odb files it creates. You
> always connect Base to some tabular data source.
> 
> File>New>Database...
> [X] Connect to existing...
> Type: 
> Specify the directory (dBase has always been a database in a directory)
> [x] Register data source
> Save the .odb file
> 
> The .odb file is just a configuration file. It does not contain any
> database data. You may add simple SQL queries to that configuration.
> 
> 

I described my operation a bit obscure. I have done the mentioned procedure (I 
mean "Connect to existing database"->"dbase"-> other procedures mentioned 
above) and after that I 
saw a database without any tables. My question: is there anyone who have seen 
that connection to dbase databases work in LO Base 3.4?


-- 
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] Clear all "new page"

[Brian Barker]

At 06:28 29/09/2011 +0200, Jean-Baptiste Faure wrote:

Le 28/09/2011 10:02, Brian Barker a écrit :

At 21:40 27/09/2011 +0200, Jean-Baptiste Faure wrote:

Le 27/09/2011 16:57, Mihamina Rakotomandimby a écrit :
I inserted a lot of "new page" (with 
Ctrl+Enter) in a Writer document.  I would 
like to clear them all: replace them with a simple "newline".


How to "find & replace" them all?


You can use regular expressions (look at this 
words in the index of the help: coding of end of paragraph is not standard).


Oh, do tell!  What element of regular 
expressions will detect the questioner's manual 
page breaks?  Where is it in the help text, please?


There : http://help.libreoffice.org/Common/List_of_Regular_Expressions


Sorry, but either you are being perverse or we 
are at cross-purposes here.  I know that table, 
of course - as, no doubt, does the other person 
replying who cannot find the solution there.  The 
questioner needs to find *manual page 
breaks*.  The table you indicate mentions line 
breaks and paragraph breaks but there is no 
mention of page breaks.  We cannot see how these 
regular expressions can be used to find page breaks - as you claim.


Please stop being obtuse and simply give us an 
example of such a regular expression.  Or agree with us that there is none.


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] Sorting Called Data

[Brian Barker]

At 04:59 28/09/2011 -0700, Nobody Noname wrote:
When I go to sort data from a column that contains data from other 
spreadsheets, it messes up my equations and called cells.  How do I 
get these to stay in place while sorting?


I'll use Tunisia as an example... before the sort its cell is defined as
='file:///C:/Users/ajax/Desktop/teamrankings/2010.ods'#$FIBAWC.B24 
and then after I sort it its all of a sudden:
='file:///C:/Users/ajax/Desktop/teamrankings/2010.ods'#$FIBAWC.B#REF! 
(its trying to call a cell that is not there in another 
spreadsheet).  Why is it changing my formula when I was it to be 
2010.ods'#$FIBAWC.B24?


Another example is Italy, I want it and have it to be
='file:///C:/Users/ajax/Desktop/teamrankings/2010.ods'#$FIFAWC.B26 
and then after I sort it goes to

='file:///C:/Users/ajax/Desktop/teamrankings/2010.ods'#$FIFAWC.B19

http://nabble.documentfoundation.org/file/n3375803/before.png
http://nabble.documentfoundation.org/file/n3375803/after.png


When you sort formulae, the sorting is performed on the results of 
the formulae - the numbers or text values (or whatever) that you 
see.  But sorting consists of moving data from cell to cell, and - 
just as when you copy and paste formulae - the row and column 
references in formulae are modified according to the displacement that occurs.


It's not entirely clear from your "after" picture which rows the data 
ends up in, but it appears from the formulae you quote that the 
"after" picture starts in row 1, not row 16, like the "before" 
picture.  This means that Italy, which starts in row 21, ends up in 
row 14 - seven rows higher - so the "B26" in its formula is properly 
converted to "B19".  This no longer refers to Italy's data in the 
source file, of course - which is your problem.


By the same token, Tunisia starts in row 43 and ends up in row 1 - 
forty-two rows higher.  The "B24" in its formula would need to be 
converted to "B-18", suggesting a non-existent row off the top of the 
sheet, so it appears as "B#REF!".


The solution, which has already been suggested, is to make your row 
references absolute: "B$26" and "B$24" would not be modified in the 
way you notice.  You can make this change to your formulae easily 
using Find & Replace if you select Formulas for "Search in" (in More Options).


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] Clear all "new page"

[Jean-Baptiste Faure]

Le 28/09/2011 10:02, Brian Barker a écrit :
> At 21:40 27/09/2011 +0200, Jean-Baptiste Faure wrote:
>> Le 27/09/2011 16:57, Mihamina Rakotomandimby a écrit :
>>> I inserted a lot of "new page" (with Ctrl+Enter) in a Writer
>>> document.  I would like to clear them all: replace them with a simple
>>> "newline".
>>>
>>> How to "find & replace" them all?
>>
>> You can use regular expressions (look at this words in the index of
>> the help: coding of end of paragraph is not standard).
> 
> Oh, do tell!  What element of regular expressions will detect the
> questioner's manual page breaks?  Where is it in the help text, please?

There : http://help.libreoffice.org/Common/List_of_Regular_Expressions

JBF

-- 
Seuls des formats ouverts peuvent assurer la pérennité de vos documents.

-- 
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.4.2 calc horizontal scroll bar don't works

[Tom Davies]

Hi :)
It might be worth re-naming the user-profile?  In suse it is probably 
/home/home/username/.libreoffice/3/user
The . at the front of libreoffice makes it a hidden folder and to rename the 
"3" folder you probably need to be Root User.
Regards from
Tom :)

--- On Wed, 28/9/11, yahoo-pier_andreit  wrote:

From: yahoo-pier_andreit 
Subject: [libreoffice-users] LibreOffice 3.4.2 calc horizontal scroll bar don't 
works
To: users@global.libreoffice.org
Date: Wednesday, 28 September, 2011, 17:34

on my suse 11.4 with kde 4.7.1 and LibreOffice 3.4.2 :
If you open a calc spreadsheet and try to move the horizontal scrollbar it 
doesn't move, have you similar problem or a solution?

thnx PLA

-- 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] Fw: [libreoffice-accessibility] LibreOffice 3.4 has stopped working

[Tom Davies]

Hi :)
Someone on the accessibility list is having trouble with portable LO
http://nabble.documentfoundation.org/LibreOffice-3-4-has-stopped-working-td3376400.html

All i could think of was re-naming the user-profile.  It's a very low-traffic 
list or you could post an answer through Nabble or something if you have better 
ideas.
Regards from
Tom :)

--- On Wed, 28/9/11, Tutor1  wrote:

From: Tutor1 
Subject: [libreoffice-accessibility] LibreOffice 3.4 has stopped working
To: accessibil...@global.libreoffice.org
Date: Wednesday, 28 September, 2011, 16:32

After downloading and installing the portable appsversion of LO I get the
following when i try to open it
I'm using Win 7 pro with service pack 1

LibreOffice 3.4 has stopped working
check online or close program
either way the problem still remains

Problem signature:
  Problem Event Name:    BEX
  Application Name:    soffice.bin
  Application Version:    3.4.302.500
  Application Timestamp:    4e54357a
  Fault Module Name:    MSVCR90.dll
  Fault Module Version:    9.0.30729.4940
  Fault Module Timestamp:    4ca2ef57
  Exception Offset:    0002e9f4
  Exception Code:    c417
  Exception Data:    
  OS Version:    6.1.7601.2.1.0.256.48
  Locale ID:    2057
  Additional Information 1:    70d5
  Additional Information 2:    70d5762ff668ba7bf0e5139640d4fd2f
  Additional Information 3:    1d77
  Additional Information 4:    1d7771fdc7b88a2d27415e12512a980d


--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-3-4-has-stopped-working-tp3376400p3376400.html
Sent from the Accessibility mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to accessibility+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/accessibility/
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 3.4.2 calc horizontal scroll bar don't works

[planas]

On Wed, 2011-09-28 at 18:34 +0200, yahoo-pier_andreit wrote: 

> on my suse 11.4 with kde 4.7.1 and LibreOffice 3.4.2 :
> If you open a calc spreadsheet and try to move the horizontal scrollbar 
> it doesn't move, have you similar problem or a solution?
> 
> thnx PLA
> 


The scroll bar works fine form me, 3.3.4 and 3.4.3 Ubuntu/Pinguy 11.04
with Gnome 2.?
-- 
Jay Lozier
jsloz...@gmail.com

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

[libreoffice-users] Re: Real Usenet newsgroups

[Ken Springer]

On 9/28/11 4:45 AM, Stefan Gruber wrote:

Mihamina Rakotomandimby schrieb:

Have you heard about Gmane?
You can have this list as newgroup with this.


I'm posting to this list via Gmane successfully, as you can see.

In contrary, posting to
gmane.comp.documentfoundation.libreoffice.user.german and other
lists does not work properly. I do not know why and do not have
time to find it out.

That is the main reason, why I personally support the OP for
calling real native newsgroups.


One thing to consider, if LO were to do this, is the cost of setting it 
up and then maintaining the system.



Besides, I also think it is the most useful way.

But I guess most of those readers are used to Mailing Lists,
although *I* don't like to blow up my Mailclient with hundreds of
Postings...


I hate mailing lists, and was just about to unsubscribe when I learned 
about Gmane.  Just recently, I found a couple other ways/places to read 
the mailing list that resembles a newsgroup, but IMO still not as handy 
as a newsgroup reader.





--
Ken

Mac OS X 10.6.8
Firefox 6.0.2
Thunderbird 6.0.2
LibreOffice 3.3.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

Re: [libreoffice-users] How to make dbase engine work in LO Base

[planas]

Aleksey

On Thu, 2011-09-29 at 00:33 +0400, Aleksey wrote: 

> Greetings, gentlemen.
> 
> When I try to open dbase data base using LO Base I enter the path to the 
> directory with dbf-files but there's no tables in LO Base? LO Calc opens dbf 
> files but how to open them in 
> LO Base? Standard connection fails to work.
> 

You could open them in Calc and then save them as a spreadsheet. In
Base, select the connect to existing database and scroll down to
spreadsheet. Follow the wizard and should import the file into Base. 

> LO version: 3.4.2
> OS: OpenSuse 11.4 64 bit
> 
> Best regards, Aleksey.
> 
> 
> 
> 



-- 
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: Sorting Called Data

[Tom Davies]

Hi :)
Text is numbers in this space-time continuum.  Surely text gets sorted by it's 
ascii code or something?  I'm not sure how equations get sorted tho.
Regards from
Tom :)


--- On Wed, 28/9/11, Andreas Säger  wrote:

From: Andreas Säger 
Subject: [libreoffice-users] Re: Sorting Called Data
To: users@global.libreoffice.org
Date: Wednesday, 28 September, 2011, 14:04

Spreadsheets are about numbers. You've got to sort numbers rather than text.


-- 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: How to make dbase engine work in LO Base

[Andreas Säger]

Am 28.09.2011 22:33, Aleksey wrote:

Greetings, gentlemen.

When I try to open dbase data base using LO Base I enter the path to the 
directory with dbf-files but there's no tables in LO Base? LO Calc opens dbf 
files but how to open them in
LO Base? Standard connection fails to work.

LO version: 3.4.2
OS: OpenSuse 11.4 64 bit

Best regards, Aleksey.






Base never opens any files other than the .odb files it creates. You 
always connect Base to some tabular data source.


File>New>Database...
[X] Connect to existing...
Type: 
Specify the directory (dBase has always been a database in a directory)
[x] Register data source
Save the .odb file

The .odb file is just a configuration file. It does not contain any 
database data. You may add simple SQL queries to that configuration.



--
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: [writer] How to check a whole table cell ?

[Guillaume]

I try with no effect.
I don't understand what this action can make.

--
View this message in context: 
http://nabble.documentfoundation.org/writer-How-to-check-a-whole-table-cell-tp3313397p3375213.html
Sent from the Users mailing list archive at Nabble.com.

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

[libreoffice-users] Re: [writer] How to check a whole table cell ?

[Guillaume]

Right, but this isn't what i try to do.

I want to create a cross inside a cell, in a writer table.

--
View this message in context: 
http://nabble.documentfoundation.org/writer-How-to-check-a-whole-table-cell-tp3313397p3375289.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

[solved] Re: [libreoffice-users] appending documents

[Tom Davies]

Hi :)
Fantastic :)  Thanks :)  The word i was struggling for was appending rather 
than merging.  I was able to drag&drop each document into the master and then 
make a pdf of it.  A couple of minor formatting went a bit wonky but it's good 
enough.  I think the wonkiness was caused by problems in the original docs.
Thanks and regards from
Tom :)

--- On Wed, 28/9/11, MiguelAngel  wrote:

From: MiguelAngel 
Subject: Re: [libreoffice-users] merging documents
To: users@global.libreoffice.org
Date: Wednesday, 28 September, 2011, 20:56

Menu/File/New/Master Document, I think is the option that you are
    looking for.Regards.Miguelngel.El 28/09/11 18:19, Tom Davies escribi:Hi :)
Is it possible to merge 2 different documents, both odt, so 
that the 1st is the title page and the 2 is the contents?The 1st page 
has photos.I'm trying to get about 6 documents together for the 
End-of-Year Report at work. 
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


-- 
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: Real Usenet newsgroups

[Stefan Gruber]

Mihamina Rakotomandimby schrieb:
> Have you heard about Gmane?
> You can have this list as newgroup with this.

I'm posting to this list via Gmane successfully, as you can see.

In contrary, posting to 
gmane.comp.documentfoundation.libreoffice.user.german and other 
lists does not work properly. I do not know why and do not have 
time to find it out.

That is the main reason, why I personally support the OP for 
calling real native newsgroups. 

Besides, I also think it is the most useful way.

But I guess most of those readers are used to Mailing Lists, 
although *I* don't like to blow up my Mailclient with hundreds of 
Postings...

Greetings
Stefan Gruber




-- 
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] How to make dbase engine work in LO Base

[Aleksey]

Greetings, gentlemen.

When I try to open dbase data base using LO Base I enter the path to the 
directory with dbf-files but there's no tables in LO Base? LO Calc opens dbf 
files but how to open them in 
LO Base? Standard connection fails to work.

LO version: 3.4.2
OS: OpenSuse 11.4 64 bit

Best regards, Aleksey.




-- 
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: merging documents

[Pedro]

Hi Tom :)

Open the first document, go to the end of the page and do Insert File
repeatedly ;)

--
View this message in context: 
http://nabble.documentfoundation.org/merging-documents-tp3376556p3377284.html
Sent from the Users mailing list archive at Nabble.com.

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

Re: [libreoffice-users] merging documents

[MiguelAngel]

Menu/File/New/Master Document, I think is the option that you are
looking for.Regards.Miguelngel.El 28/09/11 18:19, Tom Davies escribi:Hi :)
Is it possible to merge 2 different documents, both odt, so 
that the 1st is the title page and the 2 is the contents?The 1st page 
has photos.I'm trying to get about 6 documents together for the 
End-of-Year Report at work. 
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: Missing item in LibreOffice 3.4.3

[Manfred J. Krause]

Hi,

On Wed, Sep 28, 2011 at 7:04 PM, NoOp wrote:
> On 09/28/2011 12:08 AM, Jean-Baptiste Faure wrote:
>> Le 28/09/2011 08:59, plmvantoo...@hetnet.nl a écrit :
>>> Dear sirs,
>>>
>>> I have noticed, that in LibreOffice 3.4.3 there is a missing item.
>>> When you go to Tools, Macros, you will find, that in the sub-menu of 
>>> Macros, there is no option for Recording Macro (making a macro).
>>> This error you will find in Writer, Calc and Impress as well. And it might 
>>> be missing in the other modules, but I have not checked this.

"The macro recording functionality is only available for text
documents in LibreOffice Writer and for spreadsheets in LibreOffice
Calc."
See also: Writer > Help 
Index: macros;recording

>>> Please, inform me if this item will be corrected.
>>
>> You have to enable experimental features : Tools > Options > LibreOffice >
>> General
> ...
> I wonder why that is not documented in 'Help':
> ===
> Recording a Macro
> 1. Open the document for which you want to record a macro.
> 2. Choose Tools - Macros - Record Macro.
> You see the small Recording dialog with just one button called Stop
> Recording.
> ===
> Note: Prior to enabling via 'Enable experimental (unstable) features '
> in 3.3.4 the option is on the menu but greyed out. In 3.4.3 it is not
> available at all before enabling.

Bug 38509 - Meaningless text and missing Help for Options Dialog
checkbox "Experimental (unstable) features"
[Status: ASSIGNED]
https://bugs.freedesktop.org/show_bug.cgi?id=38509

mjk

-- 
Writer headers and footers revisited
http://cedric.bosdonnat.free.fr/wordpress/?p=818

-- 
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.4.2 calc horizontal scroll bar don't works

[yahoo-pier_andreit]

on my suse 11.4 with kde 4.7.1 and LibreOffice 3.4.2 :
If you open a calc spreadsheet and try to move the horizontal scrollbar 
it doesn't move, have you similar problem or a solution?


thnx PLA

--
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: Clear all "new page"

[Andreas Säger]

Am 27.09.2011 16:57, Mihamina Rakotomandimby wrote:

Hello,

I inserted a lot of "new page" (with Ctrl+Enter) in a Writer document.
I would like to clear them all: replace them with a simple "newline".

How to "find & replace" them all?



The AltSearch extension can be found here:

http://extensions.services.openoffice.org/en/project/AltSearch


Refresh several times if the page refuses to load.




--
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: Missing item in LibreOffice 3.4.3

[NoOp]

On 09/28/2011 12:08 AM, Jean-Baptiste Faure wrote:
> Hi,
> 
> Le 28/09/2011 08:59, plmvantoo...@hetnet.nl a écrit :
>> Dear sirs,
>> 
>> I have noticed, that in LibreOffice 3.4.3 there is a missing item.
>> When you go to Tools, Macros, you will find, that in the sub-menu of Macros, 
>> there is no option for Recording Macro (making a macro).
>> This error you will find in Writer, Calc and Impress as well. And it might 
>> be missing in the other modules, but I have not checked this.
>> 
>> Please, inform me if this item will be corrected.
> 
> You have to enable experimental features : Tools > Options > LibreOffice
>> General
...
I wonder why that is not documented in 'Help':
===
Recording a Macro
1. Open the document for which you want to record a macro.
2. Choose Tools - Macros - Record Macro.
You see the small Recording dialog with just one button called Stop
Recording.
===
Note: Prior to enabling via 'Enable experimental (unstable) features '
in 3.3.4 the option is on the menu but greyed out. In 3.4.3 it is not
available at all before enabling.



-- 
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] Clear all "new page"

[Johnny Rosenberg]

2011/9/28 Brian Barker :
> At 21:40 27/09/2011 +0200, Jean-Baptiste Faure wrote:
>>
>> Le 27/09/2011 16:57, Mihamina Rakotomandimby a écrit :
>>>
>>> I inserted a lot of "new page" (with Ctrl+Enter) in a Writer document.  I
>>> would like to clear them all: replace them with a simple "newline".
>>>
>>> How to "find & replace" them all?
>>
>> You can use regular expressions (look at this words in the index of the
>> help: coding of end of paragraph is not standard).
>
> Oh, do tell!  What element of regular expressions will detect the
> questioner's manual page breaks?  Where is it in the help text, please?

I also failed to find it, that's why I chose not to respond…


I guess it's possible to write a macro that handles it, but it seems
to be quite a lot of work for such a small task.

Another way would probably be to extract the file and do a search and
replace with a text editor.



Kind regards

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

>
> 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] merging documents

[Tom Davies]

Hi :)
Is it possible to merge 2 different documents, both odt, so 
that the 1st is the title page and the 2 is the contents?  The 1st page 
has photos.  I'm trying to get about 6 documents together for the 
End-of-Year Report at work. 
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

[libreoffice-users] Re: Sorting Called Data

[Andreas Säger]

Am 28.09.2011 16:08, mcbad wrote:

I'm not sure what you mean.  I did this same exact thing on Google Docs and
it worked fine, it sorted by the resulted number from the requested
spreadsheet and cell number.  Does this mean I cannot call data from another
spreadsheet and sort it?

--
View this message in context: 
http://nabble.documentfoundation.org/Sorting-Called-Data-tp3375803p3376139.html
Sent from the Users mailing list archive at Nabble.com.



Sorry, my answer was wrong. The #REF has nothing to do with sorting.

In Excel, Gnumeric and Calc you get #REF errors when
1) referring to the second sheet $Sheet2 absolutely and copy the 
reference to another document which has no second sheet.
1b) referring to the previous sheet Sheet2 relatively and copy the 
reference to the first sheet. Then there is no previous sheet anymore.
2) copying/moving a relative reference =A1 one row up since there is no 
row before row #1
3) copying/moving a relative reference =A1 one column to the left since 
there is no column before column A.



--
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: Sorting Called Data

[libo]

On 9/28/2011 10:08 AM, mcbad wrote:
> I'm not sure what you mean.  I did this same exact thing on Google Docs and
> it worked fine, it sorted by the resulted number from the requested
> spreadsheet and cell number.  Does this mean I cannot call data from another
> spreadsheet and sort it?
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Sorting-Called-Data-tp3375803p3376139.html
> Sent from the Users mailing list archive at Nabble.com.
>
try using absolute references like

#$FIBAWC.$B$24

L.


-- 
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: Sorting Called Data

[mcbad]

I'm not sure what you mean.  I did this same exact thing on Google Docs and
it worked fine, it sorted by the resulted number from the requested
spreadsheet and cell number.  Does this mean I cannot call data from another
spreadsheet and sort it?

--
View this message in context: 
http://nabble.documentfoundation.org/Sorting-Called-Data-tp3375803p3376139.html
Sent from the Users mailing list archive at Nabble.com.

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

[libreoffice-users] Re: Sorting Called Data

[Andreas Säger]

Am 28.09.2011 15:12, mcbad wrote:

But shouldn't it sort the result of the equation?  I thought that was
standard in spreadsheets.

--
View this message in context: 
http://nabble.documentfoundation.org/Sorting-Called-Data-tp3375803p3376004.html
Sent from the Users mailing list archive at Nabble.com.



Yes, of course. But the resulting cell value is NOT the displayed text.


--
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: Sorting Called Data

[mcbad]

But shouldn't it sort the result of the equation?  I thought that was
standard in spreadsheets.

--
View this message in context: 
http://nabble.documentfoundation.org/Sorting-Called-Data-tp3375803p3376004.html
Sent from the Users mailing list archive at Nabble.com.

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

[libreoffice-users] Re: Sorting Called Data

[Andreas Säger]

Spreadsheets are about numbers. You've got to sort numbers rather than text.


--
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] Sorting Called Data

[mcbad]

When I go to sort data from a column that contains data from other
spreadsheets, it messes up my equations and called cells.  How do I get
these to stay in place while sorting?

I'll use Tunisia as an example... before the sort its cell is defined as
='file:///C:/Users/ajax/Desktop/teamrankings/2010.ods'#$FIBAWC.B24 and then
after I sort it its all of a sudden: 
='file:///C:/Users/ajax/Desktop/teamrankings/2010.ods'#$FIBAWC.B#REF! (its
trying to call a cell that is not there in another spreadsheet).  Why is it
changing my formula when I was it to be 2010.ods'#$FIBAWC.B24?

Another example is Italy, I want it and have it to be
='file:///C:/Users/ajax/Desktop/teamrankings/2010.ods'#$FIFAWC.B26 and then
after I sort it goes to
='file:///C:/Users/ajax/Desktop/teamrankings/2010.ods'#$FIFAWC.B19

http://nabble.documentfoundation.org/file/n3375803/before.png 
http://nabble.documentfoundation.org/file/n3375803/after.png 

--
View this message in context: 
http://nabble.documentfoundation.org/Sorting-Called-Data-tp3375803p3375803.html
Sent from the Users mailing list archive at Nabble.com.

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

[libreoffice-users] Re: Laggy Calc in Win 7

[Andreas Säger]

I use LibO 3.3.4 on Windows 7 32 bit without any problems.
Java makes a tiny difference when the application is loading. It does 
not slow down the whole application.


Some tests:
Play with Tools>Options>Memory settings.
Go offline and turn off your virus scanner.
Reset any user defined default template if any.
File>Templates>Organize>[Command]>Reset Default Template>Spreadsheet (if 
any)



--
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: Laggy Calc in Win 7

[gnulab]

Cor Nouws wrote:
> 
> gnulab wrote (24-09-11 17:53)
> 
>> Before installing LibreOffice, I had uninstalled OpenOffice 3.3
> 
> If you did not remove the user profile explicitly, it will have stayed 
> and partly imported in LibreOffice automatically on the first start.
> 
> -- 
>   - Cor
>   - http://nl.libreoffice.org
> 

I have deleted the Openoffice user profile and still LibreOffice is showing
the same lagginess.

Henry

--
View this message in context: 
http://nabble.documentfoundation.org/Laggy-Calc-in-Win-7-tp3358202p3375553.html
Sent from the Users mailing list archive at Nabble.com.

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

Re: [libreoffice-users] [writer] How to check a whole table cell ?

[Jean-Baptiste Faure]

Hi,

Sorry, I answered for Calc instead of Writer.
You can copy-paste a table from Calc to Writer.

Best regards
JBF

Le 28/09/2011 10:14, Jean-Baptiste Faure a écrit :
> Bonjour Guillaume,
> 
> Le 06/09/2011 14:45, Guillaume Fillol a écrit :
>>
>> Hello,
>>
>> Using Writer with LibreOffice 3.4.2, I try to check a whole table cell.
>>
>> Here is an example : http://ca47.fr/LibreOfficeSample-CheckTableCell.odt
>>
>> Is there any way to do without using 2 misplaced lines ?
> 
> I am not sure if your question has been understood :-)
> If I understand right, you can do what you want in LibreOffice 3.4 :
> right click -> format cell > tab border and choose the crossing ones.
> 
> Perhaps you should ask for help on the French speaking mailing-list :
> http://fr.libreoffice.org/assistance/
> 
> 
> Best regards
> JBF
> 


-- 
Seuls des formats ouverts peuvent assurer la pérennité de vos documents.

-- 
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] [writer] How to check a whole table cell ?

[Jean-Baptiste Faure]

Bonjour Guillaume,

Le 06/09/2011 14:45, Guillaume Fillol a écrit :
> 
> Hello,
> 
> Using Writer with LibreOffice 3.4.2, I try to check a whole table cell.
> 
> Here is an example : http://ca47.fr/LibreOfficeSample-CheckTableCell.odt
> 
> Is there any way to do without using 2 misplaced lines ?

I am not sure if your question has been understood :-)
If I understand right, you can do what you want in LibreOffice 3.4 :
right click -> format cell > tab border and choose the crossing ones.

Perhaps you should ask for help on the French speaking mailing-list :
http://fr.libreoffice.org/assistance/


Best regards
JBF

-- 
Seuls des formats ouverts peuvent assurer la pérennité de vos documents.

-- 
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] Clear all "new page"

[Brian Barker]

At 21:40 27/09/2011 +0200, Jean-Baptiste Faure wrote:

Le 27/09/2011 16:57, Mihamina Rakotomandimby a écrit :
I inserted a lot of "new page" (with 
Ctrl+Enter) in a Writer document.  I would like 
to clear them all: replace them with a simple "newline".


How to "find & replace" them all?


You can use regular expressions (look at this 
words in the index of the help: coding of end of paragraph is not standard).


Oh, do tell!  What element of regular expressions 
will detect the questioner's manual page 
breaks?  Where is it in the help text, please?


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] Re: [writer] How to check a whole table cell ?

[Brian Barker]

At 09:26 28/09/2011 +0200, Ian Whitfield wrote:

On 27/09/2011 20:11, Cor Nouws wrote:

Guillaume wrote (27-09-11 18:01)

Any idea ?


- Put cursor in it
- Shift-Arrow down (or up)
- Shift-Arrow up (or down)
 .. ?


OR

Put Mouse Cursor into the cell,
Left-Click and hold,
Drag mouse in any direction to include at least one more cell,
Pull mouse back to original cell and release Left Button
Just that cell is now selected!!


You are both telling the questioner how to *select* a single table 
cell.  It wasn't obvious to me what he meant by "check", but his 
example document suggests that he wants to create diagonal lines 
which accurately join the corners of the cell, so that the cell 
becomes marked, deleted, disabled, crossed out.  His example has 
lines that have evidently been positioned manually and are not as 
neat as he would no doubt prefer.


I don't see how to do this easily.  A workaround may be to fill the 
cell with a background colour instead (after selecting it as above) - 
perhaps with a suitable grey?


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] Re: [writer] How to check a whole table cell ?

[Ian Whitfield]

On 27/09/2011 20:11, Cor Nouws wrote:

Guillaume wrote (27-09-11 18:01)

Any idea ?


- Put cursor in it
- Shift-Arrow down (or up)
- Shift-Arrow up (or down)
 .. ?

Cheers,


 OR

Put Mouse Cursor into the cell,
Left-Click and hold,
Drag mouse in any direction to include at least one more cell,
Pull mouse back to original cell and release Left Button
Just that cell is now selected!!

Ian Whitfield.

--
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] Missing item in LibreOffice 3.4.3

[Jean-Baptiste Faure]

Hi,

Le 28/09/2011 08:59, plmvantoo...@hetnet.nl a écrit :
> Dear sirs,
> 
> I have noticed, that in LibreOffice 3.4.3 there is a missing item.
> When you go to Tools, Macros, you will find, that in the sub-menu of Macros, 
> there is no option for Recording Macro (making a macro).
> This error you will find in Writer, Calc and Impress as well. And it might be 
> missing in the other modules, but I have not checked this.
> 
> Please, inform me if this item will be corrected.

You have to enable experimental features : Tools > Options > LibreOffice
> General

Best regards
JBF

-- 
Seuls des formats ouverts peuvent assurer la pérennité de vos documents.

-- 
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] Missing item in LibreOffice 3.4.3

[Onyeibo Oku]

Same here. Didn't bother with it since I don't record macros but I've noticed 
that many times

-
from twohot@device.mobile :)

-Original Message-
From: 
Date: Wed, 28 Sep 2011 08:59:31 
To: 
Reply-To: users@global.libreoffice.org
Subject: [libreoffice-users] Missing item in LibreOffice 3.4.3

Dear sirs,

I have noticed, that in LibreOffice 3.4.3 there is a missing item.
When you go to Tools, Macros, you will find, that in the sub-menu of Macros, 
there is no option for Recording Macro (making a macro).
This error you will find in Writer, Calc and Impress as well. And it might be 
missing in the other modules, but I have not checked this.

Please, inform me if this item will be corrected.


Yours sincerely,

P.L.M. van Tooren
-- 
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] Missing item in LibreOffice 3.4.3

[plmvantooren]

Dear sirs,

I have noticed, that in LibreOffice 3.4.3 there is a missing item.
When you go to Tools, Macros, you will find, that in the sub-menu of Macros, 
there is no option for Recording Macro (making a macro).
This error you will find in Writer, Calc and Impress as well. And it might be 
missing in the other modules, but I have not checked this.

Please, inform me if this item will be corrected.


Yours sincerely,

P.L.M. van Tooren
-- 
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