Re: [libreoffice-users] Re: "/" character disappears in Writer

2019-06-22 Thread Luuk
On 21-6-2019 16:12, V Stuart Foote wrote: txemaclon wrote Hello, This is my first post, so greetings to everyone. After a lot of years using Microsoft products, i recently moved to Linux Mint and also to Libreoffice. I find a little problem using Writer. When i type "/" into a filesystem path

Re: [libreoffice-users] Re: insert non-breaking semi-space

2019-06-17 Thread Luuk
On 16-6-2019 23:47, Dave Howorth wrote: On Sun, 16 Jun 2019 22:09:12 +0200 Luuk wrote: But, to /me and i am only talking about Windows here, as long as the key in mentioned here (https://support.microsoft.com/en-ca/help/12445/windows-keyboard-shortcuts) than i call it universal  Well, as I

Re: [libreoffice-users] Re: insert non-breaking semi-space

2019-06-16 Thread Luuk
On 16-6-2019 16:36, Dave Howorth wrote: On Sun, 16 Jun 2019 08:41:42 +0200 Luuk wrote: Thanks for the explanation. There are other function which are useless in the menu, like i.e. CTRL+C. Most (read 'all') users will use their keyboard. Not true. Copy does not have a universal

Re: [libreoffice-users] Re: insert non-breaking semi-space

2019-06-16 Thread Luuk
On 16-6-2019 17:01, Johnny Rosenberg wrote: Den sön 16 juni 2019 kl 08:43 skrev Luuk : There are other function which are useless in the menu, like i.e. CTRL+C. Most (read 'all') users will use their keyboard. That's not my experience. I'd rather say that most user's will use the right

Re: [libreoffice-users] Re: insert non-breaking semi-space

2019-06-16 Thread Luuk
On 16-6-2019 05:59, V Stuart Foote wrote: Luuk wrote Why did this option not get a 'reserverd place in the menu' ? together with the shortcut-key reference ( +X) ? An option like +C is only known to all people (more than 75 % ??), because the shortcut key is next to it in the menu! Hmm

Re: [libreoffice-users] Re: insert non-breaking semi-space

2019-06-15 Thread Luuk
On 15-6-2019 17:06, V Stuart Foote wrote: Eric Beversluis wrote Thanks. Looks like I want to use “thin space” Hex 200A. Is there an easy way to do that from the keyboard? None of the ways I’ve used on Linux or Windows seem to work. Eric Beversluis Johnny Rosenberg wrote

Re: [libreoffice-users] insert non-breaking semi-space

2019-06-15 Thread Luuk
an use this (if you only can remember hexcodes) https://en.wikipedia.org/wiki/Unicode_input#In_Microsoft_Windows This makes it possible to enter the hexcode via your keyboard, so you will get an "A" when entering ALT  "+" "41" (without the double quotes) Luuk Er

Re: [libreoffice-users] Vertical text in Writer on updated Linux Mint (19.1)

2019-06-09 Thread Luuk
On 9-6-2019 14:01, M Henri Day wrote: Den sön 9 juni 2019 kl 11:53 skrev M Henri Day <mailto:mhenri...@gmail.com>>: Den sön 9 juni 2019 kl 11:09 skrev Luuk mailto:luu...@gmail.com>>: On 9-6-2019 09:04, M Henri Day wrote: >> After upgrading to LO 6.2.4

Re: [libreoffice-users] Vertical text in Writer on updated Linux Mint (19.1)

2019-06-09 Thread Luuk
On 9-6-2019 09:04, M Henri Day wrote: After upgrading to LO 6.2.4,2 on Linux Mint 19.1, I found to my surprise that I was neither able to attach the Vertical text icon to the Writer Toolbar, nor implement the function. I don't encounter this problem running LO 6.2.4.2 on my Windows 10 (v 1903)

Re: [libreoffice-users] Formula returns incorrect result

2019-06-09 Thread Luuk
On 9-6-2019 04:41, Carl Winerich wrote: I'm trying to calculate the Equation of Time (EoT) to determine the difference between LAN (Local Apparent Noon) and GMT/UT-1  Greenwich Mean Time.  Then I want to plot the EoT curve (a project for later, not now)The following

Re: [libreoffice-users] percent to whole fraction

2019-04-26 Thread Luuk
wrote: Den fre 26 apr. 2019 kl 22:42 skrev Johnny Rosenberg : Den fre 26 apr. 2019 kl 20:37 skrev Luuk : Let me rephrase the question ;) In the 'example' line we see: 56 30228/151 The actual cell contents are: 56 302 0,18543046357615894039735099337748 Is it possible to get

Re: [libreoffice-users] percent to whole fraction

2019-04-26 Thread Luuk
reply inserted in your post. On 26-4-2019 22:42, Johnny Rosenberg wrote: Den fre 26 apr. 2019 kl 20:37 skrev Luuk : Let me rephrase the question ;) In the 'example' line we see: 56 30228/151 The actual cell contents are: 56 302 0,18543046357615894039735099337748

Re: [libreoffice-users] percent to whole fraction

2019-04-26 Thread Luuk
Let me rephrase the question ;) In the 'example' line we see: 56  302    28/151 The actual cell contents are: 56 302 0,18543046357615894039735099337748 Is it possible to get the values '28' and '151' as show by the fraction-formatter? On 26-4-2019 19:01, Luuk wrote

Re: [libreoffice-users] percent to whole fraction

2019-04-26 Thread Luuk
Is there an option to convert a cell with format 'Fraction' to text? example: a b 'a/b 52 297 52/297 56 302 28/151 66 311 66/311 in this third line, i want to get '28' and '151' i tried TEXT(C2;""), and FIND("/";C2;1), On 26-4-2019 00:45, Remy

Re: [libreoffice-users] CSV import trouble (numbers & locale)

2019-04-24 Thread Luuk
On 24-4-2019 05:43, Drew Jensen wrote: Howdy, Well, I'm using LibreOffice 6.2.3 (with Ubuntu) and have created a csv file with two data rows 12.12 12.123 Then set my global locale to Italian(Italy) and try to open the csv file. (which is using a tab to separate values btw) If in the dialog

Re: [libreoffice-users] Calc: moving/sorting rows on Sheet1 don't update formulas on Sheet2 that refer to them

2019-04-10 Thread Luuk
On 10-4-2019 05:32, Tim Deaton wrote: Steve & Brian, thanks for your replies. Despite decades of working on spreadsheets, I can't say I expected it.  But then, it's the first time I'd found myself in this particular scenario.  But after your first sentence, I think I can see the logic -

Re: [libreoffice-users] Concatenate Function inCalc

2019-04-03 Thread Luuk
On 2-4-2019 19:33, Robert Großkopf wrote: Hi Luuk, In 6.2.0.3 on Windows, the function CONCATENATE(a1:a3) returns the value of a1 This should be reported a a bug... So please report this, if you could see the buggy behaviour in LO 6.2.2.2 also. I can't report it, because I couldn't

Re: [libreoffice-users] Concatenate Function inCalc

2019-04-02 Thread Luuk
On 2-4-2019 16:54, Robert Großkopf wrote: Hi Michael, This thread is about CONCATENATE being disfunctional in that it accepts ranges, but does not act on them correctly. Please stop referring to CONCAT as the reason that CONCATENATE is broken. Please red the first mail of jonathon. "With

Re: [libreoffice-users] Version: 6.2.0.3 - Calc: strange delay in execution of data>sort function

2019-03-09 Thread Luuk
On 7-3-2019 04:16, Tom Cloyd wrote: I recently updated to this version, and immediately noted that upon invocation of the main menu data>sort function to sort a group of rows there is about a 2 second delay before anything happens. The number of rows being sorted seems unrelated to the delay.

Re: [libreoffice-users] Help needed with Excel spreadsheet

2019-03-09 Thread Luuk
On 6-3-2019 17:48, Tom Williams wrote: On 3/6/19 8:26 AM, Tom Williams wrote: I know it's odd to ask for Excel help in this mailing list but I need help locating a LibreOffice Calc function/feature in Excel.  :) I'm helping a friend create a billing invoice and since I'm a Linux user, I'm

Re: [libreoffice-users] Help needed with Excel spreadsheet

2019-03-06 Thread Luuk
On 6-3-2019 17:48, Tom Williams wrote: On 3/6/19 8:26 AM, Tom Williams wrote: I know it's odd to ask for Excel help in this mailing list but I need help locating a LibreOffice Calc function/feature in Excel.  :) I'm helping a friend create a billing invoice and since I'm a Linux user, I'm

[libreoffice-users] message about "This document contains macros."

2019-03-03 Thread Luuk
Today i added a worksheet to a libreoffice-calc document. After saving/re-opening this document i get the message as in the subject of this mail. Why? i do not see any macro's, when looking under: Tools/Macros/Edit/ And also , there are no macros in this document, and have never been

Re: [libreoffice-users] automatic font selection in macro

2019-02-17 Thread Luuk
On 13-2-2019 06:55, Thomas Blasejewicz wrote: Addition On 2019/02/13 13:26, Andrew Pitonyak wrote: if I wrote a macro that inserts the letter 'X', I would not expect the insertion to specify the font unless I went out of my way to do so. * Japanese font -> I was just playing around and this

Re: [libreoffice-users] Why do adding OXT palettes, not show alpha sorted?

2019-02-12 Thread Luuk
On 11-2-2019 22:05, Tim-L wrote: I am working on making color palettes - via individual or collection OXT files. The problem is when I add them to LibreOffice 6.2.0.3, the font color drop down list of palettes is not sorted in any way, except the one that came with LO are the last ones

Re: [libreoffice-users] Does something like this exist for LO?

2019-02-05 Thread Luuk
On 5-2-2019 02:55, bunk3m wrote: On 04.02.2019 06:30, Luuk wrote: On 2-2-2019 21:53, bunk3m wrote: I have been wondering how to export my Google Map Timeline so I can capture my mileage driven without having to get the kml file for each individual day. Today I found this add-in for Excel

Re: [libreoffice-users] Does something like this exist for LO?

2019-02-04 Thread Luuk
On 2-2-2019 21:53, bunk3m wrote: I have been wondering how to export my Google Map Timeline so I can capture my mileage driven without having to get the kml file for each individual day. Today I found this add-in for Excel (Don't have Excel anymore :-( ) that runs a VBA script to do exactly

Re: [libreoffice-users] Does something like this exist for LO?

2019-02-04 Thread Luuk
On 2-2-2019 21:53, bunk3m wrote: I have been wondering how to export my Google Map Timeline so I can capture my mileage driven without having to get the kml file for each individual day. Today I found this add-in for Excel (Don't have Excel anymore :-( ) that runs a VBA script to do exactly

Re: [libreoffice-users] Re: [libreoffice-website] capabilty to execute macro on a "server" version of libreoffice

2019-01-06 Thread Luuk
On 6-1-2019 17:36, Drew Jensen wrote: On Sun, Jan 6, 2019 at 10:54 AM Bruno Patin - wanadoo < bruno.pa...@wanadoo.fr> wrote: Hi, Howdy, I would like to know if there exists roadmap that would allow to create a server version of libreoffice that would execute macros job on office docs. It

Re: [libreoffice-users] what's the best way to make charts of spreadsheet data

2019-01-05 Thread Luuk
On 5-1-2019 12:29, Dave Howorth wrote: On Sat, 5 Jan 2019 10:50:42 +0100 Luuk wrote: The fact that a screen has only (a limited) number of pixels, has NOTHING to do with how many items are used, or can be used,  in a graph. You're clearly not a programmer. I, indeed, fail to see the logic

Re: [libreoffice-users] what's the best way to make charts of spreadsheet data

2019-01-05 Thread Luuk
On 4-1-2019 18:54, Regina Henschel wrote: Hi Dave, Dave Howorth schrieb am 02-Jan-19 um 18:12: [..] My spreadsheet data is in columns. Column A is the dates and column B is the times. Then ten columns of humidity data and eleven columns of temperature data. There are currently just over 5000

Re: [libreoffice-users] what's the best way to make charts of spreadsheet data

2019-01-02 Thread Luuk
On 2-1-2019 18:12, Dave Howorth wrote: The Y-axis is reasonable from 0 to 120, although it would be nice to trim the blank space at the top a bit, since the data can't exceed 100. Right click on the Y-Axis, and choose 'Format Axis' A popup will be schown where you can set Minimum- and

Re: [libreoffice-users] disable 2-digit options

2018-12-29 Thread Luuk
On 29-12-2018 15:18, Thomas Blasejewicz wrote: Good evening I am using Calc to maintain a list of patients including entries like name, age, date of birth etc. I tried to set a consistent style to about 20 different sheets. Sheet styles do not allow to adjust font etc. I choose character

Re: [libreoffice-users] Calc week number problem

2018-12-24 Thread Luuk
On 22-12-2018 21:56, . wrote: I found a LO Calc spreadsheet that provides the year’s day number, remaining days and week number. It's attached herein.Depending upon the year it’s tedious to move each week number, which begins on Sunday, so that the week number is in the row which

Re: [libreoffice-users] Icons in message box

2018-12-17 Thread Luuk
problem is my theme or something, so I just wonder if this works for anybody else. Thanks. Kind regards Johnny Rosenberg I do see the question mark. I'm not using a theme. -- Luuk -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.

Re: [libreoffice-users] Auto-closing user dialogue (macro, Basic)

2018-12-15 Thread Luuk
On 9-12-2018 19:02, Johnny Rosenberg wrote: Hi! For some reason I can't figure this out… I have made a simple dialogue with two buttons and a numeric field. Those buttons triggers two different subroutines that does two different things and then closes the entire dialogue. I want the dialogue

Re: [libreoffice-users] Re: Adding keyboard shortcut

2018-12-15 Thread Luuk
On 9-12-2018 15:21, W. Robert J. Funnell, Prof. wrote: On Sun, 9 Dec 2018, V Stuart Foote wrote: Rich Shepard wrote The *delete* you want is assigned in LibreOffice via the "Backspace" function, aka a *rubout*. Not quite. The backspace key deletes the character to the left of the

Re: [libreoffice-users] Exporting .pdf

2018-08-11 Thread Luuk
On 11-8-2018 22:00, Spleen wrote: > Dear all, > > I'm new here and don't really know if this is the correct way of looking > for help. > > I'm having troubles with exporting pdf from a .doc file. It only happens > with Gudea font and only with the letter 'à': this is simple not visible > in the

Re: [libreoffice-users] Strange Macro folder behavior

2018-07-31 Thread Luuk
On 22-7-2018 23:48, Peggy wrote: > I selected some all capitalized text in a title, wanting to make a macro to > change it to initial caps. Ran the macro, stopped it and it worked. Went to > the macros under "My macros" in the library to assign a shortcut key. Repeat the key combination

Re: [libreoffice-users] Basic : How to throw an events ?

2018-07-10 Thread Luuk
On 7-7-2018 19:58, Patrick Gelin wrote: > Hi, > > I know how to catch Event from formula by exemple, but I would like to > throw events myself with my code. I know also I've got the possibility > to use patterns like observator but if I could throw event it will be > nice ! Do you know an Uno

Re: [libreoffice-users] Executable File?

2018-06-07 Thread Luuk
On 7-6-2018 17:06, DaveB wrote: > On 07.06.2018 15:38, Peggy wrote: >> I need to choose the file that opens Libre Office writer for a another >> program's option. I can't recognize which file it is in my progarms. Can >> you tell me the name of the file I should choose? >> Thank you, >> Peggy >

Re: [libreoffice-users] Language not "picked" correctly

2018-06-06 Thread Luuk
t;>> >>> Henri added that I should go and chose the language option. Yes I >>> can do >>> that, and did so, but how many of the people who download LO will >>> not think >>> about that till they try to install the help packs? >>> >>&g

Re: [libreoffice-users] Language not "picked" correctly

2018-06-03 Thread Luuk
when using Chrome, specify the corrrect language in your browser - goto chrome://settings/ - select advanced - find 'langages' LibreOffice seems to be offered in the  first language you have there On 2-6-2018 21:30, Tim-L wrote: > > I am currently using Ubuntu 18.04 - - Language -

Re: [libreoffice-users] Writer interface font size

2018-05-12 Thread Luuk
On 12-5-2018 04:55, Thomas Blasejewicz wrote: > Good morning > Just installed LibreOffice 6.0.4 (on the computer where I had problems > with copying). > > Because I am getting older and my vision deteriorates, > the fist thing I always do with new/upgraded software is to increase > interface font

Re: [libreoffice-users] Deleting columns in empty spreadsheet

2018-05-02 Thread Luuk
On 2-5-2018 19:35, Krunose wrote: > On 02.05.2018 18:56, Luuk wrote: >> On 2-5-2018 16:51, Krunose wrote: >>> Hi, >>> >>> I just tried to delete all columns but first two in empty spreadsheet >>> and seams that Delete columns option after selecting

Re: [libreoffice-users] Deleting columns in empty spreadsheet

2018-05-02 Thread Luuk
On 2-5-2018 16:51, Krunose wrote: > Hi, > > I just tried to delete all columns but first two in empty spreadsheet > and seams that Delete columns option after selecting empty columns and > right clicking is doing nothing. > > Is it possible to have only two columns in Calc and handful of rows >

Re: [libreoffice-users] How many of you deal with the Linux Users Group [Facebook]?

2018-04-30 Thread Luuk
On 30-4-2018 17:11, James Knott wrote: > On 04/30/2018 08:32 AM, Virgil Arrington wrote: >> Today, I will be drafting the final exam for my students. I will use LO >> Writer for the task. I will then email it to my students and they will >> type their answers right onto the computer file and

Re: [libreoffice-users] How many of you deal with the Linux Users Group [Facebook]?

2018-04-30 Thread Luuk
On 30-4-2018 05:15, Tim-L wrote: > On 04/29/2018 01:17 PM, Luuk wrote: >> >> On 29-4-2018 17:23, James Knott wrote: >>> On 04/29/2018 10:23 AM, Tim-L wrote: >>>> There was a question in it about wondering how to get the users of >>>> Linux to

Re: [libreoffice-users] How many of you deal with the Linux Users Group [Facebook]?

2018-04-29 Thread Luuk
On 29-4-2018 17:23, James Knott wrote: > On 04/29/2018 10:23 AM, Tim-L wrote: >> There was a question in it about wondering how to get the users of >> Linux to save LibreOffice files to Microsoft Word formats. > Why would we want to, unless we had to? The whole point of the Open > Document

Re: [libreoffice-users] Calc: Calculate number of days until yesterday IE TODAY-1 to assist in array determination for COUNTIF?

2018-04-28 Thread Luuk
On 28-4-2018 09:14, Luuk wrote: > On 27-4-2018 18:04, Hylton Conacher (ZR1HPC) wrote: >> Hi, >> >> I am running LibreOffice 5.4.6.2 and am using a spreadsheet to enable >> me to draw graphs based on rainfall received per year, up until the >> date prior to

Re: [libreoffice-users] Calc: Calculate number of days until yesterday IE TODAY-1 to assist in array determination for COUNTIF?

2018-04-28 Thread Luuk
On 27-4-2018 18:04, Hylton Conacher (ZR1HPC) wrote: > Hi, > > I am running LibreOffice 5.4.6.2 and am using a spreadsheet to enable > me to draw graphs based on rainfall received per year, up until the > date prior to today. The figures also allow me to compare current > rainfall to date to the

Re: [libreoffice-users] [Copying slides from one presentation to another]

2018-04-07 Thread Luuk
> From: Virgil Arrington > Date: Wed, Apr 4, 2018 at 7:08 AM > Subject: Re: [libreoffice-users] [Copying slides from one presentation to > another] > To: "users@global.libreoffice.org" > > > I'm confused as to the flow of the discussion, and

Re: [libreoffice-users] avoiding recalculate on loading of Calc files

2018-02-08 Thread Luuk
make sure this is not checked  (before saving): Data/Calculate/AutoCalculate When re-opening, there should not be an automatic  recalclulation On 07-02-18 13:26, Philip Jackson wrote: > Using Calc 5.1.6.2 > > I would like a Calc file to load without recalculating so that I can > recalculate

Re: [libreoffice-users] macro to only change month

2018-01-28 Thread Luuk
On 28-01-18 16:30, Johnny Rosenberg wrote: > 2018-01-28 15:45 GMT+01:00 Luuk <luu...@gmail.com > <mailto:luu...@gmail.com>>: > > You can write a FUNCTION to get next month > > Function FirstOfNextMonth(dDate as Date) as Date

Re: [libreoffice-users] macro to only change month

2018-01-28 Thread Luuk
You can write a FUNCTION to get next month Function FirstOfNextMonth(dDate as Date) as Date     if Month(dDate)>=12 then         FirstOfNextMonth = DateSerial(Year(dDate)+1, 1, 1)     else         FirstOfNextMonth = DateSerial(Year(dDate), Month(dDate)+1, 1)     end if End Function When you use

Re: [libreoffice-users] Why are the people who answer users' questions are not getting counted?

2017-12-08 Thread Luuk
It's a crappy site anyways, because my username does not show here: https://ask.libreoffice.org/nl/users/?sort=name=4 On 08-12-17 17:48, Luuk wrote: I also do not use Ask Libreoffice But i do have (some) badges... ( 1gold, 1silver, 3 bronze) But, most important question, what can i do

Re: [libreoffice-users] Why are the people who answer users' questions are not getting counted?

2017-12-08 Thread Luuk
I also do not use Ask Libreoffice But i do have (some) badges... ( 1gold, 1silver, 3 bronze) But, most important question, what can i do with those badges BTW the link to 'Ask LibreOffice' is: https://ask.libreoffice.org On 08-12-17 16:56, Tim-L wrote: On the "Projects" list, there

Re: [libreoffice-users] Re: Another LO anti-feature

2016-12-22 Thread Luuk
why 1000 ? an option to make it not show at all is very much a better option On 22-12-16 00:13, V Stuart Foote wrote: For 5.2.4 search/replace will not show more that 1000 results to resolve tdf#92160 =-ref-=

Re: [libreoffice-users] Re: Bouncing messages from users@global.libreoffice.org

2016-12-20 Thread Luuk
me about the fact that the problem has gone, but If the problem has gone, automated stuped thing, than please automagically resend the message you where trying to send. and not some bullshit message that you where not able to , but now are able to :-):-(:-[:-[:-[ Luuk On 20-12-16 21

[libreoffice-users] Re: Bouncing messages from users@global.libreoffice.org

2016-12-19 Thread Luuk
Why twice the same message? Why this message at all? What am i missing? On 19-12-16 17:00, users+ow...@global.libreoffice.org wrote: Hi, this is the Mlmmj program managing the mailing list. Some messages to you could not be delivered. If you're seeing this

Re: [libreoffice-users] Version 5.2.3

2016-11-05 Thread Luuk
Maybe a good answer to this can be given if you specified the location from where you are downloading . On the download page i only see a link to a tar.xz version ( http://www.libreoffice.org/download/libreoffice-fresh/ ) On 04-11-16 02:00, MR ZenWiz wrote: I tried to download the

Re: [libreoffice-users] extracting data from uri

2016-07-20 Thread Luuk
On 18-07-16 18:20, Paolo Debortoli wrote: Hi. I am working on a calc sheet and need to insert data from an url: https://finance.google.com/finance/info?client=ig=NASDAQ%3aAAPL I guess it generates a csv output (in the browser it is like: // [ { "id": "22144" ,"t" : "AAPL" ,"e" : "NASDAQ"

Re: [libreoffice-users] Calc HH:MM:SS to decimal

2016-05-05 Thread Luuk
On 05-05-16 18:52, Bruce Hohl wrote: Try this in cell A2 "=VALUE(A1)*24" On Thu, May 5, 2016 at 12:44 PM, Russell wrote: does anyone know if there is a formula for a cell that will transform the HH:mm:ss from another cell into a decimal equivalent? example: Cell A1

Re: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

2016-05-05 Thread Luuk
On 05-05-16 11:12, Piet van Oostrum wrote: Luuk wrote: > > Are you saying that there are still 'hidden formated text' things in the > textfile that is created when one does do 'File/SaveAs/.txt' ?? > Save as .txt des save all text, including hidden text. Just try it out.

Re: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

2016-05-05 Thread Luuk
On 03-05-16 19:13, Walther Koehler wrote: Hallo, Am Dienstag, 3. Mai 2016 schrieb Bruce Hohl: Do you have some advice how to remove the hidden (hard-)formatted text in a simple way? File > Save :: Save as type = Text (.txt) OR Text - Choose Encoding (.txt) Thus, LO can be used to read,

Re: [libreoffice-users] advanced filter to filter out huge amount of not equal data

2016-01-30 Thread Luuk
On 30-01-16 01:12, gordom wrote: Hello everyone. How to filter out data in Calc to exclude huge series of data? If I want to filter out not equal data now, I use advanced filter. I put an operator "<>"in front of criteria data and transpose these criteria from rows to columns. What can I do

Re: [libreoffice-users] Re: LOBase Query - Left or Right Join?

2016-01-02 Thread Luuk
On 01-01-16 22:08, Paul Steyn wrote: Hi Don, Your SELECT statement is indeed incorrect; it seems as though you don't fully understand joins (I could be mistaken, but your syntax is off by enough to suggest this). Firstly, choose a format for your SELECT statement to make it easier to read.

Re: [libreoffice-users] LOBase Query - Left or Right Join?

2016-01-01 Thread Luuk
On 01-01-16 13:08, Don Parris wrote: Hi all, I have a set of tables for contacts, and a somewhat complex query that seeks all the available contact information on a subset of the contacts. By "incomplete result set", I mean I have one contact that does not show up in the query results, but

Re: [libreoffice-users] Re: LOBase Query - Left or Right Join?

2016-01-01 Thread Luuk
reply below On 01-01-16 18:06, Don Parris wrote: Update: I did try re-writing the query with LEFT/RIGHT JOINS, but all I get are syntax errors. Maybe I have my SQL statement incorrect? SELECT "tCoreCategory"."category", "tCntEntity"."entity_name", "tCntPerson"."first_name",

Re: [libreoffice-users] command line options

2015-12-24 Thread Luuk
On 24-12-15 02:18, John R. Sowden wrote: I want a link (launcher?) on my ubuntu 14.04 box to run LO in a directory that I specify without opening a specific file. I entered the "working directory" and the approved execution name (/usr/bin/libreoffice). Problem is LO comes up in, I think,

Re: [libreoffice-users] Creating Labels

2015-11-29 Thread Luuk
On 29-11-15 15:11, Herbie wrote: Is there anyway to create address labels within Libre Office Thanks https://ask.libreoffice.org/en/question/32886/how-do-i-create-labels-from-a-spreadsheet/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] writer-how to delete a carriage return in a cell of a table

2015-11-14 Thread Luuk
On 14-11-15 10:39, yahoo-pier_andreit wrote: on my PC=Dell latitude E6510, RAM=8Gb, GPU=GT218 NVS 3100M, CPU=i7 Q 720 @ 1.60GHz, OS=opensuse 13.2 KDE= 4.14.9 with libreoffice Version: 5.0.3.1 Build ID: 00m0(Build:1) Locale: en-US (en_US.UTF-8) I have a table with 2 columns and about 10 rows

Re: [libreoffice-users] Compatibility

2015-10-31 Thread Luuk
On 26-10-15 20:34, toki wrote: * EuroOffice: A European Fork of OOo; EuroOffice cannot be found on the internet, just found 1 link here from 2008 https://wiki.apache.org/incubator/OpenOfficeProposalin the picture 'The Legacy of OpenOffice.org' * AnOO: An Android fork of OOo; * AOo:

Re: [libreoffice-users] Compatibility

2015-10-26 Thread Luuk
On 26-10-15 19:44, toki wrote: MSO, EO, LibO, AnOO, etc. What do these abreviations mean? MSO - Microsoft Office (this is a guess!) EO - because i'm Dutch, the first thing i think about is 'Evangelische Omroep' (http://www.eo.nl) But that has nothing to do with an Office package..

Re: [libreoffice-users] LibreOffice 5.0 does not open

2015-09-13 Thread Luuk
On 13-09-15 15:26, Tim---Kracked_P_P---webmaster wrote: If you are getting the same error[s], then it may be that Win XP does not like to run LibreOffice 5.x.x TDF release builds require Windows Vista or later. ( see: https://wiki.documentfoundation.org/ReleaseNotes/5.0#Windows ) -- To

Re: [libreoffice-users] LibreOffice Damaged

2015-09-12 Thread Luuk
On 12-09-15 00:13, Taang Zomi wrote: I had my laptop computer (Toshiba Satellite L55-B5276; Windows 8.1) repaired, and when I got it back, I found that my LibreOffice (4.4.4) could not be used. I got a message: == LibreOffice 4.4.4 -- Fatal Error

Re: [libreoffice-users] Open from Explorer in Windows 10 not working

2015-08-04 Thread Luuk
On 2-8-2015 21:35, Brian Barker wrote: At 20:45 02/08/2015 +0200, you wrote: When double clicking on a file (filename.ods) to open it in Calc (4.4.5) it shows a popup 'How do you want to open this file?' I tried to choose the correct executable (C:\Program Files (x86)\LibreOffice

Re: [libreoffice-users] Open from Explorer in Windows 10 not working

2015-08-03 Thread Luuk
On 2-8-2015 21:35, Brian Barker wrote: At 20:45 02/08/2015 +0200, you wrote: When double clicking on a file (filename.ods) to open it in Calc (4.4.5) it shows a popup 'How do you want to open this file?' I tried to choose the correct executable (C:\Program Files (x86)\LibreOffice

Re: [libreoffice-users] Open from Explorer in Windows 10 not working

2015-08-03 Thread Luuk
On 3-8-2015 07:59, Luuk wrote: On 2-8-2015 21:35, Brian Barker wrote: At 20:45 02/08/2015 +0200, you wrote: When double clicking on a file (filename.ods) to open it in Calc (4.4.5) it shows a popup 'How do you want to open this file?' I tried to choose the correct executable (C:\Program Files

[libreoffice-users] Open from Explorer in Windows 10 not working

2015-08-02 Thread Luuk
When double clickking on a file (filename.ods) to open it in Calc (4.4.5) it shows a popup 'How do you want to open this file?' see: http://postimg.org/image/t6uuzx625/ I tried to choose the correct executable (C:\Program Files (x86)\LibreOffice 4\program\scalc.exe), but this fails also

Re: [libreoffice-users] Calc. Convert date DD to number

2015-08-01 Thread Luuk
On 1-8-2015 11:16, IGraham wrote: Hello Looking for an easy way to from a date (say) 03/05/2015 get just the day value as a number value not a date value, would like to have just '3' but '31' would do Do know of =Text(cell,DD) but text is not directly number =DAY(cell) -- To unsubscribe

Re: [libreoffice-users] Calc. Convert date DD to number

2015-08-01 Thread Luuk
On 1-8-2015 11:16, IGraham wrote: Hello Looking for an easy way to from a date (say) 03/05/2015 get just the day value as a number value not a date value, would like to have just '3' but '31' would do Do know of =Text(cell,DD) but text is not directly number =DAY(cell) there's also the

Re: [libreoffice-users] Linux alternative

2015-07-18 Thread Luuk
On 17-7-2015 23:47, Gary Dale wrote: On 17/07/15 05:25 PM, charles meyer wrote: For those on the list using or contemplating Linux, this was interesting. Frankly though, I'm confused as to why more software vendors don't compile to libwine . libwine is about 'bondage'.. It

Re: [libreoffice-users] Linux alternative

2015-07-18 Thread Luuk
On 18-7-2015 18:00, Gary Dale wrote: Windows is like a pyramid scheme that way. They sucker developers into using only their products so that users have no choice but to buy licenses to run their products properly. And that is exactly why you should not _DEVELOP_ using libwine (using it,

Re: [libreoffice-users] date

2015-07-05 Thread Luuk
On 5-7-2015 11:51, Dr. Martin Hennegriff wrote: Dear Sir, Libreoffice provides two date functions: a 'fixed' version and a 'dynamic' one. Q: How can I change the default? Regards, Since you only have a 'fixed' and a 'dynamic' one, you cannot change the 'default' one. ;) (Or, more

Re: [libreoffice-users] date

2015-07-05 Thread Luuk
On 5-7-2015 19:05, Gary Dale wrote: On 05/07/15 12:39 PM, Luuk wrote: On 5-7-2015 11:51, Dr. Martin Hennegriff wrote: Dear Sir, Libreoffice provides two date functions: a 'fixed' version and a 'dynamic' one. Q: How can I change the default? Regards, Since you only have a 'fixed

Re: [libreoffice-users] Editing an html page

2015-07-01 Thread Luuk
On 1-7-2015 20:21, Regina Henschel wrote: Hi John, I guess, you run into this bug https://bugs.documentfoundation.org/show_bug.cgi?id=48887 If it is true that LO cannot open a file, . than you have a point I create a file with an image in it, saved it ad html, and sucessfully opened it

Re: [libreoffice-users] Editing an html page

2015-07-01 Thread Luuk
On 1-7-2015 20:04, john.egger wrote: Please pardon me if I do not use the correct terminology. I do not know html. About a year ago I was able to open and edit my website's home page, index.html, using LO (Writer, I think). It looked just like the web page itself, but could be edited and then

Re: [libreoffice-users] open files automatically

2015-05-31 Thread Luuk
On 31-5-2015 20:08, Luuk wrote: On 27-5-2015 03:22, Thomas wrote: Good morning from Japan Maybe (I do not remember exactly) I did ask the same question years ago. Is there a trick to tell LibreOffice, in particular Calc, to open files automatically? For the last 15 years or so I have been

Re: [libreoffice-users] open files automatically

2015-05-31 Thread Luuk
'autostartLibreoffice.bat' (or anything else, as long as the name ends in '.bat' The contents of this file should be the names of the files you want to be opened. so, something like (other locations are OK too ;): C:\Users\Luuk\My Documents\TEST1.ods C:\Users\Luuk\My Documents\TEST1.odt When

Re: [libreoffice-users] Re: open files automatically

2015-05-31 Thread Luuk
On 31-5-2015 20:59, Pedro wrote: Hi Luuk Luuk wrote There's no need to automate Calc (or LO) simply create a file name it something like 'autostartLibreoffice.bat' (or anything else, as long as the name ends in '.bat' That has been suggested before. The OPs request is that LibreOffice

Re: [libreoffice-users] My Fix for Slow LibreOffice Calc

2015-05-23 Thread Luuk
On 22-5-2015 00:56, f150 wrote: The advice for speeding up Calc is correct, but the memory recommendations weren't robust enough for my system. This worked great: . I think the next release will work better, see: https://wiki.documentfoundation.org/BugHunting_Session_5.0.0.0

Re: [libreoffice-users] Multi-source Mail Merge

2015-05-10 Thread Luuk
On 9-5-2015 20:40, A wrote: I have multiple spreadsheet files that each represent one unique item. As an analogy, think of the spreadsheet as a basket that contains a variety of eggs (both calculated and hand-entered data). I have multiple baskets each with multiple eggs. Each basket

Re: [libreoffice-users] Find Replace first character broken?

2015-05-08 Thread Luuk
On 8-5-2015 16:36, Paul D. Mirowsky wrote: Sorry about the lack of clarity. I am opening a 'csv' document in Writer. When using Find and Replace with Regular Expression checked and Search for using characters ^.. I click on Find Next button. With cursor on position 1,1 of document, it finds

Re: [libreoffice-users] column limit in libreoffice 4.3.something

2015-04-23 Thread Luuk
On 23-4-2015 20:39, yahoo-pier_andreit wrote: today I encountered a problem opening an excel file with libreoffice 4.3.something regarding maximum number of column, why number of columns is so low in libreoffice ??? many thanks, ciao :-) pier - Please, define 'so low' i see 1024 columns in

Re: [libreoffice-users] Calc and number of copies does not work

2015-04-12 Thread Luuk
On 12-4-2015 11:11, Rafnews wrote: Hi, i have a weird behavior on Calc. When i want to print 20 times the same spreadsheet (http://prntscr.com/6srcnl) i can set 20 as number of copies, it always just print me 1 page :( what am i doing wrong ? Because you entered '1' in your screendump? ;)

Re: [libreoffice-users] Calc and number of copies does not work

2015-04-12 Thread Luuk
On 12-4-2015 14:30, Luuk wrote: On 12-4-2015 11:11, Rafnews wrote: Hi, i have a weird behavior on Calc. When i want to print 20 times the same spreadsheet (http://prntscr.com/6srcnl) i can set 20 as number of copies, it always just print me 1 page :( what am i doing wrong ? Because you

Re: [libreoffice-users] Paste working using c# code

2015-04-05 Thread Luuk
On 5-4-2015 16:38, Tom Davies wrote: Hi :) Sorry no-one has been able to reply so far! I think the Devs mailing list or irc (or whatever) channel might be more useful! Regards from Tom :) On 3 April 2015 at 14:03, vighnaharmone vighnahar.m...@upcrest.com wrote: Hi, I had just started to

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

2015-02-07 Thread Luuk
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,

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

2015-02-07 Thread Luuk
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

Re: [libreoffice-users] Re: Google Sheets QUERY and Calc equivalent

2015-01-01 Thread Luuk
On 1-1-2015 15:32, Marc Paré wrote: Le 2014-12-31 12:57, Luuk a écrit : On 31-12-2014 15:01, Alex Thurgood wrote: Le 31/12/2014 14:36, Marc Paré a écrit : Hi Marc, Is there an equivalent Calc function for the Google Sheets function QUERY? When I downloaded my spreadsheet from Google Sheets

  1   2   3   >