[users] Re: Images in OpenOffice.org Calc
Am 02.12.2010 17:07, Johnny Rosenberg wrote: Den 2010-12-01 19:51:00 skrev Andreas Säger ville...@t-online.de: Spreadsheets are not intended to do such things (hey, they name it Calc). Sorry, didn't think about that. So the next time I want to watch a movie with my COMPUTER, I'd better forget about it and buy a DVD instead, watching it with my DVD player connected to my TV. Or maybe I should go to the cinema instead. A computer should only be used for computing, right? Don't be foolish, please. Without DVD-capable player software and a set of adequate video codecs your computer can not play DVDs, let alone movie editing. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Images in OpenOffice.org Calc
Den 2010-12-04 12:26:43 skrev Andreas Säger ville...@t-online.de: Am 02.12.2010 17:07, Johnny Rosenberg wrote: Den 2010-12-01 19:51:00 skrev Andreas Säger ville...@t-online.de: Spreadsheets are not intended to do such things (hey, they name it Calc). Sorry, didn't think about that. So the next time I want to watch a movie with my COMPUTER, I'd better forget about it and buy a DVD instead, watching it with my DVD player connected to my TV. Or maybe I should go to the cinema instead. A computer should only be used for computing, right? Don't be foolish, please. Without DVD-capable player software and a set of adequate video codecs your computer can not play DVDs, let alone movie editing. There is external equipment for that too. Or was a couple of decades ago. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Images in OpenOffice.org Calc
On 02/12/2010 16:07, Johnny Rosenberg wrote: Den 2010-12-01 19:51:00 skrev Andreas Säger ville...@t-online.de: Spreadsheets are not intended to do such things (hey, they name it Calc). Sorry, didn't think about that. So the next time I want to watch a movie with my COMPUTER, I'd better forget about it and buy a DVD instead, watching it with my DVD player connected to my TV. Or maybe I should go to the cinema instead. A computer should only be used for computing, right? Or we could think that development is actually a good thing, in some aspects. Within limits. In this case, as someone High Up has decided that pictures are a good idea, IMO the facility should behave rationally and predictably. It doesn't, which is fair ground for complaint. -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Images in OpenOffice.org Calc
Den 2010-12-03 09:13:46 skrev Mike Scott m...@scottsonline.org.uk: On 02/12/2010 16:07, Johnny Rosenberg wrote: Den 2010-12-01 19:51:00 skrev Andreas Säger ville...@t-online.de: Spreadsheets are not intended to do such things (hey, they name it Calc). Sorry, didn't think about that. So the next time I want to watch a movie with my COMPUTER, I'd better forget about it and buy a DVD instead, watching it with my DVD player connected to my TV. Or maybe I should go to the cinema instead. A computer should only be used for computing, right? Or we could think that development is actually a good thing, in some aspects. Within limits. Unfortunately people always compare with Excel, and if OpenOffice.org Calc can't do something that Excel can, they are often unlikely to switch to OpenOffice.org. I am not sure if the focus should be on satisfying earlier Excel users or trying to develop unique (and good) stuff for OpenOffice.org, that Excel lacks, but what can be added that isn't there in OpenOffice.org Calc or MS Excel already? In this case, as someone High Up has decided that pictures are a good idea, IMO the facility should behave rationally and predictably. It doesn't, which is fair ground for complaint. And since I did (when writing a bug report), those who agree with me could vote for it and hopefully something nice could happen… :) -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Images in OpenOffice.org Calc
Den 2010-12-01 19:51:00 skrev Andreas Säger ville...@t-online.de: Spreadsheets are not intended to do such things (hey, they name it Calc). Sorry, didn't think about that. So the next time I want to watch a movie with my COMPUTER, I'd better forget about it and buy a DVD instead, watching it with my DVD player connected to my TV. Or maybe I should go to the cinema instead. A computer should only be used for computing, right? Or we could think that development is actually a good thing, in some aspects. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Images in OpenOffice.org Calc
Am 01.12.2010 17:06, Johnny Rosenberg wrote: No, only to a cell or a page. Remember this is OpenOffice.org Calc, not OpenOffice.org Writer. And by far more important: it is not OpenOffice.org Base where you can store things like catalog data (including pictures as cell values) and create catalogues by means of the Oracle Report Builder AddOn. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Images in OpenOffice.org Calc
Den 2010-12-01 18:45:14 skrev Andreas Säger ville...@t-online.de: Am 01.12.2010 17:06, Johnny Rosenberg wrote: No, only to a cell or a page. Remember this is OpenOffice.org Calc, not OpenOffice.org Writer. And by far more important: it is not OpenOffice.org Base where you can store things like catalog data (including pictures as cell values) and create catalogues by means of the Oracle Report Builder AddOn. Yes, but I am not used to OpenOffice.org Base. Still, no matter if there are better ways or not, I think this is a bug. Why anchor to a cell if the image won't follow sort? And, as far as I heard, Excel can do this… (but I can't use Excel since Excel lacks the most important feature: Multi operating system support). -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Images in OpenOffice.org Calc
Am 01.12.2010 19:11, Johnny Rosenberg wrote: Den 2010-12-01 18:45:14 skrev Andreas Säger ville...@t-online.de: Am 01.12.2010 17:06, Johnny Rosenberg wrote: No, only to a cell or a page. Remember this is OpenOffice.org Calc, not OpenOffice.org Writer. And by far more important: it is not OpenOffice.org Base where you can store things like catalog data (including pictures as cell values) and create catalogues by means of the Oracle Report Builder AddOn. Yes, but I am not used to OpenOffice.org Base. Still, no matter if there are better ways or not, I think this is a bug. Why anchor to a cell if the image won't follow sort? And, as far as I heard, Excel can do this… (but I can't use Excel since Excel lacks the most important feature: Multi operating system support). Well, that was a problem even with cell annotations until 2.3(?) where it has been fixed. This kind of problem seems to be very hard to fix for other shapes. Spreadsheets are not intended to do such things (hey, they name it Calc). Pictures are meant to be decorative or explanatory in respect to the sheet, not in respect to contained database data. Excel is the one and only spreadsheet program which encourages its users to misuse it as a database. Millions of users did even learn VBA to make this dream come true with devastating consequences for the overall busines IT. In the forum topic you linked in the issue report, there is another hyperlink to a hyperlink solution. Simply store a file name together with some descriptive name and compose a hyperlink by means of a formula. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Images in OpenOffice.org Calc
On 12/1/2010 1:11 PM, Johnny Rosenberg wrote: Why anchor to a cell if the image won't follow sort? And, as far as I heard, Excel can do this… (but I can't use Excel since Excel lacks the most important feature: Multi operating system support). Perhaps it is simply a matter of the cell staying put and the data contained therein is moved. Anchor an image to cell B6, then sort the sheet. Cell B6 is still B6. It may be as simple as that. Only the programmers know for sure maybe. -- Gene Young n2kvs - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Images in OpenOffice.org Calc
On 01/12/2010 18:51, Andreas Säger wrote: Am 01.12.2010 19:11, Johnny Rosenberg wrote: Den 2010-12-01 18:45:14 skrev Andreas Säger ville...@t-online.de: Am 01.12.2010 17:06, Johnny Rosenberg wrote: No, only to a cell or a page. Remember this is OpenOffice.org Calc, not OpenOffice.org Writer. And by far more important: it is not OpenOffice.org Base where you can store things like catalog data (including pictures as cell values) and create catalogues by means of the Oracle Report Builder AddOn. Yes, but I am not used to OpenOffice.org Base. Still, no matter if there are better ways or not, I think this is a bug. Why anchor to a cell if the image won't follow sort? And, as far as I heard, Excel can do this… (but I can't use Excel since Excel lacks the most important feature: Multi operating system support). Well, that was a problem even with cell annotations until 2.3(?) where it has been fixed. This kind of problem seems to be very hard to fix for other shapes. Spreadsheets are not intended to do such things (hey, they name it Calc). Pictures are meant to be decorative or explanatory in respect to the sheet, not in respect to contained database data. Excel is the one and only spreadsheet program which encourages its users to misuse it as a database. Millions of users did even learn VBA to make this dream come true with devastating consequences for the overall busines IT. In the forum topic you linked in the issue report, there is another hyperlink to a hyperlink solution. Simply store a file name together with some descriptive name and compose a hyperlink by means of a formula. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Johnny I assume from what you are saying that the text and the picture are in the same cell. Am I correct? what happens if you put the text in one cell and the picture in the next cell in the same row and then sort on both columns? Does it move then? Sorry if this is a dumb question Rob - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Images in OpenOffice.org Calc
Den 2010-12-01 20:50:20 skrev Rob Clement r...@robbev.com: On 01/12/2010 18:51, Andreas Säger wrote: Am 01.12.2010 19:11, Johnny Rosenberg wrote: Den 2010-12-01 18:45:14 skrev Andreas Säger ville...@t-online.de: Am 01.12.2010 17:06, Johnny Rosenberg wrote: No, only to a cell or a page. Remember this is OpenOffice.org Calc, not OpenOffice.org Writer. And by far more important: it is not OpenOffice.org Base where you can store things like catalog data (including pictures as cell values) and create catalogues by means of the Oracle Report Builder AddOn. Yes, but I am not used to OpenOffice.org Base. Still, no matter if there are better ways or not, I think this is a bug. Why anchor to a cell if the image won't follow sort? And, as far as I heard, Excel can do this… (but I can't use Excel since Excel lacks the most important feature: Multi operating system support). Well, that was a problem even with cell annotations until 2.3(?) where it has been fixed. This kind of problem seems to be very hard to fix for other shapes. Spreadsheets are not intended to do such things (hey, they name it Calc). Pictures are meant to be decorative or explanatory in respect to the sheet, not in respect to contained database data. Excel is the one and only spreadsheet program which encourages its users to misuse it as a database. Millions of users did even learn VBA to make this dream come true with devastating consequences for the overall busines IT. In the forum topic you linked in the issue report, there is another hyperlink to a hyperlink solution. Simply store a file name together with some descriptive name and compose a hyperlink by means of a formula. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Johnny I assume from what you are saying that the text and the picture are in the same cell. Am I correct? what happens if you put the text in one cell and the picture in the next cell in the same row and then sort on both columns? Does it move then? That was what I did. There is no text in the cell where I put the Image. Sorry if this is a dumb question Not at all. Rob - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Images in OpenOffice.org Calc
On 01/12/2010 19:44, Gene Young wrote: On 12/1/2010 1:11 PM, Johnny Rosenberg wrote: Why anchor to a cell if the image won't follow sort? And, as far as I heard, Excel can do this… (but I can't use Excel since Excel lacks the most important feature: Multi operating system support). Perhaps it is simply a matter of the cell staying put and the data contained therein is moved. Anchor an image to cell B6, then sort the sheet. Cell B6 is still B6. It may be as simple as that. Except that if you anchor a picture to a cell, then insert a row above, the picture moves down alaong with the cell and its other contents. Inconsistent behaviour however you look at it. Only the programmers know for sure maybe. You reckon? -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org