Re: How to connect lines in Writer?
At 01:08 15/11/2016 -0500, Linda Hull wrote: I[...] have Open Office 4.1.2. With a free product, there is rarely any reason to stick with older versions. What I want to do is prepare the file using Open Office Writer, instead of notepad++. If you already have something that serves the purpose, why change? An example of the text is: USER: nIckmenza ACCESS: 250 L CHANNEL: #arlington AUTOMODE: OP LAST SEEN: 0 days, 02:45:30 ago. LAST MODIFIED: pomol Sir^POMOL!digi...@pomol.users.undernet.org 4087 days, 09:31:38 ago [etc.] What I want to do is make all of the data about each individual user be on ONE line, so that it will open and appear all on a single line, in Calc. [...] How can I do the same thing in Writer, to make the data for each user in a single line? Like: USER: okidoki ACCESS: 100 L CHANNEL: #arlington AUTOMODE: OP LAST SEEN: 0 days, 17:27:17 ago. LAST MODIFIED: darxide dxd-!~d...@darxide.users.undernet.org 40 days, 07:29:15 ago o Go to Edit | Find & Replace... (or Ctrl+F). o Click More Options and tick "Regular expressions". o Search for $ and Replace with a single space. o Now search for USER: and replace with \n& . You might find it useful to replace with a semicolon instead of a space in the first case. Then, when you use Paste Special... to paste the result into your spreadsheet, you can tick Semicolon under "Separated by" in the Text Import window in order to separate the text into different columns across the rows. I wouldn't mind knowing how to eliminate the colon ":" after USER: AUTOMODE: SEEN: AND MODIFIED: without eliminating the colons in all of the times? The obvious way is Find and Replace each one R: E: N: and D:, is there a more efficient way, maybe a regex for letters not numbers? Yup. If the relevant colons are the only ones that appear after alphabetic characters instead of digits, search for ([:alpha:]): and replace with $1 (again with "Regular expressions" ticked). With your data in the spreadsheet, you may find Data | Text to Columns... useful in reformatting it. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: How to connect lines in Writer?
Download this AltSearch extension from: http://extensions.openoffice.org/en/project/alternative-dialog-find-replace-writer-altsearch With this extension you can use regex expressions On 15/11/16 5:08 PM, Linda Hull wrote: A while back, I asked some questions about opening a text file in Calc, as text, CSV. I solved the CSV part of it, but I was using notepad++ on Windows 7, to prepare the file. I'm still on Windows 7 and have Open Office 4.1.2. What I want to do is prepare the file using Open Office Writer, instead of notepad++. An example of the text is: USER: nIckmenza ACCESS: 250 L CHANNEL: #arlington AUTOMODE: OP LAST SEEN: 0 days, 02:45:30 ago. LAST MODIFIED: pomol Sir^POMOL!digi...@pomol.users.undernet.org 4087 days, 09:31:38 ago USER: NaV1GaToR ACCESS: 250 CHANNEL: #arlington AUTOMODE: OP LAST SEEN: 1572 days, 05:19:23 ago. LAST MODIFIED: pomol Sir^POMOL!digi...@sirpomol.net 5181 days, 12:13:11 ago USER: nite ACCESS: 100 CHANNEL: #arlington AUTOMODE: OP LAST SEEN: 0 days, 22:15:01 ago. LAST MODIFIED: monalisa2 Moniq!asila...@monalisa2.users.undernet.org 20 days, 16:34:36 ago USER: okidoki ACCESS: 100 L CHANNEL: #arlington AUTOMODE: OP LAST SEEN: 0 days, 17:27:17 ago. LAST MODIFIED: darxide dxd-!~d...@darxide.users.undernet.org 40 days, 07:29:15 ago USER: pomol ACCESS: 500 CHANNEL: #arlington AUTOMODE: OP LAST SEEN: 0 days, 12:34:17 ago. LAST MODIFIED: bobskc BobsKC!bob...@bobskc.users.undernet.org 4240 days, 02:36:24 ago What I want to do is make all of the data about each individual user be on ONE line, so that it will open and appear all on a single line, in Calc. In notepad++ I would \r\nCHANNEL Find and Replace to CHANNEL, which would cause the CHANNEL lines to append themselves to the above line, and then \r\nLAST would do the other lines which begin with LAST (losing the MODIFIED and SEEN). How can I do the same thing in Writer, to make the data for each user in a single line? Like: USER: okidoki ACCESS: 100 L CHANNEL: #arlington AUTOMODE: OP LAST SEEN: 0 days, 17:27:17 ago. LAST MODIFIED: darxide dxd-!~ d...@darxide.users.undernet.org 40 days, 07:29:15 ago I wouldn't mind knowing how to elimiate the colon ":" after USER: AUTOMODE: SEEN: AND MODFIED: without eliminating the colons in all of the times? The obvious way is Find and Replace each one R: E: N: and D:, is there a more efficient way, maybe a regex for letters not numbers? Thanks so much for your help! Linda - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
How to connect lines in Writer?
A while back, I asked some questions about opening a text file in Calc, as text, CSV. I solved the CSV part of it, but I was using notepad++ on Windows 7, to prepare the file. I'm still on Windows 7 and have Open Office 4.1.2. What I want to do is prepare the file using Open Office Writer, instead of notepad++. An example of the text is: USER: nIckmenza ACCESS: 250 L CHANNEL: #arlington AUTOMODE: OP LAST SEEN: 0 days, 02:45:30 ago. LAST MODIFIED: pomol Sir^POMOL!digi...@pomol.users.undernet.org 4087 days, 09:31:38 ago USER: NaV1GaToR ACCESS: 250 CHANNEL: #arlington AUTOMODE: OP LAST SEEN: 1572 days, 05:19:23 ago. LAST MODIFIED: pomol Sir^POMOL!digi...@sirpomol.net 5181 days, 12:13:11 ago USER: nite ACCESS: 100 CHANNEL: #arlington AUTOMODE: OP LAST SEEN: 0 days, 22:15:01 ago. LAST MODIFIED: monalisa2 Moniq!asila...@monalisa2.users.undernet.org 20 days, 16:34:36 ago USER: okidoki ACCESS: 100 L CHANNEL: #arlington AUTOMODE: OP LAST SEEN: 0 days, 17:27:17 ago. LAST MODIFIED: darxide dxd-!~d...@darxide.users.undernet.org 40 days, 07:29:15 ago USER: pomol ACCESS: 500 CHANNEL: #arlington AUTOMODE: OP LAST SEEN: 0 days, 12:34:17 ago. LAST MODIFIED: bobskc BobsKC!bob...@bobskc.users.undernet.org 4240 days, 02:36:24 ago What I want to do is make all of the data about each individual user be on ONE line, so that it will open and appear all on a single line, in Calc. In notepad++ I would \r\nCHANNEL Find and Replace to CHANNEL, which would cause the CHANNEL lines to append themselves to the above line, and then \r\nLAST would do the other lines which begin with LAST (losing the MODIFIED and SEEN). How can I do the same thing in Writer, to make the data for each user in a single line? Like: USER: okidoki ACCESS: 100 L CHANNEL: #arlington AUTOMODE: OP LAST SEEN: 0 days, 17:27:17 ago. LAST MODIFIED: darxide dxd-!~ d...@darxide.users.undernet.org 40 days, 07:29:15 ago I wouldn't mind knowing how to elimiate the colon ":" after USER: AUTOMODE: SEEN: AND MODFIED: without eliminating the colons in all of the times? The obvious way is Find and Replace each one R: E: N: and D:, is there a more efficient way, maybe a regex for letters not numbers? Thanks so much for your help! Linda
Re: Defaultformatierung beim Aufrufen neuer Textdateien
Hallo, > From: Bernd Hauf [mailto:b.h...@gsh-system.de] > Ich benutze die neueste Version OpenOffice 4.1.3 und möchte > beim Aufruf > neuer Textdateien (rechte Maustaste Kontextmenü im Windows > Explorer), daß > die Formatierung genauso ist, als wenn ich neue Textdateien aus dem > OpenOffice Programm aufrufe. Leider ist das nicht so. Das ist nicht so weil für das Aufrufen aus dem Kontextmenü eine *.odt-Datei als Vorlage [sic] hinterlegt ist, die nicht zwingend identisch mit der 'internen' oder manuell gesetzten Standarddokumentvorlage sind. Bei mir (Win7 OO 4.1.2) ist die Datei in C:\ProgramData\Microsoft\Windows\Templates\soffice.odt. Diese soffice.odt musst Du wie gewünscht anpassen, dann sollte es funktionieren. Die Datei ist schreibgeschützt, d.h. notfalls müsstest Du eine Kopie erstellen, dann die Datei löschen und dann eine neue, gleichnamige Datei erstellen. Das sollte gehen. > In den Foren ist das Thema schon mal angesprochen worden (2008), aber > leider kein erfolgreicher Abschluss. Hast Du dazu einen Link? Interessehalber. Gruß Jörg - To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-de-h...@openoffice.apache.org
Re: Cannot locate Dialog for editing Cell range in Calc's Line Chart
On 11/5/2016 1:31 PM, VinceB. wrote: AOO412m3(Build:9782) - Rev. 1709696 2015-10-21 09:53:29 (Mi, 21 Okt 2015 WIN10x64 Desktop Please point me to the required dialog for changing the cell range in a Calc Line Chart. When I right-click in white area, the drop down shows Edit, but nothing about cell range or data series is then shown? I cannot seem to locate how to edit the chart's X-axis cell range or cell series (I don't know/understand which is needed) to include the latest MATCH AVG data points. (See also my 28 OCT posting.) Regards, VinceB. I do not know if the above actually made it to the Mailing List servers. I've forgotten which email address I used to register for the AOO users Mail List. If there is a method to extend/revise the cell range for an existing line chart in Calc, please give me some instruction on locating the required dialog screen. I've had to create a new line chart as a workaround, but I suspect that I am not using the correct sequence. Thanks in advance. Regards, VinceB - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: A question
Hi Paul,
Itipong (Paul) schrieb:
Dear Sir or Madam
I would like to know if I can change the font color by using IF Function as an
example below.
=if((a1+b1)<5;red(a1+b1);green(a1+b1))
I cannot find a solution or an example on the OpenOffice Help. So please
advise.
Your assistance is much appreciated.
Besides the way Brian has described, I know two other ways. For both you
need to define cell styles. Define a cell style "green", where you
select a green color in tab "Font Effects" or perhaps a green background
or a green border. Do similar for cell style "red".
Method A: conditional formatting
Assign to all result cells the format "green".
Set cursor in result cell and use Format > Conditional Formatting.
Set the condition to "cell value is" "less than", the value to 5, and
the style to "red".
Copy that cell.
Select all other result cells and use Edit > Paste Special. Unselect all
but "Formats". OK
Method B: function STYLE
Use the formula =a1+b1+IF(a1+b1<5;STYLE("red");STYLE("green"))
The function STYLE results 0, so that adding it to a1+b1 will not change
the result. The function STYLE formats the cell in which it is used with
the style given by the style name.
Kind regards
Regina
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
