[libreoffice-users] Re: Query
Hi :) @ Ernest, errr, if you could upload your screen-shot or file to Nabble that might help get some advice from Alex and the others here. Follow the links to Nabble and in the correct thread reply to any suitable post. Just above where you type in the message is a row of buttons with the last being "More". The top one there is "upload" which works much the same as upload an attachment to an email except that it puts a line of html code into the message. You can move the inserted code around a bit if you need to, or even edit it if you are comfortable with html @ Alex, thanks for the insights and summary there. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Query-tp4092886p4093177.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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: Query
** Reply to message from Alex Thurgood on Mon, 20 Jan 2014 09:19:13 +0100 > Le 19/01/2014 16:02, Tom Davies a écrit : > > Tom, > > > Can Base directly connect to a Lotus Approach database and use it as > > the back-end? > > No. Never has and probably never will. > > > > > @Ernest, Have you still got access to the old Windows and thus the > > Lotus Approach directly or was this an upgrade (or a machine exchange > > or some sort)? I take it you exported the data as a ".csv" file and > > that is what is looking like a flat spreadsheet? > > Lotus Approach saves its databases as an APR file extension, but the > actual data is stored as a group of DBF tables. Any binary (e.g. image) > data or extended character data (Memo fields, etc) are stored in a > separate DBT file which is referenced in some way by the APR file and > thus appears in the DBF file that contains the binary field. > > > It was/is for its time a brilliant piece of kit that held its own with > Access and FMPro. It had an accessible UI and form builder, had a fairly > competent SQL parser, and could even be scripted with Lotus Smartscript. > In fact, from the user perspective, it was "intuitive", everything which > LO Base is not. I fully understand why people have stuck with it. > However, it was essentially, single OS (well it did run on OS/2 as well > for a while in Windows compatibility mode), as the software was provided > for the Windows platform only. Alex, Slight correction, Approach was written for OS/2 Warp4 as well as Windoz. I am using ver 1.6 on eCS running in VBox on my Mac. As you say it is very intuitive and easy to make queries. I would change over to Base if it was straight forward, but there's no way Base would be anywhere near as easy to use so I'm sticking to eCS. Cliff -- To unsubscribe e-mail to: users+unsubscr...@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] Help needed with LibreOffice Calc 4.1.3.2
Hi! This is my first time posting to the mailing list. :) A client of mine is in need of editing some Excel spreadsheets on her shiny new Windows 8 system. I installed LibreOffice 4.1.3 and it mostly works but she's not able to do some of the things she used to do with MS Excel 2000. Primarily, she wants to be able to change the color of hyperlinks of email addresses. In MS Excel 2000, she could simply select the column of email addresses and change the color to black or any other color and the color of the links changes. In Calc, we select the column of email address and change the text color to black and the hyperlinks remain blue. I did some web searching and found I needed to edit the hyperlink style, but that appears to be only for cells that use the "HYPERLINK" formula (if that's what it's called) and not on cells that have email addresses listed that aren't using "HYPERLINK" syntax. I have a test Excel spreadsheet (generated with MS Excel 2000) I can send, if necessary. Any ideas on how I can get the color of the email address links to change color? She would like to preserve the links, in the spreadsheet, as she'll occasionally click them to send messages from Mozilla Thunderbird. Also, is it possible to adjust the thickness of grid lines shown in a spreadsheet, if we enable display of grid lines? Thanks in advance! Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+unsubscr...@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] CeBit Exhibiton
I just saw on the LibO homepage https://www.libreoffice.org/default/ the great news that LibO gets shown at the CeBit in Hannover. This will expose LibO also to large, medium, and small size enterprises as well as to a very large audience which regards the CeBit as a leading exhibition. ROSt52 -- To unsubscribe e-mail to: users+unsubscr...@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] cancel lines with the (almost) the same timestamp
Brian Barker wrote:
>At 09:26 20/01/2014 -0800, Hugo Borrell wrote:
>>I download big raw data containing that is supposed to show minute
>>per minute quotation of an index (SP500). The problem is that some
>>quotations have been included twice in the same minute (at some
>>seconds of distance)
>>
>>I tried to clean that manually but it appears to be a huge work. I'd
>>like to have a smarter way to ask calc to keep only one data of each
>>minute time
>>
>>How could that be solved ?
>
>Let's imagine your values are in columns A to F.
>
>o I'm guessing that, if you need only one value per minute, you don't
>need to know the seconds value of the timestamp. In a spare column,
>enter
>=ROUNDDOWN(A5*24*60)/24/60
Would =FLOOR(A5,1/1440) accomplish the same thing and if so wouldn't it be more
efficient?
> This will round your
>timestamps to complete minutes. Now copy this column and paste it
>back over column A
Why? I would think that both columns could be retained thus eliminating a
manual operation.
I would also think, Brian, that a pivot table involving this modified time and
averaging the market quotes would replace your following steps but I may know
too little about pivot tables.
When collecting data I dislike copying and pasting (special or not). I
especially dislike wiping out formulas. I am guessing that the original poster
is somehow gathering the data automatically ("automagically") and it is being
viewed in semi real time. How this is being accomplished I don't know.
>o At a convenient place, perhaps elsewhere on the sheet or on another
>sheet, create a list of times containing only one value per
>minute. (I'm going to assume that these values are also in column A
>starting at row n.) To do this, enter the first two values manually
>(here 2013-10-11 13:47:00 and 2013-10-11 13:48:00), select both, and
>then fill them down the column as necessary. Now all you need to do
>is to harvest the appropriate values for subsequent columns.
>
>o In Bn, enter
>=VLOOKUP($An;$A$1:$F$999;COLUMN();0)
>(with the real row number in place of "n" and the real final row
>number in place of "999", of course). First fill this formula down
>column B. Then select all the relevant cells in column B (containing
>this formula, as modified) and fill these across columns C to F.
>
>How does it work? Then VLOOKUP() function searches the first column
>of the range of original data for the first occurrence of the
>appropriate timestamp. When it finds a match, it copies the value
>from the appropriate later column. Using COLUMN() in place of an
>explicit column number allows the formula to adjust automatically for
>later columns. (If your cleaned data are not in columns A to F, you
>will need to modify this parameter to COLUMN()-1 or whatever.) The
>final parameter needs to be zero (or FALSE) to indicate that if there
>is no value for that minute, you will (presumably) want to see an
>error condition instead of a value unhelpfully harvested from a nearby
>minute.
>
--
Jim
--
To unsubscribe e-mail to: users+unsubscr...@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] cancel lines with the (almost) the same timestamp
At 09:26 20/01/2014 -0800, Hugo Borrell wrote: I download big raw data containing that is supposed to show minute per minute quotation of an index (SP500). The problem is that some quotations have been included twice in the same minute (at some seconds of distance), for example here 2013-10-11 13:47:51;1701.0601;1701.21;1701;1701;696500 2013-10-11 13:47:57;1701.02;1701.21;1700.99;1700.99;644100 2013-10-11 13:48:51;1700.97;1700.97;1700.7;1700.7;496500 2013-10-11 13:49:51;1700.67;1700.67;1700.53;1700.53;369700 2013-10-11 13:49:57;1700.6801;1700.6801;1700.52;1700.52;374800 2013-10-11 13:50:57;1700.51;1700.51;1700.35;1700.37;441100 I tried to clean that manually but it appears to be a huge work. I'd like to have a smarter way to ask calc to keep only one data of each minute time, like this : 2013-10-11 13:47:51;1701.0601;1701.21;1701;1701;696500 2013-10-11 13:48:51;1700.97;1700.97;1700.7;1700.7;496500 2013-10-11 13:49:51;1700.67;1700.67;1700.53;1700.53;369700 2013-10-11 13:50:51;1700.47;1700.47;1700.35;1700.35;444900 The hard part is that not all minutes have twins (erasing one out of two wouldn't do) : here only 13:49 was twinned. How could that be solved ? Let's imagine your values are in columns A to F. o I'm guessing that, if you need only one value per minute, you don't need to know the seconds value of the timestamp. In a spare column, enter =ROUNDDOWN(A5*24*60)/24/60 and fill or copy that down the column. This will round your timestamps to complete minutes. Now copy this column and paste it back over column A (replacing your original values), but using Paste Special... instead of ordinary Paste and ensuring "Paste all" and Formulas are *not* ticked in the Paste Special dialogue. o At a convenient place, perhaps elsewhere on the sheet or on another sheet, create a list of times containing only one value per minute. (I'm going to assume that these values are also in column A starting at row n.) To do this, enter the first two values manually (here 2013-10-11 13:47:00 and 2013-10-11 13:48:00), select both, and then fill them down the column as necessary. Now all you need to do is to harvest the appropriate values for subsequent columns. o In Bn, enter =VLOOKUP($An;$A$1:$F$999;COLUMN();0) (with the real row number in place of "n" and the real final row number in place of "999", of course). First fill this formula down column B. Then select all the relevant cells in column B (containing this formula, as modified) and fill these across columns C to F. How does it work? Then VLOOKUP() function searches the first column of the range of original data for the first occurrence of the appropriate timestamp. When it finds a match, it copies the value from the appropriate later column. Using COLUMN() in place of an explicit column number allows the formula to adjust automatically for later columns. (If your cleaned data are not in columns A to F, you will need to modify this parameter to COLUMN()-1 or whatever.) The final parameter needs to be zero (or FALSE) to indicate that if there is no value for that minute, you will (presumably) want to see an error condition instead of a value unhelpfully harvested from a nearby minute. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@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] Help with Base report
Hi, I am new to this list and need some help with Base. Can anyone help me to create a list report which has one field that may expand to more that one text line? Most lines of the report in the detail report section are just one line deep. However, a few fields may wrap round to more than on line, so the height of the corresponding text box needs to be expandable and, of course, the height of the detail section as well. (i.e. similarly to MS Access - sorry, I'll wash my mouth out ;-)). Cheers Harvey -- To unsubscribe e-mail to: users+unsubscr...@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: Use Base as back end(SOLVED)
On 01/20/2014 11:44 AM, Alex Thurgood wrote: > Le 20/01/2014 16:11, Mark LaPierre a écrit : > > Hi Mark, > >> Is it possible to link Libreoffice Base as a front end to tables in >> another Libreoffice Base as a back end? > > Not that I know of, as the embedded hsqldb which is the default db > engine in an ODB file created with LO is mono-user by design. > > What can be done, however : > > https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=58337 > > https://wiki.openoffice.org/wiki/FAQ_%28Base%29 > > https://forum.openoffice.org/en/forum/viewtopic.php?f=83&t=17567 > > This enables you to have multi-user access to a hsqldb database via an > ODB file. > > It is not possible to do what I had envisioned due to the single user paradigm of the built in hsqldb database. To pull it off you need to install a local copy of the hsqldb database from this URL http://sourceforge.net/projects/hsqldb/files/ Having done that you can then create a new Base front end linked to the newly installed hsqldb hsqldb.jar file using the JDBC driver. Once you have that done you can create tables to your heart's delight. As long as you have the hsqldb database located in a directory that is shared on the network you can access the tables from anywhere on the network. -- _ °v° /(_)\ ^ ^ Mark LaPierre Registered Linux user No #267004 https://linuxcounter.net/ -- To unsubscribe e-mail to: users+unsubscr...@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] cancel lines with the (almost) the same timestamp
Hello, I download big raw data containing that is supposed to show minute per minute quotation of an indice (SP500). The problem is that some quotations have been included twice in the same minute (at some seconds of distance), for example here 2013-10-11 13:47:51;1701.0601;1701.21;1701;1701;696500 2013-10-11 13:47:57;1701.02;1701.21;1700.99;1700.99;644100 2013-10-11 13:48:51;1700.97;1700.97;1700.7;1700.7;496500 2013-10-11 13:49:51;1700.67;1700.67;1700.53;1700.53;369700 2013-10-11 13:49:57;1700.6801;1700.6801;1700.52;1700.52;374800 2013-10-11 13:50:57;1700.51;1700.51;1700.35;1700.37;441100 I tried to clean that manually but it appears to be a huge work. I'd like to have a smarter way to ask calc to keep only one data of each minute time, like this : 2013-10-11 13:47:51;1701.0601;1701.21;1701;1701;696500 2013-10-11 13:48:51;1700.97;1700.97;1700.7;1700.7;496500 2013-10-11 13:49:51;1700.67;1700.67;1700.53;1700.53;369700 2013-10-11 13:50:51;1700.47;1700.47;1700.35;1700.35;444900 The hard part is that not all minutes have twins (erasing one out of two would'nt do) : here only 13:49 was twined. How could that be solved ? -- View this message in context: http://nabble.documentfoundation.org/cancel-lines-with-the-almost-the-same-timestamp-tp4093136.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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: LibreLogo tutorial
Den 20.01.2014 15:57, skreiv Kracked_P_P---webmaster: On 01/20/2014 05:49 AM, Kolbjørn Stuestøl wrote: Den 19.01.2014 21:51, skreiv Denis J Navas: From the integrated help, search for 'Logo': Consulte http://www.numbertext.org/logo/librelogo.pdf Yes, I recognized this, and it is a good start, but I hoped to find some more tips on using LibreLogo or even someone using it. Tom: It looks like LobreLogo is one of the more or less hidden secrets of LibreOfice. Kolbjoern Page 18 gives you the needed extension, but it gives you the 1.0 version by default. You need to click on the 2.0 release version to download that one. I am running LibreLogo on LibreOffice 4.2.0.2. Do not know which LibreLogo version. It is a part of the package, not an extension. How to find LibreLogo in LibreOffice: View -> Toolbars -> Logo. Click on one of the icons on the Logo toolbar to get the turtle visible. In help, search for Logo and click on the "LibreLogo Toolbar". I forgot about Logo. I remember seeing it over 20 years ago but never really had any need to learn it. For controlling a "robot", this would be the first step in learning how to move it the way you want to. I have a Robosapien X and it has controls for movement of left, right, forward, and back. So Logo can teach you how to think in terms of robot movement and then later "translate" what you learned to the type of movement a different "robot" uses, whether on wheels or legs. I still have not learn how to program my Christmas present to myself, i.e. the Robosapien X, since I have not had the time to do so. Have fun with your robot. :-) Kolbjoern -- To unsubscribe e-mail to: users+unsubscr...@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: Use Base as back end
Le 20/01/2014 16:11, Mark LaPierre a écrit : Hi Mark, > Is it possible to link Libreoffice Base as a front end to tables in > another Libreoffice Base as a back end? Not that I know of, as the embedded hsqldb which is the default db engine in an ODB file created with LO is mono-user by design. What can be done, however : https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=58337 https://wiki.openoffice.org/wiki/FAQ_%28Base%29 https://forum.openoffice.org/en/forum/viewtopic.php?f=83&t=17567 This enables you to have multi-user access to a hsqldb database via an ODB file. Alex -- To unsubscribe e-mail to: users+unsubscr...@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] Use Base as back end
Hey Y'all, Is it possible to link Libreoffice Base as a front end to tables in another Libreoffice Base as a back end? I'm trying to set up a recipe database where the tables are kept in a Base back end. I don't want multiple versions of the recipe database with different recipes in each located in each user's home. I want all user front ends to share the same data. I will not have more than ten users accessing the data. If there is documentation that describes the process of connecting to a Base back end please provide a URL for that. I've looked at the documentation at: https://wiki.documentfoundation.org/Documentation/Publications but I can't find instructions for this type of connection. -- _ °v° /(_)\ ^ ^ Mark LaPierre Registered Linux user No #267004 https://linuxcounter.net/ -- To unsubscribe e-mail to: users+unsubscr...@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: LibreLogo tutorial
On 01/20/2014 05:49 AM, Kolbjørn Stuestøl wrote: Den 19.01.2014 21:51, skreiv Denis J Navas: From the integrated help, search for 'Logo': Consulte http://www.numbertext.org/logo/librelogo.pdf Yes, I recognized this, and it is a good start, but I hoped to find some more tips on using LibreLogo or even someone using it. Tom: It looks like LobreLogo is one of the more or less hidden secrets of LibreOfice. Kolbjoern Page 18 gives you the needed extension, but it gives you the 1.0 version by default. You need to click on the 2.0 release version to download that one. I forgot about Logo. I remember seeing it over 20 years ago but never really had any need to learn it. For controlling a "robot", this would be the first step in learning how to move it the way you want to. I have a Robosapien X and it has controls for movement of left, right, forward, and back. So Logo can teach you how to think in terms of robot movement and then later "translate" what you learned to the type of movement a different "robot" uses, whether on wheels or legs. I still have not learn how to program my Christmas present to myself, i.e. the Robosapien X, since I have not had the time to do so. -- To unsubscribe e-mail to: users+unsubscr...@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: having 2525 defined colors to choose from within LO
Some colors may have different names, depending on language and geographic regions. Some colors have different spellings, depending on the language used. Also, the real problem is that some color names are defined differently by regions or who you get the color list from. I have seen Aqua a little darker than Cyan, cyan being one of the primary printer ink colors and the name of aqua is not. So they are not interchangeable in some applications and my need different "acceptable" names for different applications. I have seen Gray spelled both ways, but gray is what I use since my American English spell checking in Thunderbird tells me "grey" is misspelled. Other languages may use "grey" instead of the other spelling. On 01/19/2014 06:37 PM, Peter West wrote: For example, apropos an earlier discussion on this list, see http://www.numbertext.org/logo/librelogo.pdf p52 "Color names." In 25 basic colours three duplicates: aqua+cyan, fuchsia+magenta and gray+grey. Peter West "Those who are well have no need of a physician, but those who are sick..." -- To unsubscribe e-mail to: users+unsubscr...@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: having 2525 defined colors to choose from within LO
On 01/20/2014 07:10 AM, Alex Thurgood wrote: Le 19/01/2014 16:54, Kracked_P_P---webmaster a écrit : Hi, You have just made my day - many thanks for all this work !! Alex I am working out the "bug" in color issues. I have been given feed back about color duplicates and colors not working correctly. I have printed these out and will work on the information in them. I did not go through all of the 2525 color lines, and many of those lines were given to me, as is, like the Crayola colors. Some duplicates may be in color sequences, so they need to stay. Some are not and can be removed. Some non-working colors will be fixed or removed [as the case with the colors I was given]. Some of the colors only have a hex code for their names, since those colors are a sequence of color shading and did not have names assigned to them. I feel that just calling them things like "red hue 15 shading 3" would not be any good, since it would be a made up name. Yes, all of the names have been made up, but I will not create names for these colors, like "rosemary pink" or "coral sea foam green". How paint companies come up with these color names is a mystery to me. Of course, some say there are too many colors to choose from. Some would like more colors. I was thinking about looking into more colors and their shading towards white. The red hues need to be found and the shadings. Maybe some of the named colors could be placed in hue order instead of alphabetical order. -- To unsubscribe e-mail to: users+unsubscr...@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: having 2525 defined colors to choose from within LO
On 01/19/2014 07:49 PM, Mark LaPierre wrote: On 01/19/2014 06:26 PM, Kracked_P_P---webmaster wrote: Printed it out Will update it soon. As I stated before, there may be duplicates. I took several lists and converted them outside the main file and then added them. Sometimes certain colors in a color sequence should be kept, even if it is a repeat. But I will look at each case. On 01/19/2014 12:15 PM, Tom Davies wrote: Hi :) Good bit of proof-reading there! I can't believe how quickly this has come together. For years i have been wondering why the colour selection was so pitiful. I've been using quite a long work-around or just putting up with it. Regards from Tom :) On 19 January 2014 17:09, Luuk wrote: On 19-01-2014 16:54, Kracked_P_P---webmaster wrote: For those who have been looking at my "color postings", I have been adding colors to the "standard.soc" file so there are many more defined colors to choose from withing Writer, Calc, etc., for things like font color and shading, or cell backgrounds. I took the original file and added the LO branding colors, and decided to go from there. With the help from a fellow user, added some colors to that list from some I had and some he had. I added gray and 99 different shades of it - i.e. 1% to 99%. At that point, I still wanted more. I found colors like Gold, Silver, Bronze, Brass, etc. and added them in. Then I added the colors from a set of color tables where they took one color and kept lightening it up 6 times, for a total of 7 color blocks. There were 7 colors per table making each one 77 colors. This added 462 colors to the color blocks you see. So now, I have 2525 color blocks, if my count is correct. For Ubuntu users, you have to look into the hidden dot folders to find the "standard.soc" file. ".config/libreoffice/4/user/config" where it is on other systems, I do not know. I have not added it to my Windows systems, yet, but will find the file later. So here is the download file link. It should work fine, but I am still new at using the "ownCloud" system. https://owncloud.documentfoundation.org/Common/QA/New-Colors/standard.soc--jan-19--10_26am---2525-color-blocks.txt Total colors in that file : 2525 Total unique colors in that file: 2366 The following colors are named more than two times: (color # is found 6 times, color #80 is found 4 times, etc) # color 6 00 4 80 3 0066cc 3 008080 3 00 3 33 3 66 4 800080 3 808000 3 99 3 b3b3b3 3 c0c0c0 3 cc 3 ff 3 ff00ff 3 ff4500 4 ff9966 5 66 3 ff -- To unsubscribe e-mail to: users+unsubscr...@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 Okay, I downloaded the file to my HD. It is a .txt file. I used locate to find the standard.soc file on my machine. It is in .xml format. I moved the original standard.soc file to standard.soc.old. I copied the standard.soc--jan-19--10_26am---2525-color-blocks.txt to the same location and renamed it standard.soc. It's in html file. I guess I should get to the question now. What am I supposed to do with that file? The new one should be renamed to "standard.soc". Then restart LO. The .xml and .html files are actually text files, but they have "controlling tags" withing them to make them usable as .html and .xml files to other packages. This is the same with many program coded files. The .soc file had the extension of ".soc" but reads as a text file in text editors. -- To unsubscribe e-mail to: users+unsubscr...@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: having 2525 defined colors to choose from within LO
Le 19/01/2014 16:54, Kracked_P_P---webmaster a écrit : Hi, You have just made my day - many thanks for all this work !! Alex -- To unsubscribe e-mail to: users+unsubscr...@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] Donations and Contribution
Hello. I have been using LibreOffice for some time now (ever since it started coming pre-installed in Ubuntu) and I have found it to be an extremely functional and comprehensive Office Suite. I would like to donate to this project at the moment (monetary) since my exams are coming up and I do not have time to contribute in any other way, at least, at this point of time. I live in India, and I am confused as to how I should make a donation. I cannot do it via PayPal because I do not have a PAN Card. Is there a surefire (and if possible, convenient) way for people in India to donate? Dantin Kakkar -- To unsubscribe e-mail to: users+unsubscr...@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: LibreLogo tutorial
Den 19.01.2014 21:51, skreiv Denis J Navas: From the integrated help, search for 'Logo': Consulte http://www.numbertext.org/logo/librelogo.pdf Yes, I recognized this, and it is a good start, but I hoped to find some more tips on using LibreLogo or even someone using it. Tom: It looks like LobreLogo is one of the more or less hidden secrets of LibreOfice. Kolbjoern -- To unsubscribe e-mail to: users+unsubscr...@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] Too many choices - not only colors
Hi, some time ago Kracked_P_P--webmaster has asked about possibilities, how to add more colors to LO. While there should be possibilities, how to do that, my problem is quite opposite. For me, there are too many colors to choose from. I am lost in the (for me too large) table of colors. For example, I do not know how to choose a color, which is the same as some text elsewhere. It is even not possible to compare the colors visually (color perception depends on neighborhood). So I have to try several times to hit the right one. I even filed a bug on this back in the OOO times. Nothing has happened, so I found my way how to choose colors. However, in LO42 there is a new color table. A nice one, with sorted colors. For me it is completely useless. I thing that common users like me need something very simple: a list of colors used in the document, the last (used or picked) color, and a "more" button). A similar situation is with line thickness - we can specify any thickness in mm (or inces or whatever). I would prefer just a few steps between very thin and very thick plus user specified value. I've file a bug about this (https://www.libreoffice.org/bugzilla/show_bug.cgi?id=48622, with dialog mockup to LO. What do you think about this? - perhaps I am the only one who has this problem Milos -- email & jabber:sramek.mi...@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@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] Lo Impress very slow with audio
Hi .. I am having problems with Impress working on an presentation for our clubs annual awards night a couple of slides need backing music with them . when i insert the sound files (ogg format) it takes around 2 minutes to load if i remove the sound file it is almost instant System Arch Linux (fully updated) KernelLinux 7-of-9 3.12.7-2-ARCH #1 SMP PREEMPT Sun Jan 12 13:09:09 CET 2014 x86_64 GNU/Linux KDE 4.1.2.1 LibreOffice 4.1.4.2 Build ID 4.1.4.2 Arch Linux Build-3 4Gb Ram 1Gb nvidia card dual monitors Help please i need this working .. Thanks Pete . -- To unsubscribe e-mail to: users+unsubscr...@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: Query
Le 19/01/2014 16:02, Tom Davies a écrit : Tom, > Can Base directly connect to a Lotus Approach database and use it as > the back-end? No. Never has and probably never will. > > @Ernest, Have you still got access to the old Windows and thus the > Lotus Approach directly or was this an upgrade (or a machine exchange > or some sort)? I take it you exported the data as a ".csv" file and > that is what is looking like a flat spreadsheet? Lotus Approach saves its databases as an APR file extension, but the actual data is stored as a group of DBF tables. Any binary (e.g. image) data or extended character data (Memo fields, etc) are stored in a separate DBT file which is referenced in some way by the APR file and thus appears in the DBF file that contains the binary field. It was/is for its time a brilliant piece of kit that held its own with Access and FMPro. It had an accessible UI and form builder, had a fairly competent SQL parser, and could even be scripted with Lotus Smartscript. In fact, from the user perspective, it was "intuitive", everything which LO Base is not. I fully understand why people have stuck with it. However, it was essentially, single OS (well it did run on OS/2 as well for a while in Windows compatibility mode), as the software was provided for the Windows platform only. Alex -- To unsubscribe e-mail to: users+unsubscr...@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: Query
Le 19/01/2014 12:15, Ernest Dale a écrit : Hi, > To surmount the problem I have downloaded Libre Office and attempted to > transfer the database on to it. I appear to have succeeded but the result > is what looks like a spreadsheet and I cannot find a way to display one > record at a time. 1) How did you transfer the database ? LO can not read APR files per se. 2) LO can read the dbf files that Lotus Approach creates to store its data : - by default in Calc, the spreadsheet component, this might be what you are seeing on your screen, but you don't give enough detail to clue us in a bit more - however, this will not be a database, and there are known issues when re-exporting (i.e. saving) your data from Calc in DBF3 format ; - you can import the dbf files into a new LO Base file, using the database creation wizard, and choosing "Connect to existing database". DBF should be in the drop down list of selectable db types. Make sure that the tables you want to connect to are all in the same directory. When importing multiple DBF tables into an ODB file (LibreOffice database file), you will lose all relationship constraints. DBF support in LO does not extend to multitable queries, foreign key setting or relational integrity. You will lose all your forms and queries. You might be able to export your queries from Approach as SQL (haven't checked), but if they involve joins, they will no longer work in LO. The only way I know of currently, at least on Windows, to have multitable DBF queries with LO is to use ODBC, which means you would have to find a driver that will work for you. Note that once you have created your ODB file referencing DBF tables, you could re-import them from the DBF/ODB by drag and drop into a default embedded hsqldb ODB file of your making (File > new Database), and then reconstruct the key constraints, queries and forms. Alex -- To unsubscribe e-mail to: users+unsubscr...@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
