Re: [libreoffice-users] import from HTML
On 11/12/2011, jef peeraer wrote: > On 12/10/2011 05:54 PM, e-letter wrote: >> On 10/12/2011, jef peeraer wrote: >>> i have a website that generates reports in HTML. it contains nice >> Not able to generate a csv report? Assuming you are importing into a spreadsheet to perform data manipulation, why is pretty formatting necessary? >>> tables, with headers andso. in another spreadsheet program, i can just >>> ctrl-a, ctrl-c and then ctrl-v, all tables are nicely imported, even the >>> markup is converted to the spreadsheet. >>> Can i do this with LO ? >>> What is stopping you to continue using the other spreadsheet? >> >> Have you tried yet??? Then tell us the results! > well, i can't use Insert > Link to External Data, because i don't hace > an URL of that generated report. >> What is wrong with the function 'paste special' and the option 'as html' in the dialogue window? -- 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] Re: Mail Merge Crashes
Hi :) Could this be a java issue? Which version of java are you using? Tools - Options - Java It is possible to have more than 1 version of java installed alongside each other. Version 6u21 seems to be the best one for LibreOffice but web-browsers and things need the most recent version you can reasonably get. So, having 2 versions makes sense. It might well be soem other problem with mail-merge tho. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Mail-Merge-Crashes-tp3577418p3578194.html Sent from the Users mailing list archive at Nabble.com. -- 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] Mail Merge Crashes
Hi, I'm running LibreOffice 3.4.4 on openSuse 11.3 (x86_64). I've created a docmument that I want to use for Mail Merging & have a connected to the database. If I use the Mail Merge tool, in preview I can see all the correct entries. However when I try to save or print the document, LibreOffice crashes and there is no error message displayed. On restarting, the document is intact, so I've not lost anything. Does anyone have any ideas as to what might be wrong/how I can fix this ? Thanks Paul -- 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] import from HTML
On 12/10/2011 05:54 PM, e-letter wrote: On 10/12/2011, jef peeraer wrote: i have a website that generates reports in HTML. it contains nice What version of html output? the copy/ special paste works ok, but i loose all special markup (like colors, etc..) it generates html tables, with headers and stuff. So it is not the latest HTML (5), just 4 i think tables, with headers andso. in another spreadsheet program, i can just ctrl-a, ctrl-c and then ctrl-v, all tables are nicely imported, even the markup is converted to the spreadsheet. Can i do this with LO ? Have you tried yet??? Then tell us the results! well, i can't use Insert > Link to External Data, because i don't hace an URL of that generated report. thanks for the help -- 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] Re: Changing data on a chart
lismurn wrote > > With regard to Jays solution, I need all the data on page 1 as I have > two different charts, the pie chart requires all data whereas the bar > chart only requires the data which I want to use. One of my problems > is that if I disregard the date rows from Dec 2008 to Dec 2009 I also > lose the column headings. > You just need to edit the Data Ranges in your charts. Replace with this for your first chart $'Dec 2011'.$A$18:$B$41;$'Dec 2011'.$B$3:$B$4;$'Dec 2011'.$H$3:$H$4;$'Dec 2011'.$H$18:$H$41 The problem is that you need to redefine the Range for Name in the Data Series tab. -- View this message in context: http://nabble.documentfoundation.org/Re-Changing-data-on-a-chart-tp3572779p3577223.html Sent from the Users mailing list archive at Nabble.com. -- 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: [SOLVED] Identifying the correct row in Spreadsheet formulas
2011/12/11 Ian Whitfield : > Hi All > > Thanks for all the help offered by the Group - It's very much appreciated!! > And with this help - although I never got an exact answer - I have been able > to solve it!! > > Basically my question could be broken down into three parts > > 1) How do I work out what ROW NUMBER a given unique value is on? > 2) How do I use this ROW NUMBER to make-up a valid CELL ADDRESS? > 3) How do I get the VALUE in that CELL ADDRESS? > > After a lot of trial and error - and with the pointers given to me by the > Group I was able to 'crack' it!! > > 1) For the ROW NUMBER I used MATCH. At first this did not give me what I > wanted as MATCH returns the ROW COUNT within a specified Array and NOT the > actual ROW NUMBER! Then it occurred to me that if I make the Array the whole > portion of the spreadsheet where the numbers are, starting at Row 1, and not > just there actual position of the values I wanted to check in then the ROW > COUNT returned by MATCH would in fact be the actual ROW NUMBER!! Or you could just use the original array and add what's missing, like ”=MATCH(Paramters)+Something” Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ > Problem > solved, so > > "=MATCH(Unique Number,Array)" > Where - 'Unique Number' is a value I put in a fixed cell so I use this Cell > address and the 'Array' is the whole section of the Spreadsheet where these > numbers are, (ie I have the numbers 1 to 12 in positions A7 to A18 so for > the Array I specify *A1*:A18 so that the ROW COUNT matches the ROW NUMBER). > > 2) For the CELL ADDRESS I have a cell that identifies each COLUMN that these > values resides in (ie all my TOTALS are in COLUMN H), and I now have the ROW > COUNT of the data I'm looking for. So I can use > > "=COLUMN ID & fixed ROW NUMBER" > > 3) The last step is to get the VALUE that is in the Cell at that location. > For this I used > > "=INDIRECT (CELL ADDRESS)" > > Perfect - PROBLEM SOLVED!! > > I can now change ONE VALUE in a cell (ie this month I'm working with > December figures so I enter "12" into the cell), and ALL my values change > automatically for that month. No more endless Cutting and Pasting!! > > Thanks again guys - I hope this explanation will be of interest to you and > maybe of use to other users trying to automate yearly figures to do monthly > analysis. > > Ian Whitfield. > > > -- > 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] Changing data on a chart
Hi John, I'm aware my answer was a little short, sorry. I've spent most of my time writing databases rather than using LO, which means I don't know about putting a chart on a base document, however the easy way (I'd guess) is to set up a spreadsheet that asks for and pulls the data required, and then you're back into familiar territory. Sorry, it's a pet peeve of mine, using a spreadsheet as a database. Don't mind me, just getting grumpy :-( Mark Stanton One small step for mankind... -- 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] Re: [SOLVED] Identifying the correct row in Spreadsheet formulas
Hi All Thanks for all the help offered by the Group - It's very much appreciated!! And with this help - although I never got an exact answer - I have been able to solve it!! Basically my question could be broken down into three parts 1) How do I work out what ROW NUMBER a given unique value is on? 2) How do I use this ROW NUMBER to make-up a valid CELL ADDRESS? 3) How do I get the VALUE in that CELL ADDRESS? After a lot of trial and error - and with the pointers given to me by the Group I was able to 'crack' it!! 1) For the ROW NUMBER I used MATCH. At first this did not give me what I wanted as MATCH returns the ROW COUNT within a specified Array and NOT the actual ROW NUMBER! Then it occurred to me that if I make the Array the whole portion of the spreadsheet where the numbers are, starting at Row 1, and not just there actual position of the values I wanted to check in then the ROW COUNT returned by MATCH would in fact be the actual ROW NUMBER!! Problem solved, so "=MATCH(Unique Number,Array)" Where - 'Unique Number' is a value I put in a fixed cell so I use this Cell address and the 'Array' is the whole section of the Spreadsheet where these numbers are, (ie I have the numbers 1 to 12 in positions A7 to A18 so for the Array I specify *A1*:A18 so that the ROW COUNT matches the ROW NUMBER). 2) For the CELL ADDRESS I have a cell that identifies each COLUMN that these values resides in (ie all my TOTALS are in COLUMN H), and I now have the ROW COUNT of the data I'm looking for. So I can use "=COLUMN ID & fixed ROW NUMBER" 3) The last step is to get the VALUE that is in the Cell at that location. For this I used "=INDIRECT (CELL ADDRESS)" Perfect - PROBLEM SOLVED!! I can now change ONE VALUE in a cell (ie this month I'm working with December figures so I enter "12" into the cell), and ALL my values change automatically for that month. No more endless Cutting and Pasting!! Thanks again guys - I hope this explanation will be of interest to you and maybe of use to other users trying to automate yearly figures to do monthly analysis. Ian Whitfield. -- 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