Re: [libreoffice-users] Re: Time-lag response in v. 4.4.0.1 Writer - Update
Hello Tom Thanks for your further thoughts on this. As it so happens, I did something else which seems to have fixed the problem (touch wood). Basically, I uninstalled 4.4 and reinstalled 4.3.5.2 (fresh), uninstalled the LibO plug in from Mendeley, reinstalled it and took it for a run. At first, same problem, then after a few minutes (and testing this problem on another document written previously and with Mendeley references) the lag stopped. I'm tempted to go back to 4.4. but since I need this for production work (i.e. my thesis), I think I'll stick with this version (4.3.5.2) for now. Thanks again. All the best Sun On 09/01/15 13:33, Tom Davies wrote: Hi :) It might be. You can test to see if any Extensions/Plug-ins or configurations and settings are causing it by renaming your User Profile; https://wiki.documentfoundation.org/UserProfile Then when you re-open LibreOffice it automatically creates a fresh new one, taking you Back to factory defaults. If that doesn't fix things then you can delete the new one and rename the old one back to the right name. It is often a good idea to create a copy of your user profile when you are reasonably happy with the way LibreOffice is working. I tend to add the date in reverse order at the end of the file-name to make it easier to figure out which backup-copy is likely to be best. Regards from Tom :) On 8 January 2015 at 18:21, Sun Shine phaedr...@gmail.com wrote: Update: Changed the auto-save setting, and that hasn't helped. Closed out all other open documents. No change. I wonder if it is an interaction problem with the LibreOffice Mendeley Plug-In? Does anyone else use Mendeley Desktop reference management software v. 1.12.4 with LibO 4.4.0.1? If so - can this lag be replicated? Not sure if this is a LibO or a Mendeley issue at this point. Thanks for any ideas. Sun On 08/01/15 17:43, Sun Shine wrote: Thanks all - I've changed the auto-save time and will see if that has any effect. Best wishes Sun On 08/01/15 17:35, Tom Davies wrote: Hi :) Tools - Options - Load/Save - General Then about half-way down the default is to save every 15mins. You might find it helps to make it half-hourly or so. Good luck and regards from Tom :) On 8 January 2015 at 15:17, Rob Jasper r...@famjasper.nl wrote: Now you mention it.. I've had this both on my slow PC and on my Mac. However, I now realize that since I changed my disk for a SSD I never had it again (even while working on a very old Mac: 24 , end 2006, 2,16 GHz Intel Core 2 Duo) Rob Op 8 jan. 2015, om 16:09 heeft Oogie McGuire het volgende geschreven: It might be due to how often LO is doing a backup of your text. With a large document it can take a while. I've had that happen to me too on all revisions of LO on a Mac with large documents. I just got used to it. I figured I'd use it as a way to take a break, look away from the screen and stretch my fingers. Perhaps there is a setting you can change to make the timing different or turn it off? I don't know abut that I never bothered to look for it. I've used the emergency recovery feature too often to turn off the automatic saving that happens occasionally. Eugenie (Oogie) McGuire Desert Weyr, LLC - Black Welsh Mountain Sheep http://www.desertweyr.com/ LambTracker - Open Source SW for Shepherds http://www.lambtracker.com Paonia, CO USA -- 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 -- 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] Form field reference to query in Base [?]
Hallo everyone. Background: We are using a spreadsheet with a pivot table to generate price lists. The price lists show prices for some sets of products. Each time somebody wants to see actual price, must do 2 things: - choose a name of the set from a drop down list and - put a current rate in a certain cell to update the prices. Then the spreadsheet: 1. checks what kind and how many items belong to the certain set 2. checks foreign description of each item and puts its proper translation 3. checks prices, multiply them by the given rate and number of items and sum up everything 4. runs macros to format data and present it nicely in the pivot Everything works fine until I have to make data modifications (i.g. if some products are not produced any more, or the prices are changed etc.). At this point updating a spreadsheet becomes a complicated and time consuming task. I think it would be easier for me to maintain these data in LO Base instead of using spreadsheet. I believe everything could be accomplished with some tables, one or few queries and front-end form that will be based on these queries. This form will be used to retrieve and present data only (not for modifying data in database). Question before I'll start designing a database (I'm a novice in Base): Is it possible to make a field in this front-end form where users can put a rate to calculate prices in the table or query on the fly (like in the spreadsheet, where a certain cell is referred to a range of cells in another worksheet)? I'll appreciate any help. Regards, gordom -- 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] Conditional DB-Fields
Hello, I want the following to work in writer (LO 4.3.5.2, Linux-Mint 17): if db.table.field != - print db.table.field else print nothing. In other words - if a field in a DB-tuple isn't empty I want LO to print that field, otherwise don't print anything. I have no problem printing fixed text if a condition is fulfilled. However, I can't get it to work in case I want the DB-field itself printed. Regards H. Stoellinger -- 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] Conditional DB-Fields
Heinrich , in the past i used the the name of the DBfield in a expression of a Conditional field. something like: suppose your DBfield is namend GENDER then if GENDER = Women. hope it helps Fernand Hello, I want the following to work in writer (LO 4.3.5.2, Linux-Mint 17): if db.table.field != - print db.table.field else print nothing. In other words - if a field in a DB-tuple isn't empty I want LO to print that field, otherwise don't print anything. I have no problem printing fixed text if a condition is fulfilled. However, I can't get it to work in case I want the DB-field itself printed. Regards H. Stoellinger -- 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] Form field reference to query in Base [?]
gordom , One advise: do not use forms , make your own dialogs with controls. Then you need to write some macro's to run the queries and fill the controls with the data from your queries or table contents. Greetz Fernand Hallo everyone. Background: We are using a spreadsheet with a pivot table to generate price lists. The price lists show prices for some sets of products. Each time somebody wants to see actual price, must do 2 things: - choose a name of the set from a drop down list and - put a current rate in a certain cell to update the prices. Then the spreadsheet: 1. checks what kind and how many items belong to the certain set 2. checks foreign description of each item and puts its proper translation 3. checks prices, multiply them by the given rate and number of items and sum up everything 4. runs macros to format data and present it nicely in the pivot Everything works fine until I have to make data modifications (i.g. if some products are not produced any more, or the prices are changed etc.). At this point updating a spreadsheet becomes a complicated and time consuming task. I think it would be easier for me to maintain these data in LO Base instead of using spreadsheet. I believe everything could be accomplished with some tables, one or few queries and front-end form that will be based on these queries. This form will be used to retrieve and present data only (not for modifying data in database). Question before I'll start designing a database (I'm a novice in Base): Is it possible to make a field in this front-end form where users can put a rate to calculate prices in the table or query on the fly (like in the spreadsheet, where a certain cell is referred to a range of cells in another worksheet)? I'll appreciate any help. Regards, gordom -- 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: Time-lag response in v. 4.4.0.1 Writer - Update
Hi :) The 4.3.5 is a good choice. That 3rd digit is roughly the equivalent of Microsoft's Service Packs but divided by 2, so the x.x.4 is roughly like Service Pack 2. LibreOffice and many, perhaps most, OpenSource projects work on 2 branches keeping both updated and current. The 'newer' branch (the one with the lower 3rd digit) tends to have more and newer features but because of that, because you can't make an omelette without breaking eggs, it sometimes suffers unexpected problems or unexpected things go a bit wonky. Hence why the older branch is still actively used and developed. The older branch has less new features which makes it less likely to have unexpected problems suddenly appearing. It gets bug-patches and fixes to fix the problems that may have appeared earlier in the branch's life-cycle. Usually branch's aim to keep producing new releases until it reaches x.x.7 although usually a branch is so solid after x.x.4 that it's decided the x.x.6 is going to be the last release for a branch. So, 4.3.5 should really be Still, because it's after the x.x.4 of that branch, but a few unusual things seem to have happened over Xmas and we have ended up with 3 active branches. Really that should probably be 2 Still branches and 1 Fresh but i'm guessing there are still discussions going on about that elsewhere. Anyway, the 4.3.x is a good choice as there are still a couple more releases due in that branch over the next few months so it's very much active. Regards from Tom :) On 10 January 2015 at 09:36, Sun Shine phaedr...@gmail.com wrote: Hello Tom Thanks for your further thoughts on this. As it so happens, I did something else which seems to have fixed the problem (touch wood). Basically, I uninstalled 4.4 and reinstalled 4.3.5.2 (fresh), uninstalled the LibO plug in from Mendeley, reinstalled it and took it for a run. At first, same problem, then after a few minutes (and testing this problem on another document written previously and with Mendeley references) the lag stopped. I'm tempted to go back to 4.4. but since I need this for production work (i.e. my thesis), I think I'll stick with this version (4.3.5.2) for now. Thanks again. All the best Sun On 09/01/15 13:33, Tom Davies wrote: Hi :) It might be. You can test to see if any Extensions/Plug-ins or configurations and settings are causing it by renaming your User Profile; https://wiki.documentfoundation.org/UserProfile Then when you re-open LibreOffice it automatically creates a fresh new one, taking you Back to factory defaults. If that doesn't fix things then you can delete the new one and rename the old one back to the right name. It is often a good idea to create a copy of your user profile when you are reasonably happy with the way LibreOffice is working. I tend to add the date in reverse order at the end of the file-name to make it easier to figure out which backup-copy is likely to be best. Regards from Tom :) On 8 January 2015 at 18:21, Sun Shine phaedr...@gmail.com wrote: Update: Changed the auto-save setting, and that hasn't helped. Closed out all other open documents. No change. I wonder if it is an interaction problem with the LibreOffice Mendeley Plug-In? Does anyone else use Mendeley Desktop reference management software v. 1.12.4 with LibO 4.4.0.1? If so - can this lag be replicated? Not sure if this is a LibO or a Mendeley issue at this point. Thanks for any ideas. Sun On 08/01/15 17:43, Sun Shine wrote: Thanks all - I've changed the auto-save time and will see if that has any effect. Best wishes Sun On 08/01/15 17:35, Tom Davies wrote: Hi :) Tools - Options - Load/Save - General Then about half-way down the default is to save every 15mins. You might find it helps to make it half-hourly or so. Good luck and regards from Tom :) On 8 January 2015 at 15:17, Rob Jasper r...@famjasper.nl wrote: Now you mention it.. I've had this both on my slow PC and on my Mac. However, I now realize that since I changed my disk for a SSD I never had it again (even while working on a very old Mac: 24 , end 2006, 2,16 GHz Intel Core 2 Duo) Rob Op 8 jan. 2015, om 16:09 heeft Oogie McGuire het volgende geschreven: It might be due to how often LO is doing a backup of your text. With a large document it can take a while. I've had that happen to me too on all revisions of LO on a Mac with large documents. I just got used to it. I figured I'd use it as a way to take a break, look away from the screen and stretch my fingers. Perhaps there is a setting you can change to make the timing different or turn it off? I don't know abut that I never bothered to look for it. I've used the emergency recovery feature too often to turn off the automatic saving that happens occasionally. Eugenie (Oogie) McGuire Desert Weyr, LLC - Black Welsh Mountain Sheep http://www.desertweyr.com/ LambTracker - Open Source SW for Shepherds
[libreoffice-users] Re: Conditional DB-Fields
Am 10.01.2015 um 16:32 schrieb Heinrich Stöllinger: Hello, I want the following to work in writer (LO 4.3.5.2, Linux-Mint 17): if db.table.field != - print db.table.field else print nothing. In other words - if a field in a DB-tuple isn't empty I want LO to print that field, otherwise don't print anything. I have no problem printing fixed text if a condition is fulfilled. However, I can't get it to work in case I want the DB-field itself printed. Regards H. Stoellinger 1) Insert Field Other Tab Functions 2) click on Field type Conditional Text (or similar, I don't know the exact english terms as I use a German localisation) 3) Enter... Condition:!db.table.field Then: (leave empty) Else: db.table.field Works well on my machine (4.1.6.2/Linux x64) Nino -- 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: Conditional DB-Fields
Am 10.01.2015 um 16:32 schrieb Heinrich Stöllinger: Hello, I want the following to work in writer (LO 4.3.5.2, Linux-Mint 17): if db.table.field != - print db.table.field else print nothing. In other words - if a field in a DB-tuple isn't empty I want LO to print that field, otherwise don't print anything. I have no problem printing fixed text if a condition is fulfilled. However, I can't get it to work in case I want the DB-field itself printed. Regards H. Stoellinger Base is not a database. If your Base document is connected to some kind of HSQLDB (see status bar), the following expression serves your need: COALESCE(Field Name, '') The embedded version 1.8 of HSQL is documented here: http://www.hsqldb.org/doc/1.8/guide/ch09.html -- 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