[libreoffice-users] Using Libreoffice as an AppImage
I saw a recent message about LibreOffice as a AppImage. Got me thinking that they might be a way for me to use a newer version then that available in the Mint package manager. I did some googling and found some basic info on using AppImages and LibreOffice but nothing that answered the questions listed below. 1) Will the AppImage version run my current spreadsheets? I assume there must be a way to pass a path to it. 2) I have a couple of Python macros that I use to manipulate sheets. Will they still work in it. 3) I have some sheets that I start with: --accept="socket,host=localhost,port=2002;urp;StarOffice.ServiceManager" So I can manipulate them from outside of the sheet. Will this be possible with the AppImage version? Thanks, Jim -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] What happened to Search
I recently moved from Mint 18.3 (LO 5.1.6.2) to Mint 20 (LO 6.4.6.2). After the move a Python script that worked fine in 5.1 no longer works correctly in 6.4. I found that in 5.1 if I did File-->Open a dialog opens that has a Search option up in the top left corner. In 6.1 the dialog opened with File-->Open no longer has a Search option. Is there a way to get the Search option back? Thanks, Jim -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Mouse cursor not moving to default dialog button
Linux Mint 20 - LO 6.4.6.2 When I was using Libreoffice on Mint 18.3 I was able to do Tools-->options-->view-->Mouse-->Positioning: Default button and the cursor would move to the default button. Now setting this option does not move the cursor to the default button, in fact it does not move it at all. I only really use Calc so this is where I notice it. Anyone else seeing this and have a work around? Thanks, Jim -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Re: python macros article
On 08/08/2016 04:12 AM, Piet van Oostrum wrote: Jim Byrnes wrote: > A while ago I read an article about updates to python uno in LO to make > it easier to use. At the time I didn't have the time to really pursue > it and forgot to bookmark it. Now I can't find it again. > > Does anyone maybe have a link to such an article? > > Thanks, Jim https://conference.libreoffice.org/assets/Conference/Aarhus/Slides/MatthewFrancisPyUNO.pdf http://nabble.documentfoundation.org/PyUNO-usability-improvements-td4151556.html Thank you. That's it. Regards, 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
[libreoffice-users] python macros article
A while ago I read an article about updates to python uno in LO to make it easier to use. At the time I didn't have the time to really pursue it and forgot to bookmark it. Now I can't find it again. Does anyone maybe have a link to such an article? Thanks, 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
[libreoffice-users] Re: Directory for Python Macros?
On 07/11/2016 11:31 AM, Jonathan Levi wrote: I’ve started learning to create Python macros for LibreOffice, but I need advice on where to put them. if I put them in /Applications/LibreOffice.app/Contents/Resources/Scripts/python (I'm using Mac OS X El Capitan, version 10.11.5, LibreOffice version 5.1.3.2, containing Python 3.5.0) they show up in the LibreOffice Macros section in the Python Macros dialogue. This works, but I would rather not insert them into the LibreOffice.app directory tree. Does anyone know what folder corresponds to the My Macros section in the Python Macros dialogue instead? I don't know about a Mac but on Linux (Ubuntu) mine are in: /home/jfb/.config/libreoffice/4/user/Scripts/python (note the dot in front of config, it's a hidden file). When I put them there they show up in MyMacros when I go to Tools-->Macros-->Organize Macros-->Python. Regards, 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
[libreoffice-users] Re: FlatPak on Ubuntu 14.04??
On 06/22/2016 10:40 AM, Paul D. Mirowsky wrote: If you are talking about package management. Flatpak is a Red Hat Product. See https://fedoramagazine.org/introducing-flatpak/ It is, but it seems to be going cross platform just like Snap. http://arstechnica.com/information-technology/2016/06/here-comes-flatpak-a-competitor-to-ubuntus-cross-platform-linux-apps/ Ubuntu is using Snap See "Universal “snap” packages launch on multiple Linux distros" at https://insights.ubuntu.com/2016/06/14/universal-snap-packages-launch-on-multiple-linux-distros/ For more in LibreOffice and Snap see "LibreOffice 5.2.0 beta2 as a snap package" https://skyfromme.wordpress.com/2016/06/14/libreoffice-5-2-0-beta2-as-a-snap-package/ Hope it helps Paul On 6/22/2016 8:48 AM, CVAlkan wrote: This is probably more of a flatpak question than a libreoffice question, but ... Will the LibreOffice in FlatPak format eventually be available for Ubuntu versions earlier than 14.04. I've been following the progress of the next LTS version (Ubuntu 16.04), but it doesn't seem stable enough nor have all the app support I need to upgrade yet. Has anyone attempted to "fudge this into working (e.g. upgrading Gnome stuff, etc.)? I've only used one of these "packaged" app systems so far (MuseScore.AppImage) but it appears to work really well ... Thanks for any comments or info ... -- View this message in context: http://nabble.documentfoundation.org/FlatPak-on-Ubuntu-14-04-tp4186884.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] Re: Double Underline in Calc
On 03/29/2016 05:45 PM, Dave Stevens wrote: Quoting Jim Byrnes : On 03/29/2016 04:28 PM, jomali wrote: On Mon, Mar 28, 2016 at 8:24 PM, Jim Byrnes wrote: Using LO vers 4.2.8.2 on Ubuntu 14.04 If I go Format Cells--> Line Styles --> double underline all I see in the cells I am trying to format is a thick dark line. Is there a way to fix this? Regards, Jim using 4.4.2 on Mint 17.2 works fine. It looks like a thick black line but zooming in shows a double underline as specified, I suppose the screen resolution is inadequate at normal zoom view. Dave Here zooming in or out makes no difference. The dark black line remains. I've been through the settings multiple times and can't find any that allows me to see a double underline on the bottom border. I just checked the resolution. I was 1920 x 1080 (16:9), I changed it to 1929 x 1200 (16:10), but there was no change in how the border displayed. Regards, 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
[libreoffice-users] Re: Double Underline in Calc
On 03/29/2016 04:28 PM, jomali wrote: On Mon, Mar 28, 2016 at 8:24 PM, Jim Byrnes wrote: Using LO vers 4.2.8.2 on Ubuntu 14.04 If I go Format Cells--> Line Styles --> double underline all I see in the cells I am trying to format is a thick dark line. Is there a way to fix this? Regards, 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 Using 5.0.5.2 on OS X El Capitan, I see this only when the focus is on the cell. When I move the focus to another cell, the double underline appears. Unfortunately moving the focus to another cell in my case still shows a thick black line in the cell I am trying to format. In fact the thick black line shows up in the User-defined area where I am selecting which border to change. Regards, 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
[libreoffice-users] Re: Double Underline in Calc
On 03/29/2016 09:05 AM, jorge wrote: Hi Jim and all: I use Versión: 4.2.8.2 Id. de compilación: 420m0(Build:2) on Ubuntu 14.04.4 LTS, and I get a good double underline following the same process. Regards, Jorge Rodríguez El lun, 28-03-2016 a las 19:24 -0500, Jim Byrnes escribió: Using LO vers 4.2.8.2 on Ubuntu 14.04 If I go Format Cells--> Line Styles --> double underline all I see in the cells I am trying to format is a thick dark line. Is there a way to fix this? Regards, Jim Philip & Jorge, Thanks for confirming that it should work. Now I can start looking for which setting is keeping it from working. Regards, 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
[libreoffice-users] Double Underline in Calc
Using LO vers 4.2.8.2 on Ubuntu 14.04 If I go Format Cells--> Line Styles --> double underline all I see in the cells I am trying to format is a thick dark line. Is there a way to fix this? Regards, 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
[libreoffice-users] Re: Python
On 03/18/2016 09:44 AM, Mark Stanton wrote: Does the Python macro interface work? Yes Does it work well if it does work? I'm not sure what you mean by well, but it worked well enough for me to write a number of python macros a number of years ago. Haven't written any for a while now. All of mine were written when I was using the 3.xx branch. At that time there was no ide like there was for basic. I don't know if that has changed. Regards, 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
[libreoffice-users] Re: Python
On 03/18/2016 09:36 PM, Paul Hammant wrote: I have tried all the security levels, with re-launches of LibreOffice in between. Yes I can run the sample Python macros. - Paul Again having never used a Mac I am just guessing. Since you can run the samples you know python macros work. Maybe it is a path issue. If you have not done so already try putting your macro in the same location as a sample that works with the proper permissions and see if that helps. Regards, Jim On Fri, Mar 18, 2016 at 9:52 PM, Jim Byrnes wrote: On 03/18/2016 03:55 PM, Paul Hammant wrote: I have not worked out how to activate it :-( Ref http://listarchives.libreoffice.org/global/users/msg47885.html -ph I see from the link you are on a Mac. I am on linux but the last part of your path to the script seems to be about the same as mine would be. Have you set the macro security to a level that will allow you to run macros? I've been tripped up by this a couple of times on new installs. Can you run any of the sample python macros that come with LO? If you can maybe that indicates a path issue after all. Regards, Jim On Fri, Mar 18, 2016 at 10:44 AM, Mark Stanton wrote: Does the Python macro interface work? Does it work well if it does work? 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 -- 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] Re: Python
On 03/18/2016 03:55 PM, Paul Hammant wrote: I have not worked out how to activate it :-( Ref http://listarchives.libreoffice.org/global/users/msg47885.html -ph I see from the link you are on a Mac. I am on linux but the last part of your path to the script seems to be about the same as mine would be. Have you set the macro security to a level that will allow you to run macros? I've been tripped up by this a couple of times on new installs. Can you run any of the sample python macros that come with LO? If you can maybe that indicates a path issue after all. Regards, Jim On Fri, Mar 18, 2016 at 10:44 AM, Mark Stanton wrote: Does the Python macro interface work? Does it work well if it does work? 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 -- 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: Weird Calc behavior: does not add entire range?
On 01/31/2016 05:26 PM, Joshua Kramer wrote: Hello, I'm using LO 5.4.0.2 on Linux, and I have some weird spreadsheet behavior. On one of my spreadsheets, I have a named range. Then I have a cell below it with the formula =SUM(NamedRange). The cell only picks up some of the values! There are 33 rows in this range. If I put a 1 in all of them, the total adds up to 26. If I use the actual cell ranges instead of the name, it adds the cells properly. How could the named range be malfunctioning?? Thanks! If you haven't do so already I would check to see that the named range actually includes all of the cells. Regards, 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
[libreoffice-users] Re: Fwd: Same bug in Fresh and Still
On 09/23/2015 04:49 PM, Peter Nikolic wrote: On Wed, 23 Sep 2015 13:07:16 +0100 Brian Barker wrote: At 02:13 23/09/2015 -0500, Julio Saleme wrote: I was using the Fresh 5.0.1 version and encounter two bugs in Writer 1) at random times when I'm typing the text move to two or three lines above. 2) random black selection shadow appears as I'm writing, when correcting a text and start erasing everything instead of editing (As shown in the picture) Attached files are removed by the mailing list processor before messages are distributed. So no-one will have seen your picture. So I downgraded to the stable version of Still 4.4.5 but the same two bugs happen. How to fix it? It's possible that this is not a software bug and has nothing to do with LibreOffice. Are you perhaps using a system - probably a notebook - with a touch-sensitive trackpad? if so, it is quite possible that you are touching the trackpad with part of your hand - perhaps your thumb - or dragging it over the trackpad whilst you are typing. These actions will respectively move the cursor position or select a region of text, producing exactly the effects you describe. The fact that it occurs with different software versions provides extra evidence for this diagnosis. You notice it in LibreOffice because that is the application you mostly use. You will probably find it difficult to believe that you are doing this, but I can assure you that I have watched people doing exactly this! Since you are concentrating on typing, you will not be aware of exactly what your thumb is doing. Get someone to watch you typing in order to be convinced. If this is your problem, you will find that you can adjust the sensitivity of the trackpad; this setting will be in your operating system (in Control Panel? under Mouse?), not in LibreOffice. If you reduce the sensitivity sufficiently, you should find this problem goes away. I trust this helps. Brian Barker I was about to say the same thing . As i suffer from the self same problem it is the track pad on this laptop that causes my problem, I now use a piece of cardboard to cover the track pad most of the time . Problem fixed .. Pete . On my HP laptop running Mint 17.2 I have a setting under "Mouse and TouchPad" called "Disable touchpad while typing". If you have it on your OS you may be able to get rid of your piece of cardboard. Regards, 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
[libreoffice-users] Re: Size of calc window
On 03/19/2015 05:52 AM, Tom Davies wrote: Hi :) Sorry! I don't have a good answer for this except the weird work-around that is not helping you in this case. :( No problem. Thanks for trying. It's not a game breaker just an oddity I noticed. It might be good to post a bug-report about it. I'm not sure who to but if you post to LibreOffice bug-reporting system the QA Team might be able to help. Apols and regards from Tom :) I am using the old 3.xx branch and I doubt anyone is interested in fixing it now. When I eventually upgrade to the 4.xx branch if it is still present I will at that point. Thanks, Jim On 17 March 2015 at 14:39, Jim Byrnes wrote: On 03/17/2015 06:31 AM, Tom Davies wrote: Hi :) Is this set by the OS rather than by LibreOffice? Oddly it does work for me on Ubuntu 14.04. It does for me to as far as the OS part of it goes, I did a poor job of asking my question. If I have 2 spreadsheets A & B. A is run full screen and B is run using half the screen. If I shutdown A and then reopen A it is full screen. If I shut down B and then reopen B it takes half the screen. What I am asking about is if I shut down A and then open B, B will open full screen. what I would like is A to always be fullscreen and B to always be half screen. Regards. 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
[libreoffice-users] Re: Size of calc window
On 03/17/2015 02:08 PM, Tom Davies wrote: Hi :) There is a weird quirk about LibreOffice. If you open a document and fill in some data (even spaces and made-up stuff seems to kinda work) and then save the document it does a much better job of remembering what size window it was last time it was open. It's one of those weird things that shouldn't make a difference and i think even the devs don't know why it changes anything. Regards from Tom :) Thanks Tom, unfortunately it doesn't seem to help in this case. Regards, Jim On 17 March 2015 at 15:41, Jim Byrnes wrote: On 03/17/2015 10:18 AM, Tom Davies wrote: Hi :) Actually i did get the same results as you on Ubuntu 14.04 and LibreOffice 4.4.1. I've not tried many layers but if i close 2 documents and then open either one of them or something else then the newly opened document uses the same place and size as whichever document i happened to close last. I'm not sure if filling in the; File - Properties - Description with some spaces and stuff makes any difference but i think that is the usual odd thing that makes it behave better. Regards from Tom :) I'm not sure what you are referring to here. I've not seen this mentioned before. I've looked at Options-->Load/Save-->General and see the Load user-specific settings with document. I have it checked and this seems like a "user-specific" setting but the size is not honored. Of course I am still on 3.5.7.2 I thought maybe it had changed but I guess not. Regards, Jim On 17 March 2015 at 14:39, Jim Byrnes wrote: On 03/17/2015 06:31 AM, Tom Davies wrote: Hi :) Is this set by the OS rather than by LibreOffice? Oddly it does work for me on Ubuntu 14.04. It does for me to as far as the OS part of it goes, I did a poor job of asking my question. If I have 2 spreadsheets A & B. A is run full screen and B is run using half the screen. If I shutdown A and then reopen A it is full screen. If I shut down B and then reopen B it takes half the screen. What I am asking about is if I shut down A and then open B, B will open full screen. what I would like is A to always be fullscreen and B to always be half screen. Regards. 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 -- 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: Size of calc window
On 03/17/2015 10:18 AM, Tom Davies wrote: Hi :) Actually i did get the same results as you on Ubuntu 14.04 and LibreOffice 4.4.1. I've not tried many layers but if i close 2 documents and then open either one of them or something else then the newly opened document uses the same place and size as whichever document i happened to close last. I'm not sure if filling in the; File - Properties - Description with some spaces and stuff makes any difference but i think that is the usual odd thing that makes it behave better. Regards from Tom :) I'm not sure what you are referring to here. I've not seen this mentioned before. I've looked at Options-->Load/Save-->General and see the Load user-specific settings with document. I have it checked and this seems like a "user-specific" setting but the size is not honored. Of course I am still on 3.5.7.2 I thought maybe it had changed but I guess not. Regards, Jim On 17 March 2015 at 14:39, Jim Byrnes wrote: On 03/17/2015 06:31 AM, Tom Davies wrote: Hi :) Is this set by the OS rather than by LibreOffice? Oddly it does work for me on Ubuntu 14.04. It does for me to as far as the OS part of it goes, I did a poor job of asking my question. If I have 2 spreadsheets A & B. A is run full screen and B is run using half the screen. If I shutdown A and then reopen A it is full screen. If I shut down B and then reopen B it takes half the screen. What I am asking about is if I shut down A and then open B, B will open full screen. what I would like is A to always be fullscreen and B to always be half screen. Regards. 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
[libreoffice-users] Re: Size of calc window
On 03/17/2015 06:31 AM, Tom Davies wrote: Hi :) Is this set by the OS rather than by LibreOffice? Oddly it does work for me on Ubuntu 14.04. It does for me to as far as the OS part of it goes, I did a poor job of asking my question. If I have 2 spreadsheets A & B. A is run full screen and B is run using half the screen. If I shutdown A and then reopen A it is full screen. If I shut down B and then reopen B it takes half the screen. What I am asking about is if I shut down A and then open B, B will open full screen. what I would like is A to always be fullscreen and B to always be half screen. Regards. 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
[libreoffice-users] Size of calc window
Using LO 3.5.7.2 on Ubuntu 12.04 Sometimes I need a full screen display other times not so big. LO Calc always opens to the size of the last sheet saved even if it is different from the one I am opening. Is there a way to save the size of the window upon closing LO Calc so that each sheet opens to its saved size? Thanks, 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
[libreoffice-users] Re: Printing from Linux, Kubuntu/Ubuntu
On 01/22/2015 11:03 AM, Tim---Kracked_P_P---webmaster wrote: I do not know if you can multi-boot two different versions of Ubuntu based distro, or so I was told a few years ago. I'm pretty sure I have done so in the past, but not doing so now. Wouldn't it be more convenient to install 13.10 in a VirtualBox? Then you could just open it when you need it instead of having to boot to a particular Ubuntu. Reagrds, Jim Be nice to have 13.10 for my photo printing on my default photo printer and 14.04LTS or newer for the rest of the work. As someone told me - off list - CUPS should be installed with the distro, but in my experience not all of the versions I have installed do so until you need it for a "dependency" for a printer driver. On 01/21/2015 01:19 PM, Tom Davies wrote: Hi :) Ahh, mostly the Ubuntu's at work are 14.04. So i might have a try at a LiveUsb or multi-boot with an earlier version alongside the existing set-ups or something. Thanks Tim ! :) Errr, i think the drivers and apps and such are still called CUPS but i think the forums and websites retired didn't they? Is there somewhere such as LinuxPrinting.Org? I might have to have more of a look tomorrow or sometime. Thanks so far and regards from Tom :) On 21 January 2015 at 13:37, Tim---Kracked_P_P---webmaster wrote: On 01/21/2015 08:02 AM, Tom Davies wrote: Hi :) I am just hoping some kind person will signpost me to the proper forums so that they can help me with a couple of printing issues. I gather that CUPS is no longer used but i'm not sure and i don't know what has replaced it. I do not know what is the replacement to CUPS, since every drive I use for Ubuntu and Mint needs CUPS. SO, I install in "manually" via the standard package manager for the distro. My default "printer" is the CUPS PDF "system". That way I have not accidental printing to any specialized printer that I have on my network, which saves paper and ink. At last my work-place has a couple of machines entirely using just Kubuntu/Ubuntu and no Windows at all. With Kubuntu LibreOffice couldn't open files on the file-server but i fudged it by installing the whole Ubuntu DE (Unity DE and tweaks) and now people have no problems using Kubuntu. Printing to the photocopier or the B&W laser printer is fine. The only problem is trying to print to the colour printer, an Oki C810, for which there seem to be hundreds of linux drivers but none of them seem to work. Actually i have only tried about a dozen drivers but it's tricky to test them especially if my boss is around. Which version are you using for Ubuntu-based OS? I have some Canon printers no longer work properly when Ubuntu 14.04 came out. Needed dependencies not longer we supported by 14.04, but was supported by 13.10. Also although the Kubuntu machines have no trouble printing to the B&W photocopier but Ubuntu ones can't cope. I have no idea how to find the drivers on the Kubuntu machines and copy them onto the Ubuntu ones. Regards from Tom :) -- 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] Re: Printing from Linux, Kubuntu/Ubuntu
On 01/22/2015 08:57 AM, Tom Davies wrote: Hi :) Thanks :) I'm trying to find a forum or somewhere i can ask questions. Someone off-list gave me a link to a thread at linuxquestions.org and that has given me a couple of things to check up on. However i was hoping for a way of reaching people who have specialised in printing issues or have some expertise or special interest. LinuxQuestions is a bit too generic. Is there a forum at the Cups website? I thought there used to be one but i can't find one now. Regards from Tom :) Tom, I read this group using gmane, so I searched it for cups and got 7 hits, including comp.printing.cups.general and comp.sysutils.apcupsd.user. Maybe they will be useful to you. Regards, Jim On 22 January 2015 at 14:20, CVAlkan wrote: Tom: CUPS still seems to be alive and well; in fact, I'm not sure how we could get along without it. It is listed in the Ubuntu repository, although has always been installed by default on any installation I've done (admittedly, not a whole lot though). If you use the Software Center, make sure to check any other additions you might require (I have everything but OpenPrinting installed). If you need to install it separately, you can download it from http://www.cups.org/software.php. I hope this helps ... Frank -- View this message in context: http://nabble.documentfoundation.org/Printing-from-Linux-Kubuntu-Ubuntu-tp4136908p4137067.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 -- 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: Support options
On 01/15/2015 12:07 PM, dave boland wrote: The problem with gmane.org is that I can't seem to append to a thread. I can follow the thread, so it is somewhat helpful. What are you using to access gmane? It probably relates more to what you are using to access gmane than gmane itself. I use Thunderbird. Once I subscribe to a group on gmane it asks me how many messages to download and marks the remaining as read. Once downloaded I can choose what I want to view, all msgs, just unread msgs or threads with unread msgs, plus some others I don't use. If I want to respond to a msg I can choose "followup" which sends the reply to the group or "replY" which sends it to the message's author. What is easy and convenient? I thought I answered that. Quick to do, no reistration, no passwords, able to see the appends in a thred like newsgroups do, the abbility to append to a thread. I have lost track of all the user id's and passwords for support web sites. I just won't use them any longer. I think gmane with the right reader will do all of these. So if the LO team can make facebook easy to find relevant info, quick to use, intuitive, no passwords or registration, then go for it. If on the other hand they are just following the latest thing, then forget it. In the end, the support solution needs to fit the users needs, not just be cool. I agree. If facebook and twitter where the only options I would be far out of date with what is happening with LO. Regards, Jim Dave, On Thu, Jan 15, 2015, at 02:44 AM, Charles-H. Schulz wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Le Thu, 15 Jan 2015 03:40:03 +, jonathon a écrit : -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 14/01/15 21:49, dave boland wrote: Can't we find a way to offer support that is easy and convenient? What do you consider to be _easy_ and _convenient_? that new groups are considered old fashioned, but they work very well, If "new groups" is a typo for newsgroups, then gmane.org is what you are looking for. If "new groups" means something else, then clarify what is meant. Just to be abundantly clear: this list alongside other lists of LibreOffice.org are available as newsgroups on gmane.org Best, - -- Charles-H. Schulz Co-founder, The Document Foundation, Kurfürstendamm 188, 10707 Berlin Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts Legal details: http://www.documentfoundation.org/imprint Mobile Number: +33 (0)6 98 65 54 24. -BEGIN PGP SIGNATURE- Version: GnuPG v2 iQIVAwUBVLdvw36ia1m3mLTjAQLkIQ/+O1ngQJv8A8GXcKI2dhFvPhfJz+eqR5Aq klmRqGApOxZbt/sLf9sY8DHz7G5TbYilaISaW6nUaX3YqMg4GJynh67wk9qutFew sLT8kXFzaHX4uWkhygKyKm647lZwbGZm5nRXfIy6wQXqz9RDQxyVN/V018fad6eG fSrOORTKmQLHv1K6xLZiEKG6IDjITJ3RyW7r7ia8ApjsOjtzvqoI20isn38tNCFm LC0Mu6E3i1jV6QVSiq+TJmZoh0lnFw9IjG+Kk7BHcuzPdZb9Py/wi15VkpHN7SXV dWdeJY8vE+6fCIWK+U2ngGKiUGuF6ZLaRt7Wi63Ea1BKodv2HBRre8QCrPqwu8tv jnC2LR+qHjRBLFkYXd/+lYkhWf7kbvYpJNsWaKCu6cQql3cn5f7Sv2/tYooe8DN4 pfdEG/5ZcMU9tymHXDhYTZYw/5/fFYQtA50CDg/GDeBxkYJefjfQdsKxqELsw3x7 q5YOMDKZjbtOV1D/RXLV9ZWfNCamtcG4vH3b/8R3QQqEvrnFDxrTH1s+BmuiR03K WIQZIiVgc1KT4weSMb+0LpBu3MOxZL2D350nOZn8gfv2lBlv2420ABlLdgJu4Pc1 uTSLtp+H5vz/av/qrqY30CMl2Sh0ffCVZdUhpdPFY3ioB+uwNXNWDmZ0BDl1UCnL Xwp/KuNtzjI= =byES -END PGP SIGNATURE- -- 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] Re: macro to add annotation to selected text range
On 11/19/2014 12:30 PM, Matt Price wrote: So, I gues there is an API reference: http://api.libreoffice.org/docs/idl/ref/index.html I had trouble loading that page. I usually use the OpenOffice one at: http://www.openoffice.org/api/docs/common/ref/index-files/index-1.html But unfortunately it doesn't give direct documentation for Basic functions. I found this document instead, which tells me where in the API the actual function calls come from: Yes, lack of more comprehensive documentation is a real pain. Hopefully someone with more knowledge than myself will comment on what I am about to write if I am wrong. With the exception of ThisComponent, what you refer to as Basic functions are not really Basic functions at all. Basic simply uses functions/methods supplied by Uno. I could write the same macro in Python but still use the same functions. To me Uno is a huge complex beast that is sparsely documented and hard to use, but very powerful if you understand it. Regards, Jim http://bernard.marcelly.perso.sfr.fr/index2.html The useful macros are embedded in the "XRay Tool". It would sure be nice to have something like this in the BASIC editor itself - -I am used to having access to functions & documentation when I'm trying to program! On Wed, Nov 19, 2014 at 1:07 PM, Tom Davies wrote: Hi :) On a linux command-line you can type whatever command and then add a "--help" or "-h" tag to get a really neat quick-cheat-sheet, 2 examples; ls --help dir -h Also can often type a command after "man" (short for manual) to get a much more verbose, but still quite geeky, detail about what the command can do. So; man ls man dir Also just typing help info often gives quite a bit of general help. Is there anything like that for macros? Regards from Tom :) On 19 November 2014 17:59, Matt Price wrote: Jim, That was it! Or, almost. I changed the line to: oText.insertTextContent(oVC, oAnno, True) And the annotation now gets attached to the whole range. I wish I knew how to find the documentation for these functions! I don't know what the various parameters actually d -- what is the final Boolean doing there? How do you know? But in any case, many thanks for solving htis problem, it's actually pretty awesome to be able to do this with a single keystroke! m On Wed, Nov 19, 2014 at 12:38 PM, Jim Byrnes wrote: On 11/19/2014 10:55 AM, Matt Price wrote: Thanks Tom, I've just spent some time looking htrough Andrew Pitonyak's macro guide. It helps a little but there doesn't seem to be any direct documentation of hte functions. What I'm looking at is the second line reproduced below: oVC = ThisComponent.CurrentController.ViewCursor oText.insertTextContent(oVC.Start, oAnno, False) Matt, I don't use Writer much and honestly I'm not sure what you expect to see. Try this. In the above two lines change Start to End and False to True and put those two lines right under your "rem I don't know what to put in here" line. Then select some text and run the macro. Regards, Jim I think oVC.Start needs to be replaced with something else, but I can't figure out what. All of Andrew's examples with insertTextContent insert the content at a single location, not at a text range, so maybe I need a different function. If someone knows another method I'd appreciate the advice. Thanks, Matt On Wed, Nov 19, 2014 at 11:15 AM, Tom Davies wrote: Hi :) The best documentation is at; https://wiki.documentfoundation.org/Documentation/Publications and the most recent full books are also on the official LibreOffice website. For macros i think the best book by far is Andrew Pitonyak's guide on https://wiki.documentfoundation.org/Documentation/Other_ Documentation_and_Resources#Programmers I'm not sure they will help for this specific use-case but they might help generally. Regards from Tom :) On 19 November 2014 16:05, Matt Price wrote: Hi, I am trying to add a really simple macro that I can bind to a key. I just want ot be able ot add checkmarks to student papers veyr quickly, so I would like to select a sentence or other text range, then press a key, and have the ckeckmark appear in a new comment. I can almost do htis, using code stolen from the web: rem--- rem -- misleadingly named macro adds a simple hceckmark at point, or in response to highlighted text. sub createComment rem create the annotation object oAnno = ThisComponent.createInstance("com.sun.star.text.textfield.Annotation") rem Chr 10004 is the decimal for hex code 2714, "heavy checkmark" oAnno.Content = Chr(10004) oAnno.Author = "Matt Price" oText = ThisComponent.Text rem check to see if anything i
[libreoffice-users] Re: macro to add annotation to selected text range
On 11/19/2014 10:55 AM, Matt Price wrote: Thanks Tom, I've just spent some time looking htrough Andrew Pitonyak's macro guide. It helps a little but there doesn't seem to be any direct documentation of hte functions. What I'm looking at is the second line reproduced below: oVC = ThisComponent.CurrentController.ViewCursor oText.insertTextContent(oVC.Start, oAnno, False) Matt, I don't use Writer much and honestly I'm not sure what you expect to see. Try this. In the above two lines change Start to End and False to True and put those two lines right under your "rem I don't know what to put in here" line. Then select some text and run the macro. Regards, Jim I think oVC.Start needs to be replaced with something else, but I can't figure out what. All of Andrew's examples with insertTextContent insert the content at a single location, not at a text range, so maybe I need a different function. If someone knows another method I'd appreciate the advice. Thanks, Matt On Wed, Nov 19, 2014 at 11:15 AM, Tom Davies wrote: Hi :) The best documentation is at; https://wiki.documentfoundation.org/Documentation/Publications and the most recent full books are also on the official LibreOffice website. For macros i think the best book by far is Andrew Pitonyak's guide on https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers I'm not sure they will help for this specific use-case but they might help generally. Regards from Tom :) On 19 November 2014 16:05, Matt Price wrote: Hi, I am trying to add a really simple macro that I can bind to a key. I just want ot be able ot add checkmarks to student papers veyr quickly, so I would like to select a sentence or other text range, then press a key, and have the ckeckmark appear in a new comment. I can almost do htis, using code stolen from the web: rem--- rem -- misleadingly named macro adds a simple hceckmark at point, or in response to highlighted text. sub createComment rem create the annotation object oAnno = ThisComponent.createInstance("com.sun.star.text.textfield.Annotation") rem Chr 10004 is the decimal for hex code 2714, "heavy checkmark" oAnno.Content = Chr(10004) oAnno.Author = "Matt Price" oText = ThisComponent.Text rem check to see if anything is selected oSels = ThisComponent.getCurrentSelection() If Not IsNull(oSels) Then rem I don't know what to put in here Else oVC = ThisComponent.CurrentController.ViewCursor oText.insertTextContent(oVC.Start, oAnno, False) End If end sub --- You can see that, if there's no selection, I already know how to insert the annotation. But I don't know how to attach the annotation to the selected range instead of just the start of the cursor. In general, I don't know where to find the funciton references or even the source code for the relevant functions. I'm finding it quite difficult to figure out how to learn to program -- is there comprehensive documentation somewhere? Thanks, Matt -- 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] Re: date acceptance patterns not sticking
On 10/14/2014 03:20 PM, bunk3m wrote: Libreoffice is driving me nuts. I am in Canada. UI is set to English US; Locale settings to English Canada and Default Currency is CAD. I have my Mac set dates to dd.mm.. (OSX 10.9.x) For some reason Libreoffice (4.3.1.2) will only accept dates in the -MM-DD format. I'm happy that I can format the date to look DD.MM. but entering in the -MM-DD is totally unnatural for me. Actually, I only usually type the DD.MM and expect the to show up automatically in Excel. I'd like the same behaviour in LO if possible. The date acceptance patterns will not accept anything except what is loaded by default ... which is D.M.;DD-MM-;D-M I don't want to have to type the each time for D.M.. I've tried to add D.M to the acceptance pattern but the text turns red and won't save. The D.M is always gone after trying to save. So if the date acceptance patterns are supposed to be customizable by the user ... what do I have to do to get this to work? Thanks in advance. B. PS I'm on digest mode. Please CC me directly Try this: right click on a cell select Format Cells in category choose User Defined in Format code enter: 00"."00".2014" Then you can go to that cell and enter for example: 2512 and it should display as 25.12.2014. A couple of things to remember. This looks like a date but I don't think you could do date math with it. I do this all the time but I just need it to visually look like a date. Also in 86 years you will need to rewrite it. Regards, 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
[libreoffice-users] Re: Path to python macros in LO 4.2.6.3[SOLVED]
On 10/09/2014 10:58 AM, Dan Lewis wrote: Actually there seems to be an important hint in the Paths section of Tools > Options > LibreOffice > Paths. You could see this also by looking at the sub folders within the "user" folder. This folder's sub folders divide the configuation into individual parts: autocorr, autotext, backup, etc. Specifically, one folder is named uno_packages. So, would it make sense to have a Python folder as a sub folder of "user" if you are using python? After all python properties don't seem to fit in any of the other sub folders. The seemingly only question would be whether to capitalize this sub folder or not. This is just an educated guess. Dan I knew where it went under vers 3.xxx. I thought I set it up under 4.xx the same way and wondered why it did not work. The problem was I mistakenly named it Python not python. Once I fixed that it worked. Regards, Jim On 10/09/2014 10:23 AM, Jim Byrnes wrote: I don't it ever was an option. I have 3.5xx on my desktop and it is not there either. I think it strictly an internal setting. Regards, Jim On 8 October 2014 15:41, Jim Byrnes wrote: On 10/08/2014 08:38 AM, Jim Byrnes wrote: On 10/08/2014 06:01 AM, Tom Davies wrote: Hi :) Something like Tools - Options - Paths is probably too obvious but it's often the obvious things that get missed so it's worth getting that out of the way before looking for something more complicated. Regards from Tom :) That's what I thought also, but looking on the working version it is not there. Must get it some place internally. Regards, Jim Turns out to be an error on my part. Despite what I wrote about the directory structure, I actually had the folder named Python not python. Now it works. Regards, Jim On 8 October 2014 02:44, Jim Byrnes wrote: I upgraded my notebook to Ubuntu 14.04 as a test bed before upgrading my desktop. I copied over some spreadsheets from my desktop LO 3.xxx system. Python did not appear in the organize macros menu item. Some goolgling told me I had to install a python script handler. I did that and Python showed up in the organize macros menu item, but the individual macros did not show up under the MyMacros. On my desktop LO 3.xxx version I have my Python macros stored in: /.config/libreoffice/3/user/Scripts/python and they show up in MyMacros. So on LO 4.2.6.3 I put them in: /.config/libreoffice/4/user/Scripts/python, but they don't show up in MyMacros. I must have a path problem but don't know how to correct it. Does anyone have python macros working in LO 4.2? Thanks, 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 -- 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: Path to python macros in LO 4.2.6.3[SOLVED]
On 10/09/2014 06:16 AM, Tom Davies wrote: Hi :) Phew!! Nicely found! Congrats on finding and fixing that. I wonder where the Paths option has gone then? It's probably mentioned in the release notes and documentation somewhere. Is there an "Advanced" section or option? I guess i'll check it out later. Good luck and regards from Tom :) I don't it ever was an option. I have 3.5xx on my desktop and it is not there either. I think it strictly an internal setting. Regards, Jim On 8 October 2014 15:41, Jim Byrnes wrote: On 10/08/2014 08:38 AM, Jim Byrnes wrote: On 10/08/2014 06:01 AM, Tom Davies wrote: Hi :) Something like Tools - Options - Paths is probably too obvious but it's often the obvious things that get missed so it's worth getting that out of the way before looking for something more complicated. Regards from Tom :) That's what I thought also, but looking on the working version it is not there. Must get it some place internally. Regards, Jim Turns out to be an error on my part. Despite what I wrote about the directory structure, I actually had the folder named Python not python. Now it works. Regards, Jim On 8 October 2014 02:44, Jim Byrnes wrote: I upgraded my notebook to Ubuntu 14.04 as a test bed before upgrading my desktop. I copied over some spreadsheets from my desktop LO 3.xxx system. Python did not appear in the organize macros menu item. Some goolgling told me I had to install a python script handler. I did that and Python showed up in the organize macros menu item, but the individual macros did not show up under the MyMacros. On my desktop LO 3.xxx version I have my Python macros stored in: /.config/libreoffice/3/user/Scripts/python and they show up in MyMacros. So on LO 4.2.6.3 I put them in: /.config/libreoffice/4/user/Scripts/python, but they don't show up in MyMacros. I must have a path problem but don't know how to correct it. Does anyone have python macros working in LO 4.2? Thanks, 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 -- 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: Path to python macros in LO 4.2.6.3[SOLVED]
On 10/08/2014 08:38 AM, Jim Byrnes wrote: On 10/08/2014 06:01 AM, Tom Davies wrote: Hi :) Something like Tools - Options - Paths is probably too obvious but it's often the obvious things that get missed so it's worth getting that out of the way before looking for something more complicated. Regards from Tom :) That's what I thought also, but looking on the working version it is not there. Must get it some place internally. Regards, Jim Turns out to be an error on my part. Despite what I wrote about the directory structure, I actually had the folder named Python not python. Now it works. Regards, Jim On 8 October 2014 02:44, Jim Byrnes wrote: I upgraded my notebook to Ubuntu 14.04 as a test bed before upgrading my desktop. I copied over some spreadsheets from my desktop LO 3.xxx system. Python did not appear in the organize macros menu item. Some goolgling told me I had to install a python script handler. I did that and Python showed up in the organize macros menu item, but the individual macros did not show up under the MyMacros. On my desktop LO 3.xxx version I have my Python macros stored in: /.config/libreoffice/3/user/Scripts/python and they show up in MyMacros. So on LO 4.2.6.3 I put them in: /.config/libreoffice/4/user/Scripts/python, but they don't show up in MyMacros. I must have a path problem but don't know how to correct it. Does anyone have python macros working in LO 4.2? Thanks, 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
[libreoffice-users] Re: Path to python macros in LO 4.2.6.3
On 10/08/2014 06:01 AM, Tom Davies wrote: Hi :) Something like Tools - Options - Paths is probably too obvious but it's often the obvious things that get missed so it's worth getting that out of the way before looking for something more complicated. Regards from Tom :) That's what I thought also, but looking on the working version it is not there. Must get it some place internally. Regards, Jim On 8 October 2014 02:44, Jim Byrnes wrote: I upgraded my notebook to Ubuntu 14.04 as a test bed before upgrading my desktop. I copied over some spreadsheets from my desktop LO 3.xxx system. Python did not appear in the organize macros menu item. Some goolgling told me I had to install a python script handler. I did that and Python showed up in the organize macros menu item, but the individual macros did not show up under the MyMacros. On my desktop LO 3.xxx version I have my Python macros stored in: /.config/libreoffice/3/user/Scripts/python and they show up in MyMacros. So on LO 4.2.6.3 I put them in: /.config/libreoffice/4/user/Scripts/python, but they don't show up in MyMacros. I must have a path problem but don't know how to correct it. Does anyone have python macros working in LO 4.2? Thanks, 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
[libreoffice-users] Path to python macros in LO 4.2.6.3
I upgraded my notebook to Ubuntu 14.04 as a test bed before upgrading my desktop. I copied over some spreadsheets from my desktop LO 3.xxx system. Python did not appear in the organize macros menu item. Some goolgling told me I had to install a python script handler. I did that and Python showed up in the organize macros menu item, but the individual macros did not show up under the MyMacros. On my desktop LO 3.xxx version I have my Python macros stored in: /.config/libreoffice/3/user/Scripts/python and they show up in MyMacros. So on LO 4.2.6.3 I put them in: /.config/libreoffice/4/user/Scripts/python, but they don't show up in MyMacros. I must have a path problem but don't know how to correct it. Does anyone have python macros working in LO 4.2? Thanks, 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
[libreoffice-users] Re: Opening worksheets from the terminal in linux?
On 09/09/2014 04:23 AM, Tom Davies wrote: Hi :) I think some of the parameters of the problem weren't clear. A default spreadsheet file normally has 3 sheets. Is it possible to select which of the 3 gets opened? I think that is what the o.p. meant. Err, i usually delete any sheets that i'm not using so that when i open an ancient file i don't have to faff around trying to see if i hid anything on one of the other 2 sheets. This might be a work-around for the o.p. because then each file would only have 1 sheet and hopefully that would be the one opened by default - but it'd probably be annoying. I sometimes find i have to add extra sheets, such as 1 per month or per quarter and breaking those out into separate files would be annoying. Also i tend to find the i don't need to include the path to soffice but do need the path to the file (unless i'm already in the correct folder). So for me it's more like soffice path-name/file-name Regards from Tom :) Yeah, my bad. I should have been taking about somefile.ods not sheets and workbooks. See my reply to Nino. Thanks, Jim On 9 September 2014 09:19, Nino Novak wrote: Hi Jim, Am 09.09.2014 03:51, schrieb Jim Byrnes: 1. Can I open a specific spreadsheet from the terminal? I have tried a lot of combinations and I either get a new/untitled worksheet or an error message. just a simple [path_to]/soffice file1.ods works fine here (4.3.1/SUSE) What error message do you get? 2. If I solve [1] will error messages appear in the terminal? (I suppose so - but don't know really, so someone else has to help you) 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 -- 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: Opening worksheets from the terminal in linux?
On 09/09/2014 03:19 AM, Nino Novak wrote: Hi Jim, Am 09.09.2014 03:51, schrieb Jim Byrnes: 1. Can I open a specific spreadsheet from the terminal? I have tried a lot of combinations and I either get a new/untitled worksheet or an error message. just a simple [path_to]/soffice file1.ods works fine here (4.3.1/SUSE) What error message do you get? It was me not including the path that caused the problem. localc [path to]/file1.ods works. 2. If I solve [1] will error messages appear in the terminal? (I suppose so - but don't know really, so someone else has to help you) If I use the correct path then when the file opens I do not get the prompt back. I haven't had a chance to see if error messages appear in the terminal. Nino Thanks, 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
[libreoffice-users] Opening worksheets from the terminal in linux?
Couple of questions about opening LibreOffice 3.5 worksheets from the terminal in Ubuntu 12.04 1. Can I open a specific spreadsheet from the terminal? I have tried a lot of combinations and I either get a new/untitled worksheet or an error message. 2. If I solve [1] will error messages appear in the terminal? I am working with some python macros and would like better access to python error messages. I got the impression from some messages I read on the net that the error messages would appear in the terminal if the work sheet was started from the terminal. So far when I get an new sheet to open from the terminal, it immediately reverts back to the prompt so no error message would appear. Thanks, 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
[libreoffice-users] Need help with regex in a calc macro
I have some cells that contain data like: (IBM) Ibm corporation. I need to extract the stock symbol ie IBM. I thought I could use regex to get (IBM) and then strip the parens. So far I have been uable to do so. Usually I can search and find examples of code I can study and modify to suit my needs, but regex examples for calc seem to be few and far between. I wonder if someone could point me to some good calc regex examples or take a look at the test code below that I have been experimenting with and tell me what I am doing wrong. Sub getMktValue() 'Main sub Dim oDoc as Object Dim oSheet as Object Dim oCalcCtrl as Object Dim oCell as Object Dim oCursor as Object Dim oRange as Object Dim myRegex as Object Dim found as Object Dim cellLoc as Object oDoc = ThisComponent 'oSheet = ThisComponent.Sheets.getByName("Income") oSheet = oDoc.Sheets.getByName("Income") oRange = oSheet.getCellRangeByName("Stocks") numRows = oRange.Rows.getCount() 'regex test code cellLoc = oSheet.getCellByPosition(0, 1) stk = cellLoc.String() myRegex =cellLoc.createSearchDescriptor() myRegex.SearchString = "\([A-Z]\)" myRegex.SearchRegularExpression = True found = cellLoc.findFirst(myRegex) 'MsgBox found End Sub This code as is runs with out error, but if I uncomment MsgBox found I get a "object variable not set" error. Thanks, 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
[libreoffice-users] Re: Link to external data question
On 08/22/2014 11:05 AM, Mark Bourne wrote: Jim Byrnes wrote: On 08/21/2014 03:16 PM, Mark Bourne wrote: Jim Byrnes wrote: I would like to import some stock quotes from finance.yahoo.com into a calc sheet. As a test I select cell A1 Insert-->Link to External Data and I get the External Data dialog Put http://finance.yahoo.com/d/quotes.csv?s=AAPL&f=a in the URL box The OK button stays greyed out I hit ENTER and I get a Text Import dialog with a number in the Fields section When I hit OK I am sent back to the External Data dialog, OK button still greyed out and when I close the dialog, nothing is entered in A1. What do I need to do to get the stock quote entered in the cell? I haven't used that feature before, but https://help.libreoffice.org/Calc/Link_to_External_Data says: Link to External Data Inserts data from an HTML, Calc, or Excel file into the current sheet as a link. The data must be located within a named range. The URL you're using points to a CSV file, which doesn't contain a named range (CSV is a very basic format, and doesn't support naming ranges). Using an ODS file with a named range works; after selecting the file, the ranges defined within the file are listed in the lower part of the "External Data" dialog, and the OK button is enabled once once is selected (with a CSV file, there are no ranges to select so OK is never enabled). But that's clearly no use to you unless Yahoo provides the data you want in that format... OK I understand now. Just seems strange that I can get the data I want in the Import Text dialog (just as I have done many times when importing csv files) but I can't get it into the spreadsheet. When I click ok in the Import Text dialog, focus goes to the Insert Dialog and the data is lost. It is a bit confusing. I think the Import Text dialog is needed to open the file - being plain text, it can't automatically determine things like the character encoding and whether cells are separated by commas, tabs or something else. Then, after opening the file, it finds that there are no ranges defined within the file. It would be more sensible if it gave some message that there are no named ranges in the file. Or, rather than requiring a named range, allow the whole sheet to be imported - but perhaps that's the purpose of the Insert > Sheet from File option. It may be possible to pick up data from a table on an HTML page. That's liable to stop working when Yahoo change the layout of the page though, requiring you to go through the Insert > Link to External Data again to find the table in the new layout, but might work well enough. Another possibility may be Insert > Sheet from File, specify that URL rather than browsing to a local file, and select the "Link" option. It seems to be rather slow to import (maybe that's just my Internet connection), and I'm not certain if it will actually update as intended, but probably worth trying. I'd suggest not modifying the imported sheet, in case either you loose your changes when the sheet is updated or modifying it prevents future updates. You can then reference cell A1 from another sheet, which should then pick up changes assuming the imported sheet does update as intended. When I try this option I don't see any place to specify the URL, all I see is a file selection dialog. You can type (or paste) a URL into the "File name" field and it will open it. What I'm not sure of is whether it will automatically update as intended; may need some experimentation. Yet another option may be to set up a LibreOffice Base database connection pointing at the CSV file as its data source. (File > New > Database > Connect to existing > Spreadsheet > Next > Enter URL > Next > Finish). Not sure offhand if or how you can reference that from your spreadsheet though, and it is getting rather extreme just to get a single number! The whole thing is getting complex. I just wanted to link about 10 cells so I wouldn't have to type in the data manually. Not a big problem it's just that I am always looking for ways to automate stuff. Always handy when possible ;o) Thanks to everyone that offered advice on this problem. I found a possible solution here: http://amourtan.com/2013/03/downloading-stock-prices-into-openoffice-calc/ It works but is a little bit of over kill for what I need. Hopefully this weekend I will have a chance to look at the code and get some ideas of how to adapt it to my simple needs. Regards, 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
[libreoffice-users] Re: Link to external data question
On 08/22/2014 05:00 AM, Tom Davies wrote: Hi :) Changing the file-ending doesn't change the format of the data itself within the file. I tried editing the url address to replace csv with ods and a file did get downloaded but it wasn't really an ods - just some sort of text file which Calc correctly identified as being like a csv and gave me the usual options (which Jim already covered). It would be handy to go back to the web-page the file came from and try to see if there are any other formats available. One day people might even start putting Ods files up so that everyone can read them. At the moment they seem to use XlsX too often (which no-one can read properly unless they get lucky) and thus 'have to' provide a Pdf too, which is also difficult to import or copy&paste from. Some wiser places do provide files in the older MS formats (so that's Xls without the X at the end) as the non-OOXML format is easily read by everyone at the moment. So, Jim, is it possible to give a link to the page that you downloaded the file from? Then we can try to see if there is a better format for downloading. My guess is that because it's Yahoo they are a bit clueless about IT issues and don't give good formats. Regards from Tom :) Here is what I was using to test: http://finance.yahoo.com/d/quotes.csv?s=AAPL&f=a I don't think Yahoo is at fault for using csv. It is a widely accepted format for transferring data of this type. For example my bank will let me download in Quicken, MS Money and maybe a couple of other formats but the fallback format is csv because most programs can handle it. In this case I was apparently trying to use a feature of clac for something it was not intended. Regards, Jim On 22 August 2014 06:24, Florian Reisinger wrote: Hi, Can you please try to use the file name without the ".CSV" as table name? Sorry I cannot provide more info now On 22. August 2014 02:35:58 MESZ, Jim Byrnes wrote: On 08/21/2014 03:16 PM, Mark Bourne wrote: Jim Byrnes wrote: I would like to import some stock quotes from finance.yahoo.com into a calc sheet. As a test I select cell A1 Insert-->Link to External Data and I get the External Data dialog Put http://finance.yahoo.com/d/quotes.csv?s=AAPL&f=a in the URL box The OK button stays greyed out I hit ENTER and I get a Text Import dialog with a number in the Fields section When I hit OK I am sent back to the External Data dialog, OK button still greyed out and when I close the dialog, nothing is entered in A1. What do I need to do to get the stock quote entered in the cell? I haven't used that feature before, but https://help.libreoffice.org/Calc/Link_to_External_Data says: Link to External Data Inserts data from an HTML, Calc, or Excel file into the current sheet as a link. The data must be located within a named range. The URL you're using points to a CSV file, which doesn't contain a named range (CSV is a very basic format, and doesn't support naming ranges). Using an ODS file with a named range works; after selecting the file, the ranges defined within the file are listed in the lower part of the "External Data" dialog, and the OK button is enabled once once is selected (with a CSV file, there are no ranges to select so OK is never enabled). But that's clearly no use to you unless Yahoo provides the data you want in that format... OK I understand now. Just seems strange that I can get the data I want in the Import Text dialog (just as I have done many times when importing csv files) but I can't get it into the spreadsheet. When I click ok in the Import Text dialog, focus goes to the Insert Dialog and the data is lost. It may be possible to pick up data from a table on an HTML page. That's liable to stop working when Yahoo change the layout of the page though, requiring you to go through the Insert > Link to External Data again to find the table in the new layout, but might work well enough. Another possibility may be Insert > Sheet from File, specify that URL rather than browsing to a local file, and select the "Link" option. It seems to be rather slow to import (maybe that's just my Internet connection), and I'm not certain if it will actually update as intended, but probably worth trying. I'd suggest not modifying the imported sheet, in case either you loose your changes when the sheet is updated or modifying it prevents future updates. You can then reference cell A1 from another sheet, which should then pick up changes assuming the imported sheet does update as intended. When I try this option I don't see any place to specify the URL, all I see is a file selection dialog. Yet another option may be to set up a LibreOffice Base database connection pointing at the CSV file as its data source. (File > New > Database > Connect to exis
[libreoffice-users] Re: Link to external data question
On 08/21/2014 03:16 PM, Mark Bourne wrote: Jim Byrnes wrote: I would like to import some stock quotes from finance.yahoo.com into a calc sheet. As a test I select cell A1 Insert-->Link to External Data and I get the External Data dialog Put http://finance.yahoo.com/d/quotes.csv?s=AAPL&f=a in the URL box The OK button stays greyed out I hit ENTER and I get a Text Import dialog with a number in the Fields section When I hit OK I am sent back to the External Data dialog, OK button still greyed out and when I close the dialog, nothing is entered in A1. What do I need to do to get the stock quote entered in the cell? I haven't used that feature before, but https://help.libreoffice.org/Calc/Link_to_External_Data says: Link to External Data Inserts data from an HTML, Calc, or Excel file into the current sheet as a link. The data must be located within a named range. The URL you're using points to a CSV file, which doesn't contain a named range (CSV is a very basic format, and doesn't support naming ranges). Using an ODS file with a named range works; after selecting the file, the ranges defined within the file are listed in the lower part of the "External Data" dialog, and the OK button is enabled once once is selected (with a CSV file, there are no ranges to select so OK is never enabled). But that's clearly no use to you unless Yahoo provides the data you want in that format... OK I understand now. Just seems strange that I can get the data I want in the Import Text dialog (just as I have done many times when importing csv files) but I can't get it into the spreadsheet. When I click ok in the Import Text dialog, focus goes to the Insert Dialog and the data is lost. It may be possible to pick up data from a table on an HTML page. That's liable to stop working when Yahoo change the layout of the page though, requiring you to go through the Insert > Link to External Data again to find the table in the new layout, but might work well enough. Another possibility may be Insert > Sheet from File, specify that URL rather than browsing to a local file, and select the "Link" option. It seems to be rather slow to import (maybe that's just my Internet connection), and I'm not certain if it will actually update as intended, but probably worth trying. I'd suggest not modifying the imported sheet, in case either you loose your changes when the sheet is updated or modifying it prevents future updates. You can then reference cell A1 from another sheet, which should then pick up changes assuming the imported sheet does update as intended. When I try this option I don't see any place to specify the URL, all I see is a file selection dialog. Yet another option may be to set up a LibreOffice Base database connection pointing at the CSV file as its data source. (File > New > Database > Connect to existing > Spreadsheet > Next > Enter URL > Next > Finish). Not sure offhand if or how you can reference that from your spreadsheet though, and it is getting rather extreme just to get a single number! Mark. The whole thing is getting complex. I just wanted to link about 10 cells so I wouldn't have to type in the data manually. Not a big problem it's just that I am always looking for ways to automate stuff. Thanks, 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
[libreoffice-users] Link to external data question
I would like to import some stock quotes from finance.yahoo.com into a calc sheet. As a test I select cell A1 Insert-->Link to External Data and I get the External Data dialog Put http://finance.yahoo.com/d/quotes.csv?s=AAPL&f=a in the URL box The OK button stays greyed out I hit ENTER and I get a Text Import dialog with a number in the Fields section When I hit OK I am sent back to the External Data dialog, OK button still greyed out and when I close the dialog, nothing is entered in A1. What do I need to do to get the stock quote entered in the cell? Thanks, 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
[libreoffice-users] Re: Acess2Base
On 08/18/2014 11:08 AM, P. . wrote: btw, it should work with LO, gnumeric etc... On 18 August 2014 18:05, P. . wrote: yes, but python in gnumeric seems to be easier, at least i found it to. Have you already taken a look at this: PyWorkbooks I believe I have, at the same time I was looking at Gnumeric. If I recall correctly, it worked but what you could do with it was limited. Is it still being updated and have features been added? Regards, Jim pdf attached On 18 August 2014 17:28, Jim Byrnes wrote: On 08/18/2014 07:47 AM, Peterle, Alex wrote: It could be easier if LO had a python macro based system like gnumeric has, isn't it? You can write macros using Python in LO. About half of my macros are in Python. A couple of years ago when I was looking for an alternative to LO because UNO is so complex, I looked at Gnumeric. At that time Python support seemed to be poorly documented and somehow incomplete. Has it gotten any better? Regards, Jim I've found convenient to install LO from the official release instead of the deb of ubuntu. I have ubuntu maverick 10.10 with LO Version: 4.2.1.1 Build ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b, installed in a very straightforward way besides ubuntu 14.04. -- 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: Acess2Base
On 08/18/2014 07:47 AM, Peterle, Alex wrote: It could be easier if LO had a python macro based system like gnumeric has, isn't it? You can write macros using Python in LO. About half of my macros are in Python. A couple of years ago when I was looking for an alternative to LO because UNO is so complex, I looked at Gnumeric. At that time Python support seemed to be poorly documented and somehow incomplete. Has it gotten any better? Regards, Jim I've found convenient to install LO from the official release instead of the deb of ubuntu. I have ubuntu maverick 10.10 with LO Version: 4.2.1.1 Build ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b, installed in a very straightforward way besides ubuntu 14.04. On 14 August 2014 16:47, Tom Davies wrote: Hi :) I keep meaning to give the link to the "Professional Support" page but i have a wedding shoot to prep for and keep forgetting. http://www.libreoffice.org/get-help/professional-support/ Hopefully it mentions Collabora which 'recently' budded off from SuSE as had been planned for years. Many companies pay devs, either in-house or as external consultants, to work on LibreOffice. It's more cost-effective (and much cheaper) than paying for licenses for a product which may never deal with their pet-issues. SuSE seemed to have more devs working on LibreOffice than most other companies. So my guess is that Collabora are probably about the best professional support it's possible to get for LIbreOffice! If you need professional support for a wider move to FOSS then you might get that from one of the other companies listed, for example Canonical or Redhat (there is also the "Free Software Foundation", but i have no way of knowing or guessing which is best for your specific case. Regards from Tom :) On 11 August 2014 21:23, Jim Byrnes wrote: On 08/11/2014 03:05 PM, Stefan Gruber wrote: Hello, Jim Byrnes schrieb am Sonntag, 10. August 2014 23:47: A couple of questions: (1) Has anyone here used it and does it make writing macros for Base easier? I looked at the examples a few weeks ago, and it seemed to me as a clearer approach to database programming as the UNO-way. IMHO it is not only useful for migrations from Access, but for more serious db-projects. I do not know anything about MS-Access-Programming, I did some old-style DBase/FoxPro-Development some years ago and I didn't feel well with this UNO-thing up to now. Obviosly it is a great API, but that huge that it becomes a labyrinth to me. I agree, it looks much cleaner. Every time I try to work with UNO, I think what an overly complex way to accomplish what is sometimes a fairly simple task. The only thing wrong with Acess2Base is that I do all my work with Calc. That's why I was wondering if there was going to be a Excel2Calc version. After Access2Base was incorporated in LO from 4.2 on, it is a promise to improve things and it might become real, if it would be featured as the standard way of programming LO Base and if gets broader acceptance. At this time I can't estimate, wether I can rely on this tool for long- term projects. And there is yet a lack of documentation, tutorials for end-users. Fortunately there are more discussions about Base in general in the last months here. I wonder why this topic came up so "late"... I would guess that, probably because of UNO, not that many people are writing macros. Regards, 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 -- 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: Dialog?
On 08/14/2014 03:03 AM, Tom Davies wrote: Hi :) I think it restricts the type of data that can be entered. Similar to the date one the numbers one probably wont allow text. Text ones will allow numbers but will format them as text so you probably can't easily do calculations on them. Errr, wouldn't this be easier as a database? Forms and Reports should be easier but that is only part of what you are doing there. Maybe get Base to read the spreadsheets as it's Tables/back-end? I'm really not sure and i'm sure you have explored various ideas to find the best fit for now. Regards from Tom :) I was asking about the different types of data strictly from a programing perspective. If I use all text fields I imagine I will have to convert text to numbers and dates to put them in formatted cells. I was wondering if using numeric and date fields would save me from doing the conversion. Just doing a little preplanning. If no one knows, I'll just do some experimenting. It is a fairly complex multi-sheet spreadsheet that right now forces me to enter some data in more than one place. The sheets are constantly changing so I don't see any way to directly link the cells on the various sheets so I thought a macro was the way to go. Regards, Jim On 13 August 2014 17:57, Jim Byrnes wrote: Using LibreOffice 3.5.7.2 on Ubuntu 12.04 if it makes any difference. I am designing a dialog that will be opened by a macro, accept some data and then place the data in the proper cells of a Calc sheet. The data will consist of text, numbers and dates. In the dialog design environment I see there are text fields, numeric fields and date fields available. Is there any advantage to using the various types of fields other than the date field will only accept date formats and the numeric field will only accept digits? Will using them possibly keep me from having to write conversion routines when putting date data in date formated cells or numeric data in numeric formated cells? Thanks, 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
[libreoffice-users] Dialog?
Using LibreOffice 3.5.7.2 on Ubuntu 12.04 if it makes any difference. I am designing a dialog that will be opened by a macro, accept some data and then place the data in the proper cells of a Calc sheet. The data will consist of text, numbers and dates. In the dialog design environment I see there are text fields, numeric fields and date fields available. Is there any advantage to using the various types of fields other than the date field will only accept date formats and the numeric field will only accept digits? Will using them possibly keep me from having to write conversion routines when putting date data in date formated cells or numeric data in numeric formated cells? Thanks, 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
[libreoffice-users] Re: Acess2Base
On 08/11/2014 03:05 PM, Stefan Gruber wrote: Hello, Jim Byrnes schrieb am Sonntag, 10. August 2014 23:47: A couple of questions: (1) Has anyone here used it and does it make writing macros for Base easier? I looked at the examples a few weeks ago, and it seemed to me as a clearer approach to database programming as the UNO-way. IMHO it is not only useful for migrations from Access, but for more serious db-projects. I do not know anything about MS-Access-Programming, I did some old-style DBase/FoxPro-Development some years ago and I didn't feel well with this UNO-thing up to now. Obviosly it is a great API, but that huge that it becomes a labyrinth to me. I agree, it looks much cleaner. Every time I try to work with UNO, I think what an overly complex way to accomplish what is sometimes a fairly simple task. The only thing wrong with Acess2Base is that I do all my work with Calc. That's why I was wondering if there was going to be a Excel2Calc version. After Access2Base was incorporated in LO from 4.2 on, it is a promise to improve things and it might become real, if it would be featured as the standard way of programming LO Base and if gets broader acceptance. At this time I can't estimate, wether I can rely on this tool for long- term projects. And there is yet a lack of documentation, tutorials for end-users. Fortunately there are more discussions about Base in general in the last months here. I wonder why this topic came up so "late"... I would guess that, probably because of UNO, not that many people are writing macros. Regards, 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
[libreoffice-users] Re: Acess2Base
On 08/10/2014 08:02 PM, rost52 wrote: Thanks Jim for introducing this topic. A small company I know is using an ACCESS DB with macros exporting certain information into EXCEL spreadsheets. This ACCESS DB is currently preventing the company to change over from MSO to LibO and Linux. A 2 step approach is discussed: First to migrate from MSO to LibO using W7 and second moving from Windows to Linux. (Distributions not yet decided but most likely Linux Mint of Linux Mint Debian or Antergos.) Therefore, 1 more question from my side: Assuming that using Access2Base helps us to get the DB and the macros into Base and create the Calc spreadsheets, can this BASE DB with the LibO macros be used as they are when changing from W7 to Linux? I don't know. I just discovered it a few hours ago. My impression is that it lets people that know how to write macros for Access use a syntax they are similar with to write macros in Base. I could be wrong. Here is a link to the website: http://www.access2base.com/access2base.html Here is a link to an OpenOffice discussion forum about it: https://forum.openoffice.org/en/forum/viewtopic.php?f=47&t=61447 HTH Regards, Jim On 2014-08-11 06:47, Jim Byrnes wrote: I am still using the 3.xx version of LO that came with Ubuntu 12.04 and haven't been on the main LibreOffice site for some time. I've been reading the naming discussion (Fresh/Still etc) and decided to look at the site. While there I stumbled across Acces2Base. I've always thought writing macros in LO was way harder than it should be because of UNO, so this is an interesting development. A couple of questions: (1) Has anyone here used it and does it make writing macros for Base easier? (2) I write most of my macros for Calc so is there a Excel2Calc planned? Regards, 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
[libreoffice-users] Acess2Base
I am still using the 3.xx version of LO that came with Ubuntu 12.04 and haven't been on the main LibreOffice site for some time. I've been reading the naming discussion (Fresh/Still etc) and decided to look at the site. While there I stumbled across Acces2Base. I've always thought writing macros in LO was way harder than it should be because of UNO, so this is an interesting development. A couple of questions: (1) Has anyone here used it and does it make writing macros for Base easier? (2) I write most of my macros for Calc so is there a Excel2Calc planned? Regards, 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
[libreoffice-users] Re: No database option
On 07/30/2014 03:42 PM, Alexander Thurgood wrote: Le 30/07/2014 19:34, Jim Byrnes a écrit : Hi Jim, Just checked with Ubuntu's package manager and Base was in fact not installed. Used it to install Base and now the option appears so I should be able to proceed. Sort of surprised as I thought the entire suite had been installed. Ubuntu, in its infinite wisdom, decided not to install Base by default along with the other modules - quite why, I have no idea, but this is not LibreOffice's fault, unfortunately. I agree that it is most frustrating however, especially when, as a continuous user of previous versions, the default meta packet install did put Base in there for you. Go figure. Alex Alex, Thanks for the info. It clears up another thing that was bothering me. How did a DB file get on my machine if Base was not installed? I started using Ubuntu at at around 9.04 or 9.10 and did a distribution upgrade to 10.04. So at this point Base was installed and I must have created the DB file. When I went to 12.04 I decided to do a clean install. I popped in a new hard drive and installed 12.04 and slowly transfered stuff from the 10.04 hard drive. I must have transfered that DB file at that time. Regards, 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
[libreoffice-users] Re: No database option
On 07/30/2014 11:51 AM, Tom Davies wrote: Hi :) You might need to install Base. I think it's the only module that can be installed separately on Gnu&Linux systems. So something like sudo apt-get install libreoffice-base should do the trick on a distro from the debian-family. Please let us know how this goes! Good luck and regards form Tom :) Just checked with Ubuntu's package manager and Base was in fact not installed. Used it to install Base and now the option appears so I should be able to proceed. Sort of surprised as I thought the entire suite had been installed. Thanks Tom Regards, Jim On 30 July 2014 17:30, Jim Byrnes wrote: Using LibreOffice 3.5.7.2 on Ubuntu 12.04. I am working with a ooBasic tutorial. It says to choose File-->New-->Database to create a new database. The problem is there is no Database item on that drop down menu. Also, on the opening screen the Database entry is grayed out. I actually have a database on my system that I was experimenting with a couple of years ago. If I go to Tools-->Options-->LibreOffice-->Databases it shows there but I can't open it. Anyone have any idea of what could be wrong and how to enable databases again? Thanks, 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
[libreoffice-users] No database option
Using LibreOffice 3.5.7.2 on Ubuntu 12.04. I am working with a ooBasic tutorial. It says to choose File-->New-->Database to create a new database. The problem is there is no Database item on that drop down menu. Also, on the opening screen the Database entry is grayed out. I actually have a database on my system that I was experimenting with a couple of years ago. If I go to Tools-->Options-->LibreOffice-->Databases it shows there but I can't open it. Anyone have any idea of what could be wrong and how to enable databases again? Thanks, 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
[libreoffice-users] Re: How to locate python macro for editing?
On 07/25/2014 06:32 PM, Andrew Douglas Pitonyak wrote: On 07/25/2014 06:16 PM, Jim Byrnes wrote: I am using Ubuntu 12.04 and LibreOffice 3.5.7.2. A couple of years ago I created a python macro and a custom menu entry to run it. It still works but I am going to change the underlying sheet and will need to change the macro. The problem is I haven't done any work with macros since I wrote it and now I can't find it to edit. If I look in Tools-->Macros-->Organize Macros-->Python I see: MyMacros (It's not in here) LibreOfficeMacros (It's not in here) MySpreadsheet.ods (clicking or double clicking this does nothing) It is not in /usr/lib/libreoffice/share/Scripts/Python or /.config/libreoffice/3/user/Scripts/python I can't remember if it is possible to embed a python macro in a sheet or not. If it is how do I edit it? The name of the macro in the menu is enterPmts. I have searched the file system for enterPmts.py and variations but have found nothing. I'm feeling a little dumb right now so any help is appreciated. Regards, Jim Clearly there is a difference between "feeling dumb" and "being dumb" since it looks like you looked in the right places :-) Andrew, Thanks for the kind words, but I don't think I deserve them. :) I had one of those 'ah hah' moments last night. Turns out this macro was older than I thought and was written when I was trying to learn LO's basic. So it was written in basic not python. Eventually at that time I decided instead of learning a new language I would figure out how to use one I already knew (python) in LibreOffice macros. Sorry for the noise. Regards, 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
[libreoffice-users] How to locate python macro for editing?
I am using Ubuntu 12.04 and LibreOffice 3.5.7.2. A couple of years ago I created a python macro and a custom menu entry to run it. It still works but I am going to change the underlying sheet and will need to change the macro. The problem is I haven't done any work with macros since I wrote it and now I can't find it to edit. If I look in Tools-->Macros-->Organize Macros-->Python I see: MyMacros (It's not in here) LibreOfficeMacros (It's not in here) MySpreadsheet.ods (clicking or double clicking this does nothing) It is not in /usr/lib/libreoffice/share/Scripts/Python or /.config/libreoffice/3/user/Scripts/python I can't remember if it is possible to embed a python macro in a sheet or not. If it is how do I edit it? The name of the macro in the menu is enterPmts. I have searched the file system for enterPmts.py and variations but have found nothing. I'm feeling a little dumb right now so any help is appreciated. Regards, 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
[libreoffice-users] Re: low traffic lately?
On 01/28/2014 06:33 PM, Dave Liesse wrote: And if you use Thunderbird and read the list through gmane you will see a followup button that replies only to the list. The reply button replies to the sender. Regards, Jim FWIW, I've done some searching of my email since my earlier post. It seems that I get the "Reply All" button for lists that are Yahoo! groups, and "Reply List" for lists that use real list servers. Dave On 1/28/2014 16:23, Peter West wrote: I've just switched to Thunderbird from Apple Mail, and the Reply List button is very handy indeed. There is a minority of lists that exhibit the same behaviour as this one with replies. The fact that it is a minority makes it all the more likely that I will send replies to the wrong address - the OP. P.S. Apple has had ongoing problems with Mail in Mavericks, and I suspect they have decided to phone home about everyone you add to the address list of an email. Using Contacts groups became painfully slow. On 29/01/2014 9:59 am, Dave Liesse wrote: Virgil, I don't think it's just the list. The mail client must have something to do with it, as well; I use Thunderbird and have a "Reply List" option on this list, while on some others I do and some I don't. Dave -- 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: Inserting a row does not change formula
On 01/12/2014 03:34 PM, mariosv wrote: Maybe this option can help: Menu/Tools/Options/LibreOffic calc/General - Expand references when new columns/rows are inserted. Miguel Ángel. Thank you, that worked. I'm curious why without that setting I can insert a row in the middle of a column of numbers and it expands correctly, but if I insert at the very top or very bottom row it does not? Regards, 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
[libreoffice-users] Inserting a row does not change formula
Running LO 3.5.7.2 on Ubuntu 12.04 If I have cells: A1 = 2 A2 = 2 A3 = 2 A4 = =SUM(A1:A3) which equals 6 If I right click on the number 2 to the left of cell A2 to select that row and then insert a row from the popup menu and enter the number 2 in that blank cell, I get: A1 = 2 A2 = 2 A3 = 2 A4 = 2 A5 = =SUM(A1:A4) which equals 8 If instead I right click on the number 4 to the left of cell A4 to select that row and then insert a row from the popup menu and enter the number 2 in that blank cell, I get: A5 = =SUM(A1:A3) which equals 6. If you need to insert a new row in a column of figures, right above the cell where you calculate a total seems to be the natural place to do it. So why doesn't the formula update when you do so? Thanks, 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
[libreoffice-users] Re: Softmaker
On 11/19/2013 08:50 PM, John Jason Jordan wrote: On Tue, 19 Nov 2013 19:30:24 -0500 "Virgil Arrington" dijo: FreeOffice is interesting. In many ways, it resembles LO or OOo. Does anyone know if it was some form of fork or dirivative? You can download a free version for Linux or Windows; I didn't see a Mac option. It appears to be a completely independent creation, not a fork of LO/OO. It's main claim is that it imports/exports MS Office files more faithfully than LO/OO. Also, there are programs for the functionality of Writer, Calc and Impress, but nothing for Base. I downloaded the free version, and then decided not to bother installing it. After all, LO does everything I need, so why bother? Still, it would be interesting to read a detailed comparative review. For example, I bet there is no plugin for Zotero and other tools that I rely on, but I'd like to read the good and the bad without having to install it and spend hours poking around. There is an almost 700 page pdf manual here: http://www.softmaker.net/down/pm2012manual_en.pdf Regards, 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
[libreoffice-users] Broken links on api docs page
Is anyone else seeing this. http://api.libreoffice.org/docs/common/ref/index-files/index-2.html [B] Gives an Object not found - error 404 While http://api.libreoffice.org/docs/common/ref/index-files/index-1.html [A] does not. All through out the list, some work and some do not. Regards, 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
[libreoffice-users] Re: Broken links on api docs page
On 09/06/2013 10:37 AM, Alexander Thurgood wrote: Le 06/09/13 17:02, Jim Byrnes a écrit : Hi Jim, I've read on the dev-list that forcing a reload of the browser cache (perhaps clearing it first) should make the problem go away. Alex Yikes. Clearing the cache made it worse. Now I can't connect to any of the indexes, even ones that worked before. Oh well I'll just use the OO ones until this is fixed. Regards, 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
[libreoffice-users] Can't print basic macro code
Ubuntu 12.04 LO 3.5.7.2 When I go to the built in basic ide and try to print the code for a macro all I get is an almost blank page. What is see is an outline of a box printed at the margins with the full name of the macro at the top but the rest of the page is blank with no code printed. I can of course cut and paste to another editor, but I wonder if anyone else sees this or maybe I am doing something wrong? Regards, 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
[libreoffice-users] OOSheet?
I found a python module that looks like it could simplify writing python macros in calc here: http://oosheet.hacklab.com.br/ . In the download/install section it shows the command to install it with pip. It then goes on to say you will need git and python uno. I already have python uno installed but why would I need git? Thanks, 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
[libreoffice-users] Re: connecting to oooforum.org
On 08/13/2013 01:58 AM, Andrew Brown wrote: Hello This is just to reply to Jim's initial problem with the oooforum website. Jim I am getting likewise no response to the web page, so similiar to other respondents, it seems to be down, or as indicated unstable. This could be currently an unmaintained server, or one with a low priority of whoever is supposed to maintain it, or the hosting co. is not offering a good level of maintenance, but all supposition. It trace routes fine from my country in an average of 300 to 400 milliseconds, so it is reachable, but the actual html or whatever being used for the web page/s seems to be the problem. Regards Andrew Brown Hi Andrew, Thanks for checking. By now you have probably seen Tim's post where he gave me a link detailing how this same problem came up earlier. I sometimes run into problems because I normally refuse cookies. If a site doesn't work I can usually fix it by accepting cookies, this time that did not work, so I sought some help. Regards, Jim On 13/08/2013 08:32 AM, Dave Barton wrote: Tom, Undoubtedly you post with the best of intentions, but please stop jumping in with confusing misinformation. There are two entirely separate forums: 1. http://www.oooforum.org The independent "unofficial" one Jim was referring to. For reasons nobody has been able to explain, their server is at best unreliable and frequently times out. 2. http://forum.openoffice.org/en/forum/ The "official" one Apache inherited from OpenOffice.org which you are referencing. Dave Tom Davies wrote: Hi :) I think it might perform better if you go to the link i gave and do your search from inside their forums. That way you might dodge any links with domains that might have changed. Outside of their forums search engines may still be giving old links. Regards from Tom :) ____________ From: Tim Lloyd To: Jim Byrnes ; "users@global.libreoffice.org" Sent: Tuesday, 13 August 2013, 4:16 Subject: [libreoffice-users] Re: connecting to oooforum.org Hi Jim, I didn't realise this had cropped up before - pretty sad as I logged the first message! I have attached a link to when this was discussed back in February http://nabble.documentfoundation.org/oooforum-org-td4039871.html#a4040074 BTW, link not working for me at present either Cheers On 08/13/2013 01:09 PM, Jim Byrnes wrote: On 08/12/2013 07:54 PM, Tim Lloyd wrote: Jim, I don't really use that forum but if you can send the link I will give it a go Cheers On 08/13/2013 10:42 AM, Jim Byrnes wrote: Is anyone else having trouble connecting to oooforum.org or is just me? Been doing a lot of googling trying to figure out how to write some python macros in LO calc and many links lead to posts on oooforum.org. Lately everytime I try one it times out. Regards, Jim I don't use it either, this is a link to an archived post. http://www.oooforum.org/forum/viewtopic.phtml?p=56015#56015 Thanks, 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
[libreoffice-users] Re: connecting to oooforum.org
On 08/12/2013 10:16 PM, Tim Lloyd wrote: Hi Jim, I didn't realise this had cropped up before - pretty sad as I logged the first message! I have attached a link to when this was discussed back in February http://nabble.documentfoundation.org/oooforum-org-td4039871.html#a4040074 BTW, link not working for me at present either Cheers Hi Tim, Thanks for trying and thanks for the link. Reading through that link I see possible spammers as the problem. I do recall one time I got a message that there were too many connection. It would be a shame if all the info became unavailable. Regards, Jim On 08/13/2013 01:09 PM, Jim Byrnes wrote: On 08/12/2013 07:54 PM, Tim Lloyd wrote: Jim, I don't really use that forum but if you can send the link I will give it a go Cheers On 08/13/2013 10:42 AM, Jim Byrnes wrote: Is anyone else having trouble connecting to oooforum.org or is just me? Been doing a lot of googling trying to figure out how to write some python macros in LO calc and many links lead to posts on oooforum.org. Lately everytime I try one it times out. Regards, Jim I don't use it either, this is a link to an archived post. http://www.oooforum.org/forum/viewtopic.phtml?p=56015#56015 Thanks, 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
[libreoffice-users] connecting to oooforum.org
Is anyone else having trouble connecting to oooforum.org or is just me? Been doing a lot of googling trying to figure out how to write some python macros in LO calc and many links lead to posts on oooforum.org. Lately everytime I try one it times out. Regards, 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
[libreoffice-users] Re: Including code example in documents
On 08/12/2013 09:04 AM, Kracked_P_P---webmaster wrote: If none of the suggestions you have received already work for you. You might want to look at Andrew Pitonyak's book [1]. It has syntax highlighted basic code. I don't know if you can tell how he did by looking at the document though. [1] http://www.pitonyak.org/book/ Regards, JIm I used NoteTab [free] and NotePad ++ as my first Windows programming and HTML editor. Having the extension to do the highlighting in Writer is a good idea though. If I remember correctly, for the Note. . . editors you can find "add ons" that are specific to the programming code. I have not tried them in a few years, but they were a real big aid to my early programming within the Windows environment. I do not remember when I installed the first one, but it was in the early days of my having dial-up Internet access, or a little later. I do not remember if I got online with Win 95 or 98 era. but I know I used them when I was using he "new" Windows version - XP. Would you tell us how large of a document these code samples will be in? Are you writing a programming guide type of documentation? Hopefully the RTF formatting option works. Sometimes pictures of text do not work well, since the snapshot resolution and the print resolution could be very different. I tend to have to make 600 DPI scanned images to get a decent "near 1 to 1 size" image when I print out a "best" print option. If you need to do the snapshot, I would run the image through a scaling option, with a edge smoothing "effect", to make the image in a large enough DPI and actual print size for your needs that actually look well. On 08/12/2013 09:13 AM, William Drago wrote: I do this all the time using the syntax highlighter in Notepad++. If you don't have Notepad++ (my favorite code/text editor), get it here: http://notepad-plus-plus.org/ Here's how to get syntax highlighted code into your LibreOffice documents: 1: Open source file with Notepad++ 2: In Notepad++ click Plugins > NppExport > Export to RTF You will now have a syntax highlighted copy of your source file however, it will be double spaced. To remove the extra spaces proceed as follows: 1: With any editor, open the .rtf file you just created 2: Search and replace "\par" with "\line" 3: Save file Open the .rtf file with LibreOffice Writer, select all (CTRL-A), copy & paste into your working document. This sounds like a bit of an ordeal, but I do this quite frequently, and once you've done it a few times, it becomes very fast and easy. Good luck, -Bill On 8/11/2013 9:22 PM, aihaike wrote: Hey Miguel, thank you for you reply. This the kind of macro I need but it does not seem to work with LibreOffice 4 unfortunately. I think I'm going to make a snapshot of my codes and include them as a picture. Éric. -- View this message in context: http://nabble.documentfoundation.org/Including-code-example-in-documents-tp4069680p4069685.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] Re: Using a listeners in a basic macro
On 07/28/2013 05:26 PM, Jim Byrnes wrote: Hi Fernand, Your reply went straight to my email inbox so I a reposting it here to keep the thread alive. Is there a concise list or table that shows what listeners are available to use in a calc sheet? Or maybe a way to generate one? Thanks, Jim Jim , i hope you know how to use xray , who can tell you what listeners are available for a sheet, and once you createted the listener, what methods are available. I installed xray and it is working but I am not seeing the output I expected. Either I am not using it correctly or my expectations are wrong. I have tried running it manually and from a macro. The code below is an example of a listener I found on the web. Sub Main rem added by me GlobalScope.BasicLibraries.loadLibrary("XrayTool") xray thisComponent End Sub global Calc1 as Object global oListner as Object Sub AddListners Calc1 = thisComponent.sheets(0).GetCellRangeByName("A2:Z20") oListner = CreateUnoListener( "Sheet1_", "com.sun.star.util.XModifyListener" ) Calc1.AddModifyListener(oListner) End Sub Sub Sheet1_Modified(oEvent) dim ocell,osheet on error resume next oCell = thisComponent.currentSelection IF oCell.string="ok" then msgbox oCell.string end if End Sub Sub Sheet1_Disposing() End Sub Here is some output from xray: _ Events watched by this Listener _ disposing com.sun.star.lang.XEventListener modified com.sun.star.util.XModifyListener _ Methods using this Listener as a parameter _( nothing to display ) Shouldn't something be displayed? Regards, 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
[libreoffice-users] Using a listeners in a basic macro
Is there a concise list or table that shows what listeners are available to use in a calc sheet? Or maybe a way to generate one? Thanks, 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
[libreoffice-users] Re: csv files not displaying properly
On 07/21/2013 04:16 PM, Tom Davies wrote: Hi :) This guide might help https://wiki.documentfoundation.org/UserProfile Regards from Tom :) Thanks for the link. Regards, 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
[libreoffice-users] Re: csv files not displaying properly
On 07/21/2013 04:09 PM, Jay Lozier wrote: On Sun, 21 Jul 2013 16:47:02 -0400, Jim Byrnes wrote: On 07/21/2013 03:16 PM, Jay Lozier wrote: On Sun, 21 Jul 2013 15:47:14 -0400, Jim Byrnes wrote: On 07/21/2013 01:29 PM, Jay Lozier wrote: 1. On Sun, 21 Jul 2013 13:56:21 -0400, Jim Byrnes wrote: OS = Ubuntu 12.04 up to date & LO = 3.5.7.2 I have been downloading and opening bank and credit card activity as csv files for some time now with no problems using LO. Today when I did it the results are unusable. In regards to the bank download, by unusable I mean: There should be six columns of data and there is, but column C is very wide. Column C should only contain a check or deposit amount. Starting on row 3, column C has parts of other columns and rows in it and has 3 separate lines in it. In regards to the credit card download: In this case it displays the columns correctly, but some rows are missing. It should have a heading and 6 rows. It displays a heading and 3 rows. The bottom 3 rows are missing. In trying to figure this out I: Looked at the files with a text editor and they look properly formatted. They open correctly in Gnumeric and Calligra sheets. In the text import dialog down in the Fields section both display correctly. That is all of the columns display as they should and all the rows are present. I have Character set = Unicode (UTF-8), Language = Default - English (USA), Separated by = Comma. Here is a sanitized sample of the bank file from a text editor. x555,06/30/2013,0.31,0,Added to Account,Accr Earning Pymt x555,06/28/2013,104.82,0,Deposit,ACH Deposit x555,06/27/2013,-1499.50,1130,,Check I had a copy of this type of file in my trash folder that I processed last month with no problems. When I tried it today I got the same results as above. To my knowledge I have not changed any settings that would cause this. The only thing I have done differently is download and read Andrew Pitonyak's excellent book on macro's in Writer format. While reading it I did activate some of his example macros. I don't see how this could cause any problems and mention it only for completeness. OK, while gathering information for this post I discovered that my problems start when a negative number is encountered. In fact if I remove the minus sign from all numbers the file displays correctly. Does anyone have any idea what is happening and how to fix it? Thanks, Jim Jim, Using your sample data I had no problems with the csv file with the following settings 1. Character set = Unicode (UTF-8), Language = Default - English (USA), Separated by = Comma, Detect Special Numbers checked 2. Character set = Unicode (UTF-8), Language = Default - English (USA), Separated by = Comma, Detect Special Numbers unchecked 3. Character set = Unicode (UTF-7), Language = Default - English (USA), Separated by = Comma, Detect Special Numbers checked In all cases the data imported correctly and the amounts behaved as expected; formatting and sum() worked as expected. Using LO 4.0.0 from openSUSE 12.3 repository. Jay, It was working for me also. Mine is from the Unbuntu repository and I don't think there have been any updates to it , but I will check. I'm hoping someone recognizes the problem or knows of some setting I may have inadvertently changed to cause the problem. Just out of curiosity did you happen to add a couple of lines after the last one that had the negative number in it? All of my problems seem to start after a negative number. Silly me, I was just giving people a look at the file format, it never dawned on me that could be used to test with. I should have included some more lines. Thanks, Jim Jim, Jay, I know there is LO ppa you can add to your ppa list that will allow you to get the lastest version. I have been thinking about doing that. I did add any extra data; I did not think of it. But after replicating the data a couple times in the csv file then importing it I had no problems with the data. I used #1 of the test methods, which is my default setting. I can not see anything is the csv file that looked wrong such as unexpected character. One thing to check is the columns in the wizard should show "standard" (the default as far as I know) for the import type. Mine say standard. I just remembered that I loaned my laptop to my daughter and it is setup the same as my desktop that I am having trouble with. Had her bring it over and I tried the problem file on it and it worked just fine, so something is wrong with my setup. I opened tools-->options on both machines and compared them line by line they were almost exactly the same. I couldn't see how the minor differences would make any difference but I changed mine to match the laptop but it still doesn't work correctly. I guess after a bit if no one else has any ideas I will reinstall or go the ppa route. Thanks, Jim Jim
[libreoffice-users] Re: csv files not displaying properly
On 07/21/2013 03:16 PM, Jay Lozier wrote: On Sun, 21 Jul 2013 15:47:14 -0400, Jim Byrnes wrote: On 07/21/2013 01:29 PM, Jay Lozier wrote: 1. On Sun, 21 Jul 2013 13:56:21 -0400, Jim Byrnes wrote: OS = Ubuntu 12.04 up to date & LO = 3.5.7.2 I have been downloading and opening bank and credit card activity as csv files for some time now with no problems using LO. Today when I did it the results are unusable. In regards to the bank download, by unusable I mean: There should be six columns of data and there is, but column C is very wide. Column C should only contain a check or deposit amount. Starting on row 3, column C has parts of other columns and rows in it and has 3 separate lines in it. In regards to the credit card download: In this case it displays the columns correctly, but some rows are missing. It should have a heading and 6 rows. It displays a heading and 3 rows. The bottom 3 rows are missing. In trying to figure this out I: Looked at the files with a text editor and they look properly formatted. They open correctly in Gnumeric and Calligra sheets. In the text import dialog down in the Fields section both display correctly. That is all of the columns display as they should and all the rows are present. I have Character set = Unicode (UTF-8), Language = Default - English (USA), Separated by = Comma. Here is a sanitized sample of the bank file from a text editor. x555,06/30/2013,0.31,0,Added to Account,Accr Earning Pymt x555,06/28/2013,104.82,0,Deposit,ACH Deposit x555,06/27/2013,-1499.50,1130,,Check I had a copy of this type of file in my trash folder that I processed last month with no problems. When I tried it today I got the same results as above. To my knowledge I have not changed any settings that would cause this. The only thing I have done differently is download and read Andrew Pitonyak's excellent book on macro's in Writer format. While reading it I did activate some of his example macros. I don't see how this could cause any problems and mention it only for completeness. OK, while gathering information for this post I discovered that my problems start when a negative number is encountered. In fact if I remove the minus sign from all numbers the file displays correctly. Does anyone have any idea what is happening and how to fix it? Thanks, Jim Jim, Using your sample data I had no problems with the csv file with the following settings 1. Character set = Unicode (UTF-8), Language = Default - English (USA), Separated by = Comma, Detect Special Numbers checked 2. Character set = Unicode (UTF-8), Language = Default - English (USA), Separated by = Comma, Detect Special Numbers unchecked 3. Character set = Unicode (UTF-7), Language = Default - English (USA), Separated by = Comma, Detect Special Numbers checked In all cases the data imported correctly and the amounts behaved as expected; formatting and sum() worked as expected. Using LO 4.0.0 from openSUSE 12.3 repository. Jay, It was working for me also. Mine is from the Unbuntu repository and I don't think there have been any updates to it , but I will check. I'm hoping someone recognizes the problem or knows of some setting I may have inadvertently changed to cause the problem. Just out of curiosity did you happen to add a couple of lines after the last one that had the negative number in it? All of my problems seem to start after a negative number. Silly me, I was just giving people a look at the file format, it never dawned on me that could be used to test with. I should have included some more lines. Thanks, Jim Jim, Jay, I know there is LO ppa you can add to your ppa list that will allow you to get the lastest version. I have been thinking about doing that. I did add any extra data; I did not think of it. But after replicating the data a couple times in the csv file then importing it I had no problems with the data. I used #1 of the test methods, which is my default setting. I can not see anything is the csv file that looked wrong such as unexpected character. One thing to check is the columns in the wizard should show "standard" (the default as far as I know) for the import type. Mine say standard. I just remembered that I loaned my laptop to my daughter and it is setup the same as my desktop that I am having trouble with. Had her bring it over and I tried the problem file on it and it worked just fine, so something is wrong with my setup. I opened tools-->options on both machines and compared them line by line they were almost exactly the same. I couldn't see how the minor differences would make any difference but I changed mine to match the laptop but it still doesn't work correctly. I guess after a bit if no one else has any ideas I will reinstall or go the ppa route. Thanks, Jim -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http
[libreoffice-users] Re: csv files not displaying properly
On 07/21/2013 01:29 PM, Jay Lozier wrote: 1. On Sun, 21 Jul 2013 13:56:21 -0400, Jim Byrnes wrote: OS = Ubuntu 12.04 up to date & LO = 3.5.7.2 I have been downloading and opening bank and credit card activity as csv files for some time now with no problems using LO. Today when I did it the results are unusable. In regards to the bank download, by unusable I mean: There should be six columns of data and there is, but column C is very wide. Column C should only contain a check or deposit amount. Starting on row 3, column C has parts of other columns and rows in it and has 3 separate lines in it. In regards to the credit card download: In this case it displays the columns correctly, but some rows are missing. It should have a heading and 6 rows. It displays a heading and 3 rows. The bottom 3 rows are missing. In trying to figure this out I: Looked at the files with a text editor and they look properly formatted. They open correctly in Gnumeric and Calligra sheets. In the text import dialog down in the Fields section both display correctly. That is all of the columns display as they should and all the rows are present. I have Character set = Unicode (UTF-8), Language = Default - English (USA), Separated by = Comma. Here is a sanitized sample of the bank file from a text editor. x555,06/30/2013,0.31,0,Added to Account,Accr Earning Pymt x555,06/28/2013,104.82,0,Deposit,ACH Deposit x555,06/27/2013,-1499.50,1130,,Check I had a copy of this type of file in my trash folder that I processed last month with no problems. When I tried it today I got the same results as above. To my knowledge I have not changed any settings that would cause this. The only thing I have done differently is download and read Andrew Pitonyak's excellent book on macro's in Writer format. While reading it I did activate some of his example macros. I don't see how this could cause any problems and mention it only for completeness. OK, while gathering information for this post I discovered that my problems start when a negative number is encountered. In fact if I remove the minus sign from all numbers the file displays correctly. Does anyone have any idea what is happening and how to fix it? Thanks, Jim Jim, Using your sample data I had no problems with the csv file with the following settings 1. Character set = Unicode (UTF-8), Language = Default - English (USA), Separated by = Comma, Detect Special Numbers checked 2. Character set = Unicode (UTF-8), Language = Default - English (USA), Separated by = Comma, Detect Special Numbers unchecked 3. Character set = Unicode (UTF-7), Language = Default - English (USA), Separated by = Comma, Detect Special Numbers checked In all cases the data imported correctly and the amounts behaved as expected; formatting and sum() worked as expected. Using LO 4.0.0 from openSUSE 12.3 repository. Jay, It was working for me also. Mine is from the Unbuntu repository and I don't think there have been any updates to it , but I will check. I'm hoping someone recognizes the problem or knows of some setting I may have inadvertently changed to cause the problem. Just out of curiosity did you happen to add a couple of lines after the last one that had the negative number in it? All of my problems seem to start after a negative number. Silly me, I was just giving people a look at the file format, it never dawned on me that could be used to test with. I should have included some more lines. Thanks, 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
[libreoffice-users] csv files not displaying properly
OS = Ubuntu 12.04 up to date & LO = 3.5.7.2 I have been downloading and opening bank and credit card activity as csv files for some time now with no problems using LO. Today when I did it the results are unusable. In regards to the bank download, by unusable I mean: There should be six columns of data and there is, but column C is very wide. Column C should only contain a check or deposit amount. Starting on row 3, column C has parts of other columns and rows in it and has 3 separate lines in it. In regards to the credit card download: In this case it displays the columns correctly, but some rows are missing. It should have a heading and 6 rows. It displays a heading and 3 rows. The bottom 3 rows are missing. In trying to figure this out I: Looked at the files with a text editor and they look properly formatted. They open correctly in Gnumeric and Calligra sheets. In the text import dialog down in the Fields section both display correctly. That is all of the columns display as they should and all the rows are present. I have Character set = Unicode (UTF-8), Language = Default - English (USA), Separated by = Comma. Here is a sanitized sample of the bank file from a text editor. x555,06/30/2013,0.31,0,Added to Account,Accr Earning Pymt x555,06/28/2013,104.82,0,Deposit,ACH Deposit x555,06/27/2013,-1499.50,1130,,Check I had a copy of this type of file in my trash folder that I processed last month with no problems. When I tried it today I got the same results as above. To my knowledge I have not changed any settings that would cause this. The only thing I have done differently is download and read Andrew Pitonyak's excellent book on macro's in Writer format. While reading it I did activate some of his example macros. I don't see how this could cause any problems and mention it only for completeness. OK, while gathering information for this post I discovered that my problems start when a negative number is encountered. In fact if I remove the minus sign from all numbers the file displays correctly. Does anyone have any idea what is happening and how to fix it? Thanks, 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