Re: Scrolling within excel spreadsheets.
Just fun: If shifting from socialism to capitalism mean something to you, pay good attention. 2014-06-11 2:31 GMT+08:00 johnny smith : > On Tue, 10 Jun 2014 17:54:06 -, Simon Harrison < > simonharrison...@gmail.com> wrote: > > For some reason since the last update when scrolling left or right within >> spread sheet pages the screen only ever moves to the right. Not sure if >> this is a bug in the program or a glitch in my mouse. >> > > it is a bug. more information here: > > https://issues.apache.org/ooo/show_bug.cgi?id=124191 > > solutions here: > > https://issues.apache.org/ooo/show_bug.cgi?id=124191#c11 > https://issues.apache.org/ooo/show_bug.cgi?id=124191#c21 > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > >
How to prevent very long text in a cell overlap the footer in Calc?
Hi I'm using OpenOffice 4.1.0 ( Windows 7 with traditional Chinese ). When I enter lots of text in a cell in Calc so that it excess the height of a page, it overlaps with the page footer. How do I prevent it? Thanks. Calc Very long text overlap with page footer.ods Description: application/vnd.oasis.opendocument.spreadsheet - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: How to prevent very long text in a cell overlap the footer in Calc?
At 23:34 11/06/2014 +0800, Hung Mark wrote: I'm using OpenOffice 4.1.0 ( Windows 7 with traditional Chinese ). When I enter lots of text in a cell in Calc so that it excess the height of a page, it overlaps with the page footer. I'm not sure what you are hoping to happen here. Surely the nature of a spreadsheet - usually containing values, whether they be numbers, text, etc, to be processed - is that you would not want a single cell to be split across pages. If a multi-line cell would otherwise be split across pages, it is moved wholesale to the next page, but that cannot solve the problem if, as you have contrived, a single cell exceeds the page length. How do I prevent it? o Change the font size. o Go to Format | Cells... | Alignment | Properties, remove the tick from "Wrap text automatically", and tick "Shrink to fit cell size". o Distribute the material between two cells. o Use a text (Writer) document instead. A table may be useful. o Use a spreadsheet but transfer the material to a text document for final formatting. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: How to prevent very long text in a cell overlap the footer in Calc?
Hi Brian, Thank you for the advices, but I expect that textflow to stop before the page footer and start from next page instead of covering over the page number. That's what I'm asking for help. I use it in a way as a form to collect opinions from other people and append new text. ( like issue tracking ) I believe this is not an unusual case of spreadsheet usage and using writer arise other inconvenience despite it solves formatting problem. 2014/6/12 上午12:42 於 "Brian Barker" 寫道: > At 23:34 11/06/2014 +0800, Hung Mark wrote: > >> I'm using OpenOffice 4.1.0 ( Windows 7 with traditional Chinese ). When I >> enter lots of text in a cell in Calc so that it excess the height of a >> page, it overlaps with the page footer. >> > > I'm not sure what you are hoping to happen here. Surely the nature of a > spreadsheet - usually containing values, whether they be numbers, text, > etc, to be processed - is that you would not want a single cell to be split > across pages. If a multi-line cell would otherwise be split across pages, > it is moved wholesale to the next page, but that cannot solve the problem > if, as you have contrived, a single cell exceeds the page length. > > How do I prevent it? >> > > o Change the font size. > o Go to Format | Cells... | Alignment | Properties, remove the tick from > "Wrap text automatically", and tick "Shrink to fit cell size". > o Distribute the material between two cells. > o Use a text (Writer) document instead. A table may be useful. > o Use a spreadsheet but transfer the material to a text document for final > formatting. > > I trust this helps. > > Brian Barker > > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > >
Open office support question
can you or someone you know help me with this issue in open office I cant open my documents on my PC HP computer. it was working than stopped. I use Open office 4.1 I tried to uninstall it and reinstall but when I do that the computer says I need to exit open office and quickstarter to do that. I dont know how to do that? I have all documents closed. how would I close open office and quickstarter in order to unistall? many thanks Richard tel; 213-369-6603 311 No. Robertson Blvd. # 288 Beverly Hills, CA 90211 Tel: 323.658.9180
Re: Open office support question
What OS are you using, Richard? Buck PS - It is not a good idea to put personal info on a forum regardless of whose it is. -Original Message- From: Richard Kerner Sent: Wednesday, June 11, 2014 1:01 PM To: users@openoffice.apache.org Subject: Open office support question can you or someone you know help me with this issue in open office I cant open my documents on my PC HP computer. it was working than stopped. I use Open office 4.1 I tried to uninstall it and reinstall but when I do that the computer says I need to exit open office and quickstarter to do that. I dont know how to do that? I have all documents closed. how would I close open office and quickstarter in order to unistall? many thanks Richard tel; 213-369-6603 311 No. Robertson Blvd. # 288 Beverly Hills, CA 90211 Tel: 323.658.9180 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: How to prevent very long text in a cell overlap the footer in Calc?
Sent from my mobile device. > On 12 Jun 2014, at 4:02 am, Hung Mark wrote: > > Hi Brian, > > Thank you for the advices, but I expect that textflow to stop before the > page footer and start from next page instead of covering over the page > number. That's what I'm asking for help. You can,t fill a 10 liter bucket with 11 liter water. > I use it in a way as a form to collect opinions from other people and > append new text. ( like issue tracking ) I believe this is not an unusual > case of spreadsheet usage Yes it is unusual, what you try to do is driving a screw in the wall wit a hamer. > and using writer arise other inconvenience > despite it solves formatting problem. >> 2014/6/12 上午12:42 於 "Brian Barker" 寫道: >> >> At 23:34 11/06/2014 +0800, Hung Mark wrote: >> >>> I'm using OpenOffice 4.1.0 ( Windows 7 with traditional Chinese ). When I >>> enter lots of text in a cell in Calc so that it excess the height of a >>> page, it overlaps with the page footer. >> >> I'm not sure what you are hoping to happen here. Surely the nature of a >> spreadsheet - usually containing values, whether they be numbers, text, >> etc, to be processed - is that you would not want a single cell to be split >> across pages. If a multi-line cell would otherwise be split across pages, >> it is moved wholesale to the next page, but that cannot solve the problem >> if, as you have contrived, a single cell exceeds the page length. >> >> How do I prevent it? >> >> o Change the font size. >> o Go to Format | Cells... | Alignment | Properties, remove the tick from >> "Wrap text automatically", and tick "Shrink to fit cell size". >> o Distribute the material between two cells. >> o Use a text (Writer) document instead. A table may be useful. >> o Use a spreadsheet but transfer the material to a text document for final >> formatting. >> >> I trust this helps. >> >> Brian Barker >> >> >> - >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org >> For additional commands, e-mail: users-h...@openoffice.apache.org >> >> - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: How to prevent very long text in a cell overlap the footer in Calc?
If this forum is to be a meaningful source of shared knowledge, no matter what skill level or ability the poster has, there must be respect and and decorum. If a poster has a question to ask, there may be many others seeking the same or similar solution. If you can't contribute to the body of knowledge, then don't reply at all. Allowing such remarks is off putting to others, enough to prevent someone from future contributions or asking of help. IMHO, Rochelle On Wed, Jun 11, 2014 at 11:48 AM, Martin Groenescheij < mar...@groenescheij.com> wrote: > > > Sent from my mobile device. > > > On 12 Jun 2014, at 4:02 am, Hung Mark wrote: > > > > Hi Brian, > > > > Thank you for the advices, but I expect that textflow to stop before the > > page footer and start from next page instead of covering over the page > > number. That's what I'm asking for help. > > You can,t fill a 10 liter bucket with 11 liter water. > > > I use it in a way as a form to collect opinions from other people and > > append new text. ( like issue tracking ) I believe this is not an unusual > > case of spreadsheet usage > > Yes it is unusual, what you try to do is driving a screw in the wall wit a > hamer. > > > and using writer arise other inconvenience > > despite it solves formatting problem. > >> 2014/6/12 上午12:42 於 "Brian Barker" 寫道: > >> > >> At 23:34 11/06/2014 +0800, Hung Mark wrote: > >> > >>> I'm using OpenOffice 4.1.0 ( Windows 7 with traditional Chinese ). > When I > >>> enter lots of text in a cell in Calc so that it excess the height of a > >>> page, it overlaps with the page footer. > >> > >> I'm not sure what you are hoping to happen here. Surely the nature of a > >> spreadsheet - usually containing values, whether they be numbers, text, > >> etc, to be processed - is that you would not want a single cell to be > split > >> across pages. If a multi-line cell would otherwise be split across > pages, > >> it is moved wholesale to the next page, but that cannot solve the > problem > >> if, as you have contrived, a single cell exceeds the page length. > >> > >> How do I prevent it? > >> > >> o Change the font size. > >> o Go to Format | Cells... | Alignment | Properties, remove the tick from > >> "Wrap text automatically", and tick "Shrink to fit cell size". > >> o Distribute the material between two cells. > >> o Use a text (Writer) document instead. A table may be useful. > >> o Use a spreadsheet but transfer the material to a text document for > final > >> formatting. > >> > >> I trust this helps. > >> > >> Brian Barker > >> > >> > >> - > >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > >> For additional commands, e-mail: users-h...@openoffice.apache.org > >> > >> > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > >
Re: How to prevent very long text in a cell overlap the footer in Calc?
On 12-6-2014 11:39, Rochelle wrote: If this forum is to be a meaningful source of shared knowledge, no matter what skill level or ability the poster has, there must be respect and and decorum. If a poster has a question to ask, there may be many others seeking the same or similar solution. The poster got an decent answer from Brian Barker but he _insisted_ to use a spreadsheet for something it is not designed for. All I wanted to make clear is that you can't go outside of the specification without consequences. If you can't contribute to the body of knowledge, then don't reply at all. My contribution here is to help the poster to see that his request is unreasonable, but if you have a solution feel free to share it with us. Allowing such remarks is off putting to others, enough to prevent someone from future contributions or asking of help. IMHO, Rochelle On Wed, Jun 11, 2014 at 11:48 AM, Martin Groenescheij < mar...@groenescheij.com> wrote: Sent from my mobile device. On 12 Jun 2014, at 4:02 am, Hung Mark wrote: Hi Brian, Thank you for the advices, but I expect that textflow to stop before the page footer and start from next page instead of covering over the page number. That's what I'm asking for help. You can,t fill a 10 liter bucket with 11 liter water. I use it in a way as a form to collect opinions from other people and append new text. ( like issue tracking ) I believe this is not an unusual case of spreadsheet usage Yes it is unusual, what you try to do is driving a screw in the wall wit a hamer. and using writer arise other inconvenience despite it solves formatting problem. 2014/6/12 ??12:42 ? "Brian Barker" ??: At 23:34 11/06/2014 +0800, Hung Mark wrote: I'm using OpenOffice 4.1.0 ( Windows 7 with traditional Chinese ). When I enter lots of text in a cell in Calc so that it excess the height of a page, it overlaps with the page footer. I'm not sure what you are hoping to happen here. Surely the nature of a spreadsheet - usually containing values, whether they be numbers, text, etc, to be processed - is that you would not want a single cell to be split across pages. If a multi-line cell would otherwise be split across pages, it is moved wholesale to the next page, but that cannot solve the problem if, as you have contrived, a single cell exceeds the page length. How do I prevent it? o Change the font size. o Go to Format | Cells... | Alignment | Properties, remove the tick from "Wrap text automatically", and tick "Shrink to fit cell size". o Distribute the material between two cells. o Use a text (Writer) document instead. A table may be useful. o Use a spreadsheet but transfer the material to a text document for final formatting. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org