[libreoffice-users] Calc not able to store options
Season's Greetings!! Hello everybody, In one of the frequent, random power failures my PC (config below) switched off despite the inverter+UPS it feeds through! I was using firefox and Calc at the time this happened. Now that I am looking at the damage apparently there was none. --- 1. The file I was working on opened up smoothly. Sometimes even if I switch off properly it goes in to recover mode the next time I try to bring it up. So I was pleasantly surprised. 2. The recent documents had just the last file I was working on. That indeed felt as a blessing in disguise because normally the recent documents under Calc shows all the recent documents including odt etc. So I do have to search and open for my recent ods document. 3. Before the event, I had configured Calc to go Right when I completed a data entry to a cell and pressed ENTER. This had changed to the standard go Down. So, I went to Tools - Options - LibreOffice Calc - General - Input Settings - and made it Right. The spread-sheet refuses to do so. I restarted Calc. No use. The above path still shows Right as the option but the next cell is the cell down the last one. I restarted the machine and still no use. I am not inclined to upgrade to higher version unless a re-installation is absolutely necessary. (As I feel the efforts and risk of me doing something stupid are not worth the possible benefits.) Any ideas? Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc not able to store options
Hi Tom :) Thanks for the reply. I got an off-list e-mail with the link same as what you provided for user profile to the other thread where is that configuration file again?. https://wiki.documentfoundation.org/Documentation/UserProfile The mail pointed to a corrupted user profile. As suggested in the link - and also in the e-mail - I did change the profile directory name and restarted LibreOffice. Changed the option from down to right and this time it worked and the choice was saved. For other newbies/ GNUbies: 1. I was not sure which exact file to be renamed so I changed the ~/.libreoffice/3/user directory itself. 2. I was also told an upgrade would not help corrupt user profile as user profile/ settings are (understandably) carried untouched to the newer version. The hardware has not thrown up other problems yet. Touch wood ;) Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: Tom Davies tomdavie...@yahoo.co.uk To: Viral Orpe viral.o...@yahoo.com; users@global.libreoffice.org users@global.libreoffice.org Sent: Sunday, December 23, 2012 3:46 AM Subject: Re: [libreoffice-users] Calc not able to store options Hi :) I assume that the machine crashes regardless of whether you are using LO or not? Perhaps now would be a good time to let your package manager run it's updates? Don't worry, it wont upgrade LO as it generally just does updates, not upgrades. Errr, do you feel comfortable opening the side of the case and do you know how to take precautions again static? Even the cleanest skin has oils that can eat into chips and destroy tracks over time. Plus skin carries a small static charge that is plenty enough to destroy components. On the other hand you can usually open the side of the case without being forced to touch anything crucial inside (except by your own curiosity). My 1st guesses as to why it's started crashing is 1. Choking dust built-up too much and is now providing insulation trapping heat. Don't blow it out! For some reason it's not like normal dust and does tend to cause choking. I usually try to have a cuppa tea or glass of milk or water fairly nearby in case i forget and need a drink in a hurry. 2. Dead or dying fan, perhaps just too weighed down by the mystery dust. 3. graphics card wobbled loose somehow and needs to be pushed back firmly but gently. 4. Ram issues. 5. Java problems Actually java and ram are probably easier to check without even taking the side off the case. When booting into Mint use the grub menu to go down to the Memory Test options and let the testing run for quite a while, a couple of hours ideally. Java you could check just by installing a newer version of java, or reverting back to an older one or by switching off java in LO (although other programs will probably still be using it) Tools - Options - Java Also just wondering if your hard-drive is quite noisy? or are the fans rattling away loudly? Is the case getting quite hot? Regards from Tom :) From: Viral Orpe viral.o...@yahoo.com To: users@global.libreoffice.org users@global.libreoffice.org Sent: Saturday, 22 December 2012, 14:19 Subject: [libreoffice-users] Calc not able to store options Season's Greetings!! Hello everybody, In one of the frequent, random power failures my PC (config below) switched off despite the inverter+UPS it feeds through! I was using firefox and Calc at the time this happened. Now that I am looking at the damage apparently there was none. --- 1. The file I was working on opened up smoothly. Sometimes even if I switch off properly it goes in to recover mode the next time I try to bring it up. So I was pleasantly surprised. 2. The recent documents had just the last file I was working on. That indeed felt as a blessing in disguise because normally the recent documents under Calc shows all the recent documents including odt etc. So I do have to search and open for my recent ods document. 3. Before the event, I had configured Calc to go Right when I completed a data entry to a cell and pressed ENTER. This had changed to the standard go Down. So, I went to Tools - Options - LibreOffice Calc - General - Input Settings - and made it Right. The spread-sheet refuses to do so. I restarted Calc. No use. The above path still shows Right as the option but the next cell is the cell down the last one. I restarted
Re: [libreoffice-users] Re: Is it possible to show cell value with text
Thanks Dan, Link/Guides look good :) Regards, Viral Orpe From: Dan Lewis elderdanle...@gmail.com To: users@global.libreoffice.org Sent: Wednesday, November 14, 2012 8:29 AM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text http://wiki.documentfoundation.org/Documentation/Publications Download the Calc Guide from this link. It may help. --Dan On 11/13/2012 08:06 PM, Viral Orpe wrote: Hi Johnny, May be I should go through Calc documents/ How to use Calc or something similar! I have used Excel/Calc in a hands on approach - using the drop down menu one gets after clicking the = sign for entering a formula, a generous use of F1, exploring the menus/ icons on tool-bar and of course, Google. So, (now it seems, obviously) I do not know the full capabilities of either software. I may not have needed/ used/ or thought possible many aspects/ functionalities of these applications that are standard practice for most users! And, hence the confusion. Got to get back to the basics :) Thanks anyways, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) Processor : Intel (R) Pentium(R) III Memory : 256MB SDRAM (!?), 20GB IDE OS : Vector Linux - Kernel (???) LibreOffice : Yet to try.. ! --- From: Johnny Rosenberg gurus.knu...@gmail.com To: LibreOffice Användare users@global.libreoffice.org Sent: Tuesday, November 13, 2012 10:14 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text 2012/11/13 Viral Orpe viral.o...@yahoo.com: Thanks Johnny, Season's Greetings!! (Today we are celebrating Diwali Festival and New Year here - India) I would like to know what is this language used to talk to Calc? And would appreciate any pointers to any literature, guides etc. I know C and have worked with formulas - this combination is new to me. I am not sure what you are asking. So far in this thread we have only talked about cell formulas, as far as I have seen. Those are the same as those in Excel, at least most of them. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Thanks, Regards, Viral Orpe :) From: Johnny Rosenberg gurus.knu...@gmail.com To: Viral Orpe viral.o...@yahoo.com Sent: Monday, November 12, 2012 11:42 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text 2012/11/12 Viral Orpe viral.o...@yahoo.com: Hi John, Checked your reply on list-archives :) Somehow must have missed on 6th Nov when it first appeared. Please, what is the stand for? =A1 B1 is the same as =CONCATENATE(A1;B1) Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Dave_ had asked the question with a + So, I guess this is some standard way of doing things(name?) with slightly diff syntax. I have never known it can be done that way - text and formula together in a cell. I have always used adjacent cells - one with the text part and another with the formula. Any pointers would be great. Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: John Clegg john.cl...@nailsea.net To: Dan Lewis elderdanle...@gmail.com Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Sunday, November 11, 2012 9:59 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text This was a thread from 5th November which I answered to the group. He thanked me but got fooled by the stupid group reply settings. On 11 November 2012 16:24, Dan Lewis elderdanle...@gmail.com wrote: On 11/11/2012 11:03 AM, dave_ wrote: Thanks for the solution. -- View this message in context: http://nabble.** documentfoundation.org/Is-it-**possible-to-show-cell-value-** with-text-tp4016842p4018036.**htmlhttp://nabble.documentfoundation.org/Is-it-possible-to-show-cell-value-with-text-tp4016842p4018036.html Sent from the Users mailing list archive at Nabble.com. How can we give you a solution when you have not yet given us the problem? It appears that you are using Calc. But what to you mean by show
Re: [libreoffice-users] Re: Is it possible to show cell value with text
Hi Johnny, May be I should go through Calc documents/ How to use Calc or something similar! I have used Excel/Calc in a hands on approach - using the drop down menu one gets after clicking the = sign for entering a formula, a generous use of F1, exploring the menus/ icons on tool-bar and of course, Google. So, (now it seems, obviously) I do not know the full capabilities of either software. I may not have needed/ used/ or thought possible many aspects/ functionalities of these applications that are standard practice for most users! And, hence the confusion. Got to get back to the basics :) Thanks anyways, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) Processor : Intel (R) Pentium(R) III Memory : 256MB SDRAM (!?), 20GB IDE OS : Vector Linux - Kernel (???) LibreOffice : Yet to try.. ! --- From: Johnny Rosenberg gurus.knu...@gmail.com To: LibreOffice Användare users@global.libreoffice.org Sent: Tuesday, November 13, 2012 10:14 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text 2012/11/13 Viral Orpe viral.o...@yahoo.com: Thanks Johnny, Season's Greetings!! (Today we are celebrating Diwali Festival and New Year here - India) I would like to know what is this language used to talk to Calc? And would appreciate any pointers to any literature, guides etc. I know C and have worked with formulas - this combination is new to me. I am not sure what you are asking. So far in this thread we have only talked about cell formulas, as far as I have seen. Those are the same as those in Excel, at least most of them. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Thanks, Regards, Viral Orpe :) From: Johnny Rosenberg gurus.knu...@gmail.com To: Viral Orpe viral.o...@yahoo.com Sent: Monday, November 12, 2012 11:42 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text 2012/11/12 Viral Orpe viral.o...@yahoo.com: Hi John, Checked your reply on list-archives :) Somehow must have missed on 6th Nov when it first appeared. Please, what is the stand for? =A1 B1 is the same as =CONCATENATE(A1;B1) Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Dave_ had asked the question with a + So, I guess this is some standard way of doing things(name?) with slightly diff syntax. I have never known it can be done that way - text and formula together in a cell. I have always used adjacent cells - one with the text part and another with the formula. Any pointers would be great. Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: John Clegg john.cl...@nailsea.net To: Dan Lewis elderdanle...@gmail.com Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Sunday, November 11, 2012 9:59 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text This was a thread from 5th November which I answered to the group. He thanked me but got fooled by the stupid group reply settings. On 11 November 2012 16:24, Dan Lewis elderdanle...@gmail.com wrote: On 11/11/2012 11:03 AM, dave_ wrote: Thanks for the solution. -- View this message in context: http://nabble.** documentfoundation.org/Is-it-**possible-to-show-cell-value-** with-text-tp4016842p4018036.**htmlhttp://nabble.documentfoundation.org/Is-it-possible-to-show-cell-value-with-text-tp4016842p4018036.html Sent from the Users mailing list archive at Nabble.com. How can we give you a solution when you have not yet given us the problem? It appears that you are using Calc. But what to you mean by show cell value? Where is the text located? Are you referring to a cell containing twenty-seven rather than 27 for example? Or perhaps ten november two thousand twelve instead of 10 Nov 2012 or Nov 10, 2012? Please be more specific. --Dan -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing
Re: [libreoffice-users] Re: Is it possible to show cell value with text
Hi John, Checked your reply on list-archives :) Somehow must have missed on 6th Nov when it first appeared. Please, what is the stand for? Dave_ had asked the question with a + So, I guess this is some standard way of doing things(name?) with slightly diff syntax. I have never known it can be done that way - text and formula together in a cell. I have always used adjacent cells - one with the text part and another with the formula. Any pointers would be great. Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: John Clegg john.cl...@nailsea.net To: Dan Lewis elderdanle...@gmail.com Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Sunday, November 11, 2012 9:59 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text This was a thread from 5th November which I answered to the group. He thanked me but got fooled by the stupid group reply settings. On 11 November 2012 16:24, Dan Lewis elderdanle...@gmail.com wrote: On 11/11/2012 11:03 AM, dave_ wrote: Thanks for the solution. -- View this message in context: http://nabble.** documentfoundation.org/Is-it-**possible-to-show-cell-value-** with-text-tp4016842p4018036.**htmlhttp://nabble.documentfoundation.org/Is-it-possible-to-show-cell-value-with-text-tp4016842p4018036.html Sent from the Users mailing list archive at Nabble.com. How can we give you a solution when you have not yet given us the problem? It appears that you are using Calc. But what to you mean by show cell value? Where is the text located? Are you referring to a cell containing twenty-seven rather than 27 for example? Or perhaps ten november two thousand twelve instead of 10 Nov 2012 or Nov 10, 2012? Please be more specific. --Dan -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc - Multiple font effects in a single cell
Hi David, .. I know I can get this effect be editing A1 manually, ... == I thought the strikeout (or for that matter ANY formatting) applies to the entire cell. I tried to strike out cde from abcdefg but had no idea how to do it. What could be the trick? Quite possible I have earlier version (check below) but that not possible with the large number of cells I want to edit in this manner. Can anyone tell me a way to do this, please? I'm willing to program this in basic if it's the only way. David Lynch Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc - Multiple font effects in a single cell
Hi MiguelAngel, That's cool. Just this last weekend I spent a lot of time trying to do exactly that - using shell script - reading line by line and then extracting the alphanums from a csv. This is way too fast and easy. Thanks,It won't address the Multiple font effects in a single cell issue. (Right?) BTW, I do not understand one thing. imo, from ease point of view the world moved from scripts to spreadsheets etc applications and now everybody wants to program them!? Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: MiguelAngel mari...@miguelangel.mobi To: users@global.libreoffice.org Sent: Friday, October 19, 2012 3:24 PM Subject: Re: [libreoffice-users] Calc - Multiple font effects in a single cell El 19/10/12 10:00, david_lynch escribió: I want to have a cell in Calc with multiple font effects, which characters get which font depends on the values in other cells. An example: A1 abcdefg A2 3 A3 5 I want to be able to program Calc so that characters A2 to A3 (3 to 5) of A1 are strikeout, so A1 looks like abcdefg with cde in strikeout. I know I can get this effect be editing A1 manually, but that not possible with the large number of cells I want to edit in this manner. Can anyone tell me a way to do this, please? I'm willing to program this in basic if it's the only way. David Lynch Maybe the function MID() is what you are looking for? =MID(abcdefg;A2;A3-A2+1) Menu/Help/LibreOffice help (F1) - Index tab - search term: MID. MID Returns a text string of a text. The parameters specify the starting position and the number of characters. Syntax MID(Text; Start; Number) Text is the text containing the characters to extract. Start is the position of the first character in the text to extract. Number specifies the number of characters in the part of the text. Example =MID(office;2;2) returns ff. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: how to crack a PW in LO?
Hi Jay :) That is an interesting idea - not to know your own password(s). You definitely can't forget what you don't know. Worth following that concept .. One of my friends would set his sharable password to iwonttell (I won't tell). He then would keep fighting back and forth for sometime when somebody would request him his password and get offended by the dramatic answer. He would explain just before something broke down that the string he uttered is to be taken as password and not as a meaningful statement! regards, - Viral Orpe :) . I use a password manager that I can set the length of the password to an arbitrary length and have it generate string of gibberish that I do not memorize. Anyone asking for my Facebook password in a job interview is out of luck; I do not know it because I use a password manager and each password I use is generated per account.. -- For unsubscribe instructions e-mail to: users+h...@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] Ambiguous Calc cell status show
Hi :) I could not find a better line for SUBJECT, sorry! Background: I am copying a few numbers from a website generated .png in to Calc. These numbers are neither download_able nor copy-paste_able. They have to be manually seen in web browser and typed in Calc. I typically tile the browser and Calc windows - manually, yet to find a tile windows option, (but that is not my query). I switch between the browser and Calc for every new set of data - say every 2 minutes. When I am inside the browser window, filling forms to request data or adjusting the output so all numbers are seen together, the Calc window is obviously deselected. However, the Calc cell I was last present in does NOT show any change in appearance. It is showing that it is the selected cell but it is ignorant about whether the application (Calc) itself is selected or not. Problem: When I am done adjusting with browser window, I make a mental note of the number to be transferred next. The browser window is still the selected window. I look at the Calc window for putting in numbers. I happen to see the cell (and not the window), and just start typing which obviously goes somewhere in dump - the browser window doesn't take it and Calc window is not looking at it since it is not selected! I have been doing this for a fairly looong time and this typing mistake is new to me. On some thought I came to this conclusion that these mistakes happen/ have increased because the cell keeps on the same look of being selected or ready to accept data. And I am sort of getting cheated every time (almost)! This is a minor irritant, I agree. Soon enough thanks to Gimp, LO draw, or Calc charts itself, I would get rid of this inefficient, tedious 16th century procedure. In the meanwhile, I am trying to pick-up Alt-Tab habit. In any case: Que. Shouldn't along with the Calc application window, the Calc cell somehow *show* that it is not active Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: Rolf Lochbühler rolf.lochbueh...@yahoo.de To: users@global.libreoffice.org users@global.libreoffice.org Sent: Friday, October 12, 2012 3:44 AM Subject: Re: [libreoffice-users] function concatenate Not sure if there's a way to do that with functions. How about this Basic macro? ~ Option Explicit Public Function CONCAT( ByRef rng As Variant ) As String Dim i, k As Long CONCAT = For i = 1 To UBound( rng(), 1 ) For k = 1 To UBound( rng(), 2 ) CONCAT = CONCAT rng( i, k ) Next k Next i End Function ~ Call it - with a column type argument like “= CONCAT(a1:a10)” or - with a row type argument like “= CONCAT(a1:j1)” or - with an array type argument like “= CONCAT(a1:b5)” -rl Am 2012-10-11 um 22:49 schrieb yahoo-pier_andreit pier_andr...@yahoo.it: is there any way to have concatenate function works like sum?? they are the same function but the first with words the second with numbers for example =SUM(a1:a10) sum all the numbers from a1 to a10 =CONCATENATE(a1:a10) should put one after the other the words from a1 to a10 but it doesn't works how can I have a such behaviour??? of course not =CONCATENATE(a1;a2;a3;a4;a5;a6) :-) thnx, :-) pier :-) -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Ambiguous Calc cell status show
Hi :) Ideally, I would like to get rid of the dependency and do all the work, the web-site's and mine, from raw data to have timely results with better control on various parameters. However, in the meanwhile I can try your idea. What are the important softwares for OCR? I thought they come bundled only when one purchases some scanner. My system details are given below. Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: rost52 bugquestcon...@online.de To: users@global.libreoffice.org Sent: Sunday, October 14, 2012 2:01 PM Subject: Re: [libreoffice-users] Ambiguous Calc cell status show Viral, I can't comment on your request with the cursor but got an idea concerning typing numbers displayed in a png-file into calc. Did you consider already using an OCR SW to transfer your numbers into a copy-enabled data form? On 14.10.2012 15:45, Viral Orpe wrote: Hi :) I could not find a better line for SUBJECT, sorry! Background: I am copying a few numbers from a website generated .png in to Calc. These numbers are neither download_able nor copy-paste_able. They have to be manually seen in web browser and typed in Calc. I typically tile the browser and Calc windows - manually, yet to find a tile windows option, (but that is not my query). I switch between the browser and Calc for every new set of data - say every 2 minutes. When I am inside the browser window, filling forms to request data or adjusting the output so all numbers are seen together, the Calc window is obviously deselected. However, the Calc cell I was last present in does NOT show any change in appearance. It is showing that it is the selected cell but it is ignorant about whether the application (Calc) itself is selected or not. Problem: When I am done adjusting with browser window, I make a mental note of the number to be transferred next. The browser window is still the selected window. I look at the Calc window for putting in numbers. I happen to see the cell (and not the window), and just start typing which obviously goes somewhere in dump - the browser window doesn't take it and Calc window is not looking at it since it is not selected! I have been doing this for a fairly looong time and this typing mistake is new to me. On some thought I came to this conclusion that these mistakes happen/ have increased because the cell keeps on the same look of being selected or ready to accept data. And I am sort of getting cheated every time (almost)! This is a minor irritant, I agree. Soon enough thanks to Gimp, LO draw, or Calc charts itself, I would get rid of this inefficient, tedious 16th century procedure. In the meanwhile, I am trying to pick-up Alt-Tab habit. In any case: Que. Shouldn't along with the Calc application window, the Calc cell somehow *show* that it is not active Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: Rolf Lochbühler rolf.lochbueh...@yahoo.de To: users@global.libreoffice.org users@global.libreoffice.org Sent: Friday, October 12, 2012 3:44 AM Subject: Re: [libreoffice-users] function concatenate Not sure if there's a way to do that with functions. How about this Basic macro? ~ Option Explicit Public Function CONCAT( ByRef rng As Variant ) As String Dim i, k As Long CONCAT = For i = 1 To UBound( rng(), 1 ) For k = 1 To UBound( rng(), 2 ) CONCAT = CONCAT rng( i, k ) Next k Next i End Function ~ Call it - with a column type argument like “= CONCAT(a1:a10)” or - with a row type argument like “= CONCAT(a1:j1)” or - with an array type argument like “= CONCAT(a1:b5)” -rl Am 2012-10-11 um 22:49 schrieb yahoo-pier_andreit pier_andr...@yahoo.it: is there any way to have concatenate function works like sum?? they are the same function but the first with words the second with numbers for example =SUM(a1:a10) sum all the numbers from a1 to a10 =CONCATENATE(a1:a10) should put one after the other the words from a1 to a10 but it doesn't works how can I have a such behaviour
Re: [libreoffice-users] Ambiguous Calc cell status show
Hi Dan :) I could find Simple Scan under Applications/ Graphics. Thanks, It is kind of stuck on the fact that I do not have a scanner. Also, couldn't find explicit mention of OCR, but I guess the menu chain Document - Scan - Text might be doing that. Seems there is some confusion here or perhaps I am not able to grasp the idea / use Simple Scan. I have a .png from a website that rost52 suggested I can pass through OCR so that I do not have to manually copy some numbers from it. Simple Scan does not take .png (or any file) as an input. (Right?) I checked under Simple Scan preferences, the source choice doesn't have file / browse facility. I have Simple Scan 3.2.1 Am I using simple scan correctly? Is there a way to separate the OCR part of Simple Scan application from the scanning part?! I mean from the menus itself, not getting down to the code! Thanks for your time, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: Dan Lewis elderdanle...@gmail.com To: users@global.libreoffice.org Sent: Sunday, October 14, 2012 5:27 PM Subject: Re: [libreoffice-users] Ambiguous Calc cell status show Ubuntu has a program called Simple Scan. Very likely your Linux version will have a similar OCR. --Dan On 10/14/2012 07:00 AM, Viral Orpe wrote: Hi :) Ideally, I would like to get rid of the dependency and do all the work, the web-site's and mine, from raw data to have timely results with better control on various parameters. However, in the meanwhile I can try your idea. What are the important softwares for OCR? I thought they come bundled only when one purchases some scanner. My system details are given below. Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: rost52 bugquestcon...@online.de To: users@global.libreoffice.org Sent: Sunday, October 14, 2012 2:01 PM Subject: Re: [libreoffice-users] Ambiguous Calc cell status show Viral, I can't comment on your request with the cursor but got an idea concerning typing numbers displayed in a png-file into calc. Did you consider already using an OCR SW to transfer your numbers into a copy-enabled data form? On 14.10.2012 15:45, Viral Orpe wrote: Hi :) I could not find a better line for SUBJECT, sorry! Background: I am copying a few numbers from a website generated .png in to Calc. These numbers are neither download_able nor copy-paste_able. They have to be manually seen in web browser and typed in Calc. I typically tile the browser and Calc windows - manually, yet to find a tile windows option, (but that is not my query). I switch between the browser and Calc for every new set of data - say every 2 minutes. When I am inside the browser window, filling forms to request data or adjusting the output so all numbers are seen together, the Calc window is obviously deselected. However, the Calc cell I was last present in does NOT show any change in appearance. It is showing that it is the selected cell but it is ignorant about whether the application (Calc) itself is selected or not. Problem: When I am done adjusting with browser window, I make a mental note of the number to be transferred next. The browser window is still the selected window. I look at the Calc window for putting in numbers. I happen to see the cell (and not the window), and just start typing which obviously goes somewhere in dump - the browser window doesn't take it and Calc window is not looking at it since it is not selected! I have been doing this for a fairly looong time and this typing mistake is new to me. On some thought I came to this conclusion that these mistakes happen/ have increased because the cell keeps on the same look of being selected or ready to accept data. And I am sort of getting cheated every time (almost)! This is a minor irritant, I agree. Soon enough thanks to Gimp, LO draw, or Calc charts itself, I would get rid of this inefficient, tedious 16th century procedure. In the meanwhile, I am trying to pick-up Alt-Tab habit. In any case: Que. Shouldn't along with the Calc application window
Re: [libreoffice-users] Fw: Help request on CALC charts' features
Hi Tom :) Yahoo screen-shot was used as an example since Yahoo is omnipresent. You are most probably right about the yahoo data but I don't think they give out any data - just charts with the limited options that are on offer - chart type , data range, and a bouquet of indicators. I take my data from the Exchange itself - The National Stock Exchange (NSE), India. And do my own calculations - in CALC - to extract some meaning out of it. http://www.nseindia.com/index_nse.htm Under the products tab one gets daily data called Bhav-copy (translates to Rate Sheet) Around 7 p.m. every evening they diligently load the day's activities in .csv (which I use) and .dbf (? database) format which I just download in case one day I use a DB. Some data is available only for the day and not for past days, that has to be collected and stored away before it gets overwritten the next day! I am worried that one day these exchanges will start asking for money for this or older data. For example, a few years ago I think I could not get the London Metal Exchange' historical data for Copper, and Gold prices - to get a glimpse of what happened when in the past. I am collecting my stock exchanges daily data ever since!! Thanks for the concern though, Much appreciated, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: Tom Davies tomdavie...@yahoo.co.uk To: users@global.libreoffice.org users@global.libreoffice.org; Viral Orpe viral.o...@yahoo.com Sent: Thursday, October 11, 2012 10:56 AM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi :) Draw also has some sort of layers function but i'm not sure they are as easy to use as Gimp. Gimp is excellent but keeping the chart in LibreOffice increases the chance of keeping the information dynamic rather than as a series of static files. Lamp uses MySql (sadly i've not heard of anyone using the non-Oracle drop-in replacement called MariaDb) which is a database back-end. Could that pull in the data you use but do it automatically and dynamically rather than as snapshots? Base can supposedly read and present the data stored in MySql/MariaDb databases. Other modules, such as Writer, can use various data sources, i think the F4 key. Can Draw? Can Base use the original data rather than trying to pull the data into a MySql databse? All that sounds like a complete nightmare to organise but i've already been very impressed with how fast you've managed to pick up new tools and get them doing something intriguingly unusual. Getting good-enough results fast is great. There might be a copyright issue with using Yahoo's data but presumably they get it their original data from a public source and then maybe do a few actions to the data to present it differently? Can you get to the original source and do your own set of calculations or do you have permission to use Yahoo;s info or is that not a concern at the moment? (prolly best NOT to answer those. It's just something to consider) Regards from Tom :) --- On Wed, 10/10/12, Viral Orpe viral.o...@yahoo.com wrote: From: Viral Orpe viral.o...@yahoo.com Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features To: users@global.libreoffice.org users@global.libreoffice.org Date: Wednesday, 10 October, 2012, 17:58 Hi :) I was able to overlap two charts in gimp as well as calc. Hurrraa :) * Adjusted axis on both charts - major, minor ticks to match each other. * Scales (rather everything) Automatic is unmarked - in case we need to scale data ranges later. * Made the top one completely transparent before moving on top of first. In gimp one can be sure that they don't slide - ever. Not sure if there is a facility for that in calc - don't really expect. Just pinging in case anyone has any ideas. Objects once placed may move - e.g. one justified left other to center etc. - on their own with some remote change elsewhere in the sheet. The charts are now 100 times more helpful. No kidding! Thanks a lot to everybody who chipped in with their suggestions. Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302
Re: [libreoffice-users] Fw: Help request on CALC charts' features
Hi :) Actually I do not have that much acquaintance with LO. I moved from MS to GL last week and had to immediately work on spreadsheets - my bread and butter! Thanks to various inputs here, I was able to get done something I just wished for soo looong. I guess by base you mean the database that comes with LO. Although I know nothing about databases what you are suggesting is a complete solution to what I do right here within the LO suite! *IF* I can link/pipe the various components of the suite, and get most of the work done automatically with gr8 info-oozing charts :) that will free me to explore other aspects of GL - maintenance without fear to begin with! Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: rost52 bugquestcon...@online.de To: users@global.libreoffice.org Sent: Thursday, October 11, 2012 6:09 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Tom, interesting information about the usage of MS at stock-exchange operations Viral, I don't recall if it was mentioned or not but did you ever consider to use base to collect the data, run queries and do calculations and get all displayed in report based charts. On 11.10.2012 21:28, Tom Davies wrote: Hi :) The LSE had the 'bright idea' of switching from their rock-solid highly-scalable unix-based Linux servers to MS servers. After years of planning and heavy investment they flicked the switch to change everything over to Windows and all the machines in the building just died. It took a whole day for the to fix it and get back to Linux. The credit crunch happened soon after. Oddly it didn't reach the mainstream news much. Apparently around 60-80% of stock exchanges run on Linux, around 20% on Bsd (not mac) and most of the remaining are also unix-based with less than 1% on Windows. It's just not stable enough. It's ok to have a few viruses and inconvenient updates and a forced reboot on desktops so that is where Windows really scores. Regards from Tom :) From: Viral Orpe viral.o...@yahoo.com To: users@global.libreoffice.org users@global.libreoffice.org Sent: Thursday, 11 October 2012, 11:33 Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi Tom :) Yahoo screen-shot was used as an example since Yahoo is omnipresent. You are most probably right about the yahoo data but I don't think they give out any data - just charts with the limited options that are on offer - chart type , data range, and a bouquet of indicators. I take my data from the Exchange itself - The National Stock Exchange (NSE), India. And do my own calculations - in CALC - to extract some meaning out of it. http://www.nseindia.com/index_nse.htm Under the products tab one gets daily data called Bhav-copy (translates to Rate Sheet) Around 7 p.m. every evening they diligently load the day's activities in .csv (which I use) and .dbf (? database) format which I just download in case one day I use a DB. Some data is available only for the day and not for past days, that has to be collected and stored away before it gets overwritten the next day! I am worried that one day these exchanges will start asking for money for this or older data. For example, a few years ago I think I could not get the London Metal Exchange' historical data for Copper, and Gold prices - to get a glimpse of what happened when in the past. I am collecting my stock exchanges daily data ever since!! Thanks for the concern though, Much appreciated, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: Tom Davies tomdavie...@yahoo.co.uk To: users@global.libreoffice.org users@global.libreoffice.org; Viral Orpe viral.o...@yahoo.com Sent: Thursday, October 11, 2012 10:56 AM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi :) Draw also has some sort of layers function but i'm not sure they are as easy to use as Gimp. Gimp is excellent but keeping the chart in LibreOffice increases the chance of keeping
Re: [libreoffice-users] Fw: Help request on CALC charts' features
Hi Tom :) Thanks for bringing the copy-right to my attention. Although stock markets here are quite old - http://www.bseindia.com/ ... Established in 1875, BSE Ltd. (formerly known as Bombay Stock Exchange Ltd.), is Asia’s first Stock Exchange and one of India’s leading exchange groups - compared to the western-world % wise very few people are acquainted with them. I started but a few years ago. NSE is relatively younger and more tech savvy and darling of the Foreign Institutional Investors (FIIs). Point is: As the copyright suggests, Stock Exchanges, Regulators here are very lenient particularly towards retail investors / traders (me!) But it is an important practice to go through the copy right notice(s) of whatever you do. BTW, NSE looking for a charting solution from me is not happening :) Thanks for the encouragement though. And interesting read on the LSE! Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: Tom Davies tomdavie...@yahoo.co.uk To: Viral Orpe viral.o...@yahoo.com; users@global.libreoffice.org users@global.libreoffice.org Sent: Thursday, October 11, 2012 6:06 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi :) The copyright notice is on http://www.nseindia.com/copyright.htm and says Copyright Except as specifically permitted herein the Exchange is the owner of copyright in all information featured on this website and no portion of the information on this website may be reproduced on or transmitted to or stored in any other website or in other form of electronic retrieval system or by in any other form or by in any other means. Visitors or users may view, print copies in hard copy and download the information for personal, non-commercial or educational purpose without in any way amending, altering, deleting or modifying any part of the information and provided full acknowledgement that the information originated from NSE's website is given in the copy of the material. Contents may be displayed provided successful linking to, redirection to NSE's website is acknowledged. Information may be used for commercial purpose after obtaining prior permission of the Exchange. Visitors or users must inform third party that material may not be copied or reproduced in any way. So i think it's probably fine for you to use but just let people who access the charts know where the data is from. If you are going to use the the charts commercially then probably best to just let them know and ask permission. Who knows, they might want you to put your charts on their website! Not sure if they would pay you for it but if they do want your charts then definitely ask for a decent salary! If they want to do it themselves then perhaps neogtiate some sort of royalties. Goodl luck and regards from Tom :) From: Viral Orpe viral.o...@yahoo.com To: users@global.libreoffice.org users@global.libreoffice.org Sent: Thursday, 11 October 2012, 11:33 Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi Tom :) Yahoo screen-shot was used as an example since Yahoo is omnipresent. You are most probably right about the yahoo data but I don't think they give out any data - just charts with the limited options that are on offer - chart type , data range, and a bouquet of indicators. I take my data from the Exchange itself - The National Stock Exchange (NSE), India. And do my own calculations - in CALC - to extract some meaning out of it. http://www.nseindia.com/index_nse.htm Under the products tab one gets daily data called Bhav-copy (translates to Rate Sheet) Around 7 p.m. every evening they diligently load the day's activities in .csv (which I use) and .dbf (? database) format which I just download in case one day I use a DB. Some data is available only for the day and not for past days, that has to be collected and stored away before it gets overwritten the next day! I am worried that one day these exchanges will start asking for money for this or older data. For example, a few years ago I think I could not get the London Metal Exchange' historical data for Copper, and Gold prices - to get a glimpse of what happened when in the past. I am collecting my stock exchanges daily data ever since!! Thanks for the concern though, Much appreciated, Regards, Viral Orpe :) --- Processor : Intel(R
Re: [libreoffice-users] Fw: Help request on CALC charts' features
Hi :) Thanks for all the responses I have tried to respond collectively here. /* */ Miguel Ángel: About overlapping several charts --- I got similar idea but not overlapping in calc itself but using gimp. I came across gimp some time last week and it had some concept like layers. I have added a transparent layer and copied two charts - with same axis scales, ranges - on each layer. I am not very conversant with gimp though so right now I can only jump from one layer to another and see two charts one-by-one. My charts themselves have opaque background so transparency of layers is not helping. Still a work in progress, I must say. Will keep you posted once I get what I need - first in gimp and then in calc. Thanks a lot for your inputs. Dan: === About using Databases: - Thanks Dan, you are absolutely right about wondering why not databases?! I was thinking the best way to do what I do is using LAMP - particularly since I have to ultimately work on data that is 245 days/year, 12 years till now, 1000+ entries everyday, each entry has say 8-10 sub-entries and at least two such sets of data! (Equity, derivatives, Commodity) (365 - 52x2weekends - 16 holidays = 245 days/year!) But this is my first week with Linux! I can't possibly get into MySQL and hope to get it rightly done without crashing my system a thousand times. Right now, I have this one machine working. I hope to resurrect an old system and do all the LAMP/ sys-admin type of work (tweaking!) on it before moving the whole thing to a powerful machine. The calc charting is a short term solution before I get (and I hope I get it ultimately) the whole LAMP thing going. (I had been using MS XP and Excel for couple of years for this purpose, I can't believe my own madness/inertia/procrastination!) In fact I have noted your suggestion of linking the database files to calc and then making charts from it. That way I can use a database even before I get in to the A P of LAMP. Dan, rost52, Tom: = About Candlestick charts: Candlestick charting is a Japanese charting technique for stocks, commodities, currencies. One candlestick represents the Open-High-Low-Close values for a given interval. The interval can be anything from minutes to years but is constant for a chart. It is an excellent visual representation that is extremely quick to grasp. Inferences are made based on a single candle or multiple candles seen together. Further info: https://en.wikipedia.org/wiki/Candlestick_chart Check the various candlestick patterns and their interpretations. *** The Japanese have shown great imagination in naming the patterns! Just to check how a candle stick chart looks, please go to yahoo finance and look for a technical analysis/ charting link (mostly you can just click any chart you see: NASDAQ/ DAX etc). Choose Basic Tech Analysis under charts. Set the range to 6 months and select type as candle. I will try to find a way to get a real life example .ods or screen-shots on the net somewhere. Steve: The chartmaster software - was it open-source? May be I should search for similar charting software in open source domain. Unfortunately till now I have found myself to be we didn't start the fire types :P Someone, somewhere has always gone way ahead before me! In any case, if I find something open-source I can be sure of tweaking it (on my own machine) to my desire/ caliber/ patience! May be add a little but not reinvent! Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: Tom Davies tomdavie...@yahoo.co.uk To: users@global.libreoffice.org; rost52 bugquestcon...@online.de Sent: Wednesday, October 10, 2012 1:46 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi :) I assumed he meant a bar-graph but made it sound more interesting. Regards from Tom :) --- On Wed, 10/10/12, rost52 bugquestcon...@online.de wrote: From: rost52 bugquestcon...@online.de Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features To: users@global.libreoffice.org Date: Wednesday, 10 October, 2012, 2:32 Could you possibly post somewhere an example of a candle stick chart? On 2012-10-10 02:52, Viral Orpe wrote: Hi :) Thanks for your time and replies. I could stop fighting calc to show me the chart as a single worksheet! I was charting the stock market data (available in daily doses
Re: [libreoffice-users] Fw: Help request on CALC charts' features
Hi rost52 :) Yes, That's right. That is the one I am using. Problem is: I want to add some indicators on it too. Like say the average of the past 3 months - which will be a line chart. I have uploaded two screenshots (.png) of the file I am using on my facebook page. They are made public under the album Libre_CALC_Query I don't use fb often so if you find any trouble downloading them please do not fight with FB. Just let me know. In all probability it will be some mistake from my side. I might make it three screen-shots with one example from yahoo finance in a couple of hours. Got to move out of this chair now!!!:) Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: rost52 bugquestcon...@online.de To: users@global.libreoffice.org Sent: Wednesday, October 10, 2012 6:01 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Candlestick charts The wikipedia link was helpful. I think that what you want to use is called in Calc chart type stock. There are 4 different sub type shown. The second from left looks very much like the chart in the wiki link. On 10.10.2012 21:10, Viral Orpe wrote: Hi :) Thanks for all the responses I have tried to respond collectively here. /* */ Miguel Ángel: About overlapping several charts --- I got similar idea but not overlapping in calc itself but using gimp. I came across gimp some time last week and it had some concept like layers. I have added a transparent layer and copied two charts - with same axis scales, ranges - on each layer. I am not very conversant with gimp though so right now I can only jump from one layer to another and see two charts one-by-one. My charts themselves have opaque background so transparency of layers is not helping. Still a work in progress, I must say. Will keep you posted once I get what I need - first in gimp and then in calc. Thanks a lot for your inputs. Dan: === About using Databases: - Thanks Dan, you are absolutely right about wondering why not databases?! I was thinking the best way to do what I do is using LAMP - particularly since I have to ultimately work on data that is 245 days/year, 12 years till now, 1000+ entries everyday, each entry has say 8-10 sub-entries and at least two such sets of data! (Equity, derivatives, Commodity) (365 - 52x2weekends - 16 holidays = 245 days/year!) But this is my first week with Linux! I can't possibly get into MySQL and hope to get it rightly done without crashing my system a thousand times. Right now, I have this one machine working. I hope to resurrect an old system and do all the LAMP/ sys-admin type of work (tweaking!) on it before moving the whole thing to a powerful machine. The calc charting is a short term solution before I get (and I hope I get it ultimately) the whole LAMP thing going. (I had been using MS XP and Excel for couple of years for this purpose, I can't believe my own madness/inertia/procrastination!) In fact I have noted your suggestion of linking the database files to calc and then making charts from it. That way I can use a database even before I get in to the A P of LAMP. Dan, rost52, Tom: = About Candlestick charts: Candlestick charting is a Japanese charting technique for stocks, commodities, currencies. One candlestick represents the Open-High-Low-Close values for a given interval. The interval can be anything from minutes to years but is constant for a chart. It is an excellent visual representation that is extremely quick to grasp. Inferences are made based on a single candle or multiple candles seen together. Further info: https://en.wikipedia.org/wiki/Candlestick_chart Check the various candlestick patterns and their interpretations. *** The Japanese have shown great imagination in naming the patterns! Just to check how a candle stick chart looks, please go to yahoo finance and look for a technical analysis/ charting link (mostly you can just click any chart you see: NASDAQ/ DAX etc). Choose Basic Tech Analysis under charts. Set the range to 6 months and select type as candle. I will try to find a way to get a real life example .ods or screen-shots on the net somewhere. Steve: The chartmaster software - was it open-source? May be I should search for similar charting software in open source domain. Unfortunately till now I have
Re: [libreoffice-users] Fw: Help request on CALC charts' features
Hi :) I have added the Yahoo finance image illustrating the overlap of the basic candlestick chart and line chart and bar chart to my facebook page. Album: LibreCALC_Query File: z.png Hope that clarifies. Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: Viral Orpe viral.o...@yahoo.com To: users@global.libreoffice.org users@global.libreoffice.org Sent: Wednesday, October 10, 2012 6:29 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi rost52 :) Yes, That's right. That is the one I am using. Problem is: I want to add some indicators on it too. Like say the average of the past 3 months - which will be a line chart. I have uploaded two screenshots (.png) of the file I am using on my facebook page. They are made public under the album Libre_CALC_Query I don't use fb often so if you find any trouble downloading them please do not fight with FB. Just let me know. In all probability it will be some mistake from my side. I might make it three screen-shots with one example from yahoo finance in a couple of hours. Got to move out of this chair now!!!:) Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: rost52 bugquestcon...@online.de To: users@global.libreoffice.org Sent: Wednesday, October 10, 2012 6:01 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Candlestick charts The wikipedia link was helpful. I think that what you want to use is called in Calc chart type stock. There are 4 different sub type shown. The second from left looks very much like the chart in the wiki link. On 10.10.2012 21:10, Viral Orpe wrote: Hi :) Thanks for all the responses I have tried to respond collectively here. /* */ Miguel Ángel: About overlapping several charts --- I got similar idea but not overlapping in calc itself but using gimp. I came across gimp some time last week and it had some concept like layers. I have added a transparent layer and copied two charts - with same axis scales, ranges - on each layer. I am not very conversant with gimp though so right now I can only jump from one layer to another and see two charts one-by-one. My charts themselves have opaque background so transparency of layers is not helping. Still a work in progress, I must say. Will keep you posted once I get what I need - first in gimp and then in calc. Thanks a lot for your inputs. Dan: === About using Databases: - Thanks Dan, you are absolutely right about wondering why not databases?! I was thinking the best way to do what I do is using LAMP - particularly since I have to ultimately work on data that is 245 days/year, 12 years till now, 1000+ entries everyday, each entry has say 8-10 sub-entries and at least two such sets of data! (Equity, derivatives, Commodity) (365 - 52x2weekends - 16 holidays = 245 days/year!) But this is my first week with Linux! I can't possibly get into MySQL and hope to get it rightly done without crashing my system a thousand times. Right now, I have this one machine working. I hope to resurrect an old system and do all the LAMP/ sys-admin type of work (tweaking!) on it before moving the whole thing to a powerful machine. The calc charting is a short term solution before I get (and I hope I get it ultimately) the whole LAMP thing going. (I had been using MS XP and Excel for couple of years for this purpose, I can't believe my own madness/inertia/procrastination!) In fact I have noted your suggestion of linking the database files to calc and then making charts from it. That way I can use a database even before I get in to the A P of LAMP. Dan, rost52, Tom: = About Candlestick charts: Candlestick charting is a Japanese charting technique for stocks, commodities, currencies. One candlestick represents the Open-High-Low-Close values for a given interval. The interval can be anything from minutes to years but is constant for a chart
Re: [libreoffice-users] Fw: Help request on CALC charts' features
Hi :) I was able to overlap two charts in gimp as well as calc. Hurrraa :) * Adjusted axis on both charts - major, minor ticks to match each other. * Scales (rather everything) Automatic is unmarked - in case we need to scale data ranges later. * Made the top one completely transparent before moving on top of first. In gimp one can be sure that they don't slide - ever. Not sure if there is a facility for that in calc - don't really expect. Just pinging in case anyone has any ideas. Objects once placed may move - e.g. one justified left other to center etc. - on their own with some remote change elsewhere in the sheet. The charts are now 100 times more helpful. No kidding! Thanks a lot to everybody who chipped in with their suggestions. Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: Viral Orpe viral.o...@yahoo.com To: users@global.libreoffice.org users@global.libreoffice.org Sent: Wednesday, October 10, 2012 9:18 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi :) I have added the Yahoo finance image illustrating the overlap of the basic candlestick chart and line chart and bar chart to my facebook page. Album: LibreCALC_Query File: z.png Hope that clarifies. Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: Viral Orpe viral.o...@yahoo.com To: users@global.libreoffice.org users@global.libreoffice.org Sent: Wednesday, October 10, 2012 6:29 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi rost52 :) Yes, That's right. That is the one I am using. Problem is: I want to add some indicators on it too. Like say the average of the past 3 months - which will be a line chart. I have uploaded two screenshots (.png) of the file I am using on my facebook page. They are made public under the album Libre_CALC_Query I don't use fb often so if you find any trouble downloading them please do not fight with FB. Just let me know. In all probability it will be some mistake from my side. I might make it three screen-shots with one example from yahoo finance in a couple of hours. Got to move out of this chair now!!!:) Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: rost52 bugquestcon...@online.de To: users@global.libreoffice.org Sent: Wednesday, October 10, 2012 6:01 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Candlestick charts The wikipedia link was helpful. I think that what you want to use is called in Calc chart type stock. There are 4 different sub type shown. The second from left looks very much like the chart in the wiki link. On 10.10.2012 21:10, Viral Orpe wrote: Hi :) Thanks for all the responses I have tried to respond collectively here. /* */ Miguel Ángel: About overlapping several charts --- I got similar idea but not overlapping in calc itself but using gimp. I came across gimp some time last week and it had some concept like layers. I have added a transparent layer and copied two charts - with same axis scales, ranges - on each layer. I am not very conversant with gimp though so right now I can only jump from one layer to another and see two charts one-by-one. My charts themselves have opaque background so transparency of layers is not helping. Still a work in progress, I must say. Will keep you posted once I get what I need - first in gimp and then in calc. Thanks a lot for your inputs. Dan: === About using Databases: - Thanks Dan, you are absolutely right about wondering why not databases?! I was thinking the best way to do
Re: [libreoffice-users] Fw: Help request on CALC charts' features
Hi :) Thanks for your time and replies. I could stop fighting calc to show me the chart as a single worksheet! I was charting the stock market data (available in daily doses to be bunched neatly in weekly, monthly, quarterly, yearly batches) in candlestick form. Both Excel and Calc do not allow any other lines on the candlestick charts (moving averages, e.g.). It robs the ease of analysis (and make me dependent on some websites that offer it - currently for free :) but I never liked the dependence) I read somewhere* what Shakespeare wrote of vaulting ambition :) Since, I have no spur to prick my intent, as of today I can't start vaulting onto tweaking CALC source code to add a new chart type. But, it would be fun and a taste + test of the Linux promise of free(dom)! Hope I reach the promised land one day. Any pointers are welcome. again, thanks for your time, regards, Viral Orpe p.s. *Vaulting Ambition :) http://www.shakespeare-online.com/plays/macbeth/soliloquies/blow.html (spur: I know just C, data structures, and presently am learning shell scripting. Nothing about Linux kernel/ internals and have never written software in a professional team) snip -- For unsubscribe instructions e-mail to: users+h...@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] Fw: Help request on CALC charts' features
The following mail was sent about 10-days ago. I picked the address from the e-mails I receive from other list-members. Even I did not get it back through the list nor was it bounced from somewhere hence sending again. This is the last time. Sorry for the trouble. /* *** */ Hi, I am new to Open source *.* (OS, environment, office, Banshee, wvdial, the works) I recently moved my excel spread-sheets to calc. I am still going through files/features-check post the translation. Most of the data, formula, and formatting are okay, fonts are better. In the charts I observed: 1. The full worksheet as chart in excel are converted to embedded charts in those sheets (no full charts). 2. Legends are peculiar. They are named as column? and not any text string that I would like to give. Is this the way Libre Calc is implemented or I can get back to chart as worksheet in itself and legends of my liking without being restricted to the first column/ first row? Also, is the system info below sufficient for posting here or anything more is advised? Any pointers would be great help. Thanks, Viral Orpe -- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory: 4GB, DDR3 Operating System: Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice Version : LibreOffice 3.4.3 OOO340m1 (Build:302) -- For unsubscribe instructions e-mail to: users+h...@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] Help request on CALC charts' features
Hi, I am new to Open source *.* (OS, environment, office, Banshee, wvdial, the works) I recently moved my excel spread-sheets to calc. I am still going through files/features-check post the translation. Most of the data, formula, and formatting are okay, fonts are better. In the charts I observed: 1. The full worksheet as chart in excel are converted to embedded charts in those sheets (no full charts). 2. Legends are peculiar. They are named as column? and not any text string that I would like to give. Is this the way Libre Calc is implemented or I can get back to chart as worksheet in itself and legends of my liking without being restricted to the first column/ first row? Also, is the system info below sufficient for posting here or anything more is advised? Any pointers would be great help. Thanks, Viral Orpe -- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory: 4GB, DDR3 Operating System: Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice Version : LibreOffice 3.4.3 OOO340m1 (Build:302) -- For unsubscribe instructions e-mail to: users+h...@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
