[libreoffice-users] RE: Formulas displaying in a cell
Please ignore this note. I found the problem. Sent from Mail for Windows 10 From: Harv Sent: Thursday, January 7, 2016 10:49 AM To: users@global.libreoffice.org Subject: Formulas displaying in a cell Hello, I can’t figure out why I have certain cells displaying the formula and not the results. I’m using calc version 5.0.4.2. Cells x12 and x13 in the attached file show the problem. Also, if I cut and paste the formula from x11 it does the same thing. The same problem exists with OpenOffice but the problem does not exist in Google Sheets. Any ideas? Thanks, Marc Schell By the way, will I get emails of any replies to this problem or is there someplace I go to see comments? -- 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: Linking a Form to another table
Hello, Ian Whitfield schrieb am Dienstag, 5. Januar 2016 13:40: > I have another table of data that I would like to link to an existing > Form. > > The Form was originally linked to Table "ABC" but I now want to link it > to table "Name/DEF". > > Is this possible and how would I do this please?? I suppose you could manage this by changing the properties of the form. E.g. in the Form Editor right-click any form element and choose "Form..." and see at the tab "Data". Alternatively select "Main Form" in the Form Navigator. HTH Stefan -- system: opensuse 13.2 -- 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] Linking a Form to another table
Hi All I take from the lack of any replies to my post of a few days back that either anyone who can help out is still on Christmas Holidays or this just can not be done ?? Ianw Pretoria RSA -- 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: Creating new global Gallery themes
Le 07/01/2016 18:41, anne-ology a écrit : Hi Anne, >Please could someone explain what these gallery themes are; > are they perhaps additional images for LO's PP and/or for LO's > Writer - > if so, where are they located and how does one access? > > They can be found via the Insert - Media - from Gallery menu or else via the sidebar, e.g. in Writer, fourth button down. The default themes are stored in /resources/gallery/ of your LibreOffice application installation. HTH, Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Anaphraseus extension
Hi Thomas Installing Anaphraseus 2.05.126b on LO 5.0.4.2 under Windows XP returned and error message but the toolbar was installed. I have no idea if it works as expected because I don't have any Translation Memory files :) Why are you using LO 4.4.3.2? If you want to stay on the 4.4 branch it would make sense to update to 4.4.7 (the extension installed without any problems on my PC) Do you have the latest Java installed? So, the answer is: it does seem to work (at least the toolbar is there and the buttons work...) -- View this message in context: http://nabble.documentfoundation.org/Anaphraseus-extension-tp4171044p4171051.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] Anaphraseus extension
Good evening I am trying to install the "Anaphraseus extension": 1)Windows 10 machine (new, high spec), LibreOffice = 4.4.3.2 / Anaphraseus 2.04.99b Installation (after some trouble) achieved, but when trying to start: Open Basic error in "An exception occurred Type: com.sun.star.container. NoSuchElementException Message: Line 32" 2)Windows 7 machine; LibreOffice = 4.4.3.2 / Anaphraseus 2.03.92b Anaphraseus 2.04.99b Anaphraseus 2.05.126 ALL attempts at installing these three versions result in: "an error occurred during file opening" Installation and startup worked on a Linux machine. (Although there Anaphraseus tells me after translating just ONE segment, that there are no other segments to translate. Not very helpful.) Is there a trick, some sort of magic to make this work? Or should I conclude that it does not work? Thank you in advance. Thomas -- 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] BaseForms: transferring contents of data fields to the database table
Hi Egbert, Andrew Pitonyak's "Open Office.org Base Macro Programming" on page 45 states - The safest solution is to modify the bound field directly. For example, your current code may be as follows: oControl.setString("myText") It is better if you can use the bound field: oControl.BoundField.updateString("myText") The required method is dependent on the data type, which is a drawback to this method. I am aware of at least one instance where the specific method (updateDate) failed, yet the generate updateString method properly updated the bound field. I have found that BoundField.updateString works well in situations such as yours. I have also worked out how to cover the problem of using a Macro to write to a Date field. If you ever need to do this, I could send you the code. Noel -- Marion & Noel Lodge lodg...@gmail.com On 5 January 2016 at 14:24, Egbert Eissing wrote: > I have a main form and a sub form. > The main form holds one single record, the sub form contains multiple > records related to the record in the main form. > Both forms are holding alphanumeric and also pure numeric data. > I wrote a macro to evaluate and calculate the numeric data in the sub form > and deposit the results in fields of the main form. > > Now my problem: The numbers placed in the main form fields by means of the > macro are not recognized by the back end MySQL database. These simply are > not transferred, whatever I do. (If I write some figures in manually, the > same are being transferred without problem.) What can I do to work around > this problem? Is there any kind of trick that makes the form believe that > the automatically generated data have been put in by hand and treated > accordingly? I am sure there must be a solution to this. > Thanks for any help. > > -- > 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