date:20111203

I don't think so because the fields are updated on open.

But the date the file was last saved is the same as the one you can see in
the file properties in Modified (at least in  the Windows OS)

Just right click on the file (don't open it) and choose Properties. In the
General tab you can see the dates for Created, Modified and Accessed.

--
View this message in context: 
http://nabble.documentfoundation.org/open-odt-without-updating-fields-tp3556731p3556882.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] open .odt without updating fields

2011-12-03 Thread Onyeibo Oku

Change it to normal text

-
from twohot@device.mobile :)

-Original Message-
From: bjloc...@lockie.ca
Date: Sat, 3 Dec 2011 03:11:41 
To: 
Reply-To: users@global.libreoffice.org
Subject: [libreoffice-users] open .odt without updating fields

I have a Writer file that has a date field.
Is it possible to open the file with the date field displaying the date it
was last saved?


-- 
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] How to define new Math symbols

2011-12-03 Thread Nir Kristal

Hello

Is there a way to define new symbols or commands to put more then one symbol?
like: "%dv" = "dx dy dz" or "%dradial" = "d%phi d%theta dr"

Or maybe even making some new commands from scratch?

Thanks a lot, Nir

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

2011-12-03 Thread Duncan Sanders

Hi
Using Windows 7
I have open office version 3.2 loaded
having converted all my previous word and excel programs
But I need to produce Christmas address labels from an original excel file
(converted to Calc)
I have followed the wizard but only produces a page for one address and none
of the others
Any help would be appreciated
 
Tks
Duncan
dun...@rowans.clara.co.uk
 

-- 
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] open .odt without updating fields

2011-12-03 Thread David S. Crampton


Insert the Field for Modified Date:

Insert |  Fields  |  Other  |  tab:DocInformation
in the Type list: Modified
in the Select list: Date
in the Format list: your heart's desire
checkbox Fixed Content: experiment. Probably for this purpose Unchecked.

In my experience this issue arises in collaborative projects where people  
are supposed to update their own portions and meet a schedule (but often  
do not).

--
David S. Crampton

On Sat, 03 Dec 2011 00:11:41 -0800,  wrote:


I have a Writer file that has a date field.
Is it possible to open the file with the date field displaying the date  
it

was last saved?



--
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] open .odt without updating fields

2011-12-03 Thread TomW


On 2011-12-03 03:11, bjloc...@lockie.ca wrote:

I have a Writer file that has a date field.
Is it possible to open the file with the date field displaying the date it
was last saved?




bjlockie:

The following will insert a date field that will auto-adjust to the date 
the file was last saved.


Insert
|Fields
|Other
|DocInformation
|Modified
|Date

To test it, I also added the time field.  Each time I saved it, it would 
adjust to the time it was saved.



TomW

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

2011-12-03 Thread Don C. Myers


Hi Duncan,

It sounds like you have setup your fields properly in Excel, and now 
calc. I personally use base, but it doesn't matter. I use the table 
style templates available from the worldlabel.com site for 
OpenOffice/LibreOffice. If you are using those, do not use the label 
wizard, but go to insert/fields/other. In that window choose the 
Database Tab, then select mail merge, and drag the fields you want to 
your label form. Once you are done with that, in the same column as the 
mail merge selection choose next record and click insert. Once you have 
one label done, then simply copy the information from the first cell to 
the other cells. When you print each label should have the correct 
information from your source database.


You will have two other issues if printing more than one page. First, a 
blank page will show up between each printer page. Second, one label 
between each sheet will disappear. Here is how to fix those issues:



Hi,

I don't know if this might help anyone or not. I had an OpenOffice 
form problem using the table template with a standard 30 label sheet 
(3 x 10). I have all of our Christmas card addresses in an OpenOffice 
database. I have the form setup, etc, to automatically pull the 
address information in when I click print and select the database, 
etc. It works great with one exception. Last year my wife said I 
missed having a few addresses included. I didn't think anything about 
it, and honestly, didn't think that was possible. This year before 
giving her the printed labels I thought I would check that everyone 
was there. I set the printing so it is sorting to print A_Z based on 
the last name. It takes three sheets. I have 78 names in the database, 
but only had 76 printed labels. What happened was when the printing 
went from the first sheet to the second sheet, it misses one record. 
The rest of the second page is fine. When I went from the second sheet 
to the third sheet, once again, it skipped the next label, then 
printed fine for the balance. When I say it skipped it, the missing 
record just disappears. It isn't that I end up with a blank label at 
the top of the sheet. The next one in line to be printed on the first 
label on Page 2 vanishes and the one that should be the second one on 
the second page becomes the first one on the second page. The same 
with the third page. A person would never pick this up unless checking 
the database against the printed labels.


The solution I had one full page of labels with the fields in. 
I read on-line that you need one complete page with fields in for each 
page of labels. So I added two more pages so I have a three page 
template. When I created Pages 2 and 3 and by pasting the complete 
page 1, then scrolled up, I found there was a blank page between each 
label page. I deleted those pages, and I now have a perfectly working 
label template printing all of the address!



Hopefully this will help you!!

Don


On 12/03/2011 08:57 AM, Duncan Sanders wrote:

Hi
Using Windows 7
I have open office version 3.2 loaded
having converted all my previous word and excel programs
But I need to produce Christmas address labels from an original excel file
(converted to Calc)
I have followed the wizard but only produces a page for one address and none
of the others
Any help would be appreciated

Tks
Duncan
dun...@rowans.clara.co.uk




--

*~~*
Don C. Myers
e-PRO Certified by the National Association of Realtors
Manager, Farm and Rural Property Division
*Coldwell Banker University Realty
*126 East Foster Avenue, State College, PA 16801
Office Phone: 814-237-6543 Fax: 814-237-6502
Home Phone: 814-422-8111 Cell Phone: 814-571-9518
Visit the Farm and Rural Property Division Web Site at 
_www.cbur-ruralproperty.com 

_View Don's Farm Web Site at www.myersfarm.com 
*~~*


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

[libreoffice-users] Stuck with 3.3 forever?

I installed Ubuntu 11.10 from scratch today on my Eee-PC and found
that the installed version of LibreOffice was 3.4.4 (my old install
had 3.3.4, which I installed from the deb files at the LibreOffice
download page).
One of the differences I noticed between 3.4.4 and 3.3.4 is that 3.4.4
can't calculate with empty cells, which I find horrible and very
surprising.

For instance, I have this formula in one cell (E10), copied to a
couple of thousands of cells in the same column:
=IF(OR(DAY(A11)>DAY(A10);C10="");"";IF(OR(B10="Lunch";B10="Läkarbesök");E9;C10+E9))

Depending on the value in other cells, the result can be a time or an
empty string (""). In this case, E9 is an empty string, so E10 becomes
”#VALUE!”, and in fact every cell below E10 is also ”#VALUE!” because
of this.

Seems like the developers decided that it shouldn't be possible to use
empty cells for calculation, and I just can't help myself wondering
why. This is a very common task in my case, and if an empty cell is
not defined as 0, it will mean that most of my formulas will be very
much longer and way more complicated than they need to be with 3.3.
That is, more complicated, harder to edit and very much slower. Is
this really the best way to go? Why is handling an empty cell as 0 in
calculations such a bad idea? Am I stuck with 3.3 like forever ow or
is this going to change any time soon?



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] Re: Stuck with 3.3 forever?


Johnny Rosenberg wrote
> 
> Depending on the value in other cells, the result can be a time or an
> empty string (""). In this case, E9 is an empty string, so E10 becomes
> ”#VALUE!”, and in fact every cell below E10 is also ”#VALUE!” because
> of this.
> 

Can you provide an example file? This used to be a problem but it is fixed
in 3.4.4 (at least under Windows)

--
View this message in context: 
http://nabble.documentfoundation.org/Stuck-with-3-3-forever-tp3557428p3557454.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] Stuck with 3.3 forever?

2011-12-03 Thread Tom Davies

Hi :)
Are the empty cells somehow defined as text-cells?  Do they contain a space or 
a ' mark or formatted to be text?
Regards from
Tom :)

--- On Sat, 3/12/11, Johnny Rosenberg  wrote:

From: Johnny Rosenberg 
Subject: [libreoffice-users] Stuck with 3.3 forever?
To: "LibreOffice Användare" 
Date: Saturday, 3 December, 2011, 17:10

I installed Ubuntu 11.10 from scratch today on my Eee-PC and found
that the installed version of LibreOffice was 3.4.4 (my old install
had 3.3.4, which I installed from the deb files at the LibreOffice
download page).
One of the differences I noticed between 3.4.4 and 3.3.4 is that 3.4.4
can't calculate with empty cells, which I find horrible and very
surprising.

For instance, I have this formula in one cell (E10), copied to a
couple of thousands of cells in the same column:
=IF(OR(DAY(A11)>DAY(A10);C10="");"";IF(OR(B10="Lunch";B10="Läkarbesök");E9;C10+E9))

Depending on the value in other cells, the result can be a time or an
empty string (""). In this case, E9 is an empty string, so E10 becomes
”#VALUE!”, and in fact every cell below E10 is also ”#VALUE!” because
of this.

Seems like the developers decided that it shouldn't be possible to use
empty cells for calculation, and I just can't help myself wondering
why. This is a very common task in my case, and if an empty cell is
not defined as 0, it will mean that most of my formulas will be very
much longer and way more complicated than they need to be with 3.3.
That is, more complicated, harder to edit and very much slower. Is
this really the best way to go? Why is handling an empty cell as 0 in
calculations such a bad idea? Am I stuck with 3.3 like forever ow or
is this going to change any time soon?

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

-- 
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: Stuck with 3.3 forever?

2011/12/3 Pedro :
>
> Johnny Rosenberg wrote
>>
>> Depending on the value in other cells, the result can be a time or an
>> empty string (""). In this case, E9 is an empty string, so E10 becomes
>> ”#VALUE!”, and in fact every cell below E10 is also ”#VALUE!” because
>> of this.
>>
>
> Can you provide an example file? This used to be a problem but it is fixed
> in 3.4.4 (at least under Windows)

I could, but it's not needed, I think. I just did this simple test in
3.3.4 and 3.4.4:

Open LibreOffice Calc from scratch.

A1:
=""

A2:
=A1+1

In LibreOffice 3.3.4 (Ubuntu 10.10), A2 displays:
1

In 3.4.4 (Ubuntu 11.10), OOO340m1 (Build:402), A2 displays:
#VALUE!



Kind regards

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

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

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

Re: [libreoffice-users] Stuck with 3.3 forever?

2011/12/3 Tom Davies :
> Hi :)
> Are the empty cells somehow defined as text-cells?  Do they contain a space 
> or a ' mark or formatted to be text?

Depends on the situation, but I found that entering ="" into a cell
causes different results from 3.3.4 vs 3.4.4.
So why do that? you might ask. Well, the formulas in a column looks
something like 
=IF(SomeCase;"";IF(AnotherCase;SomeResult;SomeResult+TheCellAbove)),
so here and there, there will be cells that are equal to ="", and in
some cases those cells will be used for calculation with the same
formula.


Kind regards

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


> Regards from
> Tom :)
>
> --- On Sat, 3/12/11, Johnny Rosenberg  wrote:
>
> From: Johnny Rosenberg 
> Subject: [libreoffice-users] Stuck with 3.3 forever?
> To: "LibreOffice Användare" 
> Date: Saturday, 3 December, 2011, 17:10
>
> I installed Ubuntu 11.10 from scratch today on my Eee-PC and found
> that the installed version of LibreOffice was 3.4.4 (my old install
> had 3.3.4, which I installed from the deb files at the LibreOffice
> download page).
> One of the differences I noticed between 3.4.4 and 3.3.4 is that 3.4.4
> can't calculate with empty cells, which I find horrible and very
> surprising.
>
> For instance, I have this formula in one cell (E10), copied to a
> couple of thousands of cells in the same column:
> =IF(OR(DAY(A11)>DAY(A10);C10="");"";IF(OR(B10="Lunch";B10="Läkarbesök");E9;C10+E9))
>
> Depending on the value in other cells, the result can be a time or an
> empty string (""). In this case, E9 is an empty string, so E10 becomes
> ”#VALUE!”, and in fact every cell below E10 is also ”#VALUE!” because
> of this.
>
> Seems like the developers decided that it shouldn't be possible to use
> empty cells for calculation, and I just can't help myself wondering
> why. This is a very common task in my case, and if an empty cell is
> not defined as 0, it will mean that most of my formulas will be very
> much longer and way more complicated than they need to be with 3.3.
> That is, more complicated, harder to edit and very much slower. Is
> this really the best way to go? Why is handling an empty cell as 0 in
> calculations such a bad idea? Am I stuck with 3.3 like forever ow or
> is this going to change any time soon?
>
>
>
> 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
>
> --
> 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: Stuck with 3.3 forever?


Johnny Rosenberg wrote
> 
> I could, but it's not needed, I think. I just did this simple test in
> 3.3.4 and 3.4.4:
> 
> Open LibreOffice Calc from scratch.
> 
> A1:
> =""
> 
> A2:
> =A1+1
> 
> In LibreOffice 3.3.4 (Ubuntu 10.10), A2 displays:
> 1
> 
> In 3.4.4 (Ubuntu 11.10), OOO340m1 (Build:402), A2 displays:
> #VALUE!
> 

That is expected. Cell A1 contains an empty text string (not a value). When
you try to do a calculation with a text string you get an error. MS Excel
also displays #VALUE

TBH I think it was version 3.3.4 that was wrong...

--
View this message in context: 
http://nabble.documentfoundation.org/Stuck-with-3-3-forever-tp3557428p3557511.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] Stuck with 3.3 forever?

2011-12-03 Thread MiguelAngel


El 03/12/11 18:57, Johnny Rosenberg escribió:

2011/12/3 Tom Davies:

Hi :)
Are the empty cells somehow defined as text-cells?  Do they contain a space or 
a ' mark or formatted to be text?

Depends on the situation, but I found that entering ="" into a cell
causes different results from 3.3.4 vs 3.4.4.
So why do that? you might ask. Well, the formulas in a column looks
something like 
=IF(SomeCase;"";IF(AnotherCase;SomeResult;SomeResult+TheCellAbove)),
so here and there, there will be cells that are equal to ="", and in
some cases those cells will be used for calculation with the same
formula.


Kind regards

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



Regards from
Tom :)

--- On Sat, 3/12/11, Johnny Rosenberg  wrote:

From: Johnny Rosenberg
Subject: [libreoffice-users] Stuck with 3.3 forever?
To: "LibreOffice Användare"
Date: Saturday, 3 December, 2011, 17:10

I installed Ubuntu 11.10 from scratch today on my Eee-PC and found
that the installed version of LibreOffice was 3.4.4 (my old install
had 3.3.4, which I installed from the deb files at the LibreOffice
download page).
One of the differences I noticed between 3.4.4 and 3.3.4 is that 3.4.4
can't calculate with empty cells, which I find horrible and very
surprising.

For instance, I have this formula in one cell (E10), copied to a
couple of thousands of cells in the same column:
=IF(OR(DAY(A11)>DAY(A10);C10="");"";IF(OR(B10="Lunch";B10="Läkarbesök");E9;C10+E9))

Depending on the value in other cells, the result can be a time or an
empty string (""). In this case, E9 is an empty string, so E10 becomes
”#VALUE!”, and in fact every cell below E10 is also ”#VALUE!” because
of this.

Seems like the developers decided that it shouldn't be possible to use
empty cells for calculation, and I just can't help myself wondering
why. This is a very common task in my case, and if an empty cell is
not defined as 0, it will mean that most of my formulas will be very
much longer and way more complicated than they need to be with 3.3.
That is, more complicated, harder to edit and very much slower. Is
this really the best way to go? Why is handling an empty cell as 0 in
calculations such a bad idea? Am I stuck with 3.3 like forever ow or
is this going to change any time soon?



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

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

In 3.4 only text which can be explicitly interpreted as number, is 
treated as number, and an space or an empty string is not a number.

You can use the N(e9) to avoid this.
=IF(OR(DAY(A11)>DAY(A10);n(C10));"";IF(OR(B10="Lunch";B10="Läkarbesök");E9;C10+N(E9)))

I think this avoid misleading with text as numbers.

Miguel Ángel.

 * Inglés - detectado
 * Afrikaans
 * Albanés
 * Árabe
 * Bielorruso
 * Búlgaro
 * Catalán
 * Chino
 * Chino (Simplificado)
 * Chino (Tradicional)
 * Croata
 * Checo
 * Danés
 * Neerlandés
 * Inglés
 * Estonio
 * Filipino
 * Finés
 * Francés
 * Gallego
 * Alemán
 * Griego
 * Griego
 * Haitiano
 * Hindi
 * Húngaro
 * Islandés
 * Indonesio
 * Irlandés
 * Italiano
 * Japonés
 * Coreano
 * Letón
 * Lituano
 * Macedonio
 * Malayo
 * Maltés
 * Noruego
 * Persa
 * Polaco
 * Portugués
 * Portugués de Portugal
 * Rumano
 * Ruso
 * Serbio
 * Eslovaco
 * Esloveno
 * Español
 * Swahili
 * Sueco
 * Tailandés
 * Turco
 * Ucraniano
 * Vietnamita
 * Galés
 * Yídish

 * Afrikaans
 * Albanés
 * Árabe
 * Bielorruso
 * Búlgaro
 * Catalán
 * Chino
 * Chino (Simplificado)
 * Chino (Tradicional)
 * Croata
 * Checo
 * Danés
 * Neerlandés
 * Inglés
 * Estonio
 * Filipino
 * Finés
 * Francés
 * Gallego
 * Alemán
 * Griego
 * Griego
 * Haitiano
 * Hindi
 * Húngaro
 * Islandés
 * Indonesio
 * Irlandés
 * Italiano
 * Japonés
 * Coreano
 * Letón
 * Lituano
 * Macedonio
 * Malayo
 * Maltés
 * Noruego
 * Persa
 * Polaco
 * Portugués
 * Portugués de Portugal
 * Rumano
 * Ruso
 * Serbio
 * Eslovaco
 * Esloveno
 * Español
 * Swahili
 * Sueco
 * Tailandés
 * Turco
 * Ucraniano
 * Vietnamita
 * Galés
 * Yídish



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

[libreoffice-users] Re: Stuck with 3.3 forever?

2011-12-03 Thread David S. Crampton

I agree with Pedro. A null text is not to be treated as a numeric zero. An
empty cell may be calculated as a zero but a null text is not an empty cell. 
If have found the #VALUE result of mixing null text within a calculation to
be a good debugging and alert technique that the values elsewhere in my
spreadsheet have become messed up.

-
--
David S. Crampton
--
View this message in context: 
http://nabble.documentfoundation.org/Stuck-with-3-3-forever-tp3557428p3557547.html
Sent from the Users mailing list archive at Nabble.com.

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

Re: [libreoffice-users] Re: Stuck with 3.3 forever?

2011/12/3 David S. Crampton :
> I agree with Pedro. A null text is not to be treated as a numeric zero. An
> empty cell may be calculated as a zero but a null text is not an empty cell.
> If have found the #VALUE result of mixing null text within a calculation to
> be a good debugging and alert technique that the values elsewhere in my
> spreadsheet have become messed up.

I could agree with that, but it would have been nice if they thought
of that since 1.0 and not changing it on the way, breaking a whole lot
of spreadsheets…


Let's assume we have this example:
A2:
=IF(A1=6;"";B1)

Now, in some cases, A2 will be an empty string, so =A2+1 will fail in
another cell, right? Is there another way to make A2 look empty in
this case, making it useable for calculations? Something like the
following:
=IF(A1=6;SomethingNiceToPutHere;B1)



Kind regards

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


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

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

Re: [libreoffice-users] Stuck with 3.3 forever?

2011/12/3 MiguelAngel :
> In 3.4 only text which can be explicitly interpreted as number, is treated
> as number, and an space or an empty string is not a number.

But what's wrong with having any kind of no-number-strings treated like 0?

> You can use the N(e9) to avoid this.
> =IF(OR(DAY(A11)>DAY(A10);n(C10));"";IF(OR(B10="Lunch";B10="Läkarbesök");E9;C10+N(E9)))
>
> I think this avoid misleading with text as numbers.

Okay, that could be an acceptable solution, I'll try it as soon as
possible. Thanks!

>
> Miguel Ángel.
>
>  * Inglés - detectado
>  * Afrikaans
>  * Albanés
>  * Árabe
>  * Bielorruso
>  * Búlgaro
>  * Catalán
>  * Chino
>  * Chino (Simplificado)
>  * Chino (Tradicional)
>  * Croata
>  * Checo
>  * Danés
>  * Neerlandés
>  * Inglés
>  * Estonio
>  * Filipino
>  * Finés
>  * Francés
>  * Gallego
>  * Alemán
>  * Griego
>  * Griego
>  * Haitiano
>  * Hindi
>  * Húngaro
>  * Islandés
>  * Indonesio
>  * Irlandés
>  * Italiano
>  * Japonés
>  * Coreano
>  * Letón
>  * Lituano
>  * Macedonio
>  * Malayo
>  * Maltés
>  * Noruego
>  * Persa
>  * Polaco
>  * Portugués
>  * Portugués de Portugal
>  * Rumano
>  * Ruso
>  * Serbio
>  * Eslovaco
>  * Esloveno
>  * Español
>  * Swahili
>  * Sueco
>  * Tailandés
>  * Turco
>  * Ucraniano
>  * Vietnamita
>  * Galés
>  * Yídish
>
>  * Afrikaans
>  * Albanés
>  * Árabe
>  * Bielorruso
>  * Búlgaro
>  * Catalán
>  * Chino
>  * Chino (Simplificado)
>  * Chino (Tradicional)
>  * Croata
>  * Checo
>  * Danés
>  * Neerlandés
>  * Inglés
>  * Estonio
>  * Filipino
>  * Finés
>  * Francés
>  * Gallego
>  * Alemán
>  * Griego
>  * Griego
>  * Haitiano
>  * Hindi
>  * Húngaro
>  * Islandés
>  * Indonesio
>  * Irlandés
>  * Italiano
>  * Japonés
>  * Coreano
>  * Letón
>  * Lituano
>  * Macedonio
>  * Malayo
>  * Maltés
>  * Noruego
>  * Persa
>  * Polaco
>  * Portugués
>  * Portugués de Portugal
>  * Rumano
>  * Ruso
>  * Serbio
>  * Eslovaco
>  * Esloveno
>  * Español
>  * Swahili
>  * Sueco
>  * Tailandés
>  * Turco
>  * Ucraniano
>  * Vietnamita
>  * Galés
>  * Yídish
>
> 
>
>
> --
> 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] Stuck with 3.3 forever?

2011-12-03 Thread Steve Edmonds




On 2011-12-04 07:12, MiguelAngel wrote:

El 03/12/11 18:57, Johnny Rosenberg escribió:

2011/12/3 Tom Davies:

Hi :)
Are the empty cells somehow defined as text-cells?  Do they contain 
a space or a ' mark or formatted to be text?

Depends on the situation, but I found that entering ="" into a cell
causes different results from 3.3.4 vs 3.4.4.
So why do that? you might ask. Well, the formulas in a column looks
something like 
=IF(SomeCase;"";IF(AnotherCase;SomeResult;SomeResult+TheCellAbove)),

so here and there, there will be cells that are equal to ="", and in
some cases those cells will be used for calculation with the same
formula.


Kind regards

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



Regards from
Tom :)

--- On Sat, 3/12/11, Johnny Rosenberg  wrote:

From: Johnny Rosenberg
Subject: [libreoffice-users] Stuck with 3.3 forever?
To: "LibreOffice Användare"
Date: Saturday, 3 December, 2011, 17:10

I installed Ubuntu 11.10 from scratch today on my Eee-PC and found
that the installed version of LibreOffice was 3.4.4 (my old install
had 3.3.4, which I installed from the deb files at the LibreOffice
download page).
One of the differences I noticed between 3.4.4 and 3.3.4 is that 3.4.4
can't calculate with empty cells, which I find horrible and very
surprising.

For instance, I have this formula in one cell (E10), copied to a
couple of thousands of cells in the same column:
=IF(OR(DAY(A11)>DAY(A10);C10="");"";IF(OR(B10="Lunch";B10="Läkarbesök");E9;C10+E9)) 



Depending on the value in other cells, the result can be a time or an
empty string (""). In this case, E9 is an empty string, so E10 becomes
”#VALUE!”, and in fact every cell below E10 is also ”#VALUE!” because
of this.

Seems like the developers decided that it shouldn't be possible to use
empty cells for calculation, and I just can't help myself wondering
why. This is a very common task in my case, and if an empty cell is
not defined as 0, it will mean that most of my formulas will be very
much longer and way more complicated than they need to be with 3.3.
That is, more complicated, harder to edit and very much slower. Is
this really the best way to go? Why is handling an empty cell as 0 in
calculations such a bad idea? Am I stuck with 3.3 like forever ow or
is this going to change any time soon?



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


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


In 3.4 only text which can be explicitly interpreted as number, is 
treated as number, and an space or an empty string is not a number.

You can use the N(e9) to avoid this.
=IF(OR(DAY(A11)>DAY(A10);n(C10));"";IF(OR(B10="Lunch";B10="Läkarbesök");E9;C10+N(E9))) 



I think this avoid misleading with text as numbers.

Thanks Miguel. I posted a similar problem to the list some months ago, 
received the explanation of the reasoning, but yours is an elegant solution.

Steve

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

[libreoffice-users] Cell formatting with CSV files in Calc

Hi, I'm having an issue with cell formatting in CSV files. Consider the
following simple CSV file (should be self explanatory):

Date;Item;Amount
01.12.2011;New laptop;-1.000,00
02.12.2011;Glass of beer;-3,00

(I'm using a German locale, so the comma is the decimal spearator.) If you
import that into Calc and format the date column with a rule like "TT.
 " and the amount column as a currency with a rule like "#.##0,00
[$EUR];[ROT]-#.##0,00 [$EUR]", then everything works fine (negative amounts
are red etc.) Save the CSV file and you end up with

"Date";"Item";"Amount"
Donnerstag, 01. Dezember 2011;"New laptop";-1.000,00 EUR
Freitag, 02. Dezember 2011;"Glass of beer";-3,00 EUR

in the file. Now open that file again with Calc and try to format the amount
column with the same rule: fail. New entries are formatted correctly, but
not existing entries. It works for the date column if you select date as the
column type in the import dialog, but you cannot choose currency as column
type.

I'm tempted to think that this is either a missing feature (no column type
"currency" in the import dialog) or incorrect saving/exporting behavior by
Calc (the cell format should only affect how the values are displayed, not
how they are stored in the file). So, what should I do:

* File a bug/feature request? If yes, where can I do that?
* Work around the issue? What would that workaround be??
* Or am I using Calc the wrong way?

Any suggestions appreciated...

Thanks, Bernhard

--
View this message in context: 
http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3557689.html
Sent from the Users mailing list archive at Nabble.com.

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

Re: [libreoffice-users] Re: Stuck with 3.3 forever?


On 12/03/2011 12:50 PM, Johnny Rosenberg wrote:

2011/12/3 Pedro:

Johnny Rosenberg wrote

Depending on the value in other cells, the result can be a time or an
empty string (""). In this case, E9 is an empty string, so E10 becomes
”#VALUE!”, and in fact every cell below E10 is also ”#VALUE!” because
of this.


Can you provide an example file? This used to be a problem but it is fixed
in 3.4.4 (at least under Windows)

I could, but it's not needed, I think. I just did this simple test in
3.3.4 and 3.4.4:

Open LibreOffice Calc from scratch.

A1:
=""

A2:
=A1+1

In LibreOffice 3.3.4 (Ubuntu 10.10), A2 displays:
1

In 3.4.4 (Ubuntu 11.10), OOO340m1 (Build:402), A2 displays:
#VALUE!
Try in A1 no data/empty cell and in A2 =A1+1, you will get 1 in A2. You 
are adding a text and number and the + operator is not used for 
concatenation.


This has to do with operator overloading, are other, similar, operations 
allowed when using '+'. Some may allow it and others may not, 
restricting its use to mathematical operations only. LO uses the '&' 
operator for concatenation.


If you use A1 = "" and A2 = A1 & 1 you get 1.



Kind regards

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


--
View this message in context: 
http://nabble.documentfoundation.org/Stuck-with-3-3-forever-tp3557428p3557454.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



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

2011-12-03 Thread Libre User

I just completed a project where I produced the 422 labels needed for 
a mineral museum display which started with an Excel spreadsheet of 
the collection.  I am using LibreOffice 3.4.3 on a Win7 64 bit system.


Here are the steps that I followed.

Creat a database (LibreBase) using the Excel spreadsheet as the 
source.  Open a new database. On the opening "Welcome to the Database 
Wizard" screen select "Connect to an existing database" and select 
"Spreadsheet" from the drop down menu.


Then use the browse function to select the Excel spreadsheet 
file.  The database will be created using the spreadsheet as data 
input.  The column headings should become the database fields


Then click on the "Insert Labels" button on the top toolbar.  This 
will bring up the Label Wizard which will run thru the steps to 
format the labels which are now in a new LO Writer file.  The 
formating is done only in the first label.  When you have it the way 
you want, click on the "Synchronize Labels" button which will then 
copy the formatting from the first label to all the others.


Once the labels are formatted, you use the Mail Merge Wizard which is 
in the Tools drop down menu in LO Writer.


For some reason, LO inserts a blank page between every label page 
when printing. [Does anyone know why?]  They will show up in the 
Print Preview.  These can be eliminated by going into the set up for 
LO (Menu>Tools>Options>LO Writer>Print then uncheck the box "Print 
Automatically Inserted Blank Pages"


Also when you print, (Use ctrl P)  open the LO Writer tab and make 
sure that the same box is unchecked there too.


I may have forgotten some of the steps but this should help. If not 
let me know and will go back and run thru the steps again to see what I missed.


Hope this helps you.

Jerry



At 06:57 AM 12/3/2011, you wrote:

Hi
Using Windows 7
I have open office version 3.2 loaded
having converted all my previous word and excel programs
But I need to produce Christmas address labels from an original excel file
(converted to Calc)
I have followed the wizard but only produces a page for one address and none
of the others
Any help would be appreciated

Tks
Duncan
dun...@rowans.clara.co.uk


--
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: Stuck with 3.3 forever?


Johnny Rosenberg wrote
> 
> I could agree with that, but it would have been nice if they thought
> of that since 1.0 and not changing it on the way, breaking a whole lot
> of spreadsheets…
> 

I see your point. But this was wrong. 
It's not a change of plans it's simply a correction. And not fixing it would
break a lot of other spreadsheets ;)


Johnny Rosenberg wrote
> 
> Is there another way to make A2 look empty in
> this case, making it useable for calculations? Something like the
> following:
> =IF(A1=6;SomethingNiceToPutHere;B1)
> 

There are at least two ways: add an extra IF to the following formula and
use ISTEXT to validate or replace SomethingNiceToPutHere by 0 (zero) and use
conditional formatting to hide the zeros (set the font to White or the cell
background color when the value is zero)

If you liked the way it worked before you can use =N() as suggested by
Miguel Angel.

--
View this message in context: 
http://nabble.documentfoundation.org/Stuck-with-3-3-forever-tp3557428p3557738.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: automatic formatting, turn off

2011-12-03 Thread 20rdj04

You indicated 'Tools|Auto Correct Options...'  It was a start, but Auto
Correct is not under Tools in my copy of  LO.  I found it under Format. 
Thank you.
NoOp wrote
> 
> On 12/01/2011 01:18 PM, 20rdj04 wrote:
> ...
>> 
>> As usual, I have not ASKED any questions.  Perhaps I should erase these 3
>> paragraphs and simply ask, "How do I convert my LibreOffice to a
>> typewriter?
> ...
> 
> 'Tools|AutoCorrect Options|Options' should get you where you want to go.
> 
> 
> 
> -- 
> For unsubscribe instructions e-mail to: users+help@.libreoffice
> 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
> 


--
View this message in context: 
http://nabble.documentfoundation.org/automatic-formatting-turn-off-tp3552912p3557812.html
Sent from the Users mailing list archive at Nabble.com.

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

Re: [libreoffice-users] Re: Stuck with 3.3 forever?

2011-12-03 Thread David S. Crampton


Expanding a bit on Jonny's concatenation:

A1: "" (null string)
A2: 1 (numeric)
A3: =A1+A2 displays #VALUE
A4: =A1 & A2 displays left-aligned "1". It is a text result.
A5: =A2 + A4 displays a right-aligned 2. It is a numeric result.

Ergo, the "+" operator gave #VALUE result when combining a null string and  
a numeric but gives a numeric when combining a interpreted as a numeric> with a numeric.


Per my mini-sermon (earlier today) on debugging and preferring strict  
type-based behavior, I would prefer A5 to also display #VALUE.

--
David S. Crampton

On Sat, 03 Dec 2011 12:08:20 -0800, Jay Lozier  wrote:


On 12/03/2011 12:50 PM, Johnny Rosenberg wrote:

2011/12/3 Pedro:

Johnny Rosenberg wrote

Depending on the value in other cells, the result can be a time or an
empty string (""). In this case, E9 is an empty string, so E10 becomes
”#VALUE!”, and in fact every cell below E10 is also ”#VALUE!” because
of this.

Can you provide an example file? This used to be a problem but it is  
fixed

in 3.4.4 (at least under Windows)

I could, but it's not needed, I think. I just did this simple test in
3.3.4 and 3.4.4:

Open LibreOffice Calc from scratch.

A1:
=""

A2:
=A1+1

In LibreOffice 3.3.4 (Ubuntu 10.10), A2 displays:
1

In 3.4.4 (Ubuntu 11.10), OOO340m1 (Build:402), A2 displays:
#VALUE!
Try in A1 no data/empty cell and in A2 =A1+1, you will get 1 in A2. You  
are adding a text and number and the + operator is not used for  
concatenation.


This has to do with operator overloading, are other, similar, operations  
allowed when using '+'. Some may allow it and others may not,  
restricting its use to mathematical operations only. LO uses the '&'  
operator for concatenation.


If you use A1 = "" and A2 = A1 & 1 you get 1.



Kind regards

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


--
View this message in context:  
http://nabble.documentfoundation.org/Stuck-with-3-3-forever-tp3557428p3557454.html

Sent from the Users mailing list archive at Nabble.com.

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

List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be  
deleted




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

[libreoffice-users] Re: Stuck with 3.3 forever?


David S. Crampton wrote
> 
> Per my mini-sermon (earlier today) on debugging and preferring strict  
> type-based behavior, I would prefer A5 to also display #VALUE.
> 

Obviously! If it behaves differently it's simply inconsistent.

It the user wants to change that he just has to do =A2+VALUE(A4)

If there is a voting somewhere you can count +1 on the strict (coherent,
consistent) behavior.

--
View this message in context: 
http://nabble.documentfoundation.org/Stuck-with-3-3-forever-tp3557428p3558054.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] Cell formatting with CSV files in Calc


On 12/03/2011 03:05 PM, berntie wrote:

Hi, I'm having an issue with cell formatting in CSV files. Consider the
following simple CSV file (should be self explanatory):

Date;Item;Amount
01.12.2011;New laptop;-1.000,00
02.12.2011;Glass of beer;-3,00

(I'm using a German locale, so the comma is the decimal spearator.) If you
import that into Calc and format the date column with a rule like "TT.
 " and the amount column as a currency with a rule like "#.##0,00
[$EUR];[ROT]-#.##0,00 [$EUR]", then everything works fine (negative amounts
are red etc.) Save the CSV file and you end up with

"Date";"Item";"Amount"
Donnerstag, 01. Dezember 2011;"New laptop";-1.000,00 EUR
Freitag, 02. Dezember 2011;"Glass of beer";-3,00 EUR

in the file. Now open that file again with Calc and try to format the amount
column with the same rule: fail. New entries are formatted correctly, but
not existing entries. It works for the date column if you select date as the
column type in the import dialog, but you cannot choose currency as column
type.

Correct


I'm tempted to think that this is either a missing feature (no column type
"currency" in the import dialog) or incorrect saving/exporting behavior by
Calc (the cell format should only affect how the values are displayed, not
how they are stored in the file). So, what should I do:

* File a bug/feature request? If yes, where can I do that?

File a feature request for a currency data type

* Work around the issue? What would that workaround be??
Work around appears to be import as standard, then format the column as 
desired. Also, once the data is imported save the Calc spreadsheet as 
*.ods to preserve formating.


I have seen with dates when I manual format an imported column Calc adds 
a ' to the original data treating the entry as text not a date. This 
occurs when I leave the import data type as standard not as date.

* Or am I using Calc the wrong way?

Any suggestions appreciated...

Thanks, Bernhard

--
View this message in context: 
http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3557689.html
Sent from the Users mailing list archive at Nabble.com.




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


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

Re: [libreoffice-users] Re: Stuck with 3.3 forever?

2011-12-03 Thread MiguelAngel

El 03/12/11 22:54, Pedro escribi:David S. Crampton wrotePer my mini-sermon 
(earlier today) on debugging and preferring strict  
type-based behavior, I would prefer A5 to also display #VALUE.Obviously! If it 
behaves differently it's simply inconsistent.


It the user wants to change that he just has to do =A2+VALUE(A4)


If there is a voting somewhere you can count +1 on the strict (coherent,
consistent) behavior.Also mine.But interpret text as number is only with direct 
reference, not
  for example in the middle of a SUM().Miguelngel..
-- 
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: Cell formatting with CSV files in Calc


berntie wrote
> 
> "Date";"Item";"Amount"
> Donnerstag, 01. Dezember 2011;"New laptop";-1.000,00 EUR
> Freitag, 02. Dezember 2011;"Glass of beer";-3,00 EUR
> 

There is a basic problem in your procedure: you can not export formats in
the CSV file.  So when you export the dates in the first column and you see
them in your csv file as long date, it means that Calc actually converted it
to the the text you are seeing. When you import it again, the cells contain
text.

As for currency, I'm not aware of a Currency data type. It is either Number
(Standard), Text or Date.

Can you explain why you want to export as CSV including formats? Maybe we
can throw same alternative solutions...

--
View this message in context: 
http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3558131.html
Sent from the Users mailing list archive at Nabble.com.

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

Re: [libreoffice-users] Re: Stuck with 3.3 forever?

2011-12-03 Thread MiguelAngel


El 03/12/11 22:54, Pedro escribió:

David S. Crampton wrote

Per my mini-sermon (earlier today) on debugging and preferring strict
type-based behavior, I would prefer A5 to also display #VALUE.


Obviously! If it behaves differently it's simply inconsistent.

It the user wants to change that he just has to do =A2+VALUE(A4)

If there is a voting somewhere you can count +1 on the strict (coherent,
consistent) behavior.


Also mine.
But interpret text as number is only with direct reference, not for 
example in the middle of a SUM().

Miguel Ángel.
.

--
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: Stuck with 3.3 forever?


On 12/03/2011 04:39 PM, David S. Crampton wrote:

Expanding a bit on Jonny's concatenation:

A1: "" (null string)
A2: 1 (numeric)
A3: =A1+A2 displays #VALUE
A4: =A1 & A2 displays left-aligned "1". It is a text result.
A5: =A2 + A4 displays a right-aligned 2. It is a numeric result.

Ergo, the "+" operator gave #VALUE result when combining a null string 
and a numeric but gives a numeric when combining a can be interpreted as a numeric> with a numeric.


Per my mini-sermon (earlier today) on debugging and preferring strict 
type-based behavior, I would prefer A5 to also display #VALUE.
The default behavior appears to be an implicit type conversion of string 
to a numeric data type when it is possible. Either to an integer or 
decimal as needed. I tried your test using 1.356 (US format) in A2 and got


A# = #VALUE
A4 = 1.356 as string (left justified)
A5 = 2.356 as decimal (right justified)

If the there is any character that can not implicitly convert to a 
number, an error is thrown. This  probably dates back to the original 
spreadsheets (Visicalc and Lotus 123). For consistency one must follow 
some of the original, even if stupid, decisions so the average user is 
not confused and spreadsheets can be easily imported into other 
spreadsheet programs.


--
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: Cell formatting with CSV files in Calc


Pedro wrote
> 
> Can you explain why you want to export as CSV including formats? Maybe we
> can throw same alternative solutions...
> 
First of, I've unintentionally replied to your address only. Sorry for that.

I just want to export as CSV, I don't want to export the formats. Basically:

I want to edit a CSV. And by "editing" I mean "adding and/or modifying
lines".  Just for convenience, It would be nice to have the amount column
formatted as a currency.

I do not require the formatted values to be written to the CSV file upon
saving, but _if_ they are written to the file then I'd need a possibility to
format those values as a currency when I open the file the next time. That's
what I cannot accomplish as for now.

--
View this message in context: 
http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3558170.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: Cell formatting with CSV files in Calc


Jay Lozier wrote
> 
>> * File a bug/feature request? If yes, where can I do that?
> File a feature request for a currency data type
Where can I do that?


Jay Lozier wrote
> 
>> * Work around the issue? What would that workaround be??
> Work around appears to be import as standard, then format the column as 
> desired. Also, once the data is imported save the Calc spreadsheet as 
> *.ods to preserve formating.
Thanks for the suggestion but saving as *.ods is not an option for me as  I
need the resulting file to be a text file.

--
View this message in context: 
http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3558180.html
Sent from the Users mailing list archive at Nabble.com.

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

Re: [libreoffice-users] Re: Problem with Linux open nouveau video driver

2011-12-03 Thread Andrew Douglas Pitonyak


[root@pitonyak ~]# lsmod | grep -i nvidia
nvidia  12112133  40
i2c_core   25728  3 nvidia,videodev,i2c_i801


Without grep:

Module  Size  Used by
lp  9581  0
tun14111  0
ppdev   7360  0
parport_pc 19600  0
parport32310  3 lp,ppdev,parport_pc
fuse   61671  5
bnep   14195  2
bluetooth 202902  7 bnep
lockd  70080  0
rfkill 16336  3 bluetooth
ip6t_REJECT 4008  2
nf_conntrack_ipv6   7714  2
nf_defrag_ipv6  9115  1 nf_conntrack_ipv6
nf_conntrack_ipv4   8310  2
nf_defrag_ipv4  1513  1 nf_conntrack_ipv4
xt_state1306  4
nf_conntrack   67597  3 nf_conntrack_ipv6,nf_conntrack_ipv4,xt_state
ip6table_filter 1655  1
ip6_tables 16776  1 ip6table_filter
binfmt_misc 6983  1
reiserfs  211389  2
nvidia  12112133  40
uvcvideo   56989  0
videodev   78689  1 uvcvideo
joydev  9567  0
snd_usb_audio 105405  1
snd_usbmidi_lib18071  1 snd_usb_audio
snd_rawmidi19878  1 snd_usbmidi_lib
snd_hda_codec_realtek   312967  1
media  11511  2 uvcvideo,videodev
v4l2_compat_ioctl32 7665  1 videodev
snd_hda_intel  24072  2
snd_hda_codec  85462  2 snd_hda_codec_realtek,snd_hda_intel
snd_hwdep   6264  2 snd_usb_audio,snd_hda_codec
snd_seq52186  0
snd_seq_device  5941  2 snd_rawmidi,snd_seq
i7core_edac16001  0
snd_pcm78498  3 snd_usb_audio,snd_hda_intel,snd_hda_codec
snd_timer  19372  2 snd_seq,snd_pcm
i2c_i8019237  0
edac_core  40154  3 i7core_edac
snd63124  17 
snd_usb_audio,snd_usbmidi_lib,snd_rawmidi,snd_hda_codec_realtek,snd_hda_intel,snd_hda_codec,snd_hwdep,snd_seq,snd_seq_device,snd_pcm,snd_timer

iTCO_wdt   12024  0
iTCO_vendor_support 2578  1 iTCO_wdt
soundcore   6267  1 snd
snd_page_alloc  7311  2 snd_hda_intel,snd_pcm
r8169  40493  0
asus_atk0110   12395  0
i2c_core   25728  3 nvidia,videodev,i2c_i801
microcode  18539  0
mii 4335  1 r8169
serio_raw   4298  0
uinput  7230  0
sunrpc201219  2 lockd
ata_generic 3587  0
pata_acpi   3419  0
mxm_wmi 1727  0
firewire_ohci  26101  0
pata_jmicron2643  0
firewire_core  49303  1 firewire_ohci
crc_itu_t   1547  1 firewire_core
wmi 9049  1 mxm_wmi
uas 7775  0
usb_storage45966  0



On 12/03/2011 02:10 AM, Onyeibo Oku wrote:

What's your output for:

lsmod nvidia


-
from twohot@device.mobile :)

-Original Message-
From: Andrew Douglas Pitonyak
Date: Fri, 02 Dec 2011 21:57:16
To:
Reply-To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Re: Problem with Linux open nouveau video
driver

I was not aware of Leigh's advice until I saw your response here. So
I found and followed his advice, and, I still see issues.

Note that I do still see the driver, however

  >rpm -qa | grep -i nouveau
xorg-x11-drv-nouveau-0.0.16-27.20110720gitb806e3f.fc16.x86_64

Then again, I also see all sorts of kmod stuff

  >rpm -qa | grep -i nvidia

xorg-x11-drv-nvidia-libs-290.10-1.fc16.x86_64
kmod-nvidia-3.1.2-1.fc16.x86_64-290.10-1.fc16.1.x86_64
nvidia-settings-1.0-13.fc16.x86_64
akmod-nvidia-290.10-1.fc16.1.x86_64
xorg-x11-drv-nvidia-290.10-1.fc16.x86_64
nvidia-xconfig-1.0-11.fc16.x86_64
kmod-nvidia-3.1.1-1.fc16.x86_64-290.06-1.fc16.2.x86_64
kmod-nvidia-3.1.1-2.fc16.x86_64-290.06-1.fc16.3.x86_64





On 12/02/2011 03:18 AM, Onyeibo Oku wrote:

If you're running "kmod" nvidia drivers then you are not running nouveau. 
Nouveau runs out-of-the-box (fresh installation) and has proven to be more headache-free. 
I have not noticed this issue. Could this be peculiar to a file? Can you describe steps 
to replicate it without transferring a sample file?

I am presently running nouveau with LO without issues on F16 but I probably haven't gone your 
route. My experience with "kmod-nvidia" and the sister "akmod-nvidia" is that 
they conflict with nouveau especially if nouveau is not silenced. Did U follow leigh's instructions 
at forums.fedoraforum.org?

-
from twohot@device.mobile :)

-Original Message-
From: Jay Lozier
Date: Fri, 02 Dec 2011 01:11:58
To:
Reply-To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Re: Problem with Linux open nouveau video
driver

On 12/01/2011 10:16 PM, Andrew Douglas Pitonyak wrote:

On 12/01/2011 10:05 PM, NoOp wrote:

On 11/30/2011 05:04 PM, J

[libreoffice-users] Re: Cell formatting with CSV files in Calc


berntie wrote
> 
> First of, I've unintentionally replied to your address only. Sorry for
> that.

No problem ;)


berntie wrote
> 
> I just want to export as CSV, I don't want to export the formats.
> Basically:
> 
> I want to edit a CSV. And by "editing" I mean "adding and/or modifying
> lines".  Just for convenience, It would be nice to have the amount column
> formatted as a currency.
> 
> I do not require the formatted values to be written to the CSV file upon
> saving, but _if_ they are written to the file then I'd need a possibility
> to format those values as a currency when I open the file the next time.
> That's what I cannot accomplish as for now.
> 

Ok. That is what I thought you were trying to do. What you need to do is

1) You CAN'T use the Save button
2) You must always Save As (although you can overwrite your csv file)
3) In the Save As dialog, always check the bottom box "Edit filter settings"
4) On the next dialog choose "Keep current format" (meaning save as CSV)
5) On the Export Text File dialog, make sure you UNCHECK the "Save cell
content as shown" option (this tells Calc not to save long date as the text
you see on screen but save the value) and CHECK the "Quote all text cells" 
option (just to make sure all text is properly saved

That's it. Since you want to save as CSV you will have to repeat this
procedure at save time and the format procedure at opening... 
Or you could have two copies, one in ODS properly formatted and a copy in
CSV which you exported following the 5 previous steps after adding new data.

Hope this helps ;)

--
View this message in context: 
http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3558201.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: Cell formatting with CSV files in Calc


Pedro wrote
> 
> What you need to do is
> 
> 1) You CAN'T use the Save button
> 2) You must always Save As (although you can overwrite your csv file)
> 3) In the Save As dialog, always check the bottom box "Edit filter
> settings"
> 4) On the next dialog choose "Keep current format" (meaning save as CSV)
> 5) On the Export Text File dialog, make sure you UNCHECK the "Save cell
> content as shown" option (this tells Calc not to save long date as the
> text you see on screen but save the value) and CHECK the "Quote all text
> cells"  option (just to make sure all text is properly saved

Works like a charm. 


Pedro wrote
> 
> That's it. Since you want to save as CSV you will have to repeat this
> procedure at save time and the format procedure at opening...  I can live
> very well with that.


Pedro wrote
> 
> Hope this helps ;) It certainly does. Thank you very much. 

Oh, and by the way, can you confirm that data validation does not work with
CSV files?


--
View this message in context: 
http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3558288.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: Cell formatting with CSV files in Calc


berntie wrote
> 
> Oh, and by the way, can you confirm that data validation does not work
> with CSV files?
> 

I'm glad I could help ;)

What do you mean? Data validation is performed by Calc, it is not affected
by the file format.

Can you explain what you did, what happened and what you expect to happen?

--
View this message in context: 
http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3558296.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: Cell formatting with CSV files in Calc


Pedro wrote
> 
> 
> berntie wrote
>> 
>> Oh, and by the way, can you confirm that data validation does not work
>> with CSV files?
>> 
> 
> I'm glad I could help ;)
> 
> What do you mean? Data validation is performed by Calc, it is not affected
> by the file format.
> 
> Can you explain what you did, what happened and what you expect to happen?
> 

When I open my CSV file, select the date column and go to "Data -> Validity"
and tell Calc to disallow dates before, say, 01.01.2010, then I can
nonetheless enter, e.g., 01.01.2009.

--
View this message in context: 
http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3558322.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: Cell formatting with CSV files in Calc


berntie wrote
> 
> When I open my CSV file, select the date column and go to "Data ->
> Validity" and tell Calc to disallow dates before, say, 01.01.2010, then I
> can nonetheless enter, e.g., 01.01.2009.
> 

Did you check the "Show error message" option in the Error Alert tab? 
When you type anything but a date after 01.01.2010 it should display a
message box saying "Invalid value" and the value or text that you typed is
simply deleted (which is not very nice :) )

--
View this message in context: 
http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3558329.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: Cell formatting with CSV files in Calc


Pedro wrote
> 
> 
> berntie wrote
>> 
>> When I open my CSV file, select the date column and go to "Data ->
>> Validity" and tell Calc to disallow dates before, say, 01.01.2010, then I
>> can nonetheless enter, e.g., 01.01.2009.
>> 
> 
> Did you check the "Show error message" option in the Error Alert tab? 
>  Yes, I did check the box.


Pedro wrote
> 
> When you type anything but a date after 01.01.2010 it should display a
> message box saying "Invalid value" and the value or text that you typed is
> simply deleted (which is not very nice :) ) Maybe it's not nice, but it's
> what I want. 

But you know what's weird? Now that I did try it again, it worked. Though, I
have absolutely no clue what I did wrong before... Anyway, the problem seems
to be on my side of things, so for me, this issue is closed.

Thanks again for your help.


--
View this message in context: 
http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3558338.html
Sent from the Users mailing list archive at Nabble.com.

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

Re: [libreoffice-users] Re: Problem with Linux open nouveau video driver

2011-12-03 Thread Onyeibo Oku

You see? If you are still having trouble, Your problem is not nouveau. From 
your lsmod output your video graphics is entirely handled by kmod-nvidia 
(although the nouveau package is installed, it is disabled). I personally grew 
weary of nvidia propriety driver months ago and settled for nouveau.  

It'll be interesting if I can replicate your scenario otherwise I've had no 
issues using LibreOffice on my nouveau driver.
-
from twohot@device.mobile :)

-Original Message-
From: Andrew Douglas Pitonyak 
Date: Sat, 03 Dec 2011 17:55:12 
To: 
Reply-To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Re: Problem with Linux open nouveau video
driver

[root@pitonyak ~]# lsmod | grep -i nvidia
nvidia  12112133  40
i2c_core   25728  3 nvidia,videodev,i2c_i801


Without grep:

Module  Size  Used by
lp  9581  0
tun14111  0
ppdev   7360  0
parport_pc 19600  0
parport32310  3 lp,ppdev,parport_pc
fuse   61671  5
bnep   14195  2
bluetooth 202902  7 bnep
lockd  70080  0
rfkill 16336  3 bluetooth
ip6t_REJECT 4008  2
nf_conntrack_ipv6   7714  2
nf_defrag_ipv6  9115  1 nf_conntrack_ipv6
nf_conntrack_ipv4   8310  2
nf_defrag_ipv4  1513  1 nf_conntrack_ipv4
xt_state1306  4
nf_conntrack   67597  3 nf_conntrack_ipv6,nf_conntrack_ipv4,xt_state
ip6table_filter 1655  1
ip6_tables 16776  1 ip6table_filter
binfmt_misc 6983  1
reiserfs  211389  2
nvidia  12112133  40
uvcvideo   56989  0
videodev   78689  1 uvcvideo
joydev  9567  0
snd_usb_audio 105405  1
snd_usbmidi_lib18071  1 snd_usb_audio
snd_rawmidi19878  1 snd_usbmidi_lib
snd_hda_codec_realtek   312967  1
media  11511  2 uvcvideo,videodev
v4l2_compat_ioctl32 7665  1 videodev
snd_hda_intel  24072  2
snd_hda_codec  85462  2 snd_hda_codec_realtek,snd_hda_intel
snd_hwdep   6264  2 snd_usb_audio,snd_hda_codec
snd_seq52186  0
snd_seq_device  5941  2 snd_rawmidi,snd_seq
i7core_edac16001  0
snd_pcm78498  3 snd_usb_audio,snd_hda_intel,snd_hda_codec
snd_timer  19372  2 snd_seq,snd_pcm
i2c_i8019237  0
edac_core  40154  3 i7core_edac
snd63124  17 
snd_usb_audio,snd_usbmidi_lib,snd_rawmidi,snd_hda_codec_realtek,snd_hda_intel,snd_hda_codec,snd_hwdep,snd_seq,snd_seq_device,snd_pcm,snd_timer
iTCO_wdt   12024  0
iTCO_vendor_support 2578  1 iTCO_wdt
soundcore   6267  1 snd
snd_page_alloc  7311  2 snd_hda_intel,snd_pcm
r8169  40493  0
asus_atk0110   12395  0
i2c_core   25728  3 nvidia,videodev,i2c_i801
microcode  18539  0
mii 4335  1 r8169
serio_raw   4298  0
uinput  7230  0
sunrpc201219  2 lockd
ata_generic 3587  0
pata_acpi   3419  0
mxm_wmi 1727  0
firewire_ohci  26101  0
pata_jmicron2643  0
firewire_core  49303  1 firewire_ohci
crc_itu_t   1547  1 firewire_core
wmi 9049  1 mxm_wmi
uas 7775  0
usb_storage45966  0



On 12/03/2011 02:10 AM, Onyeibo Oku wrote:
> What's your output for:
>
> lsmod nvidia
>
>
> -
> from twohot@device.mobile :)
>
> -Original Message-
> From: Andrew Douglas Pitonyak
> Date: Fri, 02 Dec 2011 21:57:16
> To:
> Reply-To: users@global.libreoffice.org
> Subject: Re: [libreoffice-users] Re: Problem with Linux open nouveau video
>   driver
>
> I was not aware of Leigh's advice until I saw your response here. So
> I found and followed his advice, and, I still see issues.
>
> Note that I do still see the driver, however
>
>   >rpm -qa | grep -i nouveau
> xorg-x11-drv-nouveau-0.0.16-27.20110720gitb806e3f.fc16.x86_64
>
> Then again, I also see all sorts of kmod stuff
>
>   >rpm -qa | grep -i nvidia
>
> xorg-x11-drv-nvidia-libs-290.10-1.fc16.x86_64
> kmod-nvidia-3.1.2-1.fc16.x86_64-290.10-1.fc16.1.x86_64
> nvidia-settings-1.0-13.fc16.x86_64
> akmod-nvidia-290.10-1.fc16.1.x86_64
> xorg-x11-drv-nvidia-290.10-1.fc16.x86_64
> nvidia-xconfig-1.0-11.fc16.x86_64
> kmod-nvidia-3.1.1-1.fc16.x86_64-290.06-1.fc16.2.x86_64
> kmod-nvidia-3.1.1-2.fc16.x86_64-290.06-1.fc16.3.x86_64
>
>
>
>
>
> On 12/02/2011 03:18 AM, Onyeibo Oku wrote:
>> If you're running "kmod" nvidia drivers then you are not running nouveau. 
>> Nouveau runs out-of-the-box (fresh installation) and has proven to be more 
>> headache-free. I have not noticed this issue. Could this be pec

Re: [libreoffice-users] Re: Cell formatting with CSV files in Calc

On 12/03/2011 05:43 PM, berntie wrote:

Jay Lozier wrote

* File a bug/feature request? If yes, where can I do that?

File a feature request for a currency data type

Where can I do that?

You will need a free bugzilla account to use this (a link is provided)
https://www.libreoffice.org/get-help/bug/

Jay Lozier wrote

* Work around the issue? What would that workaround be??

Work around appears to be import as standard, then format the column as
desired. Also, once the data is imported save the Calc spreadsheet as
*.ods to preserve formating.

Thanks for the suggestion but saving as *.ods is not an option for me as I
need the resulting file to be a text file.
Ok, ods saves the entire spreadsheet while saving as csv only saves the
current worksheet and loses all the formating information.

What are you actually trying to do? It sounds like your trying do
something that a database may be better at doing.

--
View this message in context:
http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3558180.html
Sent from the Users mailing list archive at Nabble.com.

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

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

[libreoffice-users] how to write in two separate column in writer?

2011-12-03 Thread soumalya ray

hi,
what i want to do is something like this with writer-


> h
>  hhh
> jj
>  
>
>  jj
> iii
>   i
>
>  i


one way is to use space button repeatedly;but is there any other way to
achieve this?
regards,



-- 
Dr soumalya ray   
MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine)
Skype: som3776 | Twitter: @docbkp 

-- 
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 write in two separate column in writer?

2011-12-03 Thread Libre User

 I just see a two lines with a series of letters. Not sure what you 
are trying to do. My email client doesn't seem to have the same 
formatting as yours.  Can you describe what you want in words.

Jerry

At 08:31 PM 12/3/2011, you wrote:
hi, what i want to do is something like this with writer- 
 > 
h >  hhh > 
jj > 
  > > 
jj > 
iii > 
   i > > 
i one way is to 
use space button repeatedly;but is there any other way to achieve 
this? regards, -- Dr soumalya ray 

MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine) Skype: som3776 | 
Twitter: @docbkp  -- 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] how to write in two separate column in writer?