You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Martin Hediger <ma...@bluewin.ch> on 2011/11/02 09:58:06 UTC
Question Replace Path in Calc
Dear List
I maintain a little database about some results from published
experiments in a calc spreadsheet. To be able to conveniently view the
publication reporting a specific experimental value, I included links to
PDFs on my local machine, such that I can just hit the link and open the
PDF if I need to recall some details about an experimental value.
Something like this:
Energy Name PDF
3.141 C3PO /Users/me/data/c3po.pdf
2.718 R2D2 /Users/me/data/r2d2.pdf
[...]
Now, I had to adjust the directory structure, and so the links are not
exactly correct anymore. The path would now be /Users/me/project/data/*pdf.
How can I adjust the links to this new path? I tried "Spelling, F7", but
it only gives suggestions for the Names, not the links.
Any suggestions are appreciated.
Martin
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Question Replace Path in Calc
Posted by Martin Hediger <ma...@bluewin.ch>.
Thanks for the further suggestion.
Martin
Am 02.11.11 13:39, schrieb Rob Weir:
> On Wed, Nov 2, 2011 at 5:59 AM, Terry<te...@yahoo.com.au> wrote:
>> Use the Find and Replace tool. If you do not have a toolbar icon, it is in the menu 'Edit' (Ctrl + F).
>>
>> When the dialogue opens, press the button on the bottom left labelled "More Options." Make sure it says to search in 'Formulae' (an anachronism meaning formulas). Enter the wording you want to replace under "Search for" and enter the new wording under "Replace with."
>>
> That's a good solution. Another approach is to use Calc's text
> functions to calculate the new path. This can work for more
> complicated examples.
>
> http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Text_functions
>
> LEFT(), RIGHT(), REPLACE(), FIND(), SEARCH(), CONCATENATE() are useful for this.
>
> -rob
>
>> Regards.
>>
>> ----- Original Message -----
>>> From: Martin Hediger<ma...@bluewin.ch>
>>> To: ooo-users@incubator.apache.org
>>> Cc:
>>> Sent: Wednesday, 2 November 2011 7:58 PM
>>> Subject: Question Replace Path in Calc
>>>
>>> Dear List
>>> I maintain a little database about some results from published experiments in a
>>> calc spreadsheet. To be able to conveniently view the publication reporting a
>>> specific experimental value, I included links to PDFs on my local machine, such
>>> that I can just hit the link and open the PDF if I need to recall some details
>>> about an experimental value. Something like this:
>>>
>>> Energy Name PDF
>>> 3.141 C3PO /Users/me/data/c3po.pdf
>>> 2.718 R2D2 /Users/me/data/r2d2.pdf
>>> [...]
>>>
>>>
>>>
>>> Now, I had to adjust the directory structure, and so the links are not exactly
>>> correct anymore. The path would now be /Users/me/project/data/*pdf.
>>> How can I adjust the links to this new path? I tried "Spelling, F7",
>>> but it only gives suggestions for the Names, not the links.
>>>
>>> Any suggestions are appreciated.
>>>
>>> Martin
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>
>>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Question Replace Path in Calc
Posted by Terry <te...@yahoo.com.au>.
I have replaced part of a formula (using search and replace) just now and it is still a working formula. If you wish, send me a copy of part of your file and I will run the function on it.
Terry
----- Original Message -----
> From: Martin Hediger <ma...@bluewin.ch>
> To: ooo-users@incubator.apache.org
> Cc:
> Sent: Thursday, 3 November 2011 10:10 PM
> Subject: Re: Question Replace Path in Calc
>
> No, I'm only searching for 'data' and replacing with
> 'project/data'
> Thanks a lot for the efforts.
> Martin
>
>
> Am 03.11.11 12:07, schrieb Terry:
>
>> Are you searching for '/Users/me/data/' and replacing it with '
> /Users/me/project/data/'?
>>
>> I will try the process in a test file.
>>
>> Terry
>>
>>
>>
>> ----- Original Message -----
>>> From: Martin Hediger<ma...@bluewin.ch>
>>> To: ooo-users@incubator.apache.org
>>> Cc:
>>> Sent: Thursday, 3 November 2011 9:52 PM
>>> Subject: Re: Question Replace Path in Calc
>>>
>>> Hallo
>>> I was using the search& replace dialog and set "search in
>>> Formulae".
>>> However, when I replace a "link", it becomes a string, and so
> no
>>> longer
>>> clickable. Then my file does not open. How can I keep it a link to a
> file?
>>>
>>> Thanks for any hints.
>>>
>>>
>>>
>>>
>>> Am 02.11.11 13:39, schrieb Rob Weir:
>>>> On Wed, Nov 2, 2011 at 5:59 AM,
> Terry<te...@yahoo.com.au>
>>> wrote:
>>>>> Use the Find and Replace tool. If you do not have a toolbar
> icon, it
>>> is in the menu 'Edit' (Ctrl + F).
>>>>> When the dialogue opens, press the button on the bottom left
> labelled
>>> "More Options." Make sure it says to search in
> 'Formulae' (an
>>> anachronism meaning formulas). Enter the wording you want to replace
> under
>>> "Search for" and enter the new wording under "Replace
> with."
>>>> That's a good solution. Another approach is to use
> Calc's text
>>>> functions to calculate the new path. This can work for more
>>>> complicated examples.
>>>>
>>>>
>>>
> http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Text_functions
>>>> LEFT(), RIGHT(), REPLACE(), FIND(), SEARCH(), CONCATENATE() are
> useful for
>>> this.
>>>> -rob
>>>>
>>>>> Regards.
>>>>>
>>>>> ----- Original Message -----
>>>>>> From: Martin Hediger<ma...@bluewin.ch>
>>>>>> To: ooo-users@incubator.apache.org
>>>>>> Cc:
>>>>>> Sent: Wednesday, 2 November 2011 7:58 PM
>>>>>> Subject: Question Replace Path in Calc
>>>>>>
>>>>>> Dear List
>>>>>> I maintain a little database about some results from
> published
>>> experiments in a
>>>>>> calc spreadsheet. To be able to conveniently view the
> publication
>>> reporting a
>>>>>> specific experimental value, I included links to PDFs on
> my local
>>> machine, such
>>>>>> that I can just hit the link and open the PDF if I need
> to recall
>>> some details
>>>>>> about an experimental value. Something like this:
>>>>>>
>>>>>> Energy Name PDF
>>>>>> 3.141 C3PO /Users/me/data/c3po.pdf
>>>>>> 2.718 R2D2 /Users/me/data/r2d2.pdf
>>>>>> [...]
>>>>>>
>>>>>>
>>>>>>
>>>>>> Now, I had to adjust the directory structure, and so the
> links are
>>> not exactly
>>>>>> correct anymore. The path would now be
> /Users/me/project/data/*pdf.
>>>>>> How can I adjust the links to this new path? I tried
>>> "Spelling, F7",
>>>>>> but it only gives suggestions for the Names, not the
> links.
>>>>>>
>>>>>> Any suggestions are appreciated.
>>>>>>
>>>>>> Martin
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Question Replace Path in Calc
Posted by Martin Hediger <ma...@bluewin.ch>.
No, I'm only searching for 'data' and replacing with 'project/data'
Thanks a lot for the efforts.
Martin
Am 03.11.11 12:07, schrieb Terry:
> Are you searching for '/Users/me/data/' and replacing it with ' /Users/me/project/data/'?
>
> I will try the process in a test file.
>
> Terry
>
>
>
> ----- Original Message -----
>> From: Martin Hediger<ma...@bluewin.ch>
>> To: ooo-users@incubator.apache.org
>> Cc:
>> Sent: Thursday, 3 November 2011 9:52 PM
>> Subject: Re: Question Replace Path in Calc
>>
>> Hallo
>> I was using the search& replace dialog and set "search in
>> Formulae".
>> However, when I replace a "link", it becomes a string, and so no
>> longer
>> clickable. Then my file does not open. How can I keep it a link to a file?
>>
>> Thanks for any hints.
>>
>>
>>
>>
>> Am 02.11.11 13:39, schrieb Rob Weir:
>>> On Wed, Nov 2, 2011 at 5:59 AM, Terry<te...@yahoo.com.au>
>> wrote:
>>>> Use the Find and Replace tool. If you do not have a toolbar icon, it
>> is in the menu 'Edit' (Ctrl + F).
>>>> When the dialogue opens, press the button on the bottom left labelled
>> "More Options." Make sure it says to search in 'Formulae' (an
>> anachronism meaning formulas). Enter the wording you want to replace under
>> "Search for" and enter the new wording under "Replace with."
>>> That's a good solution. Another approach is to use Calc's text
>>> functions to calculate the new path. This can work for more
>>> complicated examples.
>>>
>>>
>> http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Text_functions
>>> LEFT(), RIGHT(), REPLACE(), FIND(), SEARCH(), CONCATENATE() are useful for
>> this.
>>> -rob
>>>
>>>> Regards.
>>>>
>>>> ----- Original Message -----
>>>>> From: Martin Hediger<ma...@bluewin.ch>
>>>>> To: ooo-users@incubator.apache.org
>>>>> Cc:
>>>>> Sent: Wednesday, 2 November 2011 7:58 PM
>>>>> Subject: Question Replace Path in Calc
>>>>>
>>>>> Dear List
>>>>> I maintain a little database about some results from published
>> experiments in a
>>>>> calc spreadsheet. To be able to conveniently view the publication
>> reporting a
>>>>> specific experimental value, I included links to PDFs on my local
>> machine, such
>>>>> that I can just hit the link and open the PDF if I need to recall
>> some details
>>>>> about an experimental value. Something like this:
>>>>>
>>>>> Energy Name PDF
>>>>> 3.141 C3PO /Users/me/data/c3po.pdf
>>>>> 2.718 R2D2 /Users/me/data/r2d2.pdf
>>>>> [...]
>>>>>
>>>>>
>>>>>
>>>>> Now, I had to adjust the directory structure, and so the links are
>> not exactly
>>>>> correct anymore. The path would now be /Users/me/project/data/*pdf.
>>>>> How can I adjust the links to this new path? I tried
>> "Spelling, F7",
>>>>> but it only gives suggestions for the Names, not the links.
>>>>>
>>>>> Any suggestions are appreciated.
>>>>>
>>>>> Martin
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Question Replace Path in Calc
Posted by Terry <te...@yahoo.com.au>.
Are you searching for '/Users/me/data/' and replacing it with ' /Users/me/project/data/'?
I will try the process in a test file.
Terry
----- Original Message -----
> From: Martin Hediger <ma...@bluewin.ch>
> To: ooo-users@incubator.apache.org
> Cc:
> Sent: Thursday, 3 November 2011 9:52 PM
> Subject: Re: Question Replace Path in Calc
>
> Hallo
> I was using the search & replace dialog and set "search in
> Formulae".
> However, when I replace a "link", it becomes a string, and so no
> longer
> clickable. Then my file does not open. How can I keep it a link to a file?
>
> Thanks for any hints.
>
>
>
>
> Am 02.11.11 13:39, schrieb Rob Weir:
>> On Wed, Nov 2, 2011 at 5:59 AM, Terry<te...@yahoo.com.au>
> wrote:
>>> Use the Find and Replace tool. If you do not have a toolbar icon, it
> is in the menu 'Edit' (Ctrl + F).
>>>
>>> When the dialogue opens, press the button on the bottom left labelled
> "More Options." Make sure it says to search in 'Formulae' (an
> anachronism meaning formulas). Enter the wording you want to replace under
> "Search for" and enter the new wording under "Replace with."
>>>
>> That's a good solution. Another approach is to use Calc's text
>> functions to calculate the new path. This can work for more
>> complicated examples.
>>
>>
> http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Text_functions
>>
>> LEFT(), RIGHT(), REPLACE(), FIND(), SEARCH(), CONCATENATE() are useful for
> this.
>>
>> -rob
>>
>>> Regards.
>>>
>>> ----- Original Message -----
>>>> From: Martin Hediger<ma...@bluewin.ch>
>>>> To: ooo-users@incubator.apache.org
>>>> Cc:
>>>> Sent: Wednesday, 2 November 2011 7:58 PM
>>>> Subject: Question Replace Path in Calc
>>>>
>>>> Dear List
>>>> I maintain a little database about some results from published
> experiments in a
>>>> calc spreadsheet. To be able to conveniently view the publication
> reporting a
>>>> specific experimental value, I included links to PDFs on my local
> machine, such
>>>> that I can just hit the link and open the PDF if I need to recall
> some details
>>>> about an experimental value. Something like this:
>>>>
>>>> Energy Name PDF
>>>> 3.141 C3PO /Users/me/data/c3po.pdf
>>>> 2.718 R2D2 /Users/me/data/r2d2.pdf
>>>> [...]
>>>>
>>>>
>>>>
>>>> Now, I had to adjust the directory structure, and so the links are
> not exactly
>>>> correct anymore. The path would now be /Users/me/project/data/*pdf.
>>>> How can I adjust the links to this new path? I tried
> "Spelling, F7",
>>>> but it only gives suggestions for the Names, not the links.
>>>>
>>>> Any suggestions are appreciated.
>>>>
>>>> Martin
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Question Replace Path in Calc
Posted by Martin Hediger <ma...@bluewin.ch>.
Hallo
I was using the search & replace dialog and set "search in Formulae".
However, when I replace a "link", it becomes a string, and so no longer
clickable. Then my file does not open. How can I keep it a link to a file?
Thanks for any hints.
Am 02.11.11 13:39, schrieb Rob Weir:
> On Wed, Nov 2, 2011 at 5:59 AM, Terry<te...@yahoo.com.au> wrote:
>> Use the Find and Replace tool. If you do not have a toolbar icon, it is in the menu 'Edit' (Ctrl + F).
>>
>> When the dialogue opens, press the button on the bottom left labelled "More Options." Make sure it says to search in 'Formulae' (an anachronism meaning formulas). Enter the wording you want to replace under "Search for" and enter the new wording under "Replace with."
>>
> That's a good solution. Another approach is to use Calc's text
> functions to calculate the new path. This can work for more
> complicated examples.
>
> http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Text_functions
>
> LEFT(), RIGHT(), REPLACE(), FIND(), SEARCH(), CONCATENATE() are useful for this.
>
> -rob
>
>> Regards.
>>
>> ----- Original Message -----
>>> From: Martin Hediger<ma...@bluewin.ch>
>>> To: ooo-users@incubator.apache.org
>>> Cc:
>>> Sent: Wednesday, 2 November 2011 7:58 PM
>>> Subject: Question Replace Path in Calc
>>>
>>> Dear List
>>> I maintain a little database about some results from published experiments in a
>>> calc spreadsheet. To be able to conveniently view the publication reporting a
>>> specific experimental value, I included links to PDFs on my local machine, such
>>> that I can just hit the link and open the PDF if I need to recall some details
>>> about an experimental value. Something like this:
>>>
>>> Energy Name PDF
>>> 3.141 C3PO /Users/me/data/c3po.pdf
>>> 2.718 R2D2 /Users/me/data/r2d2.pdf
>>> [...]
>>>
>>>
>>>
>>> Now, I had to adjust the directory structure, and so the links are not exactly
>>> correct anymore. The path would now be /Users/me/project/data/*pdf.
>>> How can I adjust the links to this new path? I tried "Spelling, F7",
>>> but it only gives suggestions for the Names, not the links.
>>>
>>> Any suggestions are appreciated.
>>>
>>> Martin
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Export as PDF
Posted by Christoph Jopp <jo...@gmx.de>.
Am 14.11.2011 15:55, schrieb Martin Hediger:
> Yes, but there are separate radio buttions for "Selection" and "Pages"
> in the "Export as PDF" dialog, so there has to be a difference between
> them.
>
If you have (for instance) a star, a circle and a rectangle on a page
and select the star and the rectangle, only these two are on the
exported page with the "Selection" option.
>
>
>
> Am 14.11.11 14:35, schrieb floris v:
>> That depends, perhaps, on the selection - imagine you want to export
>> part of a manuscript for a book to PDF so you select 100 pages and
>> export the selection. In that case the default A4 page size won't
>> hurt. But for what you want to do it's woefully inadequate.
>> By the way, there's a thriving community forum at
>> http://user.services.openoffice.org/ where your question will get much
>> more attention than on any mailing list.
>> peter aka floris v
>>
>> Op 14-11-2011 14:29, Martin Hediger schreef:
>>> I guess we agree on that. However, then I dont quite understand what
>>> the "selection" option is useful for. Or am I misinterpretating it?
>>>
>>>
>>>
>>>
>>> Am 14.11.11 13:33, schrieb floris v:
>>>> I see what you want, but that's impossible to implement in a way
>>>> that's useful for many people. Because - what's a narrow margin?
>>>> Nobody will probably agree on ideal values for margins, and so you
>>>> might, even if something like it were implemented, oftenR end up
>>>> with a PDF with margins that are either too wide or too narrow.
>>>>
>>>> Op 14-11-2011 13:11, Martin Hediger schreef:
>>>>> Yes, thats probably an option. What I was hoping for was a PDF
>>>>> where only the selected elements were present, possibly with some
>>>>> kind of small margin of white space. If I draw a 5cm square and
>>>>> export it to PDF because i want to include it as a graphics in
>>>>> LaTeX, its not very likely to find a paper format for exactly that
>>>>> shape, that's why I'm asking. At the moment, I need to reopen every
>>>>> drawing in Mac OS X Preview and manually cut/paste the selection to
>>>>> a new file. Doing it once is ok, but several times gets
>>>>> inconvenient, so I thought there's a smarter way of doing it.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Am 14.11.11 11:11, schrieb floris v:
>>>>>> Op 14-11-2011 10:33, Martin Hediger schreef:
>>>>>>> Dear List
>>>>>>> I wonder how I can export a selection from and .odg drawing to
>>>>>>> PDF. When I select a number of elements in the drawing, I choose
>>>>>>> File->Export as PDF, and in the following Dialog I check
>>>>>>> "Selection". However, I always end up with a DIN A4 page with the
>>>>>>> selected elements.
>>>>>>>
>>>>>>> Is there anything else required to get only the selected elements
>>>>>>> into the PDF?
>>>>>>>
>>>>>>> Thanks for any hints.
>>>>>>> Martin
>>>>>>>
>>>>>>> ---------------------------------------------------------------------
>>>>>>>
>>>>>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>>>>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>>>>>
>>>>>> What's the problem? Your selection gets converted to PDF with
>>>>>> otherwise default settings. If you want a different page size, you
>>>>>> may have to copy the selection to a blank document and set the
>>>>>> paper size and any other options to what you want before exporting.
>>>>>>
>>>>>> peter aka floris v
>>>>>>
>>>>>> ---------------------------------------------------------------------
>>>>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>>>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>>>
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>>
>>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Export as PDF
Posted by Martin Hediger <ma...@bluewin.ch>.
Yes, but there are separate radio buttions for "Selection" and "Pages"
in the "Export as PDF" dialog, so there has to be a difference between them.
Am 14.11.11 14:35, schrieb floris v:
> That depends, perhaps, on the selection - imagine you want to export
> part of a manuscript for a book to PDF so you select 100 pages and
> export the selection. In that case the default A4 page size won't
> hurt. But for what you want to do it's woefully inadequate.
> By the way, there's a thriving community forum at
> http://user.services.openoffice.org/ where your question will get much
> more attention than on any mailing list.
> peter aka floris v
>
> Op 14-11-2011 14:29, Martin Hediger schreef:
>> I guess we agree on that. However, then I dont quite understand what
>> the "selection" option is useful for. Or am I misinterpretating it?
>>
>>
>>
>>
>> Am 14.11.11 13:33, schrieb floris v:
>>> I see what you want, but that's impossible to implement in a way
>>> that's useful for many people. Because - what's a narrow margin?
>>> Nobody will probably agree on ideal values for margins, and so you
>>> might, even if something like it were implemented, oftenR end up
>>> with a PDF with margins that are either too wide or too narrow.
>>>
>>> Op 14-11-2011 13:11, Martin Hediger schreef:
>>>> Yes, thats probably an option. What I was hoping for was a PDF
>>>> where only the selected elements were present, possibly with some
>>>> kind of small margin of white space. If I draw a 5cm square and
>>>> export it to PDF because i want to include it as a graphics in
>>>> LaTeX, its not very likely to find a paper format for exactly that
>>>> shape, that's why I'm asking. At the moment, I need to reopen every
>>>> drawing in Mac OS X Preview and manually cut/paste the selection to
>>>> a new file. Doing it once is ok, but several times gets
>>>> inconvenient, so I thought there's a smarter way of doing it.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Am 14.11.11 11:11, schrieb floris v:
>>>>> Op 14-11-2011 10:33, Martin Hediger schreef:
>>>>>> Dear List
>>>>>> I wonder how I can export a selection from and .odg drawing to
>>>>>> PDF. When I select a number of elements in the drawing, I choose
>>>>>> File->Export as PDF, and in the following Dialog I check
>>>>>> "Selection". However, I always end up with a DIN A4 page with the
>>>>>> selected elements.
>>>>>>
>>>>>> Is there anything else required to get only the selected elements
>>>>>> into the PDF?
>>>>>>
>>>>>> Thanks for any hints.
>>>>>> Martin
>>>>>>
>>>>>> ---------------------------------------------------------------------
>>>>>>
>>>>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>>>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>>>>
>>>>> What's the problem? Your selection gets converted to PDF with
>>>>> otherwise default settings. If you want a different page size, you
>>>>> may have to copy the selection to a blank document and set the
>>>>> paper size and any other options to what you want before exporting.
>>>>>
>>>>> peter aka floris v
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>>>
>>>>>
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Make diagrams equal sized
Posted by Dave Babcock <ol...@rochester.rr.com>.
On 12/14/2011 5:19 AM, Martin Hediger wrote:
> Dear List
> I have a spreadsheet with a number of small line diagrams illustraint
> some sets of numbers. How can I make all diagrams appear the same?
> I.e. same x- and y-range. Also, the diagram has something like an
> "outer" boarder that can be adjusted by draging with the mouse, but
> also something like an "inner" boarder, which can be adjusted after
> double-clicking the diagram area. If the inner boarders are not equal
> with two diagrams, then the diagrams will not appear the same, even if
> the outer boarder is the same. How can I synchronize that?
>
> Thanks for any feedback.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
I don't know of any clever fixes. I do this every month, almost like
chasing cats at first.
IF you are referring to graphs, I haven't been able to apply
Find-and-Replace and that may apply to "line diagrams" also.
If the graphs are mostly the same, I've had some success with junking
all but one, teasing that one to just the size/shape/colors/line
width/etc I want, then duplicating it as needed, and re-establishing the
data ranges.
Then LOCK the Ht/Wth. Get the positions right (you may be lucky and can
use the Alignment menu for most of the work) and lock them.
This is important: do not Hide rows or columns that intersect the graph
area, and do not make any of those rows or columns greatly wider, even
briefly to see something better. The positions and SIZES are very
likely to change, and /not/ go back when you do Show. I'm pretty sure I
have seen this behavior even when everything is locked.
Good luck!
Ol' Bab
Make diagrams equal sized
Posted by Martin Hediger <ma...@bluewin.ch>.
Dear List
I have a spreadsheet with a number of small line diagrams illustraint
some sets of numbers. How can I make all diagrams appear the same? I.e.
same x- and y-range. Also, the diagram has something like an "outer"
boarder that can be adjusted by draging with the mouse, but also
something like an "inner" boarder, which can be adjusted after
double-clicking the diagram area. If the inner boarders are not equal
with two diagrams, then the diagrams will not appear the same, even if
the outer boarder is the same. How can I synchronize that?
Thanks for any feedback.
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Export as PDF
Posted by floris v <fl...@gmail.com>.
That depends, perhaps, on the selection - imagine you want to export
part of a manuscript for a book to PDF so you select 100 pages and
export the selection. In that case the default A4 page size won't hurt.
But for what you want to do it's woefully inadequate.
By the way, there's a thriving community forum at
http://user.services.openoffice.org/ where your question will get much
more attention than on any mailing list.
peter aka floris v
Op 14-11-2011 14:29, Martin Hediger schreef:
> I guess we agree on that. However, then I dont quite understand what
> the "selection" option is useful for. Or am I misinterpretating it?
>
>
>
>
> Am 14.11.11 13:33, schrieb floris v:
>> I see what you want, but that's impossible to implement in a way
>> that's useful for many people. Because - what's a narrow margin?
>> Nobody will probably agree on ideal values for margins, and so you
>> might, even if something like it were implemented, oftenR end up with
>> a PDF with margins that are either too wide or too narrow.
>>
>> Op 14-11-2011 13:11, Martin Hediger schreef:
>>> Yes, thats probably an option. What I was hoping for was a PDF where
>>> only the selected elements were present, possibly with some kind of
>>> small margin of white space. If I draw a 5cm square and export it to
>>> PDF because i want to include it as a graphics in LaTeX, its not
>>> very likely to find a paper format for exactly that shape, that's
>>> why I'm asking. At the moment, I need to reopen every drawing in Mac
>>> OS X Preview and manually cut/paste the selection to a new file.
>>> Doing it once is ok, but several times gets inconvenient, so I
>>> thought there's a smarter way of doing it.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> Am 14.11.11 11:11, schrieb floris v:
>>>> Op 14-11-2011 10:33, Martin Hediger schreef:
>>>>> Dear List
>>>>> I wonder how I can export a selection from and .odg drawing to
>>>>> PDF. When I select a number of elements in the drawing, I choose
>>>>> File->Export as PDF, and in the following Dialog I check
>>>>> "Selection". However, I always end up with a DIN A4 page with the
>>>>> selected elements.
>>>>>
>>>>> Is there anything else required to get only the selected elements
>>>>> into the PDF?
>>>>>
>>>>> Thanks for any hints.
>>>>> Martin
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>>>
>>>> What's the problem? Your selection gets converted to PDF with
>>>> otherwise default settings. If you want a different page size, you
>>>> may have to copy the selection to a blank document and set the
>>>> paper size and any other options to what you want before exporting.
>>>>
>>>> peter aka floris v
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>>
>>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Export as PDF
Posted by Martin Hediger <ma...@bluewin.ch>.
I guess we agree on that. However, then I dont quite understand what the
"selection" option is useful for. Or am I misinterpretating it?
Am 14.11.11 13:33, schrieb floris v:
> I see what you want, but that's impossible to implement in a way
> that's useful for many people. Because - what's a narrow margin?
> Nobody will probably agree on ideal values for margins, and so you
> might, even if something like it were implemented, often end up with a
> PDF with margins that are either too wide or too narrow.
>
> Op 14-11-2011 13:11, Martin Hediger schreef:
>> Yes, thats probably an option. What I was hoping for was a PDF where
>> only the selected elements were present, possibly with some kind of
>> small margin of white space. If I draw a 5cm square and export it to
>> PDF because i want to include it as a graphics in LaTeX, its not very
>> likely to find a paper format for exactly that shape, that's why I'm
>> asking. At the moment, I need to reopen every drawing in Mac OS X
>> Preview and manually cut/paste the selection to a new file. Doing it
>> once is ok, but several times gets inconvenient, so I thought there's
>> a smarter way of doing it.
>>
>>
>>
>>
>>
>>
>>
>> Am 14.11.11 11:11, schrieb floris v:
>>> Op 14-11-2011 10:33, Martin Hediger schreef:
>>>> Dear List
>>>> I wonder how I can export a selection from and .odg drawing to PDF.
>>>> When I select a number of elements in the drawing, I choose
>>>> File->Export as PDF, and in the following Dialog I check
>>>> "Selection". However, I always end up with a DIN A4 page with the
>>>> selected elements.
>>>>
>>>> Is there anything else required to get only the selected elements
>>>> into the PDF?
>>>>
>>>> Thanks for any hints.
>>>> Martin
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>>
>>> What's the problem? Your selection gets converted to PDF with
>>> otherwise default settings. If you want a different page size, you
>>> may have to copy the selection to a blank document and set the paper
>>> size and any other options to what you want before exporting.
>>>
>>> peter aka floris v
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Export as PDF
Posted by Robert Funnell <ro...@mcgill.ca>.
Martin -
Sorry, I didn't mean that there is such a thing but only that there
could be, in response to the comment that such a feature is
'impossible to implement in a way that's useful for many people'.
- Robert
On Mon, 14 Nov 2011, Martin Hediger wrote:
> I was referring to what you correspond to in your first option, indeed how to
> set the margin in the "Export as PDF" dialog of Openoffice Draw. However, I
> just checked, I cant seem to see anything indicating something like "margin"
> in that dialog.
>
>
>
>
>
>
> Am 14.11.11 15:31, schrieb Robert Funnell:
>> Martin, I'm not sure exactly what your question is.
>>
>> The answer would be Yes if you mean which Draw dialogue such margin
>> settings might be in.
>>
>> The answer would be No if you mean which Inkscape dialogue I'm talking
>> about. Inkscape has Save as PDF, not Export as PDF, and doesn't have
>> exactly what I suggest.
>>
>> - Robert
>>
>> On Mon, 14 Nov 2011, Martin Hediger wrote:
>>
>>> And thats in the "Export as PDF" dialog?
>>>
>>>
>>>
>>> Am 14.11.11 14:52, schrieb Robert Funnell:
>>>> Exporting a selection with zero margins is very useful - if non-zero
>>>> margins are desired, you can add an invisible rectangle of the desired
>>>> dimensions and include it in the selection. An alternative would be to
>>>> have margin settings in the export dialogue. (These ideas were inspired
>>>> by Inkscape.)
>>>> - Robert
>>>>
>>>> On Mon, 14 Nov 2011, floris v wrote:
>>>>
>>>>> I see what you want, but that's impossible to implement in a way that's
>>>>> useful for many people. Because - what's a narrow margin? Nobody will
>>>>> probably agree on ideal values for margins, and so you might, even if
>>>>> something like it were implemented, often end up with a PDF with margins
>>>>> that are either too wide or too narrow.
>>>>>
>>>>> Op 14-11-2011 13:11, Martin Hediger schreef:
>>>>>> Yes, thats probably an option. What I was hoping for was a PDF where
>>>>>> only the selected elements were present, possibly with some kind of
>>>>>> small margin of white space. If I draw a 5cm square and export it to
>>>>>> PDF because i want to include it as a graphics in LaTeX, its not very
>>>>>> likely to find a paper format for exactly that shape, that's why I'm
>>>>>> asking. At the moment, I need to reopen every drawing in Mac OS X
>>>>>> Preview and manually cut/paste the selection to a new file. Doing it
>>>>>> once is ok, but several times gets inconvenient, so I thought there's a
>>>>>> smarter way of doing it.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> Am 14.11.11 11:11, schrieb floris v:
>>>>>>> Op 14-11-2011 10:33, Martin Hediger schreef:
>>>>>>>> Dear List
>>>>>>>> I wonder how I can export a selection from and .odg drawing to PDF.
>>>>>>>> When I select a number of elements in the drawing, I choose
>>>>>>>> File->Export as PDF, and in the following Dialog I check "Selection".
>>>>>>>> However, I always end up with a DIN A4 page with the selected
>>>>>>>> elements.
>>>>>>>>
>>>>>>>> Is there anything else required to get only the selected elements
>>>>>>>> into the PDF?
>>>>>>>>
>>>>>>>> Thanks for any hints.
>>>>>>>> Martin
>>>>>>>>
>>>>>>>> ---------------------------------------------------------------------
>>>>>>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>>>>>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>>>>>>
>>>>>>> What's the problem? Your selection gets converted to PDF with
>>>>>>> otherwise default settings. If you want a different page size, you may
>>>>>>> have to copy the selection to a blank document and set the paper size
>>>>>>> and any other options to what you want before exporting.
>>>>>>>
>>>>>>> peter aka floris v
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Export as PDF
Posted by Martin Hediger <ma...@bluewin.ch>.
I was referring to what you correspond to in your first option, indeed
how to set the margin in the "Export as PDF" dialog of Openoffice Draw.
However, I just checked, I cant seem to see anything indicating
something like "margin" in that dialog.
Am 14.11.11 15:31, schrieb Robert Funnell:
> Martin, I'm not sure exactly what your question is.
>
> The answer would be Yes if you mean which Draw dialogue such margin
> settings might be in.
>
> The answer would be No if you mean which Inkscape dialogue I'm talking
> about. Inkscape has Save as PDF, not Export as PDF, and doesn't have
> exactly what I suggest.
>
> - Robert
>
> On Mon, 14 Nov 2011, Martin Hediger wrote:
>
>> And thats in the "Export as PDF" dialog?
>>
>>
>>
>> Am 14.11.11 14:52, schrieb Robert Funnell:
>>> Exporting a selection with zero margins is very useful - if non-zero
>>> margins are desired, you can add an invisible rectangle of the
>>> desired dimensions and include it in the selection. An alternative
>>> would be to have margin settings in the export dialogue. (These
>>> ideas were inspired by Inkscape.)
>>> - Robert
>>>
>>> On Mon, 14 Nov 2011, floris v wrote:
>>>
>>>> I see what you want, but that's impossible to implement in a way
>>>> that's useful for many people. Because - what's a narrow margin?
>>>> Nobody will probably agree on ideal values for margins, and so you
>>>> might, even if something like it were implemented, often end up
>>>> with a PDF with margins that are either too wide or too narrow.
>>>>
>>>> Op 14-11-2011 13:11, Martin Hediger schreef:
>>>>> Yes, thats probably an option. What I was hoping for was a PDF
>>>>> where only the selected elements were present, possibly with some
>>>>> kind of small margin of white space. If I draw a 5cm square and
>>>>> export it to PDF because i want to include it as a graphics in
>>>>> LaTeX, its not very likely to find a paper format for exactly that
>>>>> shape, that's why I'm asking. At the moment, I need to reopen
>>>>> every drawing in Mac OS X Preview and manually cut/paste the
>>>>> selection to a new file. Doing it once is ok, but several times
>>>>> gets inconvenient, so I thought there's a smarter way of doing it.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Am 14.11.11 11:11, schrieb floris v:
>>>>>> Op 14-11-2011 10:33, Martin Hediger schreef:
>>>>>>> Dear List
>>>>>>> I wonder how I can export a selection from and .odg drawing to
>>>>>>> PDF. When I select a number of elements in the drawing, I choose
>>>>>>> File->Export as PDF, and in the following Dialog I check
>>>>>>> "Selection". However, I always end up with a DIN A4 page with
>>>>>>> the selected elements.
>>>>>>>
>>>>>>> Is there anything else required to get only the selected
>>>>>>> elements into the PDF?
>>>>>>>
>>>>>>> Thanks for any hints.
>>>>>>> Martin
>>>>>>>
>>>>>>> ---------------------------------------------------------------------
>>>>>>>
>>>>>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>>>>>> For additional commands, e-mail:
>>>>>>> ooo-users-help@incubator.apache.org
>>>>>>>
>>>>>> What's the problem? Your selection gets converted to PDF with
>>>>>> otherwise default settings. If you want a different page size,
>>>>>> you may have to copy the selection to a blank document and set
>>>>>> the paper size and any other options to what you want before
>>>>>> exporting.
>>>>>>
>>>>>> peter aka floris v
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Export as PDF
Posted by Robert Funnell <ro...@mcgill.ca>.
Martin, I'm not sure exactly what your question is.
The answer would be Yes if you mean which Draw dialogue such margin
settings might be in.
The answer would be No if you mean which Inkscape dialogue I'm talking
about. Inkscape has Save as PDF, not Export as PDF, and doesn't have
exactly what I suggest.
- Robert
On Mon, 14 Nov 2011, Martin Hediger wrote:
> And thats in the "Export as PDF" dialog?
>
>
>
> Am 14.11.11 14:52, schrieb Robert Funnell:
>> Exporting a selection with zero margins is very useful - if non-zero
>> margins are desired, you can add an invisible rectangle of the desired
>> dimensions and include it in the selection. An alternative would be to have
>> margin settings in the export dialogue. (These ideas were inspired by
>> Inkscape.)
>> - Robert
>>
>> On Mon, 14 Nov 2011, floris v wrote:
>>
>>> I see what you want, but that's impossible to implement in a way that's
>>> useful for many people. Because - what's a narrow margin? Nobody will
>>> probably agree on ideal values for margins, and so you might, even if
>>> something like it were implemented, often end up with a PDF with margins
>>> that are either too wide or too narrow.
>>>
>>> Op 14-11-2011 13:11, Martin Hediger schreef:
>>>> Yes, thats probably an option. What I was hoping for was a PDF where only
>>>> the selected elements were present, possibly with some kind of small
>>>> margin of white space. If I draw a 5cm square and export it to PDF
>>>> because i want to include it as a graphics in LaTeX, its not very likely
>>>> to find a paper format for exactly that shape, that's why I'm asking. At
>>>> the moment, I need to reopen every drawing in Mac OS X Preview and
>>>> manually cut/paste the selection to a new file. Doing it once is ok, but
>>>> several times gets inconvenient, so I thought there's a smarter way of
>>>> doing it.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Am 14.11.11 11:11, schrieb floris v:
>>>>> Op 14-11-2011 10:33, Martin Hediger schreef:
>>>>>> Dear List
>>>>>> I wonder how I can export a selection from and .odg drawing to PDF.
>>>>>> When I select a number of elements in the drawing, I choose
>>>>>> File->Export as PDF, and in the following Dialog I check "Selection".
>>>>>> However, I always end up with a DIN A4 page with the selected elements.
>>>>>>
>>>>>> Is there anything else required to get only the selected elements into
>>>>>> the PDF?
>>>>>>
>>>>>> Thanks for any hints.
>>>>>> Martin
>>>>>>
>>>>>> ---------------------------------------------------------------------
>>>>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>>>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>>>>
>>>>> What's the problem? Your selection gets converted to PDF with otherwise
>>>>> default settings. If you want a different page size, you may have to
>>>>> copy the selection to a blank document and set the paper size and any
>>>>> other options to what you want before exporting.
>>>>>
>>>>> peter aka floris v
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Export as PDF
Posted by Martin Hediger <ma...@bluewin.ch>.
And thats in the "Export as PDF" dialog?
Am 14.11.11 14:52, schrieb Robert Funnell:
> Exporting a selection with zero margins is very useful - if non-zero
> margins are desired, you can add an invisible rectangle of the desired
> dimensions and include it in the selection. An alternative would be to
> have margin settings in the export dialogue. (These ideas were
> inspired by Inkscape.)
> - Robert
>
> On Mon, 14 Nov 2011, floris v wrote:
>
>> I see what you want, but that's impossible to implement in a way
>> that's useful for many people. Because - what's a narrow margin?
>> Nobody will probably agree on ideal values for margins, and so you
>> might, even if something like it were implemented, often end up with
>> a PDF with margins that are either too wide or too narrow.
>>
>> Op 14-11-2011 13:11, Martin Hediger schreef:
>>> Yes, thats probably an option. What I was hoping for was a PDF where
>>> only the selected elements were present, possibly with some kind of
>>> small margin of white space. If I draw a 5cm square and export it to
>>> PDF because i want to include it as a graphics in LaTeX, its not
>>> very likely to find a paper format for exactly that shape, that's
>>> why I'm asking. At the moment, I need to reopen every drawing in Mac
>>> OS X Preview and manually cut/paste the selection to a new file.
>>> Doing it once is ok, but several times gets inconvenient, so I
>>> thought there's a smarter way of doing it.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> Am 14.11.11 11:11, schrieb floris v:
>>>> Op 14-11-2011 10:33, Martin Hediger schreef:
>>>>> Dear List
>>>>> I wonder how I can export a selection from and .odg drawing to
>>>>> PDF. When I select a number of elements in the drawing, I choose
>>>>> File->Export as PDF, and in the following Dialog I check
>>>>> "Selection". However, I always end up with a DIN A4 page with the
>>>>> selected elements.
>>>>>
>>>>> Is there anything else required to get only the selected elements
>>>>> into the PDF?
>>>>>
>>>>> Thanks for any hints.
>>>>> Martin
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>>>
>>>> What's the problem? Your selection gets converted to PDF with
>>>> otherwise default settings. If you want a different page size, you
>>>> may have to copy the selection to a blank document and set the
>>>> paper size and any other options to what you want before exporting.
>>>>
>>>> peter aka floris v
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>>
>>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Export as PDF
Posted by Robert Funnell <ro...@mcgill.ca>.
Exporting a selection with zero margins is very useful - if non-zero
margins are desired, you can add an invisible rectangle of the desired
dimensions and include it in the selection. An alternative would be to
have margin settings in the export dialogue. (These ideas were
inspired by Inkscape.)
- Robert
On Mon, 14 Nov 2011, floris v wrote:
> I see what you want, but that's impossible to implement in a way that's
> useful for many people. Because - what's a narrow margin? Nobody will
> probably agree on ideal values for margins, and so you might, even if
> something like it were implemented, often end up with a PDF with margins that
> are either too wide or too narrow.
>
> Op 14-11-2011 13:11, Martin Hediger schreef:
>> Yes, thats probably an option. What I was hoping for was a PDF where only
>> the selected elements were present, possibly with some kind of small margin
>> of white space. If I draw a 5cm square and export it to PDF because i want
>> to include it as a graphics in LaTeX, its not very likely to find a paper
>> format for exactly that shape, that's why I'm asking. At the moment, I need
>> to reopen every drawing in Mac OS X Preview and manually cut/paste the
>> selection to a new file. Doing it once is ok, but several times gets
>> inconvenient, so I thought there's a smarter way of doing it.
>>
>>
>>
>>
>>
>>
>>
>> Am 14.11.11 11:11, schrieb floris v:
>>> Op 14-11-2011 10:33, Martin Hediger schreef:
>>>> Dear List
>>>> I wonder how I can export a selection from and .odg drawing to PDF. When
>>>> I select a number of elements in the drawing, I choose File->Export as
>>>> PDF, and in the following Dialog I check "Selection". However, I always
>>>> end up with a DIN A4 page with the selected elements.
>>>>
>>>> Is there anything else required to get only the selected elements into
>>>> the PDF?
>>>>
>>>> Thanks for any hints.
>>>> Martin
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>>
>>> What's the problem? Your selection gets converted to PDF with otherwise
>>> default settings. If you want a different page size, you may have to copy
>>> the selection to a blank document and set the paper size and any other
>>> options to what you want before exporting.
>>>
>>> peter aka floris v
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Export as PDF
Posted by floris v <fl...@gmail.com>.
I see what you want, but that's impossible to implement in a way that's
useful for many people. Because - what's a narrow margin? Nobody will
probably agree on ideal values for margins, and so you might, even if
something like it were implemented, often end up with a PDF with margins
that are either too wide or too narrow.
Op 14-11-2011 13:11, Martin Hediger schreef:
> Yes, thats probably an option. What I was hoping for was a PDF where
> only the selected elements were present, possibly with some kind of
> small margin of white space. If I draw a 5cm square and export it to
> PDF because i want to include it as a graphics in LaTeX, its not very
> likely to find a paper format for exactly that shape, that's why I'm
> asking. At the moment, I need to reopen every drawing in Mac OS X
> Preview and manually cut/paste the selection to a new file. Doing it
> once is ok, but several times gets inconvenient, so I thought there's
> a smarter way of doing it.
>
>
>
>
>
>
>
> Am 14.11.11 11:11, schrieb floris v:
>> Op 14-11-2011 10:33, Martin Hediger schreef:
>>> Dear List
>>> I wonder how I can export a selection from and .odg drawing to PDF.
>>> When I select a number of elements in the drawing, I choose
>>> File->Export as PDF, and in the following Dialog I check
>>> "Selection". However, I always end up with a DIN A4 page with the
>>> selected elements.
>>>
>>> Is there anything else required to get only the selected elements
>>> into the PDF?
>>>
>>> Thanks for any hints.
>>> Martin
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>>
>> What's the problem? Your selection gets converted to PDF with
>> otherwise default settings. If you want a different page size, you
>> may have to copy the selection to a blank document and set the paper
>> size and any other options to what you want before exporting.
>>
>> peter aka floris v
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Export as PDF
Posted by Martin Hediger <ma...@bluewin.ch>.
Yes, thats probably an option. What I was hoping for was a PDF where
only the selected elements were present, possibly with some kind of
small margin of white space. If I draw a 5cm square and export it to PDF
because i want to include it as a graphics in LaTeX, its not very likely
to find a paper format for exactly that shape, that's why I'm asking. At
the moment, I need to reopen every drawing in Mac OS X Preview and
manually cut/paste the selection to a new file. Doing it once is ok, but
several times gets inconvenient, so I thought there's a smarter way of
doing it.
Am 14.11.11 11:11, schrieb floris v:
> Op 14-11-2011 10:33, Martin Hediger schreef:
>> Dear List
>> I wonder how I can export a selection from and .odg drawing to PDF.
>> When I select a number of elements in the drawing, I choose
>> File->Export as PDF, and in the following Dialog I check "Selection".
>> However, I always end up with a DIN A4 page with the selected elements.
>>
>> Is there anything else required to get only the selected elements
>> into the PDF?
>>
>> Thanks for any hints.
>> Martin
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>
> What's the problem? Your selection gets converted to PDF with
> otherwise default settings. If you want a different page size, you may
> have to copy the selection to a blank document and set the paper size
> and any other options to what you want before exporting.
>
> peter aka floris v
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Export as PDF
Posted by floris v <fl...@gmail.com>.
Op 14-11-2011 10:33, Martin Hediger schreef:
> Dear List
> I wonder how I can export a selection from and .odg drawing to PDF.
> When I select a number of elements in the drawing, I choose
> File->Export as PDF, and in the following Dialog I check "Selection".
> However, I always end up with a DIN A4 page with the selected elements.
>
> Is there anything else required to get only the selected elements into
> the PDF?
>
> Thanks for any hints.
> Martin
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
What's the problem? Your selection gets converted to PDF with otherwise
default settings. If you want a different page size, you may have to
copy the selection to a blank document and set the paper size and any
other options to what you want before exporting.
peter aka floris v
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Export as PDF
Posted by Brian Barker <b....@btinternet.com>.
At 10:33 14/11/2011 +0100, Martin Hediger wrote:
>I wonder how I can export a selection from and .odg drawing to PDF.
>When I select a number of elements in the drawing, I choose
>File->Export as PDF, and in the following Dialog I check
>"Selection". However, I always end up with a DIN A4 page with the
>selected elements.
I think the clue is in the "D" in "PDF": that format is designed for
final versions of *documents*, not for the interchange of
elements. So yes: what you get will always be a document in the
chosen page size.
At 13:11 14/11/2011 +0100, Martin Hediger wrote:
>What I was hoping for was a PDF where only the selected elements
>were present, possibly with some kind of small margin of white
>space. If I draw a 5cm square and export it to PDF because i want to
>include it as a graphics in LaTeX, its not very likely to find a
>paper format for exactly that shape, that's why I'm asking.
I'm not familiar with LaTeX, but it seems that you can include PNG,
JPEG, and GIF images as well.
Try this:
o Select your multiple elements - either by using click and
Shift+click or by dragging the cursor to create a rectangle including
your elements.
o Go to Modify | Convert > | To Bitmap (or right-click | Convert > |
To Bitmap).
o Now go to right-click | Save as Picture... .You can save the
collected elements with the minimum of surrounding space in a wide
range of formats - including PNG, JPEG, and GIF.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Export as PDF
Posted by Terry <te...@yahoo.com.au>.
I may be way off target here but why not save the file in a new name ("save as"), amend the new file and export it?
----- Original Message -----
> From: Martin Hediger <ma...@bluewin.ch>
> To: ooo-users@incubator.apache.org
> Cc:
> Sent: Monday, 14 November 2011 8:33 PM
> Subject: Export as PDF
>
> Dear List
> I wonder how I can export a selection from and .odg drawing to PDF. When I
> select a number of elements in the drawing, I choose File->Export as PDF, and
> in the following Dialog I check "Selection". However, I always end up
> with a DIN A4 page with the selected elements.
>
> Is there anything else required to get only the selected elements into the PDF?
>
> Thanks for any hints.
> Martin
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Export as PDF
Posted by Martin Hediger <ma...@bluewin.ch>.
Dear List
I wonder how I can export a selection from and .odg drawing to PDF. When
I select a number of elements in the drawing, I choose File->Export as
PDF, and in the following Dialog I check "Selection". However, I always
end up with a DIN A4 page with the selected elements.
Is there anything else required to get only the selected elements into
the PDF?
Thanks for any hints.
Martin
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Calc Table Display Errors
Posted by Martin Hediger <ma...@bluewin.ch>.
Hey, Fred
I just tried your suggestion and the first impression is it makes
everything really better. The scrolling is smooth again, the paining of
the spreadsheet is correct (when I deleted a cell, its content was still
visible).
Maybe this really was the solution, I'll be monitoring it in the
upcoming time.
Thanks in any case for the nice idea.
Martin
Hi
> did you try to rename your personal preferences folder and restart OOo ?
>
> for example for linux
> quit OOo
> mv .openoffice .openoffice.org .openoffice.org_origin
> then restart
>
> sometimes, it works ....
>
> fred
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Calc Table Display Errors
Posted by Larry Gusaas <la...@gmail.com>.
On 2011-11-08 5:07 PM Terry wrote:
> Martin, look in Tools> Options> OO.o> Paths. Various entries there will show you the location of the profile folder. Terry
On Macs it is OpenOffice.org/Preferences/OpenOffice.org/Paths
--
_________________________________
Larry I. Gusaas
Moose Jaw, Saskatchewan Canada
Website: http://larry-gusaas.com
"An artist is never ahead of his time but most people are far behind theirs." - Edgard Varese
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Calc Table Display Errors
Posted by Terry <te...@yahoo.com.au>.
Martin, look in Tools > Options > OO.o > Paths. Various entries there will show you the location of the profile folder. Terry
----- Original Message -----
> From: Martin Hediger <ma...@bluewin.ch>
> To: ooo-users@incubator.apache.org
> Cc:
> Sent: Wednesday, 9 November 2011 8:31 AM
> Subject: Re: Calc Table Display Errors
>
> Do you know how to do the same thing on Mac OS X?
> Martin
>
>
> Am 07.11.11 18:20, schrieb Fred Juan DIAZ:
>> 2011/11/6 Martin Hediger<ma...@bluewin.ch>
>>
>>> Just tried it,
>>> Calc kind of crashed when I hit it. And its even a fresh install of OO
> 3.3.
>>>
>>> Thanks for the support
>>> Martin
>>>
>>>
>>>
>>>
>>> Hi
>> did you try to rename your personal preferences folder and restart OOo ?
>>
>> for example for linux
>> quit OOo
>> mv .openoffice .openoffice.org .openoffice.org_origin
>> then restart
>>
>> sometimes, it works ....
>>
>> fred
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Scrolling in spreadsheet
Posted by Martin Hediger <ma...@bluewin.ch>.
Thanks Scott, wasn't aware of me replying to an existing message.
I'll be checking it out.
Am 14.11.11 09:44, schrieb Mike Scott:
> On 14/11/2011 06:36, Martin Hediger wrote:
>> I was referring to horizontal scrolling indeed, but it is also the same
>> vertically.
>> In my case, using the scroll bar does still scroll in units of cell
>> width or hight. How did you adjust this?
>
> It looks from a quick search that this issue was flagged up years ago
> (try googling for something like 'Openoffice Calc smooth scroll' --
> turns up eg
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&p=86184
> or https://bugs.launchpad.net/openoffice/+bug/375395). I didn't
> notice a solution.
>
>
> (Incidentally, when you started your new topic, you replied to an
> existing message . It means your query is buried deep in another
> thread on another topic, and may not be noticed by some.)
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Scrolling in spreadsheet
Posted by Mike Scott <mi...@scottsonline.org.uk>.
On 14/11/2011 06:36, Martin Hediger wrote:
> I was referring to horizontal scrolling indeed, but it is also the same
> vertically.
> In my case, using the scroll bar does still scroll in units of cell
> width or hight. How did you adjust this?
It looks from a quick search that this issue was flagged up years ago
(try googling for something like 'Openoffice Calc smooth scroll' --
turns up eg
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&p=86184
or https://bugs.launchpad.net/openoffice/+bug/375395). I didn't notice
a solution.
(Incidentally, when you started your new topic, you replied to an
existing message . It means your query is buried deep in another thread
on another topic, and may not be noticed by some.)
--
Mike Scott
Harlow, Essex, England
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Scrolling in spreadsheet
Posted by Martin Hediger <ma...@bluewin.ch>.
I was referring to horizontal scrolling indeed, but it is also the same
vertically.
In my case, using the scroll bar does still scroll in units of cell
width or hight. How did you adjust this?
Am 14.11.11 03:59, schrieb Terry:
>
> Reading the original post again, I think Martin is referring to horizontal scrolling. I have no problem with either horizontal or vertical scrolling.
> -- Terry
>
>> ________________________________
>> From: Fred Juan DIAZ<fr...@gmail.com>
>> To: ooo-users@incubator.apache.org; Terry<te...@yahoo.com.au>
>> Sent: Monday, 14 November 2011 8:02 AM
>> Subject: Re: Scrolling in spreadsheet
>>
>>
>> 2011/11/12 Terry<te...@yahoo.com.au>
>>
>> I find that using the vertical scrollbar, especially the arrows at the top and bottom, can scroll one row at a time. Does that resolve the issue?
>>>
>>>
>>> ----- Original Message -----
>>>> From: Martin Hediger<ma...@bluewin.ch>
>>>> To: ooo-users@incubator.apache.org
>>>> Cc:
>>>> Sent: Saturday, 12 November 2011 1:41 AM
>>>> Subject: Scrolling in spreadsheet
>>>>
>>>> Dear List
>>>> Is it possible to set the scrolling behavior such that it does not scroll in
>>>> units of cells, but continuously? It's a bit incovenient to scroll, when
>>>> cells are large in width because then the screen is jumping significantly.
>>>>
>>>> Thanks for any hints.
>>>>
>>> ========================
>>>
>> Hi
>> I share the question of Martin.
>> No, unfortunately, Terry, it doesn't . Even with these arrows, Scrolling is still jumping exactly from cell to cell and this behavior is sometimes boring when we use a wide zoom or tall cells (with many lines inside).
>> It doesn't seem possible to scroll *continuously* like we would do, for example with a drawing page or a text.
>> thanks
>> Fred Juan Diaz
>>
>>
>>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Scrolling in spreadsheet
Posted by Terry <te...@yahoo.com.au>.
Reading the original post again, I think Martin is referring to horizontal scrolling. I have no problem with either horizontal or vertical scrolling.
-- Terry
>________________________________
>From: Fred Juan DIAZ <fr...@gmail.com>
>To: ooo-users@incubator.apache.org; Terry <te...@yahoo.com.au>
>Sent: Monday, 14 November 2011 8:02 AM
>Subject: Re: Scrolling in spreadsheet
>
>
>2011/11/12 Terry <te...@yahoo.com.au>
>
>I find that using the vertical scrollbar, especially the arrows at the top and bottom, can scroll one row at a time. Does that resolve the issue?
>>
>>
>>
>>----- Original Message -----
>>> From: Martin Hediger <ma...@bluewin.ch>
>>> To: ooo-users@incubator.apache.org
>>> Cc:
>>> Sent: Saturday, 12 November 2011 1:41 AM
>>> Subject: Scrolling in spreadsheet
>>>
>>> Dear List
>>> Is it possible to set the scrolling behavior such that it does not scroll in
>>> units of cells, but continuously? It's a bit incovenient to scroll, when
>>> cells are large in width because then the screen is jumping significantly.
>>>
>>> Thanks for any hints.
>>>
>>
>>========================
>>
>
>Hi
>I share the question of Martin.
>No, unfortunately, Terry, it doesn't . Even with these arrows, Scrolling is still jumping exactly from cell to cell and this behavior is sometimes boring when we use a wide zoom or tall cells (with many lines inside).
>It doesn't seem possible to scroll *continuously* like we would do, for example with a drawing page or a text.
>thanks
>Fred Juan Diaz
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Scrolling in spreadsheet
Posted by Fred Juan DIAZ <fr...@gmail.com>.
2011/11/12 Terry <te...@yahoo.com.au>
> I find that using the vertical scrollbar, especially the arrows at the top
> and bottom, can scroll one row at a time. Does that resolve the issue?
>
>
> ----- Original Message -----
> > From: Martin Hediger <ma...@bluewin.ch>
> > To: ooo-users@incubator.apache.org
> > Cc:
> > Sent: Saturday, 12 November 2011 1:41 AM
> > Subject: Scrolling in spreadsheet
> >
> > Dear List
> > Is it possible to set the scrolling behavior such that it does not
> scroll in
> > units of cells, but continuously? It's a bit incovenient to scroll, when
> > cells are large in width because then the screen is jumping
> significantly.
> >
> > Thanks for any hints.
> >
>
> ========================
>
Hi
I share the question of Martin.
No, unfortunately, Terry, it doesn't . Even with these arrows, Scrolling is
still jumping exactly from cell to cell and this behavior is sometimes
boring when we use a wide zoom or tall cells (with many lines inside).
It doesn't seem possible to scroll *continuously* like we would do, for
example with a drawing page or a text.
thanks
Fred Juan Diaz
Re: Scrolling in spreadsheet
Posted by Terry <te...@yahoo.com.au>.
I find that using the vertical scrollbar, especially the arrows at the top and bottom, can scroll one row at a time. Does that resolve the issue?
----- Original Message -----
> From: Martin Hediger <ma...@bluewin.ch>
> To: ooo-users@incubator.apache.org
> Cc:
> Sent: Saturday, 12 November 2011 1:41 AM
> Subject: Scrolling in spreadsheet
>
> Dear List
> Is it possible to set the scrolling behavior such that it does not scroll in
> units of cells, but continuously? It's a bit incovenient to scroll, when
> cells are large in width because then the screen is jumping significantly.
>
> Thanks for any hints.
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Scrolling in spreadsheet
Posted by Martin Hediger <ma...@bluewin.ch>.
Dear List
Is it possible to set the scrolling behavior such that it does not
scroll in units of cells, but continuously? It's a bit incovenient to
scroll, when cells are large in width because then the screen is jumping
significantly.
Thanks for any hints.
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Calc Table Display Errors
Posted by Larry Gusaas <la...@gmail.com>.
On 2011-11-08 3:31 PM Martin Hediger wrote:
> Am 07.11.11 18:20, schrieb Fred Juan DIAZ:
>> did you try to rename your personal preferences folder and restart OOo ?
>>
>> for example for linux
>> quit OOo
>> mv .openoffice .openoffice.org .openoffice.org_origin
>> then restart
>>
>> sometimes, it works ....
>>
>> fred
> Do you know how to do the same thing on Mac OS X?
> Martin
/Users/<user name>/Library/Application Support/OpenOffice.org/3/user
For more information about user profiles see:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=74&t=12426
--
_________________________________
Larry I. Gusaas
Moose Jaw, Saskatchewan Canada
Website: http://larry-gusaas.com
"An artist is never ahead of his time but most people are far behind theirs." - Edgard Varese
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Calc Table Display Errors
Posted by Martin Hediger <ma...@bluewin.ch>.
Do you know how to do the same thing on Mac OS X?
Martin
Am 07.11.11 18:20, schrieb Fred Juan DIAZ:
> 2011/11/6 Martin Hediger<ma...@bluewin.ch>
>
>> Just tried it,
>> Calc kind of crashed when I hit it. And its even a fresh install of OO 3.3.
>>
>> Thanks for the support
>> Martin
>>
>>
>>
>>
>> Hi
> did you try to rename your personal preferences folder and restart OOo ?
>
> for example for linux
> quit OOo
> mv .openoffice .openoffice.org .openoffice.org_origin
> then restart
>
> sometimes, it works ....
>
> fred
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Calc Table Display Errors
Posted by Martin Hediger <ma...@bluewin.ch>.
No, I haven't but that's something I will try.
Thanks for pointing it out to me.
Martin
Am 07.11.11 18:20, schrieb Fred Juan DIAZ:
> 2011/11/6 Martin Hediger<ma...@bluewin.ch>
>
>> Just tried it,
>> Calc kind of crashed when I hit it. And its even a fresh install of OO 3.3.
>>
>> Thanks for the support
>> Martin
>>
>>
>>
>>
>> Hi
> did you try to rename your personal preferences folder and restart OOo ?
>
> for example for linux
> quit OOo
> mv .openoffice .openoffice.org .openoffice.org_origin
> then restart
>
> sometimes, it works ....
>
> fred
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Calc Table Display Errors
Posted by Fred Juan DIAZ <fr...@gmail.com>.
2011/11/6 Martin Hediger <ma...@bluewin.ch>
> Just tried it,
> Calc kind of crashed when I hit it. And its even a fresh install of OO 3.3.
>
> Thanks for the support
> Martin
>
>
>
>
> Hi
did you try to rename your personal preferences folder and restart OOo ?
for example for linux
quit OOo
mv .openoffice .openoffice.org .openoffice.org_origin
then restart
sometimes, it works ....
fred
Re: Calc Table Display Errors
Posted by Martin Hediger <ma...@bluewin.ch>.
Just tried it,
Calc kind of crashed when I hit it. And its even a fresh install of OO 3.3.
Thanks for the support
Martin
Am 05.11.11 22:08, schrieb TJ Frazier:
> On 11/5/2011 16:56, Martin Hediger wrote:
>> Hi Fred, thanks for the background details. Do you have any kind of
>> ETA? At the moment, my OO is not usable, but I need to handle
>> spreadsheets somehow. I guess I'll have to switch to MS Office if the
>> bug is not fixed soon.
>>
>> Martin
>
> Quick thought: would the Redraw command (Ctrl+Shift+R) do any good?
> __/tj/
>>
>>
>>
>>
>> Am 05.11.11 19:38, schrieb Fred Juan DIAZ:
>>> 2011/11/5 Martin Hediger<ma...@bluewin.ch>
>>>
>>>> Am 04.11.11 21:58, schrieb Fred Juan DIAZ:
>>>>
>>>>> 2011/11/3 TJ Frazier<tj...@cfl.rr.com>
>>>>>
>>>>> On 11/3/2011 18:32, Terry wrote:
>>>>>> Memory settings have been discussed on oooforum.org and on
>>>>>> the new
>>>>>>> community forum. A search should turn up suggested
>>>>>>> settings; I have seen it mentioned several times. I think
>>>>>>> you may have to experiment. This is one post on the new
>>>>>>> forum:
>>>>>>> http://user.services.**openoff**ice.org/en/forum/**<http://openoffice.org/en/forum/**>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> viewtopic.php?f=9&t=32090#****p146893<http://user.services.**
>>>>>>>
>>>>>>>
> openoffice.org/en/forum/**viewtopic.php?f=9&t=32090#**p146893<http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=32090#p146893>
>
>>>>>>>
>>>>>>>
>>>>>>> Two things seem clear. First, reduce the number of undo
>>>>>>> steps (the default, I recall, is 100) to, say 21. Secondly,
>>>>>>> increase the size of the graphics cache to, say, 128 MB.
>>>>>>> Open Office does seem to be a memory hog; it certainly
>>>>>>> places a strain at times on my system and Andrew Pitonyak
>>>>>>> has mentioned that the odt version of his macro document
>>>>>>> causes OO to crash. I have seen reference to "memory
>>>>>>> leaking" but don't know what that means.
>>>>>>>
>>>>>>>
>>>>>>> Terry
>>>>>>>
>>>>>>> FYI:
>>>>>>> http://en.wikipedia.org/wiki/****Memory_leak<http://en.wikipedia.org/wiki/**Memory_leak>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> <http://en.**wikipedia.org/wiki/Memory_leak<http://en.wikipedia.org/wiki/Memory_leak>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> **> --/tj/
>>>>>>>
>>>>>> ----- Original Message -----
>>>>>>> From: Martin Hediger<ma...@bluewin.ch> To:
>>>>>>>> ooo-users@incubator.apache.org Cc: Sent: Thursday, 3
>>>>>>>> November 2011 10:07 PM Subject: Re: Calc Table Display
>>>>>>>> Errors
>>>>>>>>
>>>>>>>> Hi The sheet is 31K in size. It only contains entries
>>>>>>>> down to row around 150 and columns to Z, around 50 URLs
>>>>>>>> are in some cells, as well as around 50 URLs to PDFs on
>>>>>>>> my hard drive. I was thinking, could it be that I'm not
>>>>>>>> assigning the correct amount of memory? This can be
>>>>>>>> adjusted in the settings, i saw, but I cant find values
>>>>>>>> that help. I think I started to have this problem only
>>>>>>>> once i turned *off* anti-aliasing of fonts, because
>>>>>>>> Openoffice Impress was having trouble handling a large A0
>>>>>>>> poster.
>>>>>>>>
>>>>>>>> Any ideas are very welcomed. Martin
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Am 02.11.11 23:39, schrieb Terry:
>>>>>>>>
>>>>>>>> That sounds like a system problem rather than a software
>>>>>>>> issue.
>>>>>>>>> Try
>>>>>>>>>
>>>>>>>>> copying two sheets to a new file, then close all files
>>>>>>>>> and exit the
>>>>>>>> software. Then open the new file only and see whether the
>>>>>>>> problem occurs in the new file. It may be that you are
>>>>>>>> placing too great a load on your system.
>>>>>>>>
>>>>>>>> Terry
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> ----- Original Message -----
>>>>>>>>>
>>>>>>>>> From: Martin Hediger<ma...@bluewin.ch> To:
>>>>>>>>>> ooo-users@incubator.apache.org Cc: Sent: Thursday, 3
>>>>>>>>>> November 2011 3:24 AM Subject: Calc Table Display
>>>>>>>>>> Errors
>>>>>>>>>>
>>>>>>>>>> Dear List I have a Calc spreadsheet open where a
>>>>>>>>>> number of tables are used. However, it becomes hardly
>>>>>>>>>> unusable, because when I switch between two
>>>>>>>>>>
>>>>>>>>>> tables
>>>>>>>>> (using the tabs at the bottom of the windom), the
>>>>>>>>> values from
>>>>>>>>>
>>>>>>>>>> the "new" table are printed on top of the "old"
>>>>>>>>>> values.
>>>>>>>>>>
>>>>>>>>>> It becomes unreadable.
>>>>>>>>> Also often when scrolling, values get "smeared" out all
>>>>>>>>> over the table. Its as if the value is printed to a new
>>>>>>>>> position but not
>>>>>>>>>
>>>>>>>>>> removed
>>>>>>>>>>
>>>>>>>>>> from the
>>>>>>>>> previous one.
>>>>>>>>>
>>>>>>>>>> What can be the reason for this? Any suggestions for
>>>>>>>>>> how to address
>>>>>>>>>>
>>>>>>>>>> this problem
>>>>>>>>> is very appreciated. I'm working with Mac OS X 10.5.8
>>>>>>>>> and OO
>>>>>>>>>
>>>>>>>>>> 3.3.0 on a MBP.
>>>>>>>>>>
>>>>>>>>>> Thanks for reading Martin<snip>
>>>>>>>>>>
>>>>>>>>>>
>>>>>> Hi
>>>>> It doesn't sound only as a memory problem but rather like a
>>>>> graphic refreshing problem too, very often encountered by
>>>>> people who produce with OOo , even with very short documents.
>>>>>
>>>>> I've been experimenting this problem several times per week
>>>>> since i daily use OOo (2001) It was told to be a bug in VCL (?
>>>>> ?)
>>>>>
>>>>> We still have the same display refreshing bug in OOo4Kids and
>>>>> OOoLight anyway, this bug (because it's really an annoying bug
>>>>> ) was already described in various ways, for example in #82448
>>>>> which is typically well described , but you will find a bunch
>>>>> of issues about the same problem at
>>>>> https://issues.apache.org/ooo/ entering keywords containing
>>>>> "display" "refresh" ... see also issues #94852 ; #95505 ;
>>>>> etc...
>>>>>
>>>>>
>>>>> Fredjd
>>>>>
>>>>> Hi Fred, thanks for your feedback. It sounds as if your
>>>>> describing
>>>> exactly what I'm trying to fix. Good to hear its not exactly only
>>>> on my side and yes, I'm starting to have it in small documents as
>>>> well (cant call 150 used rows large, right?). I'll be checking
>>>> out your references, however, can you confirm any successful
>>>> fix?
>>>>
>>>> Martin
>>>>
>>>>
>>>>
>>> Hi Martin
>>>
>>> I'm not in dev team, just simple beta-tester and member of EducOOo,
>>> waiting for the next AOOo release to be out in order to test it.
>>> However imho this bug should be a priority for the next release
>>> because it touches every end user's UI. As soon as the AOOo release
>>> is out, dev will probably make an announcement on this list. I'll
>>> test whether this bug is still there and report the results on
>>> this list too.
>>>
>>> Fredjd
>>>
>>
>>
>> ---------------------------------------------------------------------
>>
>>
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>
>>
>>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Calc Table Display Errors
Posted by TJ Frazier <tj...@cfl.rr.com>.
On 11/5/2011 16:56, Martin Hediger wrote:
> Hi Fred, thanks for the background details. Do you have any kind of
> ETA? At the moment, my OO is not usable, but I need to handle
> spreadsheets somehow. I guess I'll have to switch to MS Office if the
> bug is not fixed soon.
>
> Martin
Quick thought: would the Redraw command (Ctrl+Shift+R) do any good? __/tj/
>
>
>
>
> Am 05.11.11 19:38, schrieb Fred Juan DIAZ:
>> 2011/11/5 Martin Hediger<ma...@bluewin.ch>
>>
>>> Am 04.11.11 21:58, schrieb Fred Juan DIAZ:
>>>
>>>> 2011/11/3 TJ Frazier<tj...@cfl.rr.com>
>>>>
>>>> On 11/3/2011 18:32, Terry wrote:
>>>>> Memory settings have been discussed on oooforum.org and on
>>>>> the new
>>>>>> community forum. A search should turn up suggested
>>>>>> settings; I have seen it mentioned several times. I think
>>>>>> you may have to experiment. This is one post on the new
>>>>>> forum:
>>>>>> http://user.services.**openoff**ice.org/en/forum/**<http://openoffice.org/en/forum/**>
>>>>>>
>>>>>>
>>>>>> viewtopic.php?f=9&t=32090#****p146893<http://user.services.**
>>>>>>
>>>>>>
openoffice.org/en/forum/**viewtopic.php?f=9&t=32090#**p146893<http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=32090#p146893>
>>>>>>
>>>>>>
>>>>>> Two things seem clear. First, reduce the number of undo
>>>>>> steps (the default, I recall, is 100) to, say 21. Secondly,
>>>>>> increase the size of the graphics cache to, say, 128 MB.
>>>>>> Open Office does seem to be a memory hog; it certainly
>>>>>> places a strain at times on my system and Andrew Pitonyak
>>>>>> has mentioned that the odt version of his macro document
>>>>>> causes OO to crash. I have seen reference to "memory
>>>>>> leaking" but don't know what that means.
>>>>>>
>>>>>>
>>>>>> Terry
>>>>>>
>>>>>> FYI:
>>>>>> http://en.wikipedia.org/wiki/****Memory_leak<http://en.wikipedia.org/wiki/**Memory_leak>
>>>>>>
>>>>>>
>>>>>> <http://en.**wikipedia.org/wiki/Memory_leak<http://en.wikipedia.org/wiki/Memory_leak>
>>>>>>
>>>>>>
>>>>>> **> --/tj/
>>>>>>
>>>>> ----- Original Message -----
>>>>>> From: Martin Hediger<ma...@bluewin.ch> To:
>>>>>>> ooo-users@incubator.apache.org Cc: Sent: Thursday, 3
>>>>>>> November 2011 10:07 PM Subject: Re: Calc Table Display
>>>>>>> Errors
>>>>>>>
>>>>>>> Hi The sheet is 31K in size. It only contains entries
>>>>>>> down to row around 150 and columns to Z, around 50 URLs
>>>>>>> are in some cells, as well as around 50 URLs to PDFs on
>>>>>>> my hard drive. I was thinking, could it be that I'm not
>>>>>>> assigning the correct amount of memory? This can be
>>>>>>> adjusted in the settings, i saw, but I cant find values
>>>>>>> that help. I think I started to have this problem only
>>>>>>> once i turned *off* anti-aliasing of fonts, because
>>>>>>> Openoffice Impress was having trouble handling a large A0
>>>>>>> poster.
>>>>>>>
>>>>>>> Any ideas are very welcomed. Martin
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Am 02.11.11 23:39, schrieb Terry:
>>>>>>>
>>>>>>> That sounds like a system problem rather than a software
>>>>>>> issue.
>>>>>>>> Try
>>>>>>>>
>>>>>>>> copying two sheets to a new file, then close all files
>>>>>>>> and exit the
>>>>>>> software. Then open the new file only and see whether the
>>>>>>> problem occurs in the new file. It may be that you are
>>>>>>> placing too great a load on your system.
>>>>>>>
>>>>>>> Terry
>>>>>>>>
>>>>>>>>
>>>>>>>> ----- Original Message -----
>>>>>>>>
>>>>>>>> From: Martin Hediger<ma...@bluewin.ch> To:
>>>>>>>>> ooo-users@incubator.apache.org Cc: Sent: Thursday, 3
>>>>>>>>> November 2011 3:24 AM Subject: Calc Table Display
>>>>>>>>> Errors
>>>>>>>>>
>>>>>>>>> Dear List I have a Calc spreadsheet open where a
>>>>>>>>> number of tables are used. However, it becomes hardly
>>>>>>>>> unusable, because when I switch between two
>>>>>>>>>
>>>>>>>>> tables
>>>>>>>> (using the tabs at the bottom of the windom), the
>>>>>>>> values from
>>>>>>>>
>>>>>>>>> the "new" table are printed on top of the "old"
>>>>>>>>> values.
>>>>>>>>>
>>>>>>>>> It becomes unreadable.
>>>>>>>> Also often when scrolling, values get "smeared" out all
>>>>>>>> over the table. Its as if the value is printed to a new
>>>>>>>> position but not
>>>>>>>>
>>>>>>>>> removed
>>>>>>>>>
>>>>>>>>> from the
>>>>>>>> previous one.
>>>>>>>>
>>>>>>>>> What can be the reason for this? Any suggestions for
>>>>>>>>> how to address
>>>>>>>>>
>>>>>>>>> this problem
>>>>>>>> is very appreciated. I'm working with Mac OS X 10.5.8
>>>>>>>> and OO
>>>>>>>>
>>>>>>>>> 3.3.0 on a MBP.
>>>>>>>>>
>>>>>>>>> Thanks for reading Martin<snip>
>>>>>>>>>
>>>>>>>>>
>>>>> Hi
>>>> It doesn't sound only as a memory problem but rather like a
>>>> graphic refreshing problem too, very often encountered by
>>>> people who produce with OOo , even with very short documents.
>>>>
>>>> I've been experimenting this problem several times per week
>>>> since i daily use OOo (2001) It was told to be a bug in VCL (?
>>>> ?)
>>>>
>>>> We still have the same display refreshing bug in OOo4Kids and
>>>> OOoLight anyway, this bug (because it's really an annoying bug
>>>> ) was already described in various ways, for example in #82448
>>>> which is typically well described , but you will find a bunch
>>>> of issues about the same problem at
>>>> https://issues.apache.org/ooo/ entering keywords containing
>>>> "display" "refresh" ... see also issues #94852 ; #95505 ;
>>>> etc...
>>>>
>>>>
>>>> Fredjd
>>>>
>>>> Hi Fred, thanks for your feedback. It sounds as if your
>>>> describing
>>> exactly what I'm trying to fix. Good to hear its not exactly only
>>> on my side and yes, I'm starting to have it in small documents as
>>> well (cant call 150 used rows large, right?). I'll be checking
>>> out your references, however, can you confirm any successful
>>> fix?
>>>
>>> Martin
>>>
>>>
>>>
>> Hi Martin
>>
>> I'm not in dev team, just simple beta-tester and member of EducOOo,
>> waiting for the next AOOo release to be out in order to test it.
>> However imho this bug should be a priority for the next release
>> because it touches every end user's UI. As soon as the AOOo release
>> is out, dev will probably make an announcement on this list. I'll
>> test whether this bug is still there and report the results on
>> this list too.
>>
>> Fredjd
>>
>
>
> ---------------------------------------------------------------------
>
>
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Calc Table Display Errors
Posted by Martin Hediger <ma...@bluewin.ch>.
Hi Fred, thanks for the background details.
Do you have any kind of ETA? At the moment, my OO is not usable, but I
need to handle spreadsheets somehow. I guess I'll have to switch to MS
Office if the bug is not fixed soon.
Martin
Am 05.11.11 19:38, schrieb Fred Juan DIAZ:
> 2011/11/5 Martin Hediger<ma...@bluewin.ch>
>
>> Am 04.11.11 21:58, schrieb Fred Juan DIAZ:
>>
>>> 2011/11/3 TJ Frazier<tj...@cfl.rr.com>
>>>
>>> On 11/3/2011 18:32, Terry wrote:
>>>> Memory settings have been discussed on oooforum.org and on the new
>>>>> community forum. A search should turn up suggested settings; I have
>>>>> seen it mentioned several times. I think you may have to experiment.
>>>>> This is one post on the new forum:
>>>>> http://user.services.**openoff**ice.org/en/forum/**<http://openoffice.org/en/forum/**>
>>>>> viewtopic.php?f=9&t=32090#****p146893<http://user.services.**
>>>>> openoffice.org/en/forum/**viewtopic.php?f=9&t=32090#**p146893<http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=32090#p146893>
>>>>>
>>>>> Two things seem clear. First, reduce the number of undo steps (the
>>>>> default, I recall, is 100) to, say 21. Secondly, increase the size
>>>>> of the graphics cache to, say, 128 MB. Open Office does seem to be a
>>>>> memory hog; it certainly places a strain at times on my system and
>>>>> Andrew Pitonyak has mentioned that the odt version of his macro
>>>>> document causes OO to crash. I have seen reference to "memory
>>>>> leaking" but don't know what that means.
>>>>>
>>>>>
>>>>> Terry
>>>>>
>>>>> FYI: http://en.wikipedia.org/wiki/****Memory_leak<http://en.wikipedia.org/wiki/**Memory_leak>
>>>>> <http://en.**wikipedia.org/wiki/Memory_leak<http://en.wikipedia.org/wiki/Memory_leak>
>>>>> **> --/tj/
>>>>>
>>>> ----- Original Message -----
>>>>> From: Martin Hediger<ma...@bluewin.ch> To:
>>>>>> ooo-users@incubator.apache.org Cc: Sent: Thursday, 3 November 2011
>>>>>> 10:07 PM Subject: Re: Calc Table Display Errors
>>>>>>
>>>>>> Hi The sheet is 31K in size. It only contains entries down to row
>>>>>> around 150 and columns to Z, around 50 URLs are in some cells, as
>>>>>> well as around 50 URLs to PDFs on my hard drive. I was thinking,
>>>>>> could it be that I'm not assigning the correct amount of memory?
>>>>>> This can be adjusted in the settings, i saw, but I cant find values
>>>>>> that help. I think I started to have this problem only once i
>>>>>> turned *off* anti-aliasing of fonts, because Openoffice Impress was
>>>>>> having trouble handling a large A0 poster.
>>>>>>
>>>>>> Any ideas are very welcomed. Martin
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> Am 02.11.11 23:39, schrieb Terry:
>>>>>>
>>>>>> That sounds like a system problem rather than a software issue.
>>>>>>> Try
>>>>>>>
>>>>>>> copying two sheets to a new file, then close all files and exit the
>>>>>> software. Then open the new file only and see whether the problem
>>>>>> occurs in the new file. It may be that you are placing too great a
>>>>>> load on your system.
>>>>>>
>>>>>> Terry
>>>>>>>
>>>>>>>
>>>>>>> ----- Original Message -----
>>>>>>>
>>>>>>> From: Martin Hediger<ma...@bluewin.ch> To:
>>>>>>>> ooo-users@incubator.apache.org Cc: Sent: Thursday, 3 November
>>>>>>>> 2011 3:24 AM Subject: Calc Table Display Errors
>>>>>>>>
>>>>>>>> Dear List I have a Calc spreadsheet open where a number of
>>>>>>>> tables are used. However, it becomes hardly unusable, because
>>>>>>>> when I switch between two
>>>>>>>>
>>>>>>>> tables
>>>>>>> (using the tabs at the bottom of the windom), the values from
>>>>>>>
>>>>>>>> the "new" table are printed on top of the "old" values.
>>>>>>>>
>>>>>>>> It becomes unreadable.
>>>>>>> Also often when scrolling, values get "smeared" out all over
>>>>>>> the
>>>>>>> table. Its as if the value is printed to a new position but not
>>>>>>>
>>>>>>>> removed
>>>>>>>>
>>>>>>>> from the
>>>>>>> previous one.
>>>>>>>
>>>>>>>> What can be the reason for this? Any suggestions for how to
>>>>>>>> address
>>>>>>>>
>>>>>>>> this problem
>>>>>>> is very appreciated. I'm working with Mac OS X 10.5.8 and OO
>>>>>>>
>>>>>>>> 3.3.0 on a MBP.
>>>>>>>>
>>>>>>>> Thanks for reading Martin<snip>
>>>>>>>>
>>>>>>>>
>>>> Hi
>>> It doesn't sound only as a memory problem but rather like a graphic
>>> refreshing problem too, very often encountered by people who produce with
>>> OOo , even with very short documents.
>>>
>>> I've been experimenting this problem several times per week since i daily
>>> use OOo (2001)
>>> It was told to be a bug in VCL (? ?)
>>>
>>> We still have the same display refreshing bug in OOo4Kids and OOoLight
>>> anyway, this bug (because it's really an annoying bug ) was already
>>> described in various ways,
>>> for example in #82448 which is typically well described ,
>>> but you will find a bunch of issues about the same problem
>>> at https://issues.apache.org/ooo/ entering keywords containing "display"
>>> "refresh" ...
>>> see also issues #94852 ; #95505 ; etc...
>>>
>>>
>>> Fredjd
>>>
>>> Hi Fred, thanks for your feedback. It sounds as if your describing
>> exactly what I'm trying to fix. Good to hear its not exactly only on my
>> side and yes, I'm starting to have it in small documents as well (cant call
>> 150 used rows large, right?).
>> I'll be checking out your references, however, can you confirm any
>> successful fix?
>>
>> Martin
>>
>>
>>
> Hi Martin
>
> I'm not in dev team, just simple beta-tester and member of EducOOo, waiting
> for the next AOOo release to be out in order to test it.
> However imho this bug should be a priority for the next release because it
> touches every end user's UI.
> As soon as the AOOo release is out, dev will probably make an announcement
> on this list.
> I'll test whether this bug is still there and report the results on this
> list too.
>
> Fredjd
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Calc Table Display Errors
Posted by Fred Juan DIAZ <fr...@gmail.com>.
2011/11/5 Martin Hediger <ma...@bluewin.ch>
> Am 04.11.11 21:58, schrieb Fred Juan DIAZ:
>
>> 2011/11/3 TJ Frazier<tj...@cfl.rr.com>
>>
>> On 11/3/2011 18:32, Terry wrote:
>>>
>>> Memory settings have been discussed on oooforum.org and on the new
>>>> community forum. A search should turn up suggested settings; I have
>>>> seen it mentioned several times. I think you may have to experiment.
>>>> This is one post on the new forum:
>>>> http://user.services.**openoff**ice.org/en/forum/**<http://openoffice.org/en/forum/**>
>>>> viewtopic.php?f=9&t=32090#****p146893<http://user.services.**
>>>> openoffice.org/en/forum/**viewtopic.php?f=9&t=32090#**p146893<http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=32090#p146893>
>>>> >
>>>>
>>>>
>>>> Two things seem clear. First, reduce the number of undo steps (the
>>>> default, I recall, is 100) to, say 21. Secondly, increase the size
>>>> of the graphics cache to, say, 128 MB. Open Office does seem to be a
>>>> memory hog; it certainly places a strain at times on my system and
>>>> Andrew Pitonyak has mentioned that the odt version of his macro
>>>> document causes OO to crash. I have seen reference to "memory
>>>> leaking" but don't know what that means.
>>>>
>>>>
>>>> Terry
>>>>
>>>> FYI: http://en.wikipedia.org/wiki/****Memory_leak<http://en.wikipedia.org/wiki/**Memory_leak>
>>>> <http://en.**wikipedia.org/wiki/Memory_leak<http://en.wikipedia.org/wiki/Memory_leak>
>>>> **> --/tj/
>>>>
>>>
>>> ----- Original Message -----
>>>>
>>>> From: Martin Hediger<ma...@bluewin.ch> To:
>>>>> ooo-users@incubator.apache.org Cc: Sent: Thursday, 3 November 2011
>>>>> 10:07 PM Subject: Re: Calc Table Display Errors
>>>>>
>>>>> Hi The sheet is 31K in size. It only contains entries down to row
>>>>> around 150 and columns to Z, around 50 URLs are in some cells, as
>>>>> well as around 50 URLs to PDFs on my hard drive. I was thinking,
>>>>> could it be that I'm not assigning the correct amount of memory?
>>>>> This can be adjusted in the settings, i saw, but I cant find values
>>>>> that help. I think I started to have this problem only once i
>>>>> turned *off* anti-aliasing of fonts, because Openoffice Impress was
>>>>> having trouble handling a large A0 poster.
>>>>>
>>>>> Any ideas are very welcomed. Martin
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Am 02.11.11 23:39, schrieb Terry:
>>>>>
>>>>> That sounds like a system problem rather than a software issue.
>>>>>> Try
>>>>>>
>>>>>> copying two sheets to a new file, then close all files and exit the
>>>>> software. Then open the new file only and see whether the problem
>>>>> occurs in the new file. It may be that you are placing too great a
>>>>> load on your system.
>>>>>
>>>>> Terry
>>>>>>
>>>>>>
>>>>>>
>>>>>> ----- Original Message -----
>>>>>>
>>>>>> From: Martin Hediger<ma...@bluewin.ch> To:
>>>>>>> ooo-users@incubator.apache.org Cc: Sent: Thursday, 3 November
>>>>>>> 2011 3:24 AM Subject: Calc Table Display Errors
>>>>>>>
>>>>>>> Dear List I have a Calc spreadsheet open where a number of
>>>>>>> tables are used. However, it becomes hardly unusable, because
>>>>>>> when I switch between two
>>>>>>>
>>>>>>> tables
>>>>>> (using the tabs at the bottom of the windom), the values from
>>>>>>
>>>>>>> the "new" table are printed on top of the "old" values.
>>>>>>>
>>>>>>> It becomes unreadable.
>>>>>> Also often when scrolling, values get "smeared" out all over
>>>>>> the
>>>>>> table. Its as if the value is printed to a new position but not
>>>>>>
>>>>>>> removed
>>>>>>>
>>>>>>> from the
>>>>>> previous one.
>>>>>>
>>>>>>> What can be the reason for this? Any suggestions for how to
>>>>>>> address
>>>>>>>
>>>>>>> this problem
>>>>>> is very appreciated. I'm working with Mac OS X 10.5.8 and OO
>>>>>>
>>>>>>> 3.3.0 on a MBP.
>>>>>>>
>>>>>>> Thanks for reading Martin<snip>
>>>>>>>
>>>>>>>
>>>
>>> Hi
>>
>> It doesn't sound only as a memory problem but rather like a graphic
>> refreshing problem too, very often encountered by people who produce with
>> OOo , even with very short documents.
>>
>> I've been experimenting this problem several times per week since i daily
>> use OOo (2001)
>> It was told to be a bug in VCL (? ?)
>>
>> We still have the same display refreshing bug in OOo4Kids and OOoLight
>> anyway, this bug (because it's really an annoying bug ) was already
>> described in various ways,
>> for example in #82448 which is typically well described ,
>> but you will find a bunch of issues about the same problem
>> at https://issues.apache.org/ooo/ entering keywords containing "display"
>> "refresh" ...
>> see also issues #94852 ; #95505 ; etc...
>>
>>
>> Fredjd
>>
>> Hi Fred, thanks for your feedback. It sounds as if your describing
> exactly what I'm trying to fix. Good to hear its not exactly only on my
> side and yes, I'm starting to have it in small documents as well (cant call
> 150 used rows large, right?).
> I'll be checking out your references, however, can you confirm any
> successful fix?
>
> Martin
>
>
>
Hi Martin
I'm not in dev team, just simple beta-tester and member of EducOOo, waiting
for the next AOOo release to be out in order to test it.
However imho this bug should be a priority for the next release because it
touches every end user's UI.
As soon as the AOOo release is out, dev will probably make an announcement
on this list.
I'll test whether this bug is still there and report the results on this
list too.
Fredjd
Re: Calc Table Display Errors
Posted by Martin Hediger <ma...@bluewin.ch>.
Am 04.11.11 21:58, schrieb Fred Juan DIAZ:
> 2011/11/3 TJ Frazier<tj...@cfl.rr.com>
>
>> On 11/3/2011 18:32, Terry wrote:
>>
>>> Memory settings have been discussed on oooforum.org and on the new
>>> community forum. A search should turn up suggested settings; I have
>>> seen it mentioned several times. I think you may have to experiment.
>>> This is one post on the new forum:
>>> http://user.services.**openoffice.org/en/forum/**
>>> viewtopic.php?f=9&t=32090#**p146893<http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=32090#p146893>
>>>
>>> Two things seem clear. First, reduce the number of undo steps (the
>>> default, I recall, is 100) to, say 21. Secondly, increase the size
>>> of the graphics cache to, say, 128 MB. Open Office does seem to be a
>>> memory hog; it certainly places a strain at times on my system and
>>> Andrew Pitonyak has mentioned that the odt version of his macro
>>> document causes OO to crash. I have seen reference to "memory
>>> leaking" but don't know what that means.
>>>
>>>
>>> Terry
>>>
>>> FYI: http://en.wikipedia.org/wiki/**Memory_leak<http://en.wikipedia.org/wiki/Memory_leak> --/tj/
>>
>>> ----- Original Message -----
>>>
>>>> From: Martin Hediger<ma...@bluewin.ch> To:
>>>> ooo-users@incubator.apache.org Cc: Sent: Thursday, 3 November 2011
>>>> 10:07 PM Subject: Re: Calc Table Display Errors
>>>>
>>>> Hi The sheet is 31K in size. It only contains entries down to row
>>>> around 150 and columns to Z, around 50 URLs are in some cells, as
>>>> well as around 50 URLs to PDFs on my hard drive. I was thinking,
>>>> could it be that I'm not assigning the correct amount of memory?
>>>> This can be adjusted in the settings, i saw, but I cant find values
>>>> that help. I think I started to have this problem only once i
>>>> turned *off* anti-aliasing of fonts, because Openoffice Impress was
>>>> having trouble handling a large A0 poster.
>>>>
>>>> Any ideas are very welcomed. Martin
>>>>
>>>>
>>>>
>>>>
>>>> Am 02.11.11 23:39, schrieb Terry:
>>>>
>>>>> That sounds like a system problem rather than a software issue.
>>>>> Try
>>>>>
>>>> copying two sheets to a new file, then close all files and exit the
>>>> software. Then open the new file only and see whether the problem
>>>> occurs in the new file. It may be that you are placing too great a
>>>> load on your system.
>>>>
>>>>> Terry
>>>>>
>>>>>
>>>>>
>>>>> ----- Original Message -----
>>>>>
>>>>>> From: Martin Hediger<ma...@bluewin.ch> To:
>>>>>> ooo-users@incubator.apache.org Cc: Sent: Thursday, 3 November
>>>>>> 2011 3:24 AM Subject: Calc Table Display Errors
>>>>>>
>>>>>> Dear List I have a Calc spreadsheet open where a number of
>>>>>> tables are used. However, it becomes hardly unusable, because
>>>>>> when I switch between two
>>>>>>
>>>>> tables
>>>>> (using the tabs at the bottom of the windom), the values from
>>>>>> the "new" table are printed on top of the "old" values.
>>>>>>
>>>>> It becomes unreadable.
>>>>> Also often when scrolling, values get "smeared" out all over
>>>>> the
>>>>> table. Its as if the value is printed to a new position but not
>>>>>> removed
>>>>>>
>>>>> from the
>>>>> previous one.
>>>>>> What can be the reason for this? Any suggestions for how to
>>>>>> address
>>>>>>
>>>>> this problem
>>>>> is very appreciated. I'm working with Mac OS X 10.5.8 and OO
>>>>>> 3.3.0 on a MBP.
>>>>>>
>>>>>> Thanks for reading Martin<snip>
>>>>>>
>>
>>
> Hi
>
> It doesn't sound only as a memory problem but rather like a graphic
> refreshing problem too, very often encountered by people who produce with
> OOo , even with very short documents.
>
> I've been experimenting this problem several times per week since i daily
> use OOo (2001)
> It was told to be a bug in VCL (? ?)
>
> We still have the same display refreshing bug in OOo4Kids and OOoLight
> anyway, this bug (because it's really an annoying bug ) was already
> described in various ways,
> for example in #82448 which is typically well described ,
> but you will find a bunch of issues about the same problem
> at https://issues.apache.org/ooo/ entering keywords containing "display"
> "refresh" ...
> see also issues #94852 ; #95505 ; etc...
>
>
> Fredjd
>
Hi Fred, thanks for your feedback. It sounds as if your describing
exactly what I'm trying to fix. Good to hear its not exactly only on my
side and yes, I'm starting to have it in small documents as well (cant
call 150 used rows large, right?).
I'll be checking out your references, however, can you confirm any
successful fix?
Martin
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Calc Table Display Errors
Posted by Fred Juan DIAZ <fr...@gmail.com>.
2011/11/3 TJ Frazier <tj...@cfl.rr.com>
> On 11/3/2011 18:32, Terry wrote:
>
>> Memory settings have been discussed on oooforum.org and on the new
>> community forum. A search should turn up suggested settings; I have
>> seen it mentioned several times. I think you may have to experiment.
>> This is one post on the new forum:
>> http://user.services.**openoffice.org/en/forum/**
>> viewtopic.php?f=9&t=32090#**p146893<http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=32090#p146893>
>>
>> Two things seem clear. First, reduce the number of undo steps (the
>> default, I recall, is 100) to, say 21. Secondly, increase the size
>> of the graphics cache to, say, 128 MB. Open Office does seem to be a
>> memory hog; it certainly places a strain at times on my system and
>> Andrew Pitonyak has mentioned that the odt version of his macro
>> document causes OO to crash. I have seen reference to "memory
>> leaking" but don't know what that means.
>>
>>
>> Terry
>>
>> FYI: http://en.wikipedia.org/wiki/**Memory_leak<http://en.wikipedia.org/wiki/Memory_leak> --/tj/
>
>
>>
>> ----- Original Message -----
>>
>>> From: Martin Hediger<ma...@bluewin.ch> To:
>>> ooo-users@incubator.apache.org Cc: Sent: Thursday, 3 November 2011
>>> 10:07 PM Subject: Re: Calc Table Display Errors
>>>
>>> Hi The sheet is 31K in size. It only contains entries down to row
>>> around 150 and columns to Z, around 50 URLs are in some cells, as
>>> well as around 50 URLs to PDFs on my hard drive. I was thinking,
>>> could it be that I'm not assigning the correct amount of memory?
>>> This can be adjusted in the settings, i saw, but I cant find values
>>> that help. I think I started to have this problem only once i
>>> turned *off* anti-aliasing of fonts, because Openoffice Impress was
>>> having trouble handling a large A0 poster.
>>>
>>> Any ideas are very welcomed. Martin
>>>
>>>
>>>
>>>
>>> Am 02.11.11 23:39, schrieb Terry:
>>>
>>>> That sounds like a system problem rather than a software issue.
>>>> Try
>>>>
>>> copying two sheets to a new file, then close all files and exit the
>>> software. Then open the new file only and see whether the problem
>>> occurs in the new file. It may be that you are placing too great a
>>> load on your system.
>>>
>>>>
>>>> Terry
>>>>
>>>>
>>>>
>>>> ----- Original Message -----
>>>>
>>>>> From: Martin Hediger<ma...@bluewin.ch> To:
>>>>> ooo-users@incubator.apache.org Cc: Sent: Thursday, 3 November
>>>>> 2011 3:24 AM Subject: Calc Table Display Errors
>>>>>
>>>>> Dear List I have a Calc spreadsheet open where a number of
>>>>> tables are used. However, it becomes hardly unusable, because
>>>>> when I switch between two
>>>>>
>>>> tables
>>>
>>>> (using the tabs at the bottom of the windom), the values from
>>>>> the "new" table are printed on top of the "old" values.
>>>>>
>>>> It becomes unreadable.
>>>
>>>> Also often when scrolling, values get "smeared" out all over
>>>>>
>>>> the
>>>
>>>> table. Its as if the value is printed to a new position but not
>>>>> removed
>>>>>
>>>> from the
>>>
>>>> previous one.
>>>>>
>>>>> What can be the reason for this? Any suggestions for how to
>>>>> address
>>>>>
>>>> this problem
>>>
>>>> is very appreciated. I'm working with Mac OS X 10.5.8 and OO
>>>>> 3.3.0 on a MBP.
>>>>>
>>>>> Thanks for reading Martin <snip>
>>>>>
>>>>
>
>
>
Hi
It doesn't sound only as a memory problem but rather like a graphic
refreshing problem too, very often encountered by people who produce with
OOo , even with very short documents.
I've been experimenting this problem several times per week since i daily
use OOo (2001)
It was told to be a bug in VCL (? ?)
We still have the same display refreshing bug in OOo4Kids and OOoLight
anyway, this bug (because it's really an annoying bug ) was already
described in various ways,
for example in #82448 which is typically well described ,
but you will find a bunch of issues about the same problem
at https://issues.apache.org/ooo/ entering keywords containing "display"
"refresh" ...
see also issues #94852 ; #95505 ; etc...
Fredjd
Re: Calc Table Display Errors
Posted by TJ Frazier <tj...@cfl.rr.com>.
On 11/3/2011 18:32, Terry wrote:
> Memory settings have been discussed on oooforum.org and on the new
> community forum. A search should turn up suggested settings; I have
> seen it mentioned several times. I think you may have to experiment.
> This is one post on the new forum:
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=32090#p146893
>
> Two things seem clear. First, reduce the number of undo steps (the
> default, I recall, is 100) to, say 21. Secondly, increase the size
> of the graphics cache to, say, 128 MB. Open Office does seem to be a
> memory hog; it certainly places a strain at times on my system and
> Andrew Pitonyak has mentioned that the odt version of his macro
> document causes OO to crash. I have seen reference to "memory
> leaking" but don't know what that means.
>
>
> Terry
>
FYI: http://en.wikipedia.org/wiki/Memory_leak --/tj/
>
>
> ----- Original Message -----
>> From: Martin Hediger<ma...@bluewin.ch> To:
>> ooo-users@incubator.apache.org Cc: Sent: Thursday, 3 November 2011
>> 10:07 PM Subject: Re: Calc Table Display Errors
>>
>> Hi The sheet is 31K in size. It only contains entries down to row
>> around 150 and columns to Z, around 50 URLs are in some cells, as
>> well as around 50 URLs to PDFs on my hard drive. I was thinking,
>> could it be that I'm not assigning the correct amount of memory?
>> This can be adjusted in the settings, i saw, but I cant find values
>> that help. I think I started to have this problem only once i
>> turned *off* anti-aliasing of fonts, because Openoffice Impress was
>> having trouble handling a large A0 poster.
>>
>> Any ideas are very welcomed. Martin
>>
>>
>>
>>
>> Am 02.11.11 23:39, schrieb Terry:
>>> That sounds like a system problem rather than a software issue.
>>> Try
>> copying two sheets to a new file, then close all files and exit the
>> software. Then open the new file only and see whether the problem
>> occurs in the new file. It may be that you are placing too great a
>> load on your system.
>>>
>>> Terry
>>>
>>>
>>>
>>> ----- Original Message -----
>>>> From: Martin Hediger<ma...@bluewin.ch> To:
>>>> ooo-users@incubator.apache.org Cc: Sent: Thursday, 3 November
>>>> 2011 3:24 AM Subject: Calc Table Display Errors
>>>>
>>>> Dear List I have a Calc spreadsheet open where a number of
>>>> tables are used. However, it becomes hardly unusable, because
>>>> when I switch between two
>> tables
>>>> (using the tabs at the bottom of the windom), the values from
>>>> the "new" table are printed on top of the "old" values.
>> It becomes unreadable.
>>>> Also often when scrolling, values get "smeared" out all over
>> the
>>>> table. Its as if the value is printed to a new position but not
>>>> removed
>> from the
>>>> previous one.
>>>>
>>>> What can be the reason for this? Any suggestions for how to
>>>> address
>> this problem
>>>> is very appreciated. I'm working with Mac OS X 10.5.8 and OO
>>>> 3.3.0 on a MBP.
>>>>
>>>> Thanks for reading Martin <snip>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Calc Table Display Errors
Posted by Terry <te...@yahoo.com.au>.
Memory settings have been discussed on oooforum.org and on the new community forum. A search should turn up suggested settings; I have seen it mentioned several times.
I think you may have to experiment. This is one post on the new forum: http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=32090#p146893
Two things seem clear. First, reduce the number of undo steps (the default, I recall, is 100) to, say 21. Secondly, increase the size of the graphics cache to, say, 128 MB. Open Office does seem to be a memory hog; it certainly places a strain at times on my system and Andrew Pitonyak has mentioned that the odt version of his macro document causes OO to crash. I have seen reference to "memory leaking" but don't know what that means.
Terry
----- Original Message -----
> From: Martin Hediger <ma...@bluewin.ch>
> To: ooo-users@incubator.apache.org
> Cc:
> Sent: Thursday, 3 November 2011 10:07 PM
> Subject: Re: Calc Table Display Errors
>
> Hi
> The sheet is 31K in size. It only contains entries down to row around
> 150 and columns to Z, around 50 URLs are in some cells, as well as
> around 50 URLs to PDFs on my hard drive.
> I was thinking, could it be that I'm not assigning the correct amount of
> memory? This can be adjusted in the settings, i saw, but I cant find
> values that help.
> I think I started to have this problem only once i turned *off*
> anti-aliasing of fonts, because Openoffice Impress was having trouble
> handling a large A0 poster.
>
> Any ideas are very welcomed.
> Martin
>
>
>
>
> Am 02.11.11 23:39, schrieb Terry:
>> That sounds like a system problem rather than a software issue. Try
> copying two sheets to a new file, then close all files and exit the software.
> Then open the new file only and see whether the problem occurs in the new file.
> It may be that you are placing too great a load on your system.
>>
>> Terry
>>
>>
>>
>> ----- Original Message -----
>>> From: Martin Hediger<ma...@bluewin.ch>
>>> To: ooo-users@incubator.apache.org
>>> Cc:
>>> Sent: Thursday, 3 November 2011 3:24 AM
>>> Subject: Calc Table Display Errors
>>>
>>> Dear List
>>> I have a Calc spreadsheet open where a number of tables are used.
>>> However, it becomes hardly unusable, because when I switch between two
> tables
>>> (using the tabs at the bottom of the windom), the values from the
>>> "new" table are printed on top of the "old" values.
> It becomes unreadable.
>>> Also often when scrolling, values get "smeared" out all over
> the
>>> table. Its as if the value is printed to a new position but not removed
> from the
>>> previous one.
>>>
>>> What can be the reason for this? Any suggestions for how to address
> this problem
>>> is very appreciated.
>>> I'm working with Mac OS X 10.5.8 and OO 3.3.0 on a MBP.
>>>
>>> Thanks for reading
>>> Martin
>>> <snip>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Calc Table Display Errors
Posted by Martin Hediger <ma...@bluewin.ch>.
Hi
The sheet is 31K in size. It only contains entries down to row around
150 and columns to Z, around 50 URLs are in some cells, as well as
around 50 URLs to PDFs on my hard drive.
I was thinking, could it be that I'm not assigning the correct amount of
memory? This can be adjusted in the settings, i saw, but I cant find
values that help.
I think I started to have this problem only once i turned *off*
anti-aliasing of fonts, because Openoffice Impress was having trouble
handling a large A0 poster.
Any ideas are very welcomed.
Martin
Am 02.11.11 23:39, schrieb Terry:
> That sounds like a system problem rather than a software issue. Try copying two sheets to a new file, then close all files and exit the software. Then open the new file only and see whether the problem occurs in the new file. It may be that you are placing too great a load on your system.
>
> Terry
>
>
>
> ----- Original Message -----
>> From: Martin Hediger<ma...@bluewin.ch>
>> To: ooo-users@incubator.apache.org
>> Cc:
>> Sent: Thursday, 3 November 2011 3:24 AM
>> Subject: Calc Table Display Errors
>>
>> Dear List
>> I have a Calc spreadsheet open where a number of tables are used.
>> However, it becomes hardly unusable, because when I switch between two tables
>> (using the tabs at the bottom of the windom), the values from the
>> "new" table are printed on top of the "old" values. It becomes unreadable.
>> Also often when scrolling, values get "smeared" out all over the
>> table. Its as if the value is printed to a new position but not removed from the
>> previous one.
>>
>> What can be the reason for this? Any suggestions for how to address this problem
>> is very appreciated.
>> I'm working with Mac OS X 10.5.8 and OO 3.3.0 on a MBP.
>>
>> Thanks for reading
>> Martin
>> <snip>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Calc Table Display Errors
Posted by Terry <te...@yahoo.com.au>.
That sounds like a system problem rather than a software issue. Try copying two sheets to a new file, then close all files and exit the software. Then open the new file only and see whether the problem occurs in the new file. It may be that you are placing too great a load on your system.
Terry
----- Original Message -----
> From: Martin Hediger <ma...@bluewin.ch>
> To: ooo-users@incubator.apache.org
> Cc:
> Sent: Thursday, 3 November 2011 3:24 AM
> Subject: Calc Table Display Errors
>
> Dear List
> I have a Calc spreadsheet open where a number of tables are used.
> However, it becomes hardly unusable, because when I switch between two tables
> (using the tabs at the bottom of the windom), the values from the
> "new" table are printed on top of the "old" values. It becomes unreadable.
> Also often when scrolling, values get "smeared" out all over the
> table. Its as if the value is printed to a new position but not removed from the
> previous one.
>
> What can be the reason for this? Any suggestions for how to address this problem
> is very appreciated.
> I'm working with Mac OS X 10.5.8 and OO 3.3.0 on a MBP.
>
> Thanks for reading
> Martin
> <snip>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Calc Table Display Errors
Posted by Martin Hediger <ma...@bluewin.ch>.
Dear List
I have a Calc spreadsheet open where a number of tables are used.
However, it becomes hardly unusable, because when I switch between two
tables (using the tabs at the bottom of the windom), the values from the
"new" table are printed on top of the "old" values. It becomes unreadable.
Also often when scrolling, values get "smeared" out all over the table.
Its as if the value is printed to a new position but not removed from
the previous one.
What can be the reason for this? Any suggestions for how to address this
problem is very appreciated.
I'm working with Mac OS X 10.5.8 and OO 3.3.0 on a MBP.
Thanks for reading
Martin
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Question Replace Path in Calc
Posted by Rob Weir <ro...@apache.org>.
On Wed, Nov 2, 2011 at 5:59 AM, Terry <te...@yahoo.com.au> wrote:
> Use the Find and Replace tool. If you do not have a toolbar icon, it is in the menu 'Edit' (Ctrl + F).
>
> When the dialogue opens, press the button on the bottom left labelled "More Options." Make sure it says to search in 'Formulae' (an anachronism meaning formulas). Enter the wording you want to replace under "Search for" and enter the new wording under "Replace with."
>
That's a good solution. Another approach is to use Calc's text
functions to calculate the new path. This can work for more
complicated examples.
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Text_functions
LEFT(), RIGHT(), REPLACE(), FIND(), SEARCH(), CONCATENATE() are useful for this.
-rob
> Regards.
>
> ----- Original Message -----
>> From: Martin Hediger <ma...@bluewin.ch>
>> To: ooo-users@incubator.apache.org
>> Cc:
>> Sent: Wednesday, 2 November 2011 7:58 PM
>> Subject: Question Replace Path in Calc
>>
>> Dear List
>> I maintain a little database about some results from published experiments in a
>> calc spreadsheet. To be able to conveniently view the publication reporting a
>> specific experimental value, I included links to PDFs on my local machine, such
>> that I can just hit the link and open the PDF if I need to recall some details
>> about an experimental value. Something like this:
>>
>> Energy Name PDF
>> 3.141 C3PO /Users/me/data/c3po.pdf
>> 2.718 R2D2 /Users/me/data/r2d2.pdf
>> [...]
>>
>>
>>
>> Now, I had to adjust the directory structure, and so the links are not exactly
>> correct anymore. The path would now be /Users/me/project/data/*pdf.
>> How can I adjust the links to this new path? I tried "Spelling, F7",
>> but it only gives suggestions for the Names, not the links.
>>
>> Any suggestions are appreciated.
>>
>> Martin
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
>> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Question Replace Path in Calc
Posted by Terry <te...@yahoo.com.au>.
Use the Find and Replace tool. If you do not have a toolbar icon, it is in the menu 'Edit' (Ctrl + F).
When the dialogue opens, press the button on the bottom left labelled "More Options." Make sure it says to search in 'Formulae' (an anachronism meaning formulas). Enter the wording you want to replace under "Search for" and enter the new wording under "Replace with."
Regards.
----- Original Message -----
> From: Martin Hediger <ma...@bluewin.ch>
> To: ooo-users@incubator.apache.org
> Cc:
> Sent: Wednesday, 2 November 2011 7:58 PM
> Subject: Question Replace Path in Calc
>
> Dear List
> I maintain a little database about some results from published experiments in a
> calc spreadsheet. To be able to conveniently view the publication reporting a
> specific experimental value, I included links to PDFs on my local machine, such
> that I can just hit the link and open the PDF if I need to recall some details
> about an experimental value. Something like this:
>
> Energy Name PDF
> 3.141 C3PO /Users/me/data/c3po.pdf
> 2.718 R2D2 /Users/me/data/r2d2.pdf
> [...]
>
>
>
> Now, I had to adjust the directory structure, and so the links are not exactly
> correct anymore. The path would now be /Users/me/project/data/*pdf.
> How can I adjust the links to this new path? I tried "Spelling, F7",
> but it only gives suggestions for the Names, not the links.
>
> Any suggestions are appreciated.
>
> Martin
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org