[libreoffice-users] Table formatting problem and input list function not editable
Dear Libreoffice users and hackers, Since I am working with the Libreoffice 6.0.2.1 build ID.1.1:6.0.2~rc1-0ubuntu0.16.04.1.lo1., on an Ubuntu/with KDE plasma, post installed 16.04 (Dell note book) I am having trouble in creating tables. The symptoms are as follows: 1. Using the table button on the toolbar I create an table (doesn't matter which size), and independently of the default font configuration, it sets the table to the Liberation Serif, 12 pica and also it set the table to the table of content Style. If I try to change the font in the table of content style it dos not have any effect on the text in the table. I can change font type and size manually by marking the whole table and applying manually the fon I want and the font size. But If I move, change any cell size or column it unformats everything back to the Liberation Serif, 12 Font and size adn on top of that applyed border format play havock and dissappear or appear randomly. I've been googling around and I found that a couple of versions behind very few people were complaining of this same problem and saying this is an LO Bug. Does someone have any idea if this is really a bug or am I wrong. 2. A second problem I found at this very moment, when I tryed to edit an input list field, and the editor didn't came up to add new items to the list. Does someone found something similar? Thanks in advance for any enlightenment. Ralf Dr. Ralf Kersanach Laboratório de Genética Instituto de Ciências Biológicas Universidade Federal do Rio Grande Avenida Itália s/n CEP 96203-900, Bairro Carreiros Rio Grande, RS Brasil Tel.: +.55.53.3293.5128 Cel.: +55.53.9.9111.9367 e-mail: dmbralf"at"furg.br -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Mapping Styles usage
Hi folks, I have an question to all, I'm developing an classroom management system adjusted to our university system in Calc. I've rewritten it from an previous version I had, I use it to learn Calc. One of the facilities I use massively is conditional formatting. My main difficulty with conditional formatting is keeping track of what style is in use and what style is not in use. Question: Is there a way to keep track of style usage? Thanks, Ralf -- 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] Thikening the contour of an square crashes Impress
Anne-ology, thanks for your reply. Well, I really don't know if this is an bug, but i can repeat it consistently in impress. No I'm not streching an existing line, I use the square tool draw the square, clean the fill in and them I try to thikening the line and it crashes. I mean with arquive, when I open an new clean/blank/fresh impress file, where the only object I have draw is the square draw which I create the same way I described above. Ralf -- Laboratório de Biodiversidade Genética Instituto de Ciências Biológicas Universidade Federal do Rio Grande - FURG Av. Itália, s/n, Carreiros 96201-900, Rio Grande, RS - Brasil Tel.:+.55.53.3293.5128 +.55.53.3233.6742/6538 e-mail:dmbralf"at"furg.br msn:r_kersanach"at"hotmail.com skype: ralfkersanach On Monday 07 September 2015 14:16:51 anne-ology wrote: >There are a couple possibilities which come to my mind as to the > problem here; > > assuming there is no bug in any of your set-ups - which could be > 1 cause. > >Another possibility is that you're attempting to stretch an existing > line rather than deleting the present one which you no longer desire; > if this is the case, then merely delete that which you no longer > want & replace with that which you want. > >Another possibility may be whatever you mean by 'arquive' ???; > do you perchance mean archive?, as in saving the document? > if this is the case, then are you saving with a different name?, > or are you starting fresh with a blank PP? >You might try starting with a fresh/blank PP > then click on add file > then make any adjustments to the individual slides you want > then save the document with a different name; > Should be as you desire it, > >Hoping this helps, > > > > From: Ralf Kersanach <dmbr...@furg.br> > Date: Fri, Sep 4, 2015 at 6:40 AM > Subject: [libreoffice-users] Thikening the contour of an square crashes > Impress > To: users@global.libreoffice.org > > > Hi, > > recently I was preparing a lecture and I needed to draw a square around a > region of an image to get attention on that part of the image. When I try to > thicken the perimeter of the square, crashes. I've tried on a new arquive > without any elements and it crashes as well. Anybody with the same problem? > > I'm a user of Arch linux with kernel 4.1.6-1, Kde 4.14.11 (according to > kinfo) and my LO version is 5.0.1.2.0+ (buildID: 5.0.1.2 Arch Linux > build-1), > Locale pt-BR(interface (en_US.UTF-8). > > Ralf -- 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] Thikening the contour of an square crashes Impress
Hi, recently I was preparing an lecture and I needed to draw an square around an region of an image to get attention on that part of the image. When I try to thiken the perimeter of the square crashes. I've tried on an new arquive without any elements and it crashes as well. Anybody with the same problem? I'm an user of Arch linux with kernel 4.1.6-1, Kde 4.14.11 (according to kinfo) and my LO version is 5.0.1.2.0+ (buildID: 5.0.1.2 Arch Linux build-1), Locale pt-BR(interface (en_US.UTF-8). Ralf -- 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] display
Hi, I must say I have a similar behavior on my linux machine which has a similar configuratio as of Thomas (a part from the SSD and windows 8.1). My graphic card is the hybrid one (NVIDIA GT-630M), processor an i7 and 8 GB RAM and 1 TB HD. I boosted my libre office (4.4.2) up to 250 MB, and 50 MB per document) and sometimes even with only one document text tearing happens. I must confess I haven't payed attention a) if the overall system memory was quite low or b) if the limit of the allocated memory usage or the per document memory reached their limit. I'll keep an eye on them to see if such behavior is consistent with low memory. Ralf On Thursday 23 April 2015 02:16:52 Thomas Blasejewicz wrote: On 2015/04/23 0:44, Tom Davies wrote: Hi :) Maybe increase the memory settings in LibreOffice? The defaults tend to be extremely low and on such a high-spec machine you can whack them right up. Tools - Options - Memory It sounds a bit like rendering issues so maybe the drivers for the graphics-'card' are not quite right. I'm very much not sure about any of that though! Regards from Tom :) On 22 April 2015 at 16:17, Thomas Blasejewicz ny...@hb.tp1.jp wrote: Good night = morning from Japan I believe I did ask the same question in the past related to an installation on a Win XP machine: moving through documents (Writer) in LibreOffice while editing sometimes (constantly!) sort of blurrs/freezes the screen. That means, characters/lines/text sections disappear, look like smeared ink or are displayer overlapping. The problem is solved, by switching to another Writer document and back. That's fine, but still rather stupid and happens ONLY with Writer (not yet noticed in Calc). Computer: just bought a new one, running Windows 8.1 (= a nightmare!!!), 8 GB RAM, 120 GB SSD = OS + 1 TB HDD and probably a whole lot of fancy high-tech stuff I not capable of understanding. Thank you. Just increasing the memory (from 50 MB to 200 MB for LO) did not work, but while playing around in options, I found View - Use hardware acceleration. For now, that seems to improve things ... Graphics card, its driver etc. are things that have been put there by the manufacturer 2 weeks ago and I did not touch those. Here too I would like to think, that THEY know a lot better than I do ... -- 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] display
Hi Tom, I've never noticed it with Firefox on linux, but I'll keep an eye on it. Ralf -- Laboratório de Biodiversidade Genética Instituto de Ciências Biológicas Universidade Federal do Rio Grande - FURG Av. Itália, s/n, Carreiros 96201-900, Rio Grande, RS - Brasil Tel.:+.55.53.3293.5128 +.55.53.3233.6742/6538 e-mail:dmbralfatfurg.br msn:r_kersanachathotmail.com skype: ralfkersanach On Thursday 23 April 2015 13:50:53 Tom Davies wrote: Hi :) I'm never convinced that the settings on a new machine are perfect but i agree it is a good idea to stick with them until there is convincing enough reason to try something else. Since there was no barrage of people applauding that part of my idea it's not exactly convincing enough!! The memory part sounds plausible though and is fairly easy to change and get back to approximately default if it doesn't seem to do anything. That hardware acceleration sounds exactly perfect! Well found! I hope Firefox has something similar because that's where i get the same sort of issue on this machine. Regards from Tom :) On 23 April 2015 at 13:23, Ralf Kersanach dmbr...@furg.br wrote: Hi, I must say I have a similar behavior on my linux machine which has a similar configuration as of Thomas (apart from the SSD and windows 8.1). My graphic card is the hybrid one (NVIDIA GT-630M), processor an i7 and 8 GB RAM and 1 TB HD. I boosted my libre office (4.4.2) up to 250 MB, and 50 MB per document) and sometimes even with only one document text tearing happens. I must confess I haven't payed attention a) if the overall system memory was quite low or b) if the limit of the allocated memory usage or the per document memory reached their limit. I'll keep an eye on them to see if such behavior is consistent with low memory. Ralf On Thursday 23 April 2015 02:16:52 Thomas Blasejewicz wrote: On 2015/04/23 0:44, Tom Davies wrote: Hi :) Maybe increase the memory settings in LibreOffice? The defaults tend to be extremely low and on such a high-spec machine you can whack them right up. Tools - Options - Memory It sounds a bit like rendering issues so maybe the drivers for the graphics-'card' are not quite right. I'm very much not sure about any of that though! Regards from Tom :) On 22 April 2015 at 16:17, Thomas Blasejewicz ny...@hb.tp1.jp wrote: Good night = morning from Japan I believe I did ask the same question in the past related to an installation on a Win XP machine: moving through documents (Writer) in LibreOffice while editing sometimes (constantly!) sort of blurrs/freezes the screen. That means, characters/lines/text sections disappear, look like smeared ink or are displayer overlapping. The problem is solved, by switching to another Writer document and back. That's fine, but still rather stupid and happens ONLY with Writer (not yet noticed in Calc). Computer: just bought a new one, running Windows 8.1 (= a nightmare!!!), 8 GB RAM, 120 GB SSD = OS + 1 TB HDD and probably a whole lot of fancy high-tech stuff I not capable of understanding. Thank you. Just increasing the memory (from 50 MB to 200 MB for LO) did not work, but while playing around in options, I found View - Use hardware acceleration. For now, that seems to improve things ... Graphics card, its driver etc. are things that have been put there by the manufacturer 2 weeks ago and I did not touch those. Here too I would like to think, that THEY know a lot better than I do ... -- 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: Multiple Tables In Writer Document
Hi folks, I got probably an idea. If you do an continuous table which could fill several linked text frames, so you would change for example column size in the first frame and it would affect the size of that column through out every frame. Two points must be taken in consideration: 1- If header are the same throughout all tables. I do not know if all column headers would be the same or different. If they are the same I do not know if the item repeat table header in next page considers a change in frames equal to a change in page. If not just repeat manually headers in next frame. The downfall with this is if you add more data to the starting table you must either increase the frame or reorganize all tables manually through the text. 2- Hiding tha fact that the table is an continuous among frames and table isn included in an frame. If header repeating does not work or you headers are different you could hide the continuity among frames just by not applying line. Cell frame can also be invisible by not applying borders. Well hope it helps. Regards, Ralf On Tuesday 17 March 2015 18:14:53 Tom Davies wrote: Hi :) Is this becoming something that could be posted as a feature request? It does sound like something that could be really useful and i'm surprised no-one has thought of it before. Perhaps they have and made an Extension? I doubt that too tbh. http://extensions.libreoffice.org/ Regards from Tom :) On 17 March 2015 at 17:38, Steve Edmonds steve.edmo...@ptglobal.com wrote: It is a pity you can't use a variable field in the formatting dialogues. That could be useful in a range of places. On 2015-03-18 02:34, fang wrote: Hi Tom, I’ve looked at styles and it’s not possible to modify table properties such as column widths using styles. There are Page, Paragraph and Character styles but no Table styles. Thanks for the suggestion, Steve On Mar 17, 2015, at 9:02 AM, TomD [via Document Foundation Mail Archive] ml-node+s969070n4143508...@n3.nabble.com wrote: Hi :) I wonder if there is a Style for that sort of thing? Chapter 3 in the Getting Started Guide; https://wiki.documentfoundation.org/Documentation/Publications https://wiki.documentfoundation.org/Documentation/Publications Regards from Tom :) On 16 March 2015 at 19:43, fang [hidden email] x-msg://57/user/SendEmail.jtp?type=nodenode=4143508i=0 wrote: Thanks for the reply, but that's sad. I'm using the tables to format the document and need columns to align. Having to touch each table every time the format changes is a real bummer. -- View this message in context: http://nabble.documentfoundation.org/Multiple-Tables-In-Writer- Document-tp4143458p4143465.html http://nabble.documentfoundation.org/ Multiple-Tables-In-Writer-Document-tp4143458p4143465.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: [hidden email] x-msg://57/user/SendEmail. jtp?type=nodenode=4143508i=1 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/ Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ 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: [hidden email] x-msg://57/user/SendEmail. jtp?type=nodenode=4143508i=2 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/Multiple-Tables-In-Writer- Document-tp4143458p4143508.html http://nabble.documentfoundation.org/ Multiple-Tables-In-Writer-Document-tp4143458p4143508.html To unsubscribe from Multiple Tables In Writer Document, click here http://nabble.documentfoundation.org/template/NamlServlet.jtp? macro=unsubscribe_by_codenode=4143458code= c3RldmVAaGFycHNlcnZpY2VzLmNvbXw0MTQzNDU4fDE3NjcwNjY2NjM=. NAML http://nabble.documentfoundation.org/template/NamlServlet.jtp? macro=macro_viewerid=instant_html%21nabble%3Aemail.naml base=nabble.naml.namespaces.BasicNamespace-nabble.view. web.template.NabbleNamespace-nabble.view.web.template. NodeNamespacebreadcrumbs=notify_subscribers%21nabble%
Re: [libreoffice-users] Re: Where is Base?
Hi Tom, Well, I'm translating it to brazilian portuguese. I know that there is an libreoffice site available for Brazil, but since my time is really limited, I'd rather to it in my pace than on any time shedule. Anyway, thanks for the tip, I'll have a look at this international list and find out exactly what OmegaT is. At the moment I'm already through half of the introduction chapter. Anyway, as I said im my previous posting, I am very happy in finally finding a manual that really explains Base in an updated software version. At moment I'm using the the TradutorOOoText extension. It has several pitfalls in translating from german to portuguese, but it's quite a help. It sounds that OmegaT is more professional for translations, so I'll contact them and see how I can help. The reason why I'm starting the translation with Base is because I need to build an database to mine some data out of DNA sequences. I was doing it using SQL statement with mysqlworkbench. It was nice, but I wanted to do a more beautiful and user friendly layout and I am not prepared (due to lack of time) to learn an script and HTML languages just to build an GUI for this database. I searched a lot between possibilities which were similar to Filemaker (I've used it a lot before I changed to Opensource), and the two most friendly, in my opinion, where Base and Kexi. Personally, I don't use the portuguese version of LO, I use the english(UK)user interface, because of the help file which does not come with the (USA). For the locale setting I use portuguese (Brazil), well because is where I live. Well, once more thanks for the tip. On Monday 09 March 2015 11:22:55 you wrote: Hi :) The international translator's mailing list is just starting to experiment with translating the Published Guides, such as the Base Handbook, using OmegaT. OmegaT helps in many ways but just one of them is that it seems to track (or identify) what has changed in a newer release of the same guide so that only the changes need to be translated to bring your translation up-to-date. I suspect that they will probably start with the Getting Started with LibreOffice guide, then do the Writer Guide, then the one for Calc and then work through all the rest before ever getting to the Base one(s). If you are alread working on translating the Base Handbook then you would be a huge asset to the translation team of whichever language you are working on. There are a few teams that have worked on translating the guides but it is a struggle, especially until using a decent tool such as OmegaT. The international translators mailing list address is; l...@global.libreoffice.org (capital letters, upper-case and lower-case all get converted to just lower-case by emailing systems so they are only useful for human readers and it really doesn't matter if you get upper and lower case muddled up). Regards from Tom :) On 6 March 2015 at 14:21, Ralf Kersanach dmbr...@furg.br wrote: I guess Andreas is right in all his observations. I'll never expected LO or similars to be an top Databse development front end (although if it would reach filemakers level would be nice). What I expect, as a non IT person, from such kind of platform, is to help me out to delevelop relative simple to medium simple personal and sometimes professional problems without having to learn several programming languages to achive the same through web pages. I have some friends which simply gave up building such DB just because it was to cumberson to learn several different thinks to achieve one purpose only. I thing every tool is a right tool if we keep their limitation in mind and I think Base is in the absolute right direction. After starting to read the 4.4 manual, Tom pointed me out, I got over enthusiastic again, because I saw how much progress the Base team has done (good work folks). I got so enthusiastic that I started to translate it to my native language (as soon I reach some chapter translated I'll make the drafts available). I think that one of the major draw backs of Base and why people isn't using it is the lack of up to date manuals. There more up to date literature and information is available more people can understand power and limitations of base and how to employ it. I know there are some tutorials around, but there more there better so people can see what is possible to do with base. I know the develop and documentation team might be small for this herculean work but as I said before good job folks, the rest comes with time. On Friday 06 March 2015 13:15:13 Andreas Säger wrote: Am 05.03.2015 um 18:36 schrieb SOS: 1. I cannot use 2. LO Base is missing options LibreOffice Base is not a database development platform. It is hardly more than a bridge between databases and office documents. Yes, there is a limited set of form controls
Re: [libreoffice-users] Re: Where is Base?
Hi Tom, just for your information, the german Base manual is for version 4.4 of LO, in other words hot new. Well at least is what is claimed on their table where they list all manuals they have for Base (from 3.5 to 4.4). And best of all it is complete (up to chapter 11 and there are also two database example versions - with and without comments). Oh, thanks for the OmegaT contact, I'll surely will contact him. I've alredy looked in the address you sent me, but haven't spent much time on it. Ralf On Monday 09 March 2015 16:46:29 Tom Davies wrote: Hi :) The main man to chat with about OmegaT is Milos errr, i dunno his surname! :( He has done a huge amount of work with them to set-up something for LibreOffice. It is good that you started translating by starting on the Base Handbook. It means you really can work at your own pace because i seriously doubt anyone else is working on it. As you point out it is a good thing to work on but i think people tend to be a bit scared of database programs generally (probably thanks to needless complexity that Access exposes normal users to far too early). On this mailing list we found that it was after the Faq section about Base and the first chapter of the Base Guide were both completed that there were suddenly a lot more threads discussing Base. It led to a resurgence of interest with people joining in and getting to know it and even becoming devs for it. Errr, i guess i should have mentioned that there is a more up-to-date version of the Handbook available through the Documentation Team (extremely low-traffic mailing list at the moment) - but they would have to register you at ODFauthors for you to get at the pre-released version of the 4.2.x version. Regards from Tom :) On 9 March 2015 at 13:34, Ralf Kersanach dmbr...@furg.br wrote: Hi Tom, Well, I'm translating it to brazilian portuguese. I know that there is an libreoffice site available for Brazil, but since my time is really limited, I'd rather to it in my pace than on any time shedule. Anyway, thanks for the tip, I'll have a look at this international list and find out exactly what OmegaT is. At the moment I'm already through half of the introduction chapter. Anyway, as I said im my previous posting, I am very happy in finally finding a manual that really explains Base in an updated software version. At moment I'm using the the TradutorOOoText extension. It has several pitfalls in translating from german to portuguese, but it's quite a help. It sounds that OmegaT is more professional for translations, so I'll contact them and see how I can help. The reason why I'm starting the translation with Base is because I need to build an database to mine some data out of DNA sequences. I was doing it using SQL statement with mysqlworkbench. It was nice, but I wanted to do a more beautiful and user friendly layout and I am not prepared (due to lack of time) to learn an script and HTML languages just to build an GUI for this database. I searched a lot between possibilities which were similar to Filemaker (I've used it a lot before I changed to Opensource), and the two most friendly, in my opinion, where Base and Kexi. Personally, I don't use the portuguese version of LO, I use the english(UK)user interface, because of the help file which does not come with the (USA). For the locale setting I use portuguese (Brazil), well because is where I live. Well, once more thanks for the tip. On Monday 09 March 2015 11:22:55 you wrote: Hi :) The international translator's mailing list is just starting to experiment with translating the Published Guides, such as the Base Handbook, using OmegaT. OmegaT helps in many ways but just one of them is that it seems to track (or identify) what has changed in a newer release of the same guide so that only the changes need to be translated to bring your translation up-to-date. I suspect that they will probably start with the Getting Started with LibreOffice guide, then do the Writer Guide, then the one for Calc and then work through all the rest before ever getting to the Base one(s). If you are alread working on translating the Base Handbook then you would be a huge asset to the translation team of whichever language you are working on. There are a few teams that have worked on translating the guides but it is a struggle, especially until using a decent tool such as OmegaT. The international translators mailing list address is; l...@global.libreoffice.org (capital letters, upper-case and lower-case all get converted to just lower-case by emailing systems so they are only useful for human readers and it really doesn't matter if you get upper and lower case muddled up). Regards from Tom :) On 6 March 2015 at 14:21
Re: [libreoffice-users] Re: Where is Base?
I guess Andreas is right in all his observations. I'll never expected LO or similars to be an top Databse development front end (although if it would reach filemakers level would be nice). What I expect, as a non IT person, from such kind of platform, is to help me out to delevelop relative simple to medium simple personal and sometimes professional problems without having to learn several programming languages to achive the same through web pages. I have some friends which simply gave up building such DB just because it was to cumberson to learn several different thinks to achieve one purpose only. I thing every tool is a right tool if we keep their limitation in mind and I think Base is in the absolute right direction. After starting to read the 4.4 manual, Tom pointed me out, I got over enthusiastic again, because I saw how much progress the Base team has done (good work folks). I got so enthusiastic that I started to translate it to my native language (as soon I reach some chapter translated I'll make the drafts available). I think that one of the major draw backs of Base and why people isn't using it is the lack of up to date manuals. There more up to date literature and information is available more people can understand power and limitations of base and how to employ it. I know there are some tutorials around, but there more there better so people can see what is possible to do with base. I know the develop and documentation team might be small for this herculean work but as I said before good job folks, the rest comes with time. On Friday 06 March 2015 13:15:13 Andreas Säger wrote: Am 05.03.2015 um 18:36 schrieb SOS: 1. I cannot use 2. LO Base is missing options LibreOffice Base is not a database development platform. It is hardly more than a bridge between databases and office documents. Yes, there is a limited set of form controls and yes, it comes with macro languages anyway. The core functionality is built around the ODF standard. Database connectivity is a *simple* give-away which can be used in various ways, mainly to fill ODF documents with external data. Filemaker and Access are a completely different category. -- 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] first step forward
Hi Tom, would you mind sending me the link to this book in german or is it only available in hardcopy? Thanks Ralf -- Laboratório de Biodiversidade Genética Instituto de Ciências Biológicas Universidade Federal do Rio Grande - FURG Av. Itália, s/n, Carreiros 96201-900, Rio Grande, RS - Brasil Tel.:+.55.53.3293.5128 +.55.53.3233.6742/6538 e-mail:dmbralfatfurg.br msn:r_kersanachathotmail.com skype: ralfkersanach On Tuesday 03 March 2015 17:29:26 Tom Davies wrote: Hi :) You might find this website more useful; http://pl.libreoffice.org/ Also the Polish language mailing list might be easier as you can use Polish; https://wiki.documentfoundation.org/Local_Mailing_Lists#Polish or if your main language is something else then there is probably a different mailing list for that too. I think most people use spreadsheets (ie Calc or Excel) to create an array of numbers. However if this for bookkeeping then you might find it better to use a specialist tool such as GnuCash (also Libre and free OpenSource program). It really depends on what you are trying to do. If you think a database might be better then using Base as a front-end with an external back-end such as MySql/MariaDb, Postgresql or something else is probably a good idea. Some people have a go with a spreadsheet first as part of the planning process before designing a database. There is a book about how to use Base but it is primarily only available in German. The English one is quite outdated now (already! Time flies!) and the translator teams are often even smaller and mostly have only just begun to think about translating the Published Guides. Of course they do have the built-in help but it sounds like you really need something a bit more hefty to get a good overview. If you can find it in an appropriate language then you might like the Getting Started Guide Regards from Tom :) On 2 March 2015 at 23:22, an...@neostrada.pl wrote: Hello, Just few days've gone, I had opportunity to discover your LibreOffice 4.4.1.2. I've got really impressed. Unfortunatly, there is not enough time, till now, to answer the question: Is the LO abbly, for example, to proceed efficiently a specific arrey of numbers (a kind of compilation)? I'm pretty sure, but to get forward I've attached simple sample as below. Is the spreadsheet, or rather is the database the proper tool? Could you proceed the sample, please? Best regards, Andrew Anddos -- 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] first step forward
Hi Tom, many thanks for the links. Ralf -- On Tuesday 03 March 2015 23:32:21 Tom Davies wrote: Hi :) The link to the English translation is; https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_B ase_Handbook The original in German is; https://wiki.documentfoundation.org/Documentation/de#Handbuch_f.C3.BCr_Base_ .28Datenbank-Programm.29 Regards from Tom :) On 3 March 2015 at 18:40, Ralf Kersanach dmbr...@furg.br wrote: Hi Tom, would you mind sending me the link to this book in german or is it only available in hardcopy? Thanks Ralf -- Laboratório de Biodiversidade Genética Instituto de Ciências Biológicas Universidade Federal do Rio Grande - FURG Av. Itália, s/n, Carreiros 96201-900, Rio Grande, RS - Brasil Tel.:+.55.53.3293.5128 +.55.53.3233.6742/6538 e-mail:dmbralfatfurg.br msn:r_kersanachathotmail.com skype: ralfkersanach On Tuesday 03 March 2015 17:29:26 Tom Davies wrote: Hi :) You might find this website more useful; http://pl.libreoffice.org/ Also the Polish language mailing list might be easier as you can use Polish; https://wiki.documentfoundation.org/Local_Mailing_Lists#Polish or if your main language is something else then there is probably a different mailing list for that too. I think most people use spreadsheets (ie Calc or Excel) to create an array of numbers. However if this for bookkeeping then you might find it better to use a specialist tool such as GnuCash (also Libre and free OpenSource program). It really depends on what you are trying to do. If you think a database might be better then using Base as a front-end with an external back-end such as MySql/MariaDb, Postgresql or something else is probably a good idea. Some people have a go with a spreadsheet first as part of the planning process before designing a database. There is a book about how to use Base but it is primarily only available in German. The English one is quite outdated now (already! Time flies!) and the translator teams are often even smaller and mostly have only just begun to think about translating the Published Guides. Of course they do have the built-in help but it sounds like you really need something a bit more hefty to get a good overview. If you can find it in an appropriate language then you might like the Getting Started Guide Regards from Tom :) On 2 March 2015 at 23:22, an...@neostrada.pl wrote: Hello, Just few days've gone, I had opportunity to discover your LibreOffice 4.4.1.2. I've got really impressed. Unfortunatly, there is not enough time, till now, to answer the question: Is the LO abbly, for example, to proceed efficiently a specific arrey of numbers (a kind of compilation)? I'm pretty sure, but to get forward I've attached simple sample as below. Is the spreadsheet, or rather is the database the proper tool? Could you proceed the sample, please? Best regards, Andrew Anddos -- 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] Re: Where is Base?
Hi everbody, although I am not an data IT person, I've been a long time user of openoffice/libreoffice. I'll allways wanted to use LO as an official front end for an database; first of all because I do not know how to program html (even with all those facilities we have today) and also I don't want to start now learning how to program in an script language. So I always hoped to find an GUI front end for an database, that would feel very similar to FileMaker (Mac/win). Well those that claim, that base is already very similar probably never used FileMaker intensly. Even Kexi which is also claimed to be as good as FileMaker is mile away from it. Don't take me wrong here I don't want to make any apology to this program, but they really got it quite right. Even though still thing that LO and similar are the way to go. But I think for sometime its being a unstable GUI crashing once and a while. After lefting it to rest for some time, last week, I took courage to restart an small project I wanted to move from an Calc tables to an real DB. I started using Kexi and tested again if LO Base would connect to the MariaDB with the native mysql driver it went flawlessly. One improvement I immediately saw (or at least as far as I remember), was the hability to see tables not generated by LO and read/write data as well. The last time I used base, if I remember well, base could only read tables from an DB if it generated the tables. But other simple things like changing the order of fields (with MariaDB as backend) do not work in LO but in Kexi it works. It seems also that crashing event were eliminated or reduced to a minimum. I don't want to compare GUI and list advantages or disadvantages, I just want to point out that although big leaps happened since I last tried to use base, what makes me very happy. On the downside, to become an great and easy to use GUI for developing grahical DB interfaces, if comparing with FileMaker, there is still along way to go. I tell this because I've used FileMaker for a while. I've learned to use it in quite a short time (~ 3-4 month) and did fairly complex reports, queries, etc in graphic mode. I can not say the samething for SQL likes. Probably my problem. But I belive that base is the right way to go, because it is an multiplataform program that links to several diferent DB programs and is open, I think two key conditions for the success of an software, as Fernand Vanrie mentioned. More up to date literature and how-to's would be a nice help and also an harder development unfortunately this last one I can not help due to my limitations. Greetings -- On Monday 02 March 2015 20:23:49 Tom Davies wrote: Hi :) Apparently another great database program to use as a back-end is Postgresql. Some of the Postgresql people worked with the LibreOffice people to make a really good connector and then got that connector into LibreOffice main trunk. So, Postgresql has an advantage over MySql in not needing a connector, apparently. I dunno how it gets updated though! Also MariaDb is a drop-in replacement for MySql and i think a few places use it but continue to claim they are using MySql. Apparently all the MySql connectors work just the same but i've only heard from a very small number of people about that and the person who makes/builds the MySql connector wasn't certain they would work. I think those are all the larger database back-ends but HSqlDb is supposedly faster and more efficient with small databases such as almost all address books. There are tons to choose from though so you might find that whatever is being used somewhere already can probably be viewed and edited through Base. I think the way Base makes it so easy to connect to external back-ends is one of the huge advantages that Base offers. Instead we try to cripple it by giving it an internal back-end to make it as broken as Access. Regards from Tom :) On 2 March 2015 at 19:04, Andreas Säger ville...@t-online.de wrote: Am 02.03.2015 um 19:33 schrieb Florian Reisinger: Just a short note: Base can connect to a MySql database using a connector. I even think, knowing not much about Base, that an external database for storage is a very good way to go...Am 02.03.2015 16:54 schrieb Peter Goggin petergog...@bigpond.com: External is the one and only way to go. The embedded HSQL 1.8 simply does not work well enough. There are far too many reports of total data losses which is inacceptable for a database product. You can connect MySQL via ODBC, JDBC and the SDBC driver built into the office suite. I prefer external HSQL 2.3 via JDBC because the office frontend is tailored around HSQL, because HSQL 2 converts formerly embedded HSQL 1.8 on the fly and because any connection to an external HSQLDB requires only one file hsqldb.jar anywhere on the system. In server mode it takes this file plus self made start/stop scripts and