Re: Speichern von Schreiben Probleme z. B. Speichen oder Speichen unter!

[,]

Hallo .,

ich habe mal versucht das nachzubauen, einer Testdatei mit Excel als CSV 
gespeichert. Einmal mit Komma, einmal mit Semikolon getrennt.


In beiden fällen "mit Openoffice CAlc" geöffnet. Datum und Zahlen werden 
erkannt und lassen sich formatieren, die Zahlen auch summieren.


Im Import-Dialog von OpenOffice Calc habe ich alle zu importierenden 
Spalten als "Standard" formatiert. Das war eh schon die Einstellung.


Als ich alles als Text importierte wr es dann vorbei mit formatieren, 
und summieren.


Mag es daran liegen?

--
Grüßle
Detlef

Am 14.03.2019 um 19:23 schrieb .:

HI!


-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

[Martin Groenescheij]

On 14/03/2019 20:59, Joost Andrae wrote:

Hi,

if you format cells using a cell formating template (function key F11)


F11 refers to Styles and Formatting which is not the same as Templates.

To achieve the desired results you have to  create a Cell Style using 
the F11 Function Key.
Then in one of the Cells Select Conditional Formatting and change "Cell 
value is" to "Formula is" then enter "FIND("GOES";UPPER(A1);1)" in the 
condition box.

In the Cell Style you select the newly created Cell Style.
Now you can Copy and Paste Special the format to a range of cells.

then you can easily change this cell formating by changing the cell 
formating template (eg. by adding background color red to this 
template). If you change this template then all cells where you 
assinged the template to change it's formating immediately.


It think it's a better way then using search

Kind regards, Joost



Am 14.03.2019 um 19:44 schrieb Martin Groenescheij:



On 14 Mar 2019, at 6:33 pm, WA.TWORSX via AOL 
 wrote:



Hi David:

I do not think you understand what I am attempting to do, so I'll 
try to clarify what my goal is.


In my spreadsheet cells I have typed a word, e.g., Goes,many times.  
I meant to type that word in Bold font.  Is there a way to change 
the already typed word (e.g., Goes) to be in bold font by use of the 
Find & Replace function?


You can use Conditional Formatting to make a whole Cell bold, just 
check if the Cell contains “Goes” and create a new Paragraph Stype.




I am not attempting to highlight an area within the spreadsheet.  I 
do not program in vbs, or any other language for that matter. :-) 
Years ago, I started to learn machine language for the Motorola 
6809E chip, but have not ever put what I learned to use.


TNX for your reply.


VinceB.




On 3/14/2019 11:54 AM, David Belina wrote:
The way the data is displayed in any spreadsheet is determined by 
the formatting which is linked to cell/row/column and not the 
particular data.  The search and replace function searches the data 
not the format.


You might be able to write a script (in excel you do this in vbs 
(visual basic) but I’m not sure in OO.


The question is what you want to highlight.  If it is a summary or 
other function you eventually want to arrive at - you can just 
format the last result cell.



On March 14, 2019 at 9:24:27 AM, WA.TWORSX via AOL 
(wa.two...@verizon.net.invalid) wrote:



AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

Desktop Windows 10-64 Home





I am trying to change the attributes on data that exists within an AOO
Calc cell when using the Find & Replace function. For example, if the
cell presently shows:

 Goes

I want it to be replaced with:

*    Goes*

That is, add the *bold* attribute to the existing data.

In the Find & Replace dialogue window, I have selected: Fewer Options,
with none of the boxes checked.  I have also selected: Search in:
"Values" (near the bottom of that window).
**

Is there a way to change / replace the assigned attributes when using
Find & Replace function in AOO-Calc Spreadsheets?

Regards,

VinceB.







-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

[Joost Andrae]

Hi,

if you format cells using a cell formating template (function key F11)
then you can easily change this cell formating by changing the cell 
formating template (eg. by adding background color red to this 
template). If you change this template then all cells where you assinged 
the template to change it's formating immediately.


It think it's a better way then using search

Kind regards, Joost



Am 14.03.2019 um 19:44 schrieb Martin Groenescheij:




On 14 Mar 2019, at 6:33 pm, WA.TWORSX via AOL  
wrote:


Hi David:

I do not think you understand what I am attempting to do, so I'll try to 
clarify what my goal is.

In my spreadsheet cells I have typed a word, e.g., Goes,many times.  I meant to 
type that word in Bold font.  Is there a way to change the already typed word 
(e.g., Goes) to be in bold font by use of the Find & Replace function?


You can use Conditional Formatting to make a whole Cell bold, just check if the 
Cell contains “Goes” and create a new Paragraph Stype.



I am not attempting to highlight an area within the spreadsheet.  I do not 
program in vbs, or any other language for that matter. :-) Years ago, I started 
to learn machine language for the Motorola 6809E chip, but have not ever put 
what I learned to use.

TNX for your reply.


VinceB.




On 3/14/2019 11:54 AM, David Belina wrote:
The way the data is displayed in any spreadsheet is determined by the 
formatting which is linked to cell/row/column and not the particular data.  The 
search and replace function searches the data not the format.

You might be able to write a script (in excel you do this in vbs (visual basic) 
but I’m not sure in OO.

The question is what you want to highlight.  If it is a summary or other 
function you eventually want to arrive at - you can just format the last result 
cell.


On March 14, 2019 at 9:24:27 AM, WA.TWORSX via AOL 
(wa.two...@verizon.net.invalid) wrote:


AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

Desktop Windows 10-64 Home





I am trying to change the attributes on data that exists within an AOO
Calc cell when using the Find & Replace function. For example, if the
cell presently shows:

 Goes

I want it to be replaced with:

*Goes*

That is, add the *bold* attribute to the existing data.

In the Find & Replace dialogue window, I have selected:  Fewer Options,
with none of the boxes checked.  I have also selected: Search in:
"Values" (near the bottom of that window).
**

Is there a way to change / replace the assigned attributes when using
Find & Replace function in AOO-Calc Spreadsheets?

Regards,

VinceB.







-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

[Martin Groenescheij]

> On 14 Mar 2019, at 6:33 pm, WA.TWORSX via AOL  
> wrote:
> 
> 
> Hi David:
> 
> I do not think you understand what I am attempting to do, so I'll try to 
> clarify what my goal is.
> 
> In my spreadsheet cells I have typed a word, e.g., Goes,many times.  I meant 
> to type that word in Bold font.  Is there a way to change the already typed 
> word (e.g., Goes) to be in bold font by use of the Find & Replace function?

You can use Conditional Formatting to make a whole Cell bold, just check if the 
Cell contains “Goes” and create a new Paragraph Stype.

> 
> I am not attempting to highlight an area within the spreadsheet.  I do not 
> program in vbs, or any other language for that matter. :-) Years ago, I 
> started to learn machine language for the Motorola 6809E chip, but have not 
> ever put what I learned to use.
> 
> TNX for your reply.
> 
> 
> VinceB.
> 
> 
> 
>> On 3/14/2019 11:54 AM, David Belina wrote:
>> The way the data is displayed in any spreadsheet is determined by the 
>> formatting which is linked to cell/row/column and not the particular data.  
>> The search and replace function searches the data not the format.
>> 
>> You might be able to write a script (in excel you do this in vbs (visual 
>> basic) but I’m not sure in OO.
>> 
>> The question is what you want to highlight.  If it is a summary or other 
>> function you eventually want to arrive at - you can just format the last 
>> result cell.
>> 
>> 
>> On March 14, 2019 at 9:24:27 AM, WA.TWORSX via AOL 
>> (wa.two...@verizon.net.invalid) wrote:
>> 
>> 
>> AOO415m1(Build:9789)  -  Rev. 1817496
>> 2017-12-11 17:25
>> 
>> Desktop Windows 10-64 Home
>> 
>> 
>> 
>> 
>> 
>> I am trying to change the attributes on data that exists within an AOO
>> Calc cell when using the Find & Replace function. For example, if the
>> cell presently shows:
>> 
>> Goes
>> 
>> I want it to be replaced with:
>> 
>> *Goes*
>> 
>> That is, add the *bold* attribute to the existing data.
>> 
>> In the Find & Replace dialogue window, I have selected:  Fewer Options,
>> with none of the boxes checked.  I have also selected: Search in:
>> "Values" (near the bottom of that window).
>> **
>> 
>> Is there a way to change / replace the assigned attributes when using
>> Find & Replace function in AOO-Calc Spreadsheets?
>> 
>> Regards,
>> 
>> VinceB.
>> 
>> 
>> 


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

[WA.TWORSX via AOL]

Hi David:

I do not think you understand what I am attempting to do, so I'll try to 
clarify what my goal is.


In my spreadsheet cells I have typed a word, e.g., Goes,many times.  I 
meant to type that word in Bold font.  Is there a way to change the 
already typed word (e.g., Goes) to be in bold font by use of the Find & 
Replace function?


I am not attempting to highlight an area within the spreadsheet.  I do 
not program in vbs, or any other language for that matter. :-) Years 
ago, I started to learn machine language for the Motorola 6809E chip, 
but have not ever put what I learned to use.


TNX for your reply.


VinceB.



On 3/14/2019 11:54 AM, David Belina wrote:

The way the data is displayed in any spreadsheet is determined by the 
formatting which is linked to cell/row/column and not the particular data.  The 
search and replace function searches the data not the format.

You might be able to write a script (in excel you do this in vbs (visual basic) 
but I’m not sure in OO.

The question is what you want to highlight.  If it is a summary or other 
function you eventually want to arrive at - you can just format the last result 
cell.


On March 14, 2019 at 9:24:27 AM, WA.TWORSX via AOL 
(wa.two...@verizon.net.invalid) wrote:


AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

Desktop Windows 10-64 Home





I am trying to change the attributes on data that exists within an AOO
Calc cell when using the Find & Replace function. For example, if the
cell presently shows:

     Goes

I want it to be replaced with:

*    Goes*

That is, add the *bold* attribute to the existing data.

In the Find & Replace dialogue window, I have selected:  Fewer Options,
with none of the boxes checked.  I have also selected: Search in:
"Values" (near the bottom of that window).
**

Is there a way to change / replace the assigned attributes when using
Find & Replace function in AOO-Calc Spreadsheets?

Regards,

VinceB.

AW: Speichern von Schreiben Probleme z. B. Speichen oder Speichenunter!

[.]

Hi!

Danke für deine eMail.

Ich habe folgendes Problem: Ich habe einen Kontoauszug im CSV-Format 
heruntergeladen. Dann mit OpenOffice Calc geöffnet. Ich würde gerne die Zellen 
formatieren, also bspw. das Format auf Währung stellen (sodass tausender 
Trennzeichen und das €-Zeichen erscheint) oder auch die negativen Zahlen rot 
darstellen lassen. Leider funktioniert beides nicht. Die Zelle ist dann zwar 
formatiert, aber die Darstellung der Zahl wird nicht angepasst.
Eine Summe in einer dritten Zelle kann ich auch nicht bilden.

Hättest du vielleicht eine Idee an was das liegen kann?
Alle anderen Zellen, die nicht durch den CSV-Import beschrieben wurden, 
funktionieren (d.h. ich gebe eine Zahl ein und kann diese wie gewünscht 
darstellen lassen).
Vielleicht übersehe ich eine Einstellung beim CSV-Import?

Über eine Rückmeldung würde ich mich freuen.
LG



Von: Wolfgang Jäth
Gesendet: Donnerstag, 14. März 2019 15:18
An: users-de@openoffice.apache.org
Betreff: Re: Speichern von Schreiben Probleme z. B. Speichen oder Speichenunter!

Am 14.03.2019 um 12:10 schrieb Günter Franz:
> Er reagiert- und speichert nicht.

Wer? Writer? Calc? Gott? ...

> Bitte um eine Lösung.

Sorry, meine Kristallkugel ist gerade wieder wegen Überforderung kaputt
gegangen. Also beschreibe bitte dein Problem genauer. Was genau möchtest
du machen (und mit welchem Programm, Version usw.), wie genau gehst du
dazu vor, und was genau passiert.

Wolfgang
--
Durch Donald Trump ist mir endgültig klar geworden: Es ist
nicht der Turm von Pisa, der schief steht, es ist die Welt!


-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

AW: Speichern von Schreiben Probleme z. B. Speichen oder Speichen unter!

[.]

HI!

Danke für deine eMail. Sorry wenn mein Ton unfreundlich rüber kam – das war 
nicht meine Absicht.

Ich habe folgendes Problem: Ich habe einen Kontoauszug im CSV-Format 
heruntergeladen. Dann mit OpenOffice Calc geöffnet. Ich würde gerne die Zellen 
formatieren, also bspw. das Format auf Währung stellen (sodass tausender 
Trennzeichen und das €-Zeichen erscheint) oder auch die negativen Zahlen rot 
darstellen lassen. Leider funktioniert beides nicht. Die Zelle ist dann zwar 
formatiert, aber die Darstellung der Zahl wird nicht angepasst. Eine Summe in 
einer dritten Zelle kann ich auch nicht bilden.

Hättest du vielleicht eine Idee an was das liegen kann?
Alle anderen Zellen, die nicht durch den CSV-Import beschrieben wurden, 
funktionieren.
Vielleicht übersehe ich eine Einstellung für den CSV-Import?

Über eine Rückmeldung würde ich mich freuen.
LG


Von: Dave
Gesendet: Donnerstag, 14. März 2019 14:08
An: users-de@openoffice.apache.org
Betreff: Re: Speichern von Schreiben Probleme z. B. Speichen oder Speichen 
unter!

Wir sind unter uns eines höflichen Umgangstons gewöhnt. Wir sind keine
Automaten, sondern Menschen, OpenOffice-User*innen, die gerne anderen Usern
helfen, wenn die sich einigermaßen ausdrücken können.

Programm reagiert nicht? Einfach neu starten. Unter Extras kann man die
automatische Speicherung von 10 auf 1 Minute runtersetzen, dann sind beim
Neustart alle Änderungen an der Datei da (bis auf die letzten Sekunden).

On Thu, 14 Mar 2019 at 13:53, Günter Franz  wrote:

> Er reagiert- und speichert nicht. Bitte um eine Lösung. G. Franz
> Gesendet von Mail für Windows 10
>
>

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

[Keith N. McKenna]

On 3/14/2019 11:54 AM, David Belina wrote:
> The way the data is displayed in any spreadsheet is determined by the
> formatting which is linked to cell/row/column and not the particular
> data.  The search and replace function searches the data not the
> format.
> 
> You might be able to write a script (in excel you do this in vbs
> (visual basic) but I’m not sure in OO.
> 
In AOO you would use OpenOffice Basic the guide for which can be found
at https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide
Keith

> The question is what you want to highlight.  If it is a summary or
> other function you eventually want to arrive at - you can just format
> the last result cell.
> 
> 
> On March 14, 2019 at 9:24:27 AM, WA.TWORSX via AOL
> (wa.two...@verizon.net.invalid) wrote:
> 
> 
> AOO415m1(Build:9789)  -  Rev. 1817496 2017-12-11 17:25
> 
> Desktop Windows 10-64 Home
> 
> 
> 
> 
> 
> I am trying to change the attributes on data that exists within an
> AOO Calc cell when using the Find & Replace function. For example, if
> the cell presently shows:
> 
> Goes
> 
> I want it to be replaced with:
> 
> *Goes*
> 
> That is, add the *bold* attribute to the existing data.
> 
> In the Find & Replace dialogue window, I have selected:  Fewer
> Options, with none of the boxes checked.  I have also selected:
> Search in: "Values" (near the bottom of that window). **
> 
> Is there a way to change / replace the assigned attributes when using
>  Find & Replace function in AOO-Calc Spreadsheets?
> 
> Regards,
> 
> VinceB.
> 
> 
> 




signature.asc
Description: OpenPGP digital signature

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

[David Belina]

The way the data is displayed in any spreadsheet is determined by the 
formatting which is linked to cell/row/column and not the particular data.  The 
search and replace function searches the data not the format.

You might be able to write a script (in excel you do this in vbs (visual basic) 
but I’m not sure in OO.

The question is what you want to highlight.  If it is a summary or other 
function you eventually want to arrive at - you can just format the last result 
cell.


On March 14, 2019 at 9:24:27 AM, WA.TWORSX via AOL 
(wa.two...@verizon.net.invalid) wrote:


AOO415m1(Build:9789)  -  Rev. 1817496  
2017-12-11 17:25  

Desktop Windows 10-64 Home  


  


I am trying to change the attributes on data that exists within an AOO  
Calc cell when using the Find & Replace function. For example, if the  
cell presently shows:  

    Goes  

I want it to be replaced with:  

*    Goes*  

That is, add the *bold* attribute to the existing data.  

In the Find & Replace dialogue window, I have selected:  Fewer Options,  
with none of the boxes checked.  I have also selected: Search in:  
"Values" (near the bottom of that window).  
**  

Is there a way to change / replace the assigned attributes when using  
Find & Replace function in AOO-Calc Spreadsheets?  

Regards,  

VinceB.  

Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

[WA.TWORSX via AOL]

AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

Desktop Windows 10-64 Home





I am trying to change the attributes on data that exists within an AOO 
Calc cell when using the Find & Replace function. For example, if the 
cell presently shows:


    Goes

I want it to be replaced with:

*    Goes*

That is, add the *bold* attribute to the existing data.

In the Find & Replace dialogue window, I have selected:  Fewer Options, 
with none of the boxes checked.  I have also selected: Search in: 
"Values" (near the bottom of that window).

**

Is there a way to change / replace the assigned attributes when using 
Find & Replace function in AOO-Calc Spreadsheets?


Regards,

VinceB.

Re: OO description?

[Martin Groenescheij]

Seeing all the questions you raised last weeks I have the feeling that you 
haven’t done any effort to dig in the available documentation.

> On 14 Mar 2019, at 13:34,   wrote:
> 
> 
> 
> I may need to know what words of OO description similar Microsoft Word,
> Excel, Outlook, PowerPoint, Publisher & Access.  Parenthesis is for MS and I
> need to understand in what OO words consist. 
> 
> Writer (Word) 
> 
> Calc (Excel)  
> 
> Impress (PowerPoint) ?  
> 
> Draw ( ? )  
> 
> Base ( ? ) 
> 
> Math ( ? ) 
> 
> 
> 
> CJ 
> 


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Speichern von Schreiben Probleme z. B. Speichen oder Speichen unter!

[Wolfgang Jäth]

Am 14.03.2019 um 12:10 schrieb Günter Franz:
> Er reagiert- und speichert nicht. 

Wer? Writer? Calc? Gott? ...

> Bitte um eine Lösung. 

Sorry, meine Kristallkugel ist gerade wieder wegen Überforderung kaputt
gegangen. Also beschreibe bitte dein Problem genauer. Was genau möchtest
du machen (und mit welchem Programm, Version usw.), wie genau gehst du
dazu vor, und was genau passiert.

Wolfgang
-- 
Durch Donald Trump ist mir endgültig klar geworden: Es ist
nicht der Turm von Pisa, der schief steht, es ist die Welt!


-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Re: Speichern von Schreiben Probleme z. B. Speichen oder Speichen unter!

[Dave]

Wir sind unter uns eines höflichen Umgangstons gewöhnt. Wir sind keine
Automaten, sondern Menschen, OpenOffice-User*innen, die gerne anderen Usern
helfen, wenn die sich einigermaßen ausdrücken können.

Programm reagiert nicht? Einfach neu starten. Unter Extras kann man die
automatische Speicherung von 10 auf 1 Minute runtersetzen, dann sind beim
Neustart alle Änderungen an der Datei da (bis auf die letzten Sekunden).

On Thu, 14 Mar 2019 at 13:53, Günter Franz  wrote:

> Er reagiert- und speichert nicht. Bitte um eine Lösung. G. Franz
> Gesendet von Mail für Windows 10
>
>

Speichern von Schreiben Probleme z. B. Speichen oder Speichen unter!

[Günter Franz]

Er reagiert- und speichert nicht. Bitte um eine Lösung. G. Franz
Gesendet von Mail für Windows 10

OO description?

[cj-gs]

 

I may need to know what words of OO description similar Microsoft Word,
Excel, Outlook, PowerPoint, Publisher & Access.  Parenthesis is for MS and I
need to understand in what OO words consist. 

Writer (Word) 

Calc (Excel)  

Impress (PowerPoint) ?  

Draw ( ? )  

Base ( ? ) 

Math ( ? ) 

 

CJ 

cannot register

[brobobross]

I cannot register because it  says emain is in use;  also

I am trying  to open a file  i've used for several ryears.  But now I get
an error message that  says .  ascii filter options and under that it says
properties and under that it says character set with many options (i choose
western europe), and then default fonts  with many options (I choose times
new roman) and then under that it says language with many options (i choose
english).  please help me I need that file.  when I click ok it opens like
a word document with all # signs.