Re: Spreadsheet comments

[Brian Barker]

At 20:24 03/06/2016 -0700, Ron Patterson wrote:
... I use a lot of Comments. When I right click on some cells, I get 
the normal drop down menu that lets me leave a comment. Other cells 
I often get a different drop down menu without the comment commands?


The nature of the rogue menu will probably tell you what is happening 
- but you've kept that a secret!


One possibility is that you have entered Edit Mode in the cell. To 
see the context menu including Insert Comment, you need to have 
selected the relevant cell, of course, such that the cell is outlined 
with a heavy border. But if you double-click the cell (or press F2) 
you will have entered Edit Mode - evidenced by the lack of the 
border, a cursor within the cell, and the appearance of the red cross 
and green tick mark to the left of the Input Line.


You can leave Edit Mode by pressing Esc. Note that even in Edit Mode 
you can insert a comment using Insert | Comment or Ctrl+Alt+C.


On cells that have a comment why is there no EDIT command. How does 
one edit an existing comment?


You simply use any of the techniques to insert a comment: these will 
bring up any existing comment and you can edit it in place.



How does one resize a comment window?


o Use Show Comment from the context menu to toggle on the display of 
the comment.

o Single-click the comment itself to show the eight coloured handles.
o Drag the handles as necessary. Alternatively use Position and 
Size... from the context menu in the comment.
o If desired, use Show Comment from the context menu in the cell 
again to toggle off the display of the comment.


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

Spreadsheet comments

[Ron Patterson]

Win 7 Pro - in the left hand column I use a lot of Comments.

When I right click on some cells, I get the normal drop down menu that 
lets me leave a comment.  Other cells I often get a different drop down 
menu without the comment commands?


On cells that have a comment why is there no EDIT command.  How does one 
edit an existing comment?


How does one resize a comment window?

Re: OPEN OFFICE 4.1.2 uninstall

[Ella Oblas]

I'm just guessing now.  When you have the current program that is telling you 
that the same program is also running, try going to the upper right hand corner 
and click on the diminish symbol to make the program you are working on 
disappear from the big screen and rest in its diminished form on the task bar.  
Once the current screen is diminished, then anything that was working in the 
background will  appear.  Good luck


From: john 
Sent: Friday, June 3, 2016 3:11 PM
To: users@openoffice.apache.org
Subject: OPEN OFFICE 4.1.2 uninstall

Good afternoon.

Need assistance please. I want to uninstall current program but when In run 
install wizard it stops and gives me a message saying to “please exit 4.1.2 and 
4.1 quickstarter and mentions something about making sure program is closed and 
no other users have it open. This is home personal computer and no other 
program is open when I try to uninstall. How can I check and correct this 
problem please? Using Win 10.

Thank you,

John

Sent from Mail for Windows 10


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Gartner Magic Quadrant Analysis

[toki]

All:

Can somebody point me in the general direction on how to create a Magic
Quadrant Analysis using Calc

Specifically, labelling each datapoint in the quadrant.

Here is the link to an example chart from Garnet.
http://na3.www.gartner.com/imagesrv/research/magic-quadrants/MQ_img1.gif;wa6133018e53c72211

jonathon






-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

RE: OPEN OFFICE 4.1.2 uninstall

[Dennis E. Hamilton]

 1. Start Apache OpenOffice (any application or the dashboard).

 2. On the menu bar, click through Tools > Options ... > OpenOffice > Memory 
and under OpenOffice Quickstarter, *remove* the check mark for "Load OpenOffice 
during system start-up"

 3. Close OpenOffice.

 4. Restart your PC

 5. When Windows 10 comes back up, you should now be able to uninstall AOO.


 - Dennis


> -Original Message-
> From: john [mailto:jd...@yahoo.com.INVALID]
> Sent: Friday, June 3, 2016 12:12
> To: users@openoffice.apache.org
> Subject: OPEN OFFICE 4.1.2 uninstall
> 
> Good afternoon.
> 
> Need assistance please. I want to uninstall current program but when In
> run install wizard it stops and gives me a message saying to “please
> exit 4.1.2 and 4.1 quickstarter and mentions something about making sure
> program is closed and no other users have it open. This is home personal
> computer and no other program is open when I try to uninstall. How can I
> check and correct this problem please? Using Win 10.
> 
> Thank you,
> 
> John
> 
> Sent from Mail for Windows 10



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Unable to Get Page Break Preview

[Vince]

Well, I have gone around in circles, today, for about 1.25 hours! :-[

However, I am happy :-) to be able to report that I now am able to see a 
"normal" View>Page Break Preview on screen for each of the tabbed-sheets 
within the /2016 My Bowling Score Data.ods/ file.  It remains a mystery 
to me, for now, what I actually had done to create this problem!


It turns out that I needed to /define a print range/ for each 
tabbed-sheet; not to remove/delete those that already existed, within 
that .ods file.


Thanks to Brian and to Girvin for taking their time to offer helpful 
suggestions.


Now, I am back to redesigning the .ods file to include Brian's or 
Dennis's formula for detecting hits of my bowling scores that fall 
within specific /range bin-decades/, from 100 to 109, 110 to 119,  
290 to 299, etc., and 300.


Regards,

VinceB.


On 6/2/2016 5:22 PM, Vince wrote:

AOO-Calc 4.1.2; WIN8.1

_ 



I have been working for several hours today with a Calc file that has 
eight tab-sheets within it.


All tab-sheets, except for two, do not show the expected Page Break 
Preview. Instead, the entire sheet palette is a shade of gray 
background. Also, within one sheet that also happens to have hidden 
cell data, the color of the characters are showing as white in those 
cells. There are no indication of (blue) page breaks or watermarked- 
Page numbers.


I have no idea how or why this has happened. (I probably did something 
silly while jumping back and forth from one tab-sheet to another.)  
After exiting AOO and after rebooting my computer, the problem 
remains.  I've checked several other Calc files, and they do not 
exhibit this particular problem.


Can anyone shed some light on this problem and offer a solution?

Thanks for reading this.

Regards,

VinceB.

OPEN OFFICE 4.1.2 uninstall

[john]

Good afternoon.

Need assistance please. I want to uninstall current program but when In run 
install wizard it stops and gives me a message saying to “please exit 4.1.2 and 
4.1 quickstarter and mentions something about making sure program is closed and 
no other users have it open. This is home personal computer and no other 
program is open when I try to uninstall. How can I check and correct this 
problem please? Using Win 10.

Thank you,

John

Sent from Mail for Windows 10 

Re: Unable to Get Page Break Preview

[Girvin R. Herr]

Vince,

By my experience this is the other way around.  To be able to print a 
sheet, a print range must be defined for that sheet, and defining a 
print range for one sheet does not apply to the remaining sheets.  If 
you want to print all sheets, then all sheets must have a print range 
defined.  Personally, I think that all sheets' print ranges should 
default to "Entire Sheet" when created, but the devs must not see it 
that way, since this requirement has been around for years.  To me, it 
is a productivity time-waster to set the print ranges for each and every 
sheet.


HTH
Girvin Herr



On 06/03/2016 04:46 AM, Vince B. wrote:

If I understand you correctly, then I should remove/delete any Print Range that 
is found to exist.  Will try that later today.

Thanks.

Regards,
Vince

Sent from my iPad


On Jun 3, 2016, at 03:02, Brian Barker  wrote:

At 17:22 02/06/2016 -0400, Vince Bonly wrote:

I have been working for several hours today with a Calc file that has eight 
tab-sheets within it. All tab-sheets, except for two, do not show the expected 
Page Break Preview. Instead, the entire sheet palette is a shade of gray 
background.

That's fairly easy, I think: your print ranges require nothing on those sheets 
to be printed. Remember that print ranges do not operate independently for the 
sheet they are on. This means that if you define a print range or ranges on one 
sheet, nothing on any other sheet of the spreadsheet will print unless it is 
also included in a print range.

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: Referencing a cell from previous worksheet in same spreadsheet file...

[Girvin R. Herr]

Clay,

I use renamed sheets and it works for me, but be absolutely sure there 
is no space to the left of the "=" in the expression.  I spent a lot of 
time troubleshooting this before I realized I had a space before the =.  
The symptom is that the cell displays the expression (text), not the 
data from the referenced cell.  Also, I am not sure it is required, but 
I make sure the referencing cell has the correct type for the referenced 
data: number, currency, text, etc.


HTH
Girvin Herr



On 06/03/2016 07:07 AM, Clay McCall wrote:

I am trying to carry over a =sum() value from a cell in one spreadsheet to 
another cell in another sheet in the same spreadsheet file.  The instructions 
in the help section “Referencing a Cell in the Same Document” says that the 
formula is =sheet2.A1,  I have discovered that if you rename the sheets then 
this does not work.  Why can I not reference a sheet by another name?

Thanks for any assist,

R/
Clay McCall



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Referencing a cell from previous worksheet in same spreadsheet file...

[Jim McLaughlin]

That will not work, but only for 1 value in the origin cell on sheet 1.

If the origin cell on sheet 1 undergoes a  value change, that  change will
not carry over to the target cell on sheet 2.

So if sheet 1's origin cell is dynamic, and its value is changed, by, say,
adding another number in to the origin cell [remember, the OP was using the
formula =SUM(:) in the origin cell on sheet 1] one needs o utilize the LINK
function in the "Paste Special"pop up / drop down screen.



On Fri, Jun 3, 2016 at 9:13 AM, Steve Ahlers 
wrote:

>
> Even easier, type "=" in the formula bar for destination cell, then
> navigate to the original cell, click on it and hit "Enter" ( or "Return")
>
> Steve
> Sent from my iPad
>
> On Jun 3, 2016, at 7:21 AM, Jim McLaughlin 
> wrote:
>
> > try this:
> >
> > highlight cell to be copied> click edit >click copy;>navigate  to sheet
> > where cell is to be pasted> navigate to cell on second sheet where
> original
> > cell is to be pasted >highlight destination location > edit > click
> "paste
> > special"  > on grey pop up screen click "link"
> >
> > On Fri, Jun 3, 2016 at 7:07 AM, Clay McCall 
> wrote:
> >
> >> I am trying to carry over a =sum() value from a cell in one spreadsheet
> to
> >> another cell in another sheet in the same spreadsheet file.  The
> >> instructions in the help section “Referencing a Cell in the Same
> Document”
> >> says that the formula is =sheet2.A1,  I have discovered that if you
> rename
> >> the sheets then this does not work.  Why can I not reference a sheet by
> >> another name?
> >>
> >> Thanks for any assist,
> >>
> >> R/
> >> Clay McCall
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Referencing a cell from previous worksheet in same spreadsheet file...

[Steve Ahlers]

Even easier, type "=" in the formula bar for destination cell, then navigate to 
the original cell, click on it and hit "Enter" ( or "Return")

Steve
Sent from my iPad

On Jun 3, 2016, at 7:21 AM, Jim McLaughlin  wrote:

> try this:
> 
> highlight cell to be copied> click edit >click copy;>navigate  to sheet
> where cell is to be pasted> navigate to cell on second sheet where original
> cell is to be pasted >highlight destination location > edit > click "paste
> special"  > on grey pop up screen click "link"
> 
> On Fri, Jun 3, 2016 at 7:07 AM, Clay McCall  wrote:
> 
>> I am trying to carry over a =sum() value from a cell in one spreadsheet to
>> another cell in another sheet in the same spreadsheet file.  The
>> instructions in the help section “Referencing a Cell in the Same Document”
>> says that the formula is =sheet2.A1,  I have discovered that if you rename
>> the sheets then this does not work.  Why can I not reference a sheet by
>> another name?
>> 
>> Thanks for any assist,
>> 
>> R/
>> Clay McCall

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Java

[Fernando Cassia]

On 6/3/16, suhail ansari  wrote:
>
> Hi everyone, I have a suggestion that Apache OpenOffice should be re written
> in java because java is available on all major server and desktop operating
> system. Google recently switched to OpenJDK for Android development and
> there is a project http://openjdk.java.net/projects/mobile this will port
> OpenJDK to android, ios and Windows phone. It will be easy for open office
> to port to different desktop, server and mobile operating systems.

Your proposal has been made before. I like it. But, like last time,
surely a handful of individuals on this list with an axe to grind
against Java will vote against it.

In fact, it makes so much sense now as it did 6 years ago. it was
Oracle's idea to rewrite OpenOffice.org into JavaFX, before the
"Freedom Fighters" who opposed the dual-licensing scheme of
OpenOffice.org (which allowed for the derivative StarOffice w
propietary add-ons), made their move and led Oracle to hand over OO.o
to the Apache foundation and lay off all its paid developers.

Oracle sees future of JavaFX with OpenOffice
http://www.fhshh.com/oracle-sees-the-future-of-javafx-with-openoffice.html

"At the JavaOne conference, Larry Ellison has sent a message to the
developers of the open source project, encouraging them to quickly
build libraries for JavaFX. This development language, introduced as a
competitor to Adobe AIR and FLex, and Silverlight (Microsoft) in the
design of rich Internet applications (RIAs)".

Unlike the situation at that time, now JavaFX can be made to work
inside browsers without plug-in via solutions like GluonHQ
https://mobile.twitter.com/JavaFX_Hulk/status/737541368067690497

...So, Oracle's idea -had it succeeded and not being stabbed in the
back by the LO Fork- would have meant that today there would be OO.o
and/or StarOffice on every mobile phone and tablet...

FC

-- 
During times of Universal Deceit, telling the truth becomes a revolutionary
act
Durante épocas de Engaño Universal, decir la verdad se convierte en un Acto
Revolucionario
- George Orwell

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Java

[suhail ansari]

Hi everyone, I have a suggestion that Apache OpenOffice should be re written in 
java because java is available on all major server and desktop operating 
system. Google recently switched to OpenJDK for Android development and there 
is a project http://openjdk.java.net/projects/mobile this will port OpenJDK to 
android, ios and Windows phone. It will be easy for open office to port to 
different desktop, server and mobile operating systems.
Sent from Mail for Windows 10

Re: Referencing a cell from previous worksheet in same spreadsheet file...

[Jim McLaughlin]

try this:

highlight cell to be copied> click edit >click copy;>navigate  to sheet
where cell is to be pasted> navigate to cell on second sheet where original
cell is to be pasted >highlight destination location > edit > click "paste
special"  > on grey pop up screen click "link"

On Fri, Jun 3, 2016 at 7:07 AM, Clay McCall  wrote:

> I am trying to carry over a =sum() value from a cell in one spreadsheet to
> another cell in another sheet in the same spreadsheet file.  The
> instructions in the help section “Referencing a Cell in the Same Document”
> says that the formula is =sheet2.A1,  I have discovered that if you rename
> the sheets then this does not work.  Why can I not reference a sheet by
> another name?
>
> Thanks for any assist,
>
> R/
> Clay McCall

Referencing a cell from previous worksheet in same spreadsheet file...

[Clay McCall]

I am trying to carry over a =sum() value from a cell in one spreadsheet to 
another cell in another sheet in the same spreadsheet file.  The instructions 
in the help section “Referencing a Cell in the Same Document” says that the 
formula is =sheet2.A1,  I have discovered that if you rename the sheets then 
this does not work.  Why can I not reference a sheet by another name?

Thanks for any assist,

R/
Clay McCall

Re: Unable to Get Page Break Preview

[Vince B.]

If I understand you correctly, then I should remove/delete any Print Range that 
is found to exist.  Will try that later today.

Thanks.

Regards, 
Vince

Sent from my iPad

> On Jun 3, 2016, at 03:02, Brian Barker  wrote:
> 
> At 17:22 02/06/2016 -0400, Vince Bonly wrote:
>> I have been working for several hours today with a Calc file that has eight 
>> tab-sheets within it. All tab-sheets, except for two, do not show the 
>> expected Page Break Preview. Instead, the entire sheet palette is a shade of 
>> gray background.
> 
> That's fairly easy, I think: your print ranges require nothing on those 
> sheets to be printed. Remember that print ranges do not operate independently 
> for the sheet they are on. This means that if you define a print range or 
> ranges on one sheet, nothing on any other sheet of the spreadsheet will print 
> unless it is also included in a print range.
> 
> 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: Test

[Martin Groenescheij]

On 03/06/16 6:18 PM, William Bowles wrote:

Test


Test successful



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Test

[William Bowles]

Test

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Trouble sending you an email

[Andrea]

The Mail came through the Mailinglist - no problem. It's a little bit 
funny to read in an eMail, that it was impossible to send an eMail ;-)


And about the question: I think everybody here has a phone number ;-) - 
we are not an organisation, we are just a group of users.


Am 03.06.2016 um 08:41 schrieb Herb Eichner:

 Trouble sending you an email
users@openoffice.apache.org 

I have been trying to send an email to you but it keeps bouncing back. What am 
I doing wrong? Do you have a phone number for the simple questions? Please 
advise. (I'm afraid this will bounce back too.
Thanks; Herb Eichner of heichn...@gmail.com 
Ph.# 780-433-5521






-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Unable to Get Page Break Preview

[Brian Barker]

At 17:22 02/06/2016 -0400, Vince Bonly wrote:
I have been working for several hours today with a Calc file that 
has eight tab-sheets within it. All tab-sheets, except for two, do 
not show the expected Page Break Preview. Instead, the entire sheet 
palette is a shade of gray background.


That's fairly easy, I think: your print ranges require nothing on 
those sheets to be printed. Remember that print ranges do not operate 
independently for the sheet they are on. This means that if you 
define a print range or ranges on one sheet, nothing on any other 
sheet of the spreadsheet will print unless it is also included in a 
print range.


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