Re: adding up columns in excel

[Brian Barker]

At 10:04 02/04/2018 -0400, Carol Noname wrote:

adding up columns in excel


If you are adding up columns in Microsoft Excel, you may need to look 
elsewhere for help. Perhaps you mean in an OpenOffice spreadsheet?


I am trying to download an excel spread sheet from ebay. Every time 
I do, the column with prices has an apostrophe before the number so 
I cannot add up the columns.


If you mean that you can see the apostrophes in the cells themselves, 
that is very odd. But you probably mean that when a cell value is 
displayed in the Input Line it shows with a leading apostrophe: that 
is a standard part of spreadsheet behaviour. This indicates that what 
you have in a cell with a numeric format (including a currency one) 
is actually text - which may look like a number - and not a genuine 
number. This may be because the author has intentionally entered text 
instead of numbers, has entered currency amounts in what is not the 
standard currency for his or her locale, or because of the way in 
which you have incorporated the material into your spreadsheet document.


If the distinction between number and text which looks like a number 
is not obvious, just consider your (US) zip code, which you quote as 
"01373". That is text. If it were a number, you could quote it 
instead as 1373 - but you cannot. If it were a number, you could read 
it as "one thousand, three hundred [and] seventy-three" - but you'd 
never do that. If it were a number, there would be some special 
significance in the postal location that happened to have exactly 
twice its value - 02746 - but there isn't. After all, it is called a 
"zip code", not a "zip number". So there *is* a use for text which 
happens to look like a number - not what you want here.



My older version didn't do this.


I hope it did, as this is correct spreadsheet behaviour. This 
spreadsheet document may be different from previous ones, or you may 
have incorporated the material in a different way.



Please help!


o If you are pasting material into a spreadsheet, you should see the 
Text Import window. Tick the "Detect special numbers" box and your 
text values will be converted to genuine numbers. (This works for 
currency values as well as for numbers.) But this won't help if you 
are actually downloading and opening a spreadsheet document, as you say.


When you have text values in your spreadsheet, there are various ways 
to convert them to real numbers:


o You can use the VALUE() function to derive the values you need into 
a separate column. If you wish, you can then paste them back over the 
originals, but using Edit | Paste Special (or Ctrl+Shift+V) instead 
of ordinary Paste, and ensuring the Formulae is *not* ticked in the 
Paste Spacial dialogue. You may need to format the cells as Currency 
in order to add or replace the currency symbol.


o Select the material. Go to Data | Text to Columns... . (The "Detect 
special numbers" box should be ticked.) Your text values will be 
converted to numbers.


But here is an interesting trick: you can add the text values without 
converting them to numbers. If you want to add up, say, the values in 
A1 to A99, you might use the formula

=SUM(A1:A99)
As you have found, if you use that with your text values masquerading 
as numbers, it will not work. How about incorporating the VALUE() 
function to convert the values on the fly? You might try

=SUM(VALUE(A1:A99))
- but that doesn't work either, as the VALUE() function cannot take a 
range as its parameter. But what does work is this: enter

=SUM(VALUE(A1:A99))
as the formula in the cell, but instead of pressing Enter or the 
(green tick mark) Accept button in the Input Line to complete the 
entry, press Ctrl+Shift+Enter. This creates an array formula, which 
does work. (You will need the result cell to be formatted as Currency 
for its value to behave correctly.) Note that when you have done 
this, your formula will appear in the Input Line surrounded by braces, i.e. as

{=SUM(VALUE(A1:A99))}
- but you *cannot* achieve the effect by entering these yourself: you 
must instead use Ctrl+Shift+Enter to complete the formula.


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: adding up columns in excel

[Martin Groenescheij]

On 03/04/18 12:04 AM, LTS Tools, Inc wrote:

Hello,
  
I am trying to download an excel spread sheet from ebay. Every time I do, the column with prices has an apostrophe before the number so I cannot add up the columns. My older version didn't do this. Please help!


If you download a Excel file that the problem is with the Excel file.
If you copy data into into an OpenOffice file or open a csv file into 
OpenOffice tick the 'Detect special number" box in the Import window.


  
Thank you,

Carol
LTS Tools, Inc
40 Conway St
South Deerfield, Ma 01373
413-775-3026 phone



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

Re: trying to read the help files in open office

[zahra a]

i love people and pray for there salvation, prosperity and felicity
and add God bless you in the last sentences of my answers most of
times!

On 4/2/18, Martin Groenescheij  wrote:
>
>
> On 01/04/18 11:27 PM, zahra a wrote:
>> hi.
>> just be sure that report object discriptions is checked in object
>> presentation and nvda explanes most of menus and options for you.
>> hope that help, God bless you all.
>
> I rely need God's blessings to understand what you're talking about.
>
>>
>> On 4/1/18, Keith N. McKenna  wrote:
>>> On 3/31/2018 1:24 PM, Rosemarie Chavarria wrote:
 Hi, everyone,



 I just downloaded and installed open office not too long ago and am
 trying
 to read the help files but when I press alt H, all I get are combo
 boxes
 for
 different things but no file. What am I missing?



 Thanks in advance.



 Rosemarie






>>> All alt+H does is open the the Help Menu from the menu bar, than you
>>> have to click on what you want. To open the help files without going to
>>> the menu use the F1 function key on your keyboard.
>>>
>>> Regards
>>> Keith
>>>
>>>
>>
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>


-- 
By God,
were I given all the seven heavens
with all they contain
in order that
I may disobey God
by depriving an ant
from the husk of a grain of barley,
I would not do it.
imam ali

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

adding up columns in excel

[LTS Tools, Inc]

Hello,
 
I am trying to download an excel spread sheet from ebay. Every time I do, the 
column with prices has an apostrophe before the number so I cannot add up the 
columns. My older version didn't do this. Please help!
 
Thank you,
Carol
LTS Tools, Inc
40 Conway St
South Deerfield, Ma 01373
413-775-3026 phone

Re: OTS file not opening

[james mcauliffe]

Thanks Martin,

I had a number of emails with Brian. I meant ODS file, unfortunately my file is 
corrupted and I did not have automatic backup on in my settings so have lost 
the file.

Sent from my iPad

On 2 Apr 2018, at 8:02 pm, Martin Groenescheij 
mailto:mar...@groenescheij.com>> wrote:



On 02/04/18 11:42 AM, james mcauliffe wrote:

Hello


our OTS files are not opening, each time they try and convert to an OTD file 
and open in document rather than spreadsheet.

OTS files are spreadsheet templates see the wiki page 
here
 and templates are never opened but rather used to created a new
document with the properties of the template. If the template itself was used 
you basically overwrite the template.


Any idea why this is happening?

The first thing come into my mind is that some user (maybe you) have given the 
file the wrong extension.



regards

James


Sent from 
Outlook

Re: language settings for downloaded Open Office

[Jana K.]

I found out how: uninstall existing Open Office and download the English 
version.
-- Původní e-mail --
Od: Martin Groenescheij 
Komu: users@openoffice.apache.org
Datum: 2. 4. 2018 12:05:48
Předmět: Re: language settings for downloaded Open Office
"

On 02/04/18 3:24 PM, Jana K. wrote:
> Greetings,
>
>
> is there a way to get Open Office in English? I'm American working in the
> Czech Rep., and I purchased a computer with Open Office from my co-worker,

> however, it's in Czech - all the toolbars, etc.. Is there a way to change
it
> to English? Can't find one, perhaps for the very reason that it's all in
> Czech.

The simplest solution is to download it free from the download page at
www.openoffice.org
And go to the extension page to download the Czech language extension

>
> Thanks,
>
> Jane

"

Re: language settings for downloaded Open Office

[Matthias Seidel]

Hi Jane,

You can always download a language pack (en-US) for your version of AOO
from here:
https://www.openoffice.org/download/index.html

After installing it you can change the user interface to English under
"Nástroje - Volby... - Jazyková nastavení - Jazyki".

I think you have to download the English dictionary additionally from here:
https://extensions.openoffice.org/en/project/english-dictionaries-apache-openoffice

Regards,

   Matthias


Am 02.04.2018 um 07:24 schrieb Jana K.:
> Greetings, 
>
>
> is there a way to get Open Office in English? I'm American working in the 
> Czech Rep., and I purchased a computer with Open Office from my co-worker, 
> however, it's in Czech - all the toolbars, etc.. Is there a way to change it
> to English? Can't find one, perhaps for the very reason that it's all in 
> Czech. 
>
> Thanks,
>
> Jane




smime.p7s
Description: S/MIME Cryptographic Signature

Re: trying to read the help files in open office

[Martin Groenescheij]

On 01/04/18 11:27 PM, zahra a wrote:

hi.
just be sure that report object discriptions is checked in object
presentation and nvda explanes most of menus and options for you.
hope that help, God bless you all.


I rely need God's blessings to understand what you're talking about.



On 4/1/18, Keith N. McKenna  wrote:

On 3/31/2018 1:24 PM, Rosemarie Chavarria wrote:

Hi, everyone,



I just downloaded and installed open office not too long ago and am
trying
to read the help files but when I press alt H, all I get are combo boxes
for
different things but no file. What am I missing?



Thanks in advance.



Rosemarie







All alt+H does is open the the Help Menu from the menu bar, than you
have to click on what you want. To open the help files without going to
the menu use the F1 function key on your keyboard.

Regards
Keith







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

Re: language settings for downloaded Open Office

[Martin Groenescheij]

On 02/04/18 3:24 PM, Jana K. wrote:

Greetings,


is there a way to get Open Office in English? I'm American working in the
Czech Rep., and I purchased a computer with Open Office from my co-worker,
however, it's in Czech - all the toolbars, etc.. Is there a way to change it
to English? Can't find one, perhaps for the very reason that it's all in
Czech.


The simplest solution is to download it free from the download page at 
www.openoffice.org

And go to the extension page to download the Czech language extension



Thanks,

Jane



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

Re: OTS file not opening

[Martin Groenescheij]

On 02/04/18 11:42 AM, james mcauliffe wrote:

Hello


our OTS files are not opening, each time they try and convert to an OTD file 
and open in document rather than spreadsheet.


OTS files are spreadsheet templates see the wiki page here 
 
and templates are never opened but rather used to created a new
document with the properties of the template. If the template itself was 
used you basically overwrite the template.



Any idea why this is happening?


The first thing come into my mind is that some user (maybe you) have 
given the file the wrong extension.





regards

James


Sent from Outlook

language settings for downloaded Open Office

[Jana K.]

Greetings, 


is there a way to get Open Office in English? I'm American working in the 
Czech Rep., and I purchased a computer with Open Office from my co-worker,
however, it's in Czech - all the toolbars, etc.. Is there a way to change it
to English? Can't find one, perhaps for the very reason that it's all in 
Czech. 

Thanks,

Jane

Re: OTS file not opening

[Johnny Rosenberg]

2018-04-02 3:42 GMT+02:00 james mcauliffe :

> Hello
>
>
> our OTS files are not opening, each time they try and convert to an OTD
> file and open in document rather than spreadsheet. Any idea why this is
> happening?
>
> What is OTS and OTD? Or do you mean ODS and ODT?


Kind regards

Johnny Rosenberg



>
> regards
>
> James
>
>
> Sent from Outlook
>