Re: [libreoffice-users] Calc - Invalid name error - help request

[jorge Rodríguez]

Hi again:

I suggest to do this in the Language-Language settings:

*User Interface: Select English US

*Locale Settings: English (Canada)

*Decimal Separator Key: uncheck

*Default Currency: Default CAD (English or French)

*Default Language for Documents: A English Canada or French

*Ignore system input language: check

I did this in my LO, and restart LO, and then LO accept " . " 
as decimal separator key


I hope this help,

Jorge Rodríguez


El 28/07/2017 a las 18:14, jorge Rodríguez escribió:

Hi:

In LO Preference (Menu-Tools-Options-Language settings), you can 
find some ways to customize your settings.


I hope this help,

Jorge Rodríguez


El 28/07/2017 a las 16:11, bunk3m escribió:

Thank you Jorge.

I have checked this.  The Mac settings are OK.  It works with Excel 
fine and Apple Numbers.  Mac settings are to show decimal as "."


I have some LO Calc sheets that were created a few years ago that are 
OK.  It seems to be some change in the last few versions??


Would you know if there are any override settings in the LO 
Preferences?  I can't find it if it exists.


Thanks again.
B.

On 28.07.2017 17:46, jorge Rodríguez wrote:

Hi :

 I don't have a Mac, I use GNU / Linux Ubuntu...but usually that 
kind of issues are define with the Operative System. Try to find how 
is it define it in you Mac. Probably is as " , " and you have to 
change to " . " as you use it in Canada.


Regards,


Jorge Rodríguez



El 28/07/2017 a las 14:50, bunk3m escribió:
I'm having a struggle with Calc.  I trying to migrate over from 
Excel but have a problem.


When I type [=1+1.5] into a cell, I get "Invalid Name" error. If I 
save the file as an xlsx and open in Excel it calculates OK and 
give 2.5.  If I then open the xlsx in LO, it still says "Invalid 
Name".


If I put [=1+1,5], I get ERR: 509. This makes sense since I'm in 
Canada and we use "." to separate decimals.


If I put [=1+1] LO correctly calculates "2" with no error.

I have older LO spreadsheets that calculate OK.  Every new CALC 
spreadsheet has this problem.


I'm not sure how to figure out why I get this error and why LO 
won't calculate such a basic equation.


What should I be looking at?

Mac OSX 10.10.5
LO 5.3.4 & 5.4

I'm on daily digest mode so please cc me when you reply to the list.

Thank you in advance.
B.









--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc - Invalid name error - help request

[jorge Rodríguez]

Hi:

In LO Preference (Menu-Tools-Options-Language settings), you can 
find some ways to customize your settings.


I hope this help,

Jorge Rodríguez


El 28/07/2017 a las 16:11, bunk3m escribió:

Thank you Jorge.

I have checked this.  The Mac settings are OK.  It works with Excel 
fine and Apple Numbers.  Mac settings are to show decimal as "."


I have some LO Calc sheets that were created a few years ago that are 
OK.  It seems to be some change in the last few versions??


Would you know if there are any override settings in the LO 
Preferences?  I can't find it if it exists.


Thanks again.
B.

On 28.07.2017 17:46, jorge Rodríguez wrote:

Hi :

 I don't have a Mac, I use GNU / Linux Ubuntu...but usually that 
kind of issues are define with the Operative System. Try to find how 
is it define it in you Mac. Probably is as " , " and you have to 
change to " . " as you use it in Canada.


Regards,


Jorge Rodríguez



El 28/07/2017 a las 14:50, bunk3m escribió:
I'm having a struggle with Calc.  I trying to migrate over from 
Excel but have a problem.


When I type [=1+1.5] into a cell, I get "Invalid Name" error. If I 
save the file as an xlsx and open in Excel it calculates OK and give 
2.5.  If I then open the xlsx in LO, it still says "Invalid Name".


If I put [=1+1,5], I get ERR: 509. This makes sense since I'm in 
Canada and we use "." to separate decimals.


If I put [=1+1] LO correctly calculates "2" with no error.

I have older LO spreadsheets that calculate OK.  Every new CALC 
spreadsheet has this problem.


I'm not sure how to figure out why I get this error and why LO won't 
calculate such a basic equation.


What should I be looking at?

Mac OSX 10.10.5
LO 5.3.4 & 5.4

I'm on daily digest mode so please cc me when you reply to the list.

Thank you in advance.
B.







--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc - Invalid name error - help request

[Regina Henschel]

Hi,

bunk3m schrieb:

Thank you Jorge.

I have checked this.  The Mac settings are OK.  It works with Excel fine
and Apple Numbers.  Mac settings are to show decimal as "."

I have some LO Calc sheets that were created a few years ago that are
OK.  It seems to be some change in the last few versions??

Would you know if there are any override settings in the LO Preferences?
 I can't find it if it exists.


There exists the setting in Tools > Options > Language Settings > 
Languages, where you can determine the decimal separator key.


In addition there is a setting "Ignore system input language", but I 
don't know, what effect it has.


Another setting is in the cell properties in Format > Cells. On the tab 
"Numbers" you find top right a "Language" drop-down list. You can 
determine the language for numbers independent from UI. Do not use the 
"Default - xyz" but select the correct language explicitly.


That the places I know, which might influence it.

Kind regards
Regina


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc - Invalid name error - help request

[bunk3m]

Thank you Jorge.

I have checked this.  The Mac settings are OK.  It works with Excel fine 
and Apple Numbers.  Mac settings are to show decimal as "."


I have some LO Calc sheets that were created a few years ago that are 
OK.  It seems to be some change in the last few versions??


Would you know if there are any override settings in the LO Preferences? 
 I can't find it if it exists.


Thanks again.
B.

On 28.07.2017 17:46, jorge Rodríguez wrote:

Hi :

 I don't have a Mac, I use GNU / Linux Ubuntu...but usually that 
kind of issues are define with the Operative System. Try to find how is 
it define it in you Mac. Probably is as " , " and you have to change to 
" . " as you use it in Canada.


Regards,


Jorge Rodríguez



El 28/07/2017 a las 14:50, bunk3m escribió:
I'm having a struggle with Calc.  I trying to migrate over from Excel 
but have a problem.


When I type [=1+1.5] into a cell, I get "Invalid Name" error.  If I 
save the file as an xlsx and open in Excel it calculates OK and give 
2.5.  If I then open the xlsx in LO, it still says "Invalid Name".


If I put [=1+1,5], I get ERR: 509. This makes sense since I'm in 
Canada and we use "." to separate decimals.


If I put [=1+1] LO correctly calculates "2" with no error.

I have older LO spreadsheets that calculate OK.  Every new CALC 
spreadsheet has this problem.


I'm not sure how to figure out why I get this error and why LO won't 
calculate such a basic equation.


What should I be looking at?

Mac OSX 10.10.5
LO 5.3.4 & 5.4

I'm on daily digest mode so please cc me when you reply to the list.

Thank you in advance.
B.






--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc - Invalid name error - help request

[jorge Rodríguez]

Hi :

I don't have a Mac, I use GNU / Linux Ubuntu...but usually that 
kind of issues are define with the Operative System. Try to find how is 
it define it in you Mac. Probably is as " , " and you have to change to 
" . " as you use it in Canada.


Regards,


Jorge Rodríguez



El 28/07/2017 a las 14:50, bunk3m escribió:
I'm having a struggle with Calc.  I trying to migrate over from Excel 
but have a problem.


When I type [=1+1.5] into a cell, I get "Invalid Name" error.  If I 
save the file as an xlsx and open in Excel it calculates OK and give 
2.5.  If I then open the xlsx in LO, it still says "Invalid Name".


If I put [=1+1,5], I get ERR: 509. This makes sense since I'm in 
Canada and we use "." to separate decimals.


If I put [=1+1] LO correctly calculates "2" with no error.

I have older LO spreadsheets that calculate OK.  Every new CALC 
spreadsheet has this problem.


I'm not sure how to figure out why I get this error and why LO won't 
calculate such a basic equation.


What should I be looking at?

Mac OSX 10.10.5
LO 5.3.4 & 5.4

I'm on daily digest mode so please cc me when you reply to the list.

Thank you in advance.
B.




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Calc - Invalid name error - help request

[bunk3m]

I'm having a struggle with Calc.  I trying to migrate over from Excel 
but have a problem.


When I type [=1+1.5] into a cell, I get "Invalid Name" error.  If I save 
the file as an xlsx and open in Excel it calculates OK and give 2.5.  If 
I then open the xlsx in LO, it still says "Invalid Name".


If I put [=1+1,5], I get ERR: 509. This makes sense since I'm in Canada 
and we use "." to separate decimals.


If I put [=1+1] LO correctly calculates "2" with no error.

I have older LO spreadsheets that calculate OK.  Every new CALC 
spreadsheet has this problem.


I'm not sure how to figure out why I get this error and why LO won't 
calculate such a basic equation.


What should I be looking at?

Mac OSX 10.10.5
LO 5.3.4 & 5.4

I'm on daily digest mode so please cc me when you reply to the list.

Thank you in advance.
B.

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Letter page format size prints portrait pages as landscape on OS X

[bunk3m]

Alex,

Apologies if this has already been answered as I only get the daily digest.

In Canada our standard is letter (8.5" x 11"), legal (8.5" x 14"), 
tabloid (11" x 17").  Because we use the metric system, PCs usually 
default to cm.  This is totally useless since our paper standards are in 
inches.


I haven't had the problem with HP printers but I print to PDF more than 
direct to the printer. PDF production is good.  Perhaps the people with 
this issue should print to pdf first and then open in Preview and print 
the PDF.  I've done this in the past when Acrobat did silly things.


Until today I was using LO 5.3.4. Today I upgraded to 5.4 so we'll see 
if this changes.


B.

On 28.07.2017 05:14, Alexander Thurgood wrote:

Le 27/07/2017 à 22:09, amaloney a écrit :

Hi Al,



I have reported this as a recurrent bug - Bug 86838
When attempting to print a Writer portrait document, it prints rotated 90
degrees (= landscape).

This occurs with 5.3.5.X and 5.4.0.x

Does anyone have a similar problem?


For those users who don't care to read through the whole shebang of
comments on that bug report :

- it appears to affect only Mac OSX;

- it appears to affect only those users for whom the locale-based
default page setting is Letter - in other words, mainly US and Canadian
(not sure what the default page size is in Canada?) based users;

- it mainly seems to show up with Brother and HP printers.


Reports from users corresponding to the above much appreciated.


Alex






--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Letter page format size prints portrait pages as landscape on OS X

[amaloney]

The problem is resolved with:

Version: 5.4.0.3
Build ID: 7556cbc6811c9d992f4064ab9287069087d7f62c
CPU threads: 4; OS: Mac OS X 10.12.6; UI render: default; 
Locale: en-CA (en_US.UTF-8); Calc: group

Al Maloney




--
View this message in context: 
http://nabble.documentfoundation.org/Letter-page-format-size-prints-portrait-pages-as-landscape-on-OS-X-tp4219209p4219249.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Unwanted Alternative Image Names

[Dave Howorth]

On Fri, 28 Jul 2017 06:28:50 +
jonathon  wrote:

> On 27 July 2017 10:10:20 PM GMT-07:00, gordon cooper  wrote:
> 
> >However, the Alternative text should not appear if the image
> >already has the Name used as the caption.   
> 
> Er no. The alternative name is supposed to be a description of the
> image content.  
> 
> jonathon

Err, aren't we talking about HTML export? So the alternate text should
be placed as the value of the alt attribute of the img element and
should not be visible on the page at all! But readable by screen
readers?

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Letter page format size prints portrait pages as landscape on OS X

[Alexander Thurgood]

Le 27/07/2017 à 22:09, amaloney a écrit :

Hi Al,


> I have reported this as a recurrent bug - Bug 86838
> When attempting to print a Writer portrait document, it prints rotated 90
> degrees (= landscape).
> 
> This occurs with 5.3.5.X and 5.4.0.x
> 
> Does anyone have a similar problem?

For those users who don't care to read through the whole shebang of
comments on that bug report :

- it appears to affect only Mac OSX;

- it appears to affect only those users for whom the locale-based
default page setting is Letter - in other words, mainly US and Canadian
(not sure what the default page size is in Canada?) based users;

- it mainly seems to show up with Brother and HP printers.


Reports from users corresponding to the above much appreciated.


Alex




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Unwanted Alternative Image Names

[jonathon]

On 27 July 2017 10:10:20 PM GMT-07:00, gordon cooper  wrote:

>However, the Alternative text should not appear if the image
>already has the Name used as the caption. 

Er no. The alternative name is supposed to be a description of the image 
content.  

jonathon
-- 
Using LibreOffice in a Multi-lingual Environment

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Releases

[zahra a]

hi stuart.
thanks so much for your great informations that you provided for me.
may i be in contact with you directly?
libreoffice 5/3.4 has many bug fixes related to my books, but
libreoffice 5.3 has a very big issue in accessibility for me which i
did not have in 5.2 and previous versions.
could you please see bug 108582 which i reported?
i tried my best to explane, but i did not recieve reply from developers?
https://bugs.documentfoundation.org/show_bug.cgi?id=108582

but my biggest issues using libreoffice is not supporting diacritics
as general letters and also not supporting sayAll command for screen
reader users.

On 7/27/17, V Stuart Foote  wrote:
> krackedpress wrote
>> "Master Branch"?
>> This is the first time I heard of a master branch.  I know of "still",
>> "fresh", and "developer's" versions, but not "master".
>
> Master is the current development git code base at each branch
> corresponding
> to a release cycle the source tree is split/replicated.
>
> 
>
> Project uses tinderbox for test builds, this is list of current TBs
> building
> master.
>
> 
>
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Releases-tp4219060p4219199.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>


-- 
we have not sent you but as a mercy to the creation.
holy quran, chapter 21, verse 107.
in the very authentic narration is:
imam hosein is the beacon of light and the ark of salvation.
best website for studying islamic book in different languages
al-islam.org

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted