Re: [libreoffice-users] Re: How to do this in Calc

At 18:16 07/02/2015 -0700, Jerry Van Brimmer wrote: Yes, I believe the data is text, since it is in a .csv file. The CSV file will contain just text, of course - but that could be interpreted as numbers, dates, times or whatever when opened in Calc. So that's no guarantee. Column A is prec

Re: [libreoffice-users] How to do this in Calc

Which language are you using in Calc? The commands are language dependant. Those I wrote is for an English version. /Kaj Den 2015-02-08 02:31, skrev "J. Van Brimmer": See below... On Sat, Feb 7, 2015 at 4:59 PM, Kaj <70147pers...@telia.com> wrote: If this is a simple string, then the extrac

Re: [libreoffice-users] How to do this in Calc

See below... On Sat, Feb 7, 2015 at 4:59 PM, Kaj <70147pers...@telia.com> wrote: > If this is a simple string, then the extract is quite simple. But if it > contains date formulas in a way, it is a wee more complicated. But let us > start with the simple assumption, that the string is exactly th

Re: [libreoffice-users] How to do this in Calc

Sorry for my posts going all over the place. Just learning how to use gmail for a mailing list. See below... On Sat, Feb 7, 2015 at 4:43 PM, Brian Barker wrote: > At 15:22 07/02/2015 -0700, Jerry Van Brimmer wrote: > >> Column A has the following data: >> 2015-01-06 00:00:00to 2015-01-06 01:00

[libreoffice-users] Re: How to do this in Calc

I'll first reply to Brian's post and hopefully that will answer everybody's questions. Comments are inline below ... On Sat, Feb 7, 2015 at 4:44 PM, Brian Barker [via Document Foundation Mail Archive] wrote: > At 15:22 07/02/2015 -0700, Jerry Van Brimmer wrote: > > >Column A has the following d

Re: [libreoffice-users] How to do this in Calc

If this is a simple string, then the extract is quite simple. But if it contains date formulas in a way, it is a wee more complicated. But let us start with the simple assumption, that the string is exactly the one you give, including e.g. the lacking space before "to": Assuming your string is

Re: [libreoffice-users] How to do this in Calc

At 15:22 07/02/2015 -0700, Jerry Van Brimmer wrote: Column A has the following data: 2015-01-06 00:00:00to 2015-01-06 01:00:00 I want a formula in column B to convert it to this: 00:00 - 01:00 This looks easy, I just don't have the know how to do it. It's basically a copy, minus the -mm-dd

Re: [libreoffice-users] How to do this in Calc

Thanks for reading, but I just manually formatted one page, and then I can copy/paste to other pages. Sorry for any inconvenience. I'd still like to know how to do it though. I'm thinking a macro is really what I need. On Sat, Feb 7, 2015 at 2:22 PM, jerryvb wrote: > Column A has the followi

Re: [libreoffice-users] Remove Strikethrough - Libre Writer

On 2/7/2015 5:23 PM, charles meyer wrote: I Googled this question and after 3 pages of results none of it worked. Can anyone please share how you *remove* strikethrough from text on many pages? Text is lined through on many pages and I want to remove it. If I choose Format>Font>Font Effects I

[libreoffice-users] Remove Strikethrough - Libre Writer

I Googled this question and after 3 pages of results none of it worked. Can anyone please share how you *remove* strikethrough from text on many pages? Text is lined through on many pages and I want to remove it. If I choose Format>Font>Font Effects I can see it but it doesn't remove it. If I r

[libreoffice-users] How to do this in Calc

Column A has the following data: 2015-01-06 00:00:00to 2015-01-06 01:00:00 I want a formula in column B to convert it to this: 00:00 - 01:00 This looks easy, I just don't have the know how to do it. It's basically a copy, minus the -mm-dd, and replacing the "to" with a dash. You can just p

Re: [libreoffice-users] Is This Possible In Calc?

On 7-2-2015 18:58, Kolbjørn Stuestøl wrote: Well, I posted my e-mail before the other answers showed up. But I agree with you, Tom. This is *the* link if you needs help or some tips using LibreOffice. Kolbjoern Den 07.02.2015 17:23, Tom Davies skreiv: Hi :) I like it when a few different peopl

Re: [libreoffice-users] Is This Possible In Calc?

First a big thank you to all who took the time to answer. I started out (many hours ago) trying unsuccessfully to work out a solution with conditional formatting, which is why I changed direction to the IF formula in cell A1. The real world situation is way more complex than I previously explaine

Re: [libreoffice-users] Is This Possible In Calc?

Well, I posted my e-mail before the other answers showed up. But I agree with you, Tom. This is *the* link if you needs help or some tips using LibreOffice. Kolbjoern Den 07.02.2015 17:23, Tom Davies skreiv: Hi :) I like it when a few different people all give basically the same answer but say

[libreoffice-users] Re: Suddenly get black menu and some areas

Well, I solve this problem by deleting the ~/.config/libreoffice/ directory. - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/Suddenly-get-black-menu-and-some-areas-tp4139272p4139274.html Sent from the Users mailing list archive at Nabble.com.

[libreoffice-users] Suddenly get black menu and some areas

Hello, I just installed LibreOffice fresh on my Arch linux system. I tried to setup to get automatically the A4 papersize. Finally, I have succes in that. Then I setup the View of LO and choose small icons in the menubar. Then I close LO and after that I start it again. I get black menubar and

[libreoffice-users] Suddenly get black menu and some areas

Hello, I just installed LibreOffice fresh on my Arch linux system. I tried to setup to get automatically the A4 papersize. Finally, I have succes in that. Then I setup the View of LO and choose small icons in the menubar. Then I close LO and after that I start it again. I get black menubar and

[libreoffice-users] Re: LinuxQuestions.org's Office Suite of the Year: LibreOffice!

"Valter Mura": a version of Office for Linux. Can you please provide the link. Still waiting for the link... This version is called 'wine' and it's available in your repository or at www.winehq.org/download. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Re: Is This Possible In Calc?

Not from other but you can do it directly in C20. C20: =formula + IF(B1=10;STYLE(whatever);0) LibreOffice help: STYLE function -- View this message in context: http://nabble.documentfoundation.org/Is-This-Possible-In-Calc-tp

Re: [libreoffice-users] Is This Possible In Calc?

Den 07.02.2015 16:14, Dave Barton skreiv: I don't believe the following is possible, but I hope some Calc guru (Brian?) here can prove me wrong. To have a formula in cell A which evaluates the contents of cell B and changes the style, but NOT the content, of cell C. eg. A1=contains the formula,

Re: [libreoffice-users] Is This Possible In Calc?

At 16:14 07/02/2015 +0100, Dave Barton wrote: I don't believe the following is possible, but I hope some Calc guru (Brian?) here can prove me wrong. I'm not sure I'm a guru, but here goes: To have a formula in cell A which evaluates the contents of cell B and changes the style, but NOT the co

Re: [libreoffice-users] Is This Possible In Calc?

On 02/07/2015 10:14 AM, Dave Barton wrote: I don't believe the following is possible, but I hope some Calc guru (Brian?) here can prove me wrong. To have a formula in cell A which evaluates the contents of cell B and changes the style, but NOT the content, of cell C. eg. A1=contains the formula

Re: [libreoffice-users] Is This Possible In Calc?

On 7-2-2015 16:14, Dave Barton wrote: I don't believe the following is possible, but I hope some Calc guru (Brian?) here can prove me wrong. To have a formula in cell A which evaluates the contents of cell B and changes the style, but NOT the content, of cell C. eg. A1=contains the formula, B1=0

[libreoffice-users] Is This Possible In Calc?

I don't believe the following is possible, but I hope some Calc guru (Brian?) here can prove me wrong. To have a formula in cell A which evaluates the contents of cell B and changes the style, but NOT the content, of cell C. eg. A1=contains the formula, B1=0, C1=20 Pseudo Code for cell A1: =IF(B1=

Re: [libreoffice-users] Re: LinuxQuestions.org's Office Suite of the Year: LibreOffice!

Le 06/02/2015 22:02, Urmas a écrit : > "Italo Vignoli": > > You need to understand that there are only two kinds of soft- and > hardware: that which solves the client problem at adequate cost, and > that which doesn't. Anything else is irrelevant. You're right. But the issue is how you calculate

Re: [libreoffice-users] Re: LinuxQuestions.org's Office Suite of the Year: LibreOffice!

Il 06/02/2015 09:35, Graham Luffrum ha scritto: Urmas, I obviously missed the announcement that MS have a version of Office for Linux. Can you please provide the link. Hey, Hi! Still waiting for the link from him/her... On 6 February 2015 at 06:04, Urmas wrote: "Robinson Tryon": Grab