[libreoffice-users] writer-how to delete a carriage return in a cell of a table
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 and I cannot delete carriage returns (the non printable character lsimilar to q ) in the cells, so the cells result with two lines. how can I delete this character to have a single line row?? manythanks, :-) ciao :-) pier -- 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] Large spreadsheet does not open in LibreOffice.
Can you change that for all users ? Ta Mal On Friday 13 Nov 2015 22:07:01 Tom Davies wrote: > Hi :) > It does seem like an usually huge file-size. 150 kb would be more normal! > > There is a "memory" setting that might be useful to increase quite > dramatically. From the "Tools" menu; > > Tools - Options - Memory > > You can see the settings are mostly all very low so that people can > easily use LibreOffice on very low-spec machines. Modern desktops and > laptops have plenty of Ram these days and i'm guessing you are not > using a tablet or phone so you can radically increase most of those > values. I tried bumping the "used by LibreOffice" one up from around > 10-20 Mb to about 200 Mb. I think the maximum value is 256 Mb because > when i tried higher values they got reduced to 256 Mb. I usually > reduce the number of steps it can undo because 100 usually takes me to > waaay before my last back-up. > > If the file really is Mb instead of just kb then is it due to having > lots of images and art? > Regards from > Tom :) > > On 13 November 2015 at 19:27, Joel Maderowrote: > > On Fri, Nov 13, 2015 at 7:52 AM, ammorei wrote: > >> Good afternoon! > >> > >> I have a spreadsheet in '.xlsx', with a size around 150Mb and containing > >> +/- > >> 40 lines. > > > > I have never seen a 150 mb functional spreadsheet before. I'd like to see > > the file because I'm relatively sure that a database is what is > > needed (especially if there are a ton of functions in it and nested ifs) > > > > I would recommend trying to open the file and leave the computer going > > over > > night. The issue is that LibreOffice has to use xlsx filters to open the > > file, this is going to be slow when you're talking about 150 megs. Open > > the > > file over night, save it as an open document format (ods) and I suspect it > > will be quite a bit faster. > > > > But, again, I bet that file needs to be a database and not a > > spreadsheet... > > > > > > Best, > > Joel > > -- > > *Joel Madero* > > LibreOffice QA Volunteer > > jmadero@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 -- 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] writer-how to delete a carriage return in a cell of a table
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 and I cannot delete carriage returns (the non printable character lsimilar to q ) in the cells, so the cells result with two lines. how can I delete this character to have a single line row?? Are there actually two lines? i.e. can you place the cursor on the second line and start typing? It may have changed in version 5.0, but in 4.4 I see the paragraph break character at the end of every line in a table cell, including the last. So even with only one line in the cell, there is a paragraph break character. If you can't actually enter text on the line following the break, you probably have "spacing below paragraph" set on the Table Contents style (or whichever style you're using) - on the Indents & Spacing tab of the paragraph style settings. Mark. -- 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] writer-how to delete a carriage return in a cell of a table
At 10:39 14/11/2015 +0100, Pier Andreit wrote: I have a table with 2 columns and about 10 rows and I cannot delete carriage returns (the non printable character similar to q) in the cells, so the cells result with two lines. how can I delete this character to have a single line row? Try searching for $ and replacing with nothing (or possibly a blank space) with "Regular expressions" ticked. 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
Re: [libreoffice-users] writer-how to delete a carriage return in a cell of a table
Hi, when I only have a few to do, I place the cursor at the beginning of the second line and backspace (to join 2 words) then hit the space bar. Steve On 2015-11-14 22: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 and I cannot delete carriage returns (the non printable character lsimilar to q ) in the cells, so the cells result with two lines. how can I delete this character to have a single line row?? manythanks, :-) ciao :-) pier -- 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] Match Items from two different matrix
At 12:10 14/11/2015 -0600, Jorge Rodríguez wrote: I have two different matrix. One of them has a list of item from a site of internet. The other I made it. But both matrix are different but each row sometime has a equal word between them ... that word is what I'm finding to match both row. I fancy the problem needs to be better defined. o Is the equal word the entire contents of each cell or are you looking for substrings in common? o What do you expect as the result? Just an indication in each row of whether the cells are identical? A separate list of row numbers that satisfy the criterion? A separate list of words that match? A separate list of unique words that match? Try =A1=B1 in C1 and fill down. Or =IF(A1=B1;"Snap!";""). I used Vlookup but it doesn't work for me. You would use VLOOKUP() if you wanted to search all the rows of one column for a match for each cell in the other - which is not what you appear to want here. 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
Re: [libreoffice-users] Large spreadsheet does not open in LibreOffice.
Search for this: planning/ designing database This should be able to help you. Of course, this is only my opinion, but then again I wrote it. This is only one of multiple chapters about using Base that are available for downloading. Dan Original message From: "James E. Lang"Date:11/14/2015 1:42 AM (GMT-05:00) To: Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Large spreadsheet does not open in LibreOffice. -Original Message- From: Joel Madero To: toki Cc: users@global.libreoffice.org Sent: Fri, 13 Nov 2015 21:12 Subject: Re: [libreoffice-users] Large spreadsheet does not open in LibreOffice. On 11/13/2015 08:23 PM, toki wrote: > On 13/11/2015 19:27, Joel Madero wrote: > >> I have never seen a 150 mb functional spreadsheet before. > That size is not uncommon in environments where Excel is the only office > tool that the employees know how to use. Trust me...I know. I worked somewhere where we had a 750 meg excel file that crashed multiple times a day and was entirely useless. When I suggested that someone (meaning I) take the time to do it rightIT pushed back heavily and was afraid that I'd break something (as if things weren't already horribly broken). I recommend to most people who see their spreadsheets creeping into the 10's to 100's of megs to start looking at how to structure databases and do things right instead of horrible hacks that tend to have lots of issues - despite many people trying, a spreadsheet is not a database. [Joel, although I agree that my 7 MB spreadsheet has gotten unwieldy, I have no clue how to design and implement a database to replace the mess. I suspect that most users who have these oversized, abused, spreadsheets have the same problem. Businesses should be able to hire a database designer but as a retired individual I don't have financial resources to even get training in database design. So I appear to be stuck. I won't go into any of my spreadsheet's details here. Suffice it to say I recognize that it has become a kludge. At 7,145 KB after about 45 weeks accumulation of data I can see the possibility that the .ods file could expand past 8MB for the full year. Then it will start over and I'll need to figure out how to carry over some values computed from this year's data to the new spreadsheet. -- jl] Best, Joel -- 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 -- 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] writer-how to delete a carriage return in a cell of a table
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 and I cannot delete carriage returns (the non printable character lsimilar to q ) in the cells, so the cells result with two lines. how can I delete this character to have a single line row?? manythanks, :-) ciao :-) pier tyr using the 'backspace', and not the 'delete' button -- 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] writer-how to delete a carriage return in a cell of a table
Hi: That kind of characters is not for delete it is used by the system LO to mark Enter function (As I know). You can hide with: Menu-View-Not Print Character (uncheck) To delete extra row you have to delete blank space...that's all Regards, Jorge Rodríguez El sáb, 14-11-2015 a las 10:39 +0100, yahoo-pier_andreit escribió: > 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 and I cannot delete > carriage returns (the non printable character lsimilar to q ) in the > cells, so the cells result with two lines. > how can I delete this character to have a single line row?? > manythanks, :-) ciao :-) pier > -- Atentamente, Jorge Rodríguez -- 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: Large spreadsheet does not open in LibreOffice.
Sometimes people select the whole sheet to apply a direct format, cleaning direct formatting, at least out of data range could helps a lot, because seems LibreOffice doesn't like it too much. Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Large-spreadsheet-does-not-open-in-LibreOffice-tp4166243p4166294.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
[libreoffice-users] LibreOffice 4.4, 5.0 : firefox personas not work with path url...why?
hello from Libreoffice 4.3 is best than 4.4 and 5.0 for PATH URL from a theme firefox (personas), BECAUSE:4.4 and 5.0 is changed GUI and delete path of url.. see screenshot of libreoffice 4.3: http://www.osside.net/wp-content/uploads/2014/10/libfoxtheme8.jpg and see GUI of 5.0: https://wiki.documentfoundation.org/images/thumb/1/19/Firefox_themes_browser.jpeg/600px-Firefox_themes_browser.jpeg then you try go to: from firefox theme personas: https://addons.mozilla.org/it/firefox/addon/dandywater/ copy link and go to in dialog of libreoffice 5.0 (4.4) results: it's not detected the theme personas.This is problem.. missed input for PATH URL... my case situation : libreoffice 4.4 and 5.0 i try write in dialog of libreoffice 5.0 (4.4) search form: 1) "Dandelion Seeds . Water Droplets" not detected! 2)"VanillaOrchids" not detected! SO THIS IS IMPOSSIBLE TO USE...instead version 4.3 is TRUE worked 'copy and paste' url path!this is true EASY TO USE IT FOR USER NEWBIEit'sRIGHT? but please to ask to team developers to ADD new INPUT-TEXT for URL...it's simple to add new input-text, it is right?SO to keep the dialog of 4.4 and 5.0 and ADD new input-text for url, it's possible? i use linux opensuse 13.2 64bit, libreoffice 4.3, libreoffice 4.4, libreoffice 5.0.thank you -- 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] Large spreadsheet does not open in LibreOffice.
^1: More than one researcher has argued that The Human Genome Project > was a complete waste of money, time, and effort, because of the > numerous > _known_ errors inflicted upon the project, by the use of Excel, and > its > silent translation of data to something other that what the user > wrote. It would be interesting to have some references for this claim 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] Large spreadsheet does not open in LibreOffice.
Hi :) I think so. I have no idea how to do that though. Which OS are you using? Is it a version of Windows? Xp, Win7 or something? Regards from tom :) On 14 November 2015 at 11:20, malcolmwrote: > Can you change that for all users ? > > Ta > > Mal > > > On Friday 13 Nov 2015 22:07:01 Tom Davies wrote: >> Hi :) >> It does seem like an usually huge file-size. 150 kb would be more normal! >> >> There is a "memory" setting that might be useful to increase quite >> dramatically. From the "Tools" menu; >> >> Tools - Options - Memory >> >> You can see the settings are mostly all very low so that people can >> easily use LibreOffice on very low-spec machines. Modern desktops and >> laptops have plenty of Ram these days and i'm guessing you are not >> using a tablet or phone so you can radically increase most of those >> values. I tried bumping the "used by LibreOffice" one up from around >> 10-20 Mb to about 200 Mb. I think the maximum value is 256 Mb because >> when i tried higher values they got reduced to 256 Mb. I usually >> reduce the number of steps it can undo because 100 usually takes me to >> waaay before my last back-up. >> >> If the file really is Mb instead of just kb then is it due to having >> lots of images and art? >> Regards from >> Tom :) >> >> On 13 November 2015 at 19:27, Joel Madero wrote: >> > On Fri, Nov 13, 2015 at 7:52 AM, ammorei wrote: >> >> Good afternoon! >> >> >> >> I have a spreadsheet in '.xlsx', with a size around 150Mb and containing >> >> +/- >> >> 40 lines. >> > >> > I have never seen a 150 mb functional spreadsheet before. I'd like to see >> > the file because I'm relatively sure that a database is what is >> > needed (especially if there are a ton of functions in it and nested ifs) >> > >> > I would recommend trying to open the file and leave the computer going >> > over >> > night. The issue is that LibreOffice has to use xlsx filters to open the >> > file, this is going to be slow when you're talking about 150 megs. Open >> > the >> > file over night, save it as an open document format (ods) and I suspect it >> > will be quite a bit faster. >> > >> > But, again, I bet that file needs to be a database and not a >> > spreadsheet... >> > >> > >> > Best, >> > Joel >> > -- >> > *Joel Madero* >> > LibreOffice QA Volunteer >> > jmadero@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 > > > -- > 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 > -- 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] Large spreadsheet does not open in LibreOffice.
Documents for LibreOffice: http://wiki.documentationfoundation.org/documentation/publications The Base Guide section contains my writings. The Base Handbook has been translated from the German. Dan Original message From: "James E. Lang"Date:11/14/2015 1:42 AM (GMT-05:00) To: Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Large spreadsheet does not open in LibreOffice. -Original Message- From: Joel Madero To: toki Cc: users@global.libreoffice.org Sent: Fri, 13 Nov 2015 21:12 Subject: Re: [libreoffice-users] Large spreadsheet does not open in LibreOffice. On 11/13/2015 08:23 PM, toki wrote: > On 13/11/2015 19:27, Joel Madero wrote: > >> I have never seen a 150 mb functional spreadsheet before. > That size is not uncommon in environments where Excel is the only office > tool that the employees know how to use. Trust me...I know. I worked somewhere where we had a 750 meg excel file that crashed multiple times a day and was entirely useless. When I suggested that someone (meaning I) take the time to do it rightIT pushed back heavily and was afraid that I'd break something (as if things weren't already horribly broken). I recommend to most people who see their spreadsheets creeping into the 10's to 100's of megs to start looking at how to structure databases and do things right instead of horrible hacks that tend to have lots of issues - despite many people trying, a spreadsheet is not a database. [Joel, although I agree that my 7 MB spreadsheet has gotten unwieldy, I have no clue how to design and implement a database to replace the mess. I suspect that most users who have these oversized, abused, spreadsheets have the same problem. Businesses should be able to hire a database designer but as a retired individual I don't have financial resources to even get training in database design. So I appear to be stuck. I won't go into any of my spreadsheet's details here. Suffice it to say I recognize that it has become a kludge. At 7,145 KB after about 45 weeks accumulation of data I can see the possibility that the .ods file could expand past 8MB for the full year. Then it will start over and I'll need to figure out how to carry over some values computed from this year's data to the new spreadsheet. -- jl] Best, Joel -- 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 -- 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] Large spreadsheet does not open in LibreOffice.
On 14/11/2015 06:42, James E. Lang wrote: > I have no clue how to design and implement a database to replace the mess. One of the good things about Microsoft Access, was that it was easy for people who knew nothing about databases, to create their own database. I'll grant, that from a theoretical point of view, the overwhelming majority of those databases are non-optimal. For the typical SOHO/individual user database, that is completely irrelevant. Where LibO falls down, is that database creation is neither intuitive, nor well explained. Your basic relational database record has four fields: * Record number; * A value; * What that value represents; * What that value is associated with; The record number is to ensure that every record has at least one unique field. This way, data can be edited, deleted, or added, as required. (If the database software one uses does not mandate/require that at least one field in each record be unique, then the database software is trash, and its usage should be permanently barred, ASAP.) The value that is represented is the piece of information in the record that is important. The client name, or the client address, for example. What the value represents, tells the user what that piece of information is. It isn't much use have a "value represented" of 48.6,122.25, if one has no idea what that value is supposed to be of. What the value is associated with, indicates which other records share common parameters with this specific record. for example, "48.6, 122.25" is part of my address. Other records would contain the street number, street name, city name, Postal Code, and Country. What makes database construction awkward, is in knowing which records belong together. To make that task easier, instead of having a four-field record, one has a record with umpteen fields. IE: Address Database record: * Record number; * Name; * Street Number; * Street Name; * Street Extension; * City; * Postal Code; * Country; instead of 7 records, each with only one part of the address, which is what relational database theory suggests is optimum; > I suspect that most users who have these oversized, abused, spreadsheets have the same problem. Yes, and no. _Lotus 1,2,3_ literally revolutionized how data could be understood, and analysed. Things that formerly took months, if not years to determine, could now be done in weeks. The major hold up was being able to use the corporate database. What the more daring users did, was simply added the data that would have gone into the corporate database, onto a quick and dirty spreadsheet. These spreadsheets were then spread around the office, and quickly became mission-critical monstrosities, entirely unsupported by IT. Circa 2000, one organization that specialized in corporate software development estimated that it would take five years for the typical corporate mission-critical spreadsheet that had become a monstrosity, to be properly developed by the corporate IT department. For most organizations, that was an unacceptable length of time to wait for a replacement, especially since the odds were that the spreadsheet had originated less than five years earlier. Slowly, spreadsheet developers incorporated quasi-database functionality into their spreadsheets, to the point that spreadsheets that lacked database functionality, were considered to be "crippled" by "power-users". The end result is that one can currently find books exonerating the usage of spreadsheet software as databases, and, worse luck, teaching users how to abuse the spreadsheet software, as a database program. (I've forgotten the name of the book on using Excel, but it was a fairly detailed explanation of how to use Excel as a database. Needless to say, it would have been much easier, and safer (^1), for the user to have done everything described in that book, by using R, or even Python, and SQLite, MariaDB, or PostgreSQL.) All that said, some database developers use spreadsheets, to determine what fields are needed, and what the database flow should allow, and what it should dis-allow.IOW, the spreadsheet becomes a spec-sheet for the database, and attendant items, that they deliver. > So I appear to be stuck. I won't go into any of my spreadsheet's details here. This is where a dozen or more database templates, with comprehensive instructions on how to use them, and modify them, would be extremely useful. > Then it will start over and I'll need to figure out how to carry over some values computed from this year's data to the new spreadsheet. In an ideal world, one of those database templates would work as a replacement for your spreadsheet. ^1: More than one researcher has argued that The Human Genome Project was a complete waste of money, time, and effort, because of the numerous _known_ errors inflicted upon the project, by the use of Excel, and its silent translation of data to something other that what the user wrote. FWIW, Calc does the same type of silent
[libreoffice-users] Match Items from two different matrix
Hi all: I need your help I have two different matrix. One of them has a list of item from a site of internet. The other I made it. But both matrix are different but each row sometime has a equal word between them ... that word is what I'm finding to match both row. I used Vlookup but it doesn work for me. Do you know another way to find that word to match the rows. Regards, Jorge Rodríguez -- Atentamente, Jorge Rodríguez -- 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] LibreOffice 4.4, 5.0 : firefox personas not work with path url...why?
Are you comparing FireFox with LO?; FireFox is a website where LO is a program. If you are desirous of using some of these screensavers on your computer, then open FireFox, not LO, go to those URLs, download whatever to your machine. Then with that image on your machine, you can place it as a screensaver or use however else - assuming that these images are for public usage ;-) Hoping this answers your questions, From:Date: Sat, Nov 14, 2015 at 10:29 AM Subject: [libreoffice-users] LibreOffice 4.4, 5.0 : firefox personas not work with path url...why? To: "users@global.libreoffice.org" hello from Libreoffice 4.3 is best than 4.4 and 5.0 for PATH URL from a theme firefox (personas), BECAUSE:4.4 and 5.0 is changed GUI and delete path of url.. see screenshot of libreoffice 4.3: http://www.osside.net/wp-content/uploads/2014/10/libfoxtheme8.jpg and see GUI of 5.0: https://wiki.documentfoundation.org/images/thumb/1/19/Firefox_themes_browser.jpeg/600px-Firefox_themes_browser.jpeg then you try go to: from firefox theme personas: https://addons.mozilla.org/it/firefox/addon/dandywater/ copy link and go to in dialog of libreoffice 5.0 (4.4) results: it's not detected the theme personas.This is problem.. missed input for PATH URL... my case situation : libreoffice 4.4 and 5.0 i try write in dialog of libreoffice 5.0 (4.4) search form: 1) "Dandelion Seeds . Water Droplets" not detected! 2)"VanillaOrchids" not detected! SO THIS IS IMPOSSIBLE TO USE...instead version 4.3 is TRUE worked 'copy and paste' url path!this is true EASY TO USE IT FOR USER NEWBIEit'sRIGHT? but please to ask to team developers to ADD new INPUT-TEXT for URL...it's simple to add new input-text, it is right?SO to keep the dialog of 4.4 and 5.0 and ADD new input-text for url, it's possible? i use linux opensuse 13.2 64bit, libreoffice 4.3, libreoffice 4.4, libreoffice 5.0.thank you -- 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] Large spreadsheet does not open in LibreOffice.
On 14/11/2015 17:43, Harvey Nimmo wrote: >> ^1: More than one researcher has argued that The Human Genome Project was a complete waste of money, time, and effort, > It would be interesting to have some references for this claim Which claim: * That researchers called the Human Genome Project a waste of money, time, etc; * That Excel destroys data by silent transformation; * Something else; Regardless, here are some pages that discuss known errors in using spreadsheets: * http://panko.shidler.hawaii.edu/SSR/Mypapers/whatknow.htm; * http://www.eusprig.org/horror-stories.htm; * http://www.eusprig.org/stories.htm * http://www.strategy-at-risk.com/2009/03/03/the-risk-of-spreadsheet-errors/; * http://www.excellentones.com/resources/spreadsheet-mistakes.html; * http://www.pages.drexel.edu/~bdm25/excel2007.pdf * http://andrewgelman.com/2013/04/16/memo-to-reinhart-and-rogoff-i-think-its-best-to-admit-your-errors-and-go-on-from-there/ Doing a cut and paste from a /. about the deficits of spreadsheets in statistical analysis. author = {Yalta, A.T.}, title = {The accuracy of statistical distributions in Microsoft® Excel 2007}, journal = {Computational Statistics and Data Analysis}, author = {B.D. McCullough and David A. Heiser}, title = {On the accuracy of statistical procedures in Microsoft Excel 2007}, journal = {Computational Statistics \& Data Analysis}, author = {B.D. McCullough}, title = {Special section on Microsoft Excel 2007}, journal = {Computational Statistics \& Data Analysis}, author = {Altman,Micah and McDonald,Michaell P.}, title = {Choosing Reliable Statistical Software}, journal = {PS: Political Science \& Politics}, author = {B. D. McCullough and Berry Wilson}, title = {On the accuracy of statistical procedures in Microsoft Excel 97}, journal = {Computational Statistics \& Data Analysis}, And for a fun read, http://www2.odn.ne.jp/~cbl97790/kakikataJO.htm jonathon -- 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] Large spreadsheet does not open in LibreOffice.
On Sat, 2015-11-14 at 19:47 +, toki wrote: > On 14/11/2015 17:43, Harvey Nimmo wrote: > > > > ^1: More than one researcher has argued that The Human Genome > > > Project > was a complete waste of money, time, and effort, > > It would be interesting to have some references for this claim > > Which claim: > * That researchers called the Human Genome Project a waste of money, > time, etc; > * That Excel destroys data by silent transformation; > * Something else; Sorry for my imprecision :-(. I meant references for the negative impact of Excel on the Human Genom project. Just because Excel had been used, it might have beenn likely to affect the project negatively, but there should have been data quality checks in place as well, which might have compensated them. 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] writer-how to delete a carriage return in a cell of a table
On 11/14/2015 11:31 AM, Brian Barker wrote: At 10:39 14/11/2015 +0100, Pier Andreit wrote: I have a table with 2 columns and about 10 rows and I cannot delete carriage returns (the non printable character similar to q) in the cells, so the cells result with two lines. how can I delete this character to have a single line row? Try searching for $ and replacing with nothing (or possibly a blank space) with "Regular expressions" ticked. I trust this helps. Brian Barker manythanks Brian and all the others, it helped me to know why I wasn't able to delete a carriage return/paragraph mark, it was becouse the two paragraph marks were in two different cells with the separation border hidden, so the two cells appeared like as they were a single cell with two paragraphs, nothing highlight/stand out the presence of a hidden border that split the two cells, even if you set to on the "show non printable character". I don't know if it is a bug but it is a very misleading behaviour, in the past I remember a subtle dotted border to identify a cell and I think it would be better to reintroduce it, also only in "show non printable characters" set on. thanks again :-) ciao :-) pier -- 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] Large spreadsheet does not open in LibreOffice.
Oops, Dan. Your link contained errors. After a couple of educated guesses I found http://wiki.documentfoundation.org/documentation/Publications Your posted domain name was incorrect and the page name needed an upper case P rather than the lower case p. I hope this correction helps somebody else. Thanks to the others who also responded. FWIW, my unwieldy spreadsheet thrashed about for hours when I tried to add 30 rows near the bottom of the 2810 active rows on each of two sheets. This was on Windows XP. I finally terminated the process which was running alone and using "403,500 KB" of memory. I _will_ try migrating this file to my Kubuntu system. If that doesn't work then it's really desperation time. -- Jim -Original Message- From: elderdanlewisTo: "users@global.libreoffice.org" Sent: Sat, 14 Nov 2015 9:15 Subject: Re: [libreoffice-users] Large spreadsheet does not open in LibreOffice. Documents for LibreOffice: http://wiki.documentationfoundation.org/documentation/publications The Base Guide section contains my writings. The Base Handbook has been translated from the German. Dan -- 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] writer-how to delete a carriage return in a cell of a table
On 11/14/2015 11:31 AM, Brian Barker wrote: At 10:39 14/11/2015 +0100, Pier Andreit wrote: I have a table with 2 columns and about 10 rows and I cannot delete carriage returns (the non printable character similar to q) in the cells, so the cells result with two lines. how can I delete this character to have a single line row? Try searching for $ and replacing with nothing (or possibly a blank space) with "Regular expressions" ticked. I trust this helps. Brian Barker manythanks Brian, it helped me to know why I wasn't able to delete a carriage return/paragraph mark, it was becouse the two paragraph marks were in two different cells with the separation border hidden, so the two cells appeared like as they were a single cell with two paragraphs, nothing highlight/stand out the presence of a hidden border that split the two cells, even if you set to on the "show non printable character". I don't know if it is a bug but it is a very misleading behaviour, in the past I remember a subtle dotted border to identify a cell and I think it would be better to reintroduce it, also only in "show non printable characters" set on. thanks again :-) ciao :-) pier -- 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] LibreOffice 4.4, 5.0 : firefox personas not work with path url...why?
On 14/11/2015 05:21 PM, anne-ology wrote: Are you comparing FireFox with LO?; FireFox is a website where LO is a program. No. Both are programmes. They of course do different things, being different programmes. -- 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