Re: [libreoffice-users] Calc 5.x Mac - syntax to link cells in two spreadsheets?

[bunk3m]

Steve,

I just tested your scenario (Tools:Automatic Spell Check -> off) and I 
had a similar transformation of text.  It didn't remove the "!" though. 
All the other changes happened.


B.

On 30.10.2017 18:40, Steve Edmonds wrote:

Hi.
This is not some sort of auto spell correct on the Mac where LO changes 
all the upper case letters to lower case, changes some of the characters 
ie. #, $ and ! are removed is it.

steve

On 31/10/17 11:36, bunk3m wrote:
OK I've had some time to test this with the same spreadsheets on 
various versions of LO on Mac, LO on VM running Win & LO on VM running 
Linux (Xubuntu).


I've tested LO 5.1, 5.3 & 5.4 on Mac, LO 5.1 Win, LO 3.5.7.2 Linux and 
OO 3.3 and OO 4.1


In each case I followed these steps.
1) open two linked spreadsheets
2) place "=" in a cell, switch to other spreadsheet, select the linked 
cell and press enter key.
3) in each case on the Mac (LO 5.1/5.3/5.4); LO changes all the upper 
case letters to lower case, changes some of the characters ie. #, $ 
and ! are removed and you get an error message.


If you try to manually change the text entry changes from (3), when 
you press the enter key it reverts to the incorrect text.


Using the same spreadsheets and following steps (1) & (2) and using 
Win LO 5.2 & Linux Xubuntu LO 3.5.7.2, the linking works without error.


Using the same spreadsheets and following steps (1) & (2) and using 
Mac OO 3.3 and 4.1, the links work without error.


So at this point I opened the spreadsheet in LO Mac and the links 
created by Win and Linux versions are still OK.


If I use Mac LO to copy and paste the entire cell created by Win & 
Linux versions of LO and OO,there is no transformation and the linking 
works.


If I use Mac LO and select in the cell, highlight and copy the link 
formula, and paste the formula into another cell, Mac LO transposes 
the formula and ERROR.


I think we've found a bug.

B.

On 30.10.2017 14:46, bunk3m wrote:

A quick update.

I wasn't able to find LO 5.1 but I did find LO 5.3 and OpenOffice 
3.3. I downloaded and installed both LO 5.3 and OO 3.3.  LO 5.3 has 
the same issue and won't allow the link.


OO 3.3 has absolutely no problem with the linking to external files. 
So my file does link when using OO.  This is beginning to look like a 
bug in LO 5.3 & 5.4.


I will try OO 4.x and see if there it work also.

And I will see if I have LO on a Linux VM image to see if the 
spreadsheet will work using Linux.


B.

On 30.10.2017 14:04, bunk3m wrote:

Hi Steve,

Thanks for your continued help.

I checked my LO and it has Formula syntax -> Excel A1.  I tried 
again to change the syntax "!" vs ".", "#" or not etc. but still 
getting ERR:510|ERR:507 or ERR:501 and the occasional #NAME?.  :-p


Please let me know if you have a problem when you try LO 5.4 Mac. If 
it's a bug, then I'll happily add it.


I will see if I can find LO 5.1 Mac and give that a try.  Will 
report back.


B.

On 29.10.2017 21:57, Steve Edmonds wrote:

Hi.
My Mac has LO 5.1..., My Linux 5.3...
When I add the connection on my Mac as in my earlier test I get a 
formula like

='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11

I don't get any error, it calculates fine on creation of the 
formula, but cannot get it to update if the source changes.


I will update my Mac to 5.4 and see if that changes anything, but I 
would assume if the file is an ods then adding a new formula should 
result in ods formatting.

BUT from a few years ago I found

"I think the issue is the separator between sheet name and address 
"!",


First option)
Change Menu/Tools/Options/LibreOffice/Formula/Formula 
options/Formula syntax -> Excel A1."


So may be check Menu/Tools/Options/LibreOffice/Formula/Formula 
options/Formula syntax


Steve

On 30/10/17 09:54, bunk3m wrote:

Thank you for testing this, Steve.

I tried what you suggested near the beginning of my testing and 
tried it again just now.  When I follow your instructions, I get 
an ERR:507.


I've tried following the instructions that Remy provided [The link 
was inserted as per the instructions in the help 
(https://help.libreoffice.org/Calc/Referencing_a_Cell_in_Another_Document)] 
but I get completely different looking formula.  There is no 
"green check mark" as per the help instructions either.


Within the same spreadsheet I get similar, ie. ='tab'!cell  This 
does work.


To reference a spreadsheet outside of the present spreadsheet,

where Remy gets:
='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11
on Linux

I get:
=['file:///users/me/folder/spreadsheet.ods']'tab'!i54

This isn't what the help file shows either.

Could this be something due to the fact that this started out as 
an Excel file but was saved as an ods sometime over the past months?


I'm confused.
B.

On 29.10.2017 16:12, Steve Edmonds wrote:

Just tried on my mac.
Open the sheet I want to perform the calculation in.
Open the source sheet from which I want to fetch the data

Enter the 

Re: [libreoffice-users] Calc 5.x Mac - syntax to link cells in two spreadsheets?

[Steve Edmonds]

Hi.
This is not some sort of auto spell correct on the Mac where LO changes 
all the upper case letters to lower case, changes some of the characters 
ie. #, $ and ! are removed is it.

steve

On 31/10/17 11:36, bunk3m wrote:
OK I've had some time to test this with the same spreadsheets on 
various versions of LO on Mac, LO on VM running Win & LO on VM running 
Linux (Xubuntu).


I've tested LO 5.1, 5.3 & 5.4 on Mac, LO 5.1 Win, LO 3.5.7.2 Linux and 
OO 3.3 and OO 4.1


In each case I followed these steps.
1) open two linked spreadsheets
2) place "=" in a cell, switch to other spreadsheet, select the linked 
cell and press enter key.
3) in each case on the Mac (LO 5.1/5.3/5.4); LO changes all the upper 
case letters to lower case, changes some of the characters ie. #, $ 
and ! are removed and you get an error message.


If you try to manually change the text entry changes from (3), when 
you press the enter key it reverts to the incorrect text.


Using the same spreadsheets and following steps (1) & (2) and using 
Win LO 5.2 & Linux Xubuntu LO 3.5.7.2, the linking works without error.


Using the same spreadsheets and following steps (1) & (2) and using 
Mac OO 3.3 and 4.1, the links work without error.


So at this point I opened the spreadsheet in LO Mac and the links 
created by Win and Linux versions are still OK.


If I use Mac LO to copy and paste the entire cell created by Win & 
Linux versions of LO and OO,there is no transformation and the linking 
works.


If I use Mac LO and select in the cell, highlight and copy the link 
formula, and paste the formula into another cell, Mac LO transposes 
the formula and ERROR.


I think we've found a bug.

B.

On 30.10.2017 14:46, bunk3m wrote:

A quick update.

I wasn't able to find LO 5.1 but I did find LO 5.3 and OpenOffice 
3.3. I downloaded and installed both LO 5.3 and OO 3.3.  LO 5.3 has 
the same issue and won't allow the link.


OO 3.3 has absolutely no problem with the linking to external files.  
So my file does link when using OO.  This is beginning to look like a 
bug in LO 5.3 & 5.4.


I will try OO 4.x and see if there it work also.

And I will see if I have LO on a Linux VM image to see if the 
spreadsheet will work using Linux.


B.

On 30.10.2017 14:04, bunk3m wrote:

Hi Steve,

Thanks for your continued help.

I checked my LO and it has Formula syntax -> Excel A1.  I tried 
again to change the syntax "!" vs ".", "#" or not etc. but still 
getting ERR:510|ERR:507 or ERR:501 and the occasional #NAME?.  :-p


Please let me know if you have a problem when you try LO 5.4 Mac.  
If it's a bug, then I'll happily add it.


I will see if I can find LO 5.1 Mac and give that a try.  Will 
report back.


B.

On 29.10.2017 21:57, Steve Edmonds wrote:

Hi.
My Mac has LO 5.1..., My Linux 5.3...
When I add the connection on my Mac as in my earlier test I get a 
formula like

='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11

I don't get any error, it calculates fine on creation of the 
formula, but cannot get it to update if the source changes.


I will update my Mac to 5.4 and see if that changes anything, but I 
would assume if the file is an ods then adding a new formula should 
result in ods formatting.

BUT from a few years ago I found

"I think the issue is the separator between sheet name and address 
"!",


First option)
Change Menu/Tools/Options/LibreOffice/Formula/Formula 
options/Formula syntax -> Excel A1."


So may be check Menu/Tools/Options/LibreOffice/Formula/Formula 
options/Formula syntax


Steve

On 30/10/17 09:54, bunk3m wrote:

Thank you for testing this, Steve.

I tried what you suggested near the beginning of my testing and 
tried it again just now.  When I follow your instructions, I get 
an ERR:507.


I've tried following the instructions that Remy provided [The link 
was inserted as per the instructions in the help 
(https://help.libreoffice.org/Calc/Referencing_a_Cell_in_Another_Document)] 
but I get completely different looking formula.  There is no 
"green check mark" as per the help instructions either.


Within the same spreadsheet I get similar, ie. ='tab'!cell  This 
does work.


To reference a spreadsheet outside of the present spreadsheet,

where Remy gets:
='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11
on Linux

I get:
=['file:///users/me/folder/spreadsheet.ods']'tab'!i54

This isn't what the help file shows either.

Could this be something due to the fact that this started out as 
an Excel file but was saved as an ods sometime over the past months?


I'm confused.
B.

On 29.10.2017 16:12, Steve Edmonds wrote:

Just tried on my mac.
Open the sheet I want to perform the calculation in.
Open the source sheet from which I want to fetch the data

Enter the formula in a cell in the first sheet, i.e =2*
then click in the source cell in the second sheet,
then click enter and it seems to work.
steve

On 30/10/17 07:42, bunk3m wrote:

Hello all,

I've been struggling with this one for a week 

Re: [libreoffice-users] Calc 5.x Mac - syntax to link cells in two spreadsheets?

[bunk3m]

OK I've had some time to test this with the same spreadsheets on various 
versions of LO on Mac, LO on VM running Win & LO on VM running Linux 
(Xubuntu).


I've tested LO 5.1, 5.3 & 5.4 on Mac, LO 5.1 Win, LO 3.5.7.2 Linux and 
OO 3.3 and OO 4.1


In each case I followed these steps.
1) open two linked spreadsheets
2) place "=" in a cell, switch to other spreadsheet, select the linked 
cell and press enter key.
3) in each case on the Mac (LO 5.1/5.3/5.4); LO changes all the upper 
case letters to lower case, changes some of the characters ie. #, $ and 
! are removed and you get an error message.


If you try to manually change the text entry changes from (3), when you 
press the enter key it reverts to the incorrect text.


Using the same spreadsheets and following steps (1) & (2) and using Win 
LO 5.2 & Linux Xubuntu LO 3.5.7.2, the linking works without error.


Using the same spreadsheets and following steps (1) & (2) and using Mac 
OO 3.3 and 4.1, the links work without error.


So at this point I opened the spreadsheet in LO Mac and the links 
created by Win and Linux versions are still OK.


If I use Mac LO to copy and paste the entire cell created by Win & Linux 
versions of LO and OO,there is no transformation and the linking works.


If I use Mac LO and select in the cell, highlight and copy the link 
formula, and paste the formula into another cell, Mac LO transposes the 
formula and ERROR.


I think we've found a bug.

B.

On 30.10.2017 14:46, bunk3m wrote:

A quick update.

I wasn't able to find LO 5.1 but I did find LO 5.3 and OpenOffice 3.3. I 
downloaded and installed both LO 5.3 and OO 3.3.  LO 5.3 has the same 
issue and won't allow the link.


OO 3.3 has absolutely no problem with the linking to external files.  So 
my file does link when using OO.  This is beginning to look like a bug 
in LO 5.3 & 5.4.


I will try OO 4.x and see if there it work also.

And I will see if I have LO on a Linux VM image to see if the 
spreadsheet will work using Linux.


B.

On 30.10.2017 14:04, bunk3m wrote:

Hi Steve,

Thanks for your continued help.

I checked my LO and it has Formula syntax -> Excel A1.  I tried again 
to change the syntax "!" vs ".", "#" or not etc. but still getting 
ERR:510|ERR:507 or ERR:501 and the occasional #NAME?.  :-p


Please let me know if you have a problem when you try LO 5.4 Mac.  If 
it's a bug, then I'll happily add it.


I will see if I can find LO 5.1 Mac and give that a try.  Will report 
back.


B.

On 29.10.2017 21:57, Steve Edmonds wrote:

Hi.
My Mac has LO 5.1..., My Linux 5.3...
When I add the connection on my Mac as in my earlier test I get a 
formula like

='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11

I don't get any error, it calculates fine on creation of the formula, 
but cannot get it to update if the source changes.


I will update my Mac to 5.4 and see if that changes anything, but I 
would assume if the file is an ods then adding a new formula should 
result in ods formatting.

BUT from a few years ago I found

"I think the issue is the separator between sheet name and address "!",

First option)
Change Menu/Tools/Options/LibreOffice/Formula/Formula options/Formula 
syntax -> Excel A1."


So may be check Menu/Tools/Options/LibreOffice/Formula/Formula 
options/Formula syntax


Steve

On 30/10/17 09:54, bunk3m wrote:

Thank you for testing this, Steve.

I tried what you suggested near the beginning of my testing and 
tried it again just now.  When I follow your instructions, I get an 
ERR:507.


I've tried following the instructions that Remy provided [The link 
was inserted as per the instructions in the help 
(https://help.libreoffice.org/Calc/Referencing_a_Cell_in_Another_Document)] 
but I get completely different looking formula.  There is no "green 
check mark" as per the help instructions either.


Within the same spreadsheet I get similar, ie. ='tab'!cell  This 
does work.


To reference a spreadsheet outside of the present spreadsheet,

where Remy gets:
='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11
on Linux

I get:
=['file:///users/me/folder/spreadsheet.ods']'tab'!i54

This isn't what the help file shows either.

Could this be something due to the fact that this started out as an 
Excel file but was saved as an ods sometime over the past months?


I'm confused.
B.

On 29.10.2017 16:12, Steve Edmonds wrote:

Just tried on my mac.
Open the sheet I want to perform the calculation in.
Open the source sheet from which I want to fetch the data

Enter the formula in a cell in the first sheet, i.e =2*
then click in the source cell in the second sheet,
then click enter and it seems to work.
steve

On 30/10/17 07:42, bunk3m wrote:

Hello all,

I've been struggling with this one for a week now.  Google hasn't 
been my friend so far so thought I'd ask the user group.


LO 5.4.2.2 Mac 64 Bit.

I have a spreadsheet (originally in xls but now ods) where data is 
provided to a summary spreadsheet.


I am unable to get 

Re: [libreoffice-users] LO 5.4 unusable with large document including comments

[Jack Wallen]

On 10/30/2017 04:44 PM, Heiko Tietze wrote:
> Would be good when you add a comment to the ticket "me too" and report what 
> helped.
>
> On 30.10.2017 21:26, Jack Wallen wrote:
I will say this configuration only made the document usable. It's not
ideal and still really sluggish scroll through the document. What I did
was open up LO, click on Menu > Tools > Options and then configure
Memory with the following settings:

Use for LibreOffice 512 MB
Memory per object 40 MB

Even with those numbers, LO Writer is still a bit challenging to use
(albeit much improved over the default).

>> On 10/30/2017 04:15 PM, jorge Rodríguez wrote:
>>> Hi Jack and all:
>>>
>>>         Why not probe increasing memory to LibreOffice Writer:
>>>
>>>         Menu--> Tools --> Options --> Memory
>>>
>>> I hope this help,
>>>
>>> Jorge Rodríguez
>> Thank you so much, Jorge. That actually helped considerably.
>>>
>>> El 30/10/2017 a las 07:41, Jack Wallen escribió:
 I'm an author. I've been using LO for a very long time. However,
 recently I changed editors to one who does all of her editing within
 comments. Yesterday I opened the file she'd just edited, to find it
 unusable. Trying to scroll through the document was painfully slow. I
 saved the file to .docx format, opened in Apple Pages, and it had no
 problems.

 I did a bit of searching to find this a common issue with LO (documents
 with hundreds or thousands of comments becoming unusable). Thing is, I
 could not find a work-around. Is this going to be the deal breaker, or
 is there a solution for this issue?

 Thank you so much for any input anyone might have.

 Jack

>>>

-- 


  Jack Wallen

Author of dark, twisty fiction
Tech writer for TechRepublic , Linux.com
, and more.
Get Jack'd at jackwallen.com 

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

Re: [libreoffice-users] LO 5.4 unusable with large document including comments

[Heiko Tietze]

Would be good when you add a comment to the ticket "me too" and report what 
helped.

On 30.10.2017 21:26, Jack Wallen wrote:
> On 10/30/2017 04:15 PM, jorge Rodríguez wrote:
>> Hi Jack and all:
>>
>>         Why not probe increasing memory to LibreOffice Writer:
>>
>>         Menu--> Tools --> Options --> Memory
>>
>> I hope this help,
>>
>> Jorge Rodríguez
> Thank you so much, Jorge. That actually helped considerably.
>>
>>
>> El 30/10/2017 a las 07:41, Jack Wallen escribió:
>>> I'm an author. I've been using LO for a very long time. However,
>>> recently I changed editors to one who does all of her editing within
>>> comments. Yesterday I opened the file she'd just edited, to find it
>>> unusable. Trying to scroll through the document was painfully slow. I
>>> saved the file to .docx format, opened in Apple Pages, and it had no
>>> problems.
>>>
>>> I did a bit of searching to find this a common issue with LO (documents
>>> with hundreds or thousands of comments becoming unusable). Thing is, I
>>> could not find a work-around. Is this going to be the deal breaker, or
>>> is there a solution for this issue?
>>>
>>> Thank you so much for any input anyone might have.
>>>
>>> Jack
>>>
>>
>>
> 

-- 
Dr. Heiko Tietze
UX designer
Tel. +49 (0)179/1268509


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

Re: [libreoffice-users] LO 5.4 unusable with large document including comments

[Jack Wallen]

On 10/30/2017 04:15 PM, jorge Rodríguez wrote:
> Hi Jack and all:
>
>         Why not probe increasing memory to LibreOffice Writer:
>
>         Menu--> Tools --> Options --> Memory
>
> I hope this help,
>
> Jorge Rodríguez
Thank you so much, Jorge. That actually helped considerably.
>
>
> El 30/10/2017 a las 07:41, Jack Wallen escribió:
>> I'm an author. I've been using LO for a very long time. However,
>> recently I changed editors to one who does all of her editing within
>> comments. Yesterday I opened the file she'd just edited, to find it
>> unusable. Trying to scroll through the document was painfully slow. I
>> saved the file to .docx format, opened in Apple Pages, and it had no
>> problems.
>>
>> I did a bit of searching to find this a common issue with LO (documents
>> with hundreds or thousands of comments becoming unusable). Thing is, I
>> could not find a work-around. Is this going to be the deal breaker, or
>> is there a solution for this issue?
>>
>> Thank you so much for any input anyone might have.
>>
>> Jack
>>
>
>

-- 


  Jack Wallen

Author of dark, twisty fiction
Tech writer for TechRepublic , Linux.com
, and more.
Get Jack'd at jackwallen.com 

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

Re: [libreoffice-users] LO 5.4 unusable with large document including comments

[jorge Rodríguez]

Hi Jack and all:

        Why not probe increasing memory to LibreOffice Writer:

        Menu--> Tools --> Options --> Memory

I hope this help,

Jorge Rodríguez


El 30/10/2017 a las 07:41, Jack Wallen escribió:

I'm an author. I've been using LO for a very long time. However,
recently I changed editors to one who does all of her editing within
comments. Yesterday I opened the file she'd just edited, to find it
unusable. Trying to scroll through the document was painfully slow. I
saved the file to .docx format, opened in Apple Pages, and it had no
problems.

I did a bit of searching to find this a common issue with LO (documents
with hundreds or thousands of comments becoming unusable). Thing is, I
could not find a work-around. Is this going to be the deal breaker, or
is there a solution for this issue?

Thank you so much for any input anyone might have.

Jack




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

Re: [libreoffice-users] Calc 5.x Mac - syntax to link cells in two spreadsheets?

[bunk3m]

A quick update.

I wasn't able to find LO 5.1 but I did find LO 5.3 and OpenOffice 3.3. 
I downloaded and installed both LO 5.3 and OO 3.3.  LO 5.3 has the same 
issue and won't allow the link.


OO 3.3 has absolutely no problem with the linking to external files.  So 
my file does link when using OO.  This is beginning to look like a bug 
in LO 5.3 & 5.4.


I will try OO 4.x and see if there it work also.

And I will see if I have LO on a Linux VM image to see if the 
spreadsheet will work using Linux.


B.

On 30.10.2017 14:04, bunk3m wrote:

Hi Steve,

Thanks for your continued help.

I checked my LO and it has Formula syntax -> Excel A1.  I tried again to 
change the syntax "!" vs ".", "#" or not etc. but still getting 
ERR:510|ERR:507 or ERR:501 and the occasional #NAME?.  :-p


Please let me know if you have a problem when you try LO 5.4 Mac.  If 
it's a bug, then I'll happily add it.


I will see if I can find LO 5.1 Mac and give that a try.  Will report back.

B.

On 29.10.2017 21:57, Steve Edmonds wrote:

Hi.
My Mac has LO 5.1..., My Linux 5.3...
When I add the connection on my Mac as in my earlier test I get a 
formula like

='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11

I don't get any error, it calculates fine on creation of the formula, 
but cannot get it to update if the source changes.


I will update my Mac to 5.4 and see if that changes anything, but I 
would assume if the file is an ods then adding a new formula should 
result in ods formatting.

BUT from a few years ago I found

"I think the issue is the separator between sheet name and address "!",

First option)
Change Menu/Tools/Options/LibreOffice/Formula/Formula options/Formula 
syntax -> Excel A1."


So may be check Menu/Tools/Options/LibreOffice/Formula/Formula 
options/Formula syntax


Steve

On 30/10/17 09:54, bunk3m wrote:

Thank you for testing this, Steve.

I tried what you suggested near the beginning of my testing and tried 
it again just now.  When I follow your instructions, I get an ERR:507.


I've tried following the instructions that Remy provided [The link 
was inserted as per the instructions in the help 
(https://help.libreoffice.org/Calc/Referencing_a_Cell_in_Another_Document)] 
but I get completely different looking formula.  There is no "green 
check mark" as per the help instructions either.


Within the same spreadsheet I get similar, ie. ='tab'!cell  This does 
work.


To reference a spreadsheet outside of the present spreadsheet,

where Remy gets:
='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11
on Linux

I get:
=['file:///users/me/folder/spreadsheet.ods']'tab'!i54

This isn't what the help file shows either.

Could this be something due to the fact that this started out as an 
Excel file but was saved as an ods sometime over the past months?


I'm confused.
B.

On 29.10.2017 16:12, Steve Edmonds wrote:

Just tried on my mac.
Open the sheet I want to perform the calculation in.
Open the source sheet from which I want to fetch the data

Enter the formula in a cell in the first sheet, i.e =2*
then click in the source cell in the second sheet,
then click enter and it seems to work.
steve

On 30/10/17 07:42, bunk3m wrote:

Hello all,

I've been struggling with this one for a week now.  Google hasn't 
been my friend so far so thought I'd ask the user group.


LO 5.4.2.2 Mac 64 Bit.

I have a spreadsheet (originally in xls but now ods) where data is 
provided to a summary spreadsheet.


I am unable to get the syntax to link the cells in the two 
spreadsheets on my Mac.


I've tried, single and double quotes for file location, "." or "!" 
for identifying the source cell but nothing seems to work.  I get 
ERR:507/ERR:508/ERR:501/ERR:510 and occasionally #NAME?#


The file names have spaces as do the tab in the spreadsheet.

I've tried the =HYPERLINK(file:///... and ='file:///...' commands 
but that doesn't work.


I've also tried the Insert Hyperlink but that won't let me select 
the cell in target spreadsheet.


I'm loath to go back to Excel for this one spreadsheet but I've 
been linking spreadsheets in Excel for so long and it works.


I'd appreciate any Mac specific guidance.

Bunk3m.
PS on Digest mode.  Please cc me directly in addition to answering 
to the list.










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

Re: [libreoffice-users] Calc 5.x Mac - syntax to link cells in two spreadsheets?

[bunk3m]

Hi Steve,

Thanks for your continued help.

I checked my LO and it has Formula syntax -> Excel A1.  I tried again to 
change the syntax "!" vs ".", "#" or not etc. but still getting 
ERR:510|ERR:507 or ERR:501 and the occasional #NAME?.  :-p


Please let me know if you have a problem when you try LO 5.4 Mac.  If 
it's a bug, then I'll happily add it.


I will see if I can find LO 5.1 Mac and give that a try.  Will report back.

B.

On 29.10.2017 21:57, Steve Edmonds wrote:

Hi.
My Mac has LO 5.1..., My Linux 5.3...
When I add the connection on my Mac as in my earlier test I get a 
formula like

='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11

I don't get any error, it calculates fine on creation of the formula, 
but cannot get it to update if the source changes.


I will update my Mac to 5.4 and see if that changes anything, but I 
would assume if the file is an ods then adding a new formula should 
result in ods formatting.

BUT from a few years ago I found

"I think the issue is the separator between sheet name and address "!",

First option)
Change Menu/Tools/Options/LibreOffice/Formula/Formula options/Formula 
syntax -> Excel A1."


So may be check Menu/Tools/Options/LibreOffice/Formula/Formula 
options/Formula syntax


Steve

On 30/10/17 09:54, bunk3m wrote:

Thank you for testing this, Steve.

I tried what you suggested near the beginning of my testing and tried 
it again just now.  When I follow your instructions, I get an ERR:507.


I've tried following the instructions that Remy provided [The link was 
inserted as per the instructions in the help 
(https://help.libreoffice.org/Calc/Referencing_a_Cell_in_Another_Document)] 
but I get completely different looking formula.  There is no "green 
check mark" as per the help instructions either.


Within the same spreadsheet I get similar, ie. ='tab'!cell  This does 
work.


To reference a spreadsheet outside of the present spreadsheet,

where Remy gets:
='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11
on Linux

I get:
=['file:///users/me/folder/spreadsheet.ods']'tab'!i54

This isn't what the help file shows either.

Could this be something due to the fact that this started out as an 
Excel file but was saved as an ods sometime over the past months?


I'm confused.
B.

On 29.10.2017 16:12, Steve Edmonds wrote:

Just tried on my mac.
Open the sheet I want to perform the calculation in.
Open the source sheet from which I want to fetch the data

Enter the formula in a cell in the first sheet, i.e =2*
then click in the source cell in the second sheet,
then click enter and it seems to work.
steve

On 30/10/17 07:42, bunk3m wrote:

Hello all,

I've been struggling with this one for a week now.  Google hasn't 
been my friend so far so thought I'd ask the user group.


LO 5.4.2.2 Mac 64 Bit.

I have a spreadsheet (originally in xls but now ods) where data is 
provided to a summary spreadsheet.


I am unable to get the syntax to link the cells in the two 
spreadsheets on my Mac.


I've tried, single and double quotes for file location, "." or "!" 
for identifying the source cell but nothing seems to work.  I get 
ERR:507/ERR:508/ERR:501/ERR:510 and occasionally #NAME?#


The file names have spaces as do the tab in the spreadsheet.

I've tried the =HYPERLINK(file:///... and ='file:///...' commands 
but that doesn't work.


I've also tried the Insert Hyperlink but that won't let me select 
the cell in target spreadsheet.


I'm loath to go back to Excel for this one spreadsheet but I've been 
linking spreadsheets in Excel for so long and it works.


I'd appreciate any Mac specific guidance.

Bunk3m.
PS on Digest mode.  Please cc me directly in addition to answering 
to the list.










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

Re: [libreoffice-users] LO 5.4 unusable with large document including comments

[Heiko Tietze]

There are at least two bug reports, you may find many more.
https://bugs.documentfoundation.org/show_bug.cgi?id=61558
https://bugs.documentfoundation.org/show_bug.cgi?id=38295

If those don't fit just file another issue.

To my knowledge there is no good workaround. You could try the Navigator which 
has a section for comments. 

On 30.10.2017 16:40, Jack Wallen wrote:
> 
> 
> On 10/30/2017 11:26 AM, Krunose wrote:
>> On 30.10.2017 14:41, Jack Wallen wrote:
>>> I'm an author. I've been using LO for a very long time. However,
>>> recently I changed editors to one who does all of her editing within
>>> comments. Yesterday I opened the file she'd just edited, to find it
>>> unusable. Trying to scroll through the document was painfully slow. I
>>> saved the file to .docx format, opened in Apple Pages, and it had no
>>> problems.
>>>
>>> I did a bit of searching to find this a common issue with LO (documents
>>> with hundreds or thousands of comments becoming unusable). Thing is, I
>>> could not find a work-around. Is this going to be the deal breaker, or
>>> is there a solution for this issue?
>>>
>>> Thank you so much for any input anyone might have.
>>>
>>> Jack
>>>
>>
>> Well, if you have very long document, you should consider using Master
>> Document where you write every chapter in separate document and Master
>> Document acts as container. You don't edit Master Document, you just
>> print it.
>>
>> Having long text splitted in smaller chunks may help you with the
>> problem. Just remember to send all chapters (as separate documents) to
>> your editor.
>>
>> Consult documentation about this.
>>
>> Kruno
>>
>>
> Kruno, thank you for your input. Unfortunately, that isn't really an
> option. Any editor I've worked with would lose their minds having to
> manage a separate document for each chapter. On top of that, considering
> neither Apple Pages or MS Office has no problem with this, I'd like to
> think the LO developers could resolve such an issue. A work around for a
> long document with comments shouldn't be necessary.
> 

-- 
Dr. Heiko Tietze
UX designer
Tel. +49 (0)179/1268509


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

Re: [libreoffice-users] LO 5.4 unusable with large document including comments

[Jack Wallen]

On 10/30/2017 11:26 AM, Krunose wrote:
> On 30.10.2017 14:41, Jack Wallen wrote:
>> I'm an author. I've been using LO for a very long time. However,
>> recently I changed editors to one who does all of her editing within
>> comments. Yesterday I opened the file she'd just edited, to find it
>> unusable. Trying to scroll through the document was painfully slow. I
>> saved the file to .docx format, opened in Apple Pages, and it had no
>> problems.
>>
>> I did a bit of searching to find this a common issue with LO (documents
>> with hundreds or thousands of comments becoming unusable). Thing is, I
>> could not find a work-around. Is this going to be the deal breaker, or
>> is there a solution for this issue?
>>
>> Thank you so much for any input anyone might have.
>>
>> Jack
>>
>
> Well, if you have very long document, you should consider using Master
> Document where you write every chapter in separate document and Master
> Document acts as container. You don't edit Master Document, you just
> print it.
>
> Having long text splitted in smaller chunks may help you with the
> problem. Just remember to send all chapters (as separate documents) to
> your editor.
>
> Consult documentation about this.
>
> Kruno
>
>
Kruno, thank you for your input. Unfortunately, that isn't really an
option. Any editor I've worked with would lose their minds having to
manage a separate document for each chapter. On top of that, considering
neither Apple Pages or MS Office has no problem with this, I'd like to
think the LO developers could resolve such an issue. A work around for a
long document with comments shouldn't be necessary.

-- 


  Jack Wallen

Author of dark, twisty fiction
Tech writer for TechRepublic , Linux.com
, and more.
Get Jack'd at jackwallen.com 

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

Re: [libreoffice-users] LO 5.4 unusable with large document including comments

[Krunose]

On 30.10.2017 14:41, Jack Wallen wrote:

I'm an author. I've been using LO for a very long time. However,
recently I changed editors to one who does all of her editing within
comments. Yesterday I opened the file she'd just edited, to find it
unusable. Trying to scroll through the document was painfully slow. I
saved the file to .docx format, opened in Apple Pages, and it had no
problems.

I did a bit of searching to find this a common issue with LO (documents
with hundreds or thousands of comments becoming unusable). Thing is, I
could not find a work-around. Is this going to be the deal breaker, or
is there a solution for this issue?

Thank you so much for any input anyone might have.

Jack



Well, if you have very long document, you should consider using Master 
Document where you write every chapter in separate document and Master 
Document acts as container. You don't edit Master Document, you just 
print it.


Having long text splitted in smaller chunks may help you with the 
problem. Just remember to send all chapters (as separate documents) to 
your editor.


Consult documentation about this.

Kruno


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

Re: [libreoffice-users] automatic fractions

[Gary Collins]

Correction. I dont need the double click. But i *do* need to follow the 
fraction with a space before pressing CtrlZ..

G.

On Mon, 30/10/17, Regina Henschel  wrote:

 Subject: Re: [libreoffice-users] automatic fractions
 To: "Gary Collins" 
 Date: Monday, 30 October, 2017, 11:53
 
 Hi Gary,
 
 please do not replay to a single person but to
 the mailing list.
 
 Gary
 Collins schrieb:
 > Thanks for reply. It
 doesnt seem to work ctrlZ in calc 5.2.2.2 ubuntu 16.10
 returns to the cell where the fraction was entered but
 leaves it as a single character
 
 You have to use Ctrl+Z really _immediately_
 after 1/2 was replaced by ½. 
 If you have
 already written further characters or have exit edit mode,
 
 it will not work.
 
 Kind regards
 Regina
 
 >
 > G.
 >
 >
 
 > On Mon, 30/10/17, Regina Henschel 
 wrote:
 >
 >  Subject:
 Re: [libreoffice-users] automatic fractions
 >  To: users@global.libreoffice.org
 >  Date: Monday, 30 October, 2017, 11:30
 >
 >  Hi Gary,
 >
 >  Gary
 >  Collins schrieb:
 > 
 > Hi
 >  > Usually its a useful
 thing to have
 >  fractions like 1/2
 converted to a single character but
 > 
 sometimes its better if the characters are kept separate,
 eg
 >  if used along with other fractions
 that dont have a single
 >  character
 representation, eg 5/7.
 >  >
 >  > Is it possible to cancel the
 conversion on
 >  a one-off basis, ie
 without having to alter preferences,
 > 
 conversion tables or whatever?
 >
 >  Yes. Press Ctrl+Z immediately after
 the
 >  conversion happens.
 >
 >  Kind
 >  regards
 >  Regina
 >
 >
 >  --
 >  To
 >  unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 >  Problems? 
 >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 >  Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
 >  List archive: https://listarchives.libreoffice.org/global/users/
 >  All messages sent to this list will be
 publicly
 >  archived and cannot be
 deleted
 >
 >
 
 

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

Re: [libreoffice-users] automatic fractions

[Gary Collins]

Sorry i thought i had replied to list but it seems i was mistaken. Ive got it 
sussed now, i have to *double click* in the cell and then *add a space* after 
the fraction before pressing ctrlZ (as the fraction was the only text in the 
cell, i didn't think to do either of these). Then it works just as i need it 
to. Thanks for your help.

G.

On Mon, 30/10/17, Regina Henschel  wrote:

 Subject: Re: [libreoffice-users] automatic fractions
 To: "Gary Collins" 
 Date: Monday, 30 October, 2017, 11:53
 
 Hi Gary,
 
 please do not replay to a single person but to
 the mailing list.
 
 Gary
 Collins schrieb:
 > Thanks for reply. It
 doesnt seem to work ctrlZ in calc 5.2.2.2 ubuntu 16.10
 returns to the cell where the fraction was entered but
 leaves it as a single character
 
 You have to use Ctrl+Z really _immediately_
 after 1/2 was replaced by ½. 
 If you have
 already written further characters or have exit edit mode,
 
 it will not work.
 
 Kind regards
 Regina
 
 >
 > G.
 >
 >
 
 > On Mon, 30/10/17, Regina Henschel 
 wrote:
 >
 >  Subject:
 Re: [libreoffice-users] automatic fractions
 >  To: users@global.libreoffice.org
 >  Date: Monday, 30 October, 2017, 11:30
 >
 >  Hi Gary,
 >
 >  Gary
 >  Collins schrieb:
 > 
 > Hi
 >  > Usually its a useful
 thing to have
 >  fractions like 1/2
 converted to a single character but
 > 
 sometimes its better if the characters are kept separate,
 eg
 >  if used along with other fractions
 that dont have a single
 >  character
 representation, eg 5/7.
 >  >
 >  > Is it possible to cancel the
 conversion on
 >  a one-off basis, ie
 without having to alter preferences,
 > 
 conversion tables or whatever?
 >
 >  Yes. Press Ctrl+Z immediately after
 the
 >  conversion happens.
 >
 >  Kind
 >  regards
 >  Regina
 >
 >
 >  --
 >  To
 >  unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 >  Problems? 
 >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 >  Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
 >  List archive: https://listarchives.libreoffice.org/global/users/
 >  All messages sent to this list will be
 publicly
 >  archived and cannot be
 deleted
 >
 >
 
 

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

[libreoffice-users] Re: automatic fractions

[V Stuart Foote]

The "conversion" is done in the AutoCorrect. From Tools -> AutoCorrect ->
AutoCorrect Options you can disable, or modify the  replacement table to add
the additional franctional forms, or remove them all.   Play with it a bit,
several ways to adjust.

A profile reset will restore defaults.



--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

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

[libreoffice-users] LO 5.4 unusable with large document including comments

[Jack Wallen]

I'm an author. I've been using LO for a very long time. However,
recently I changed editors to one who does all of her editing within
comments. Yesterday I opened the file she'd just edited, to find it
unusable. Trying to scroll through the document was painfully slow. I
saved the file to .docx format, opened in Apple Pages, and it had no
problems.

I did a bit of searching to find this a common issue with LO (documents
with hundreds or thousands of comments becoming unusable). Thing is, I
could not find a work-around. Is this going to be the deal breaker, or
is there a solution for this issue?

Thank you so much for any input anyone might have.

Jack

-- 


  Jack Wallen

Author of dark, twisty fiction
Tech writer for TechRepublic , Linux.com
, and more.
Get Jack'd at jackwallen.com 

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

Re: [libreoffice-users] automatic fractions

[Regina Henschel]

Hi Gary,

Gary Collins schrieb:

Hi
Usually its a useful thing to have fractions like 1/2 converted to a single 
character but sometimes its better if the characters are kept separate, eg if 
used along with other fractions that dont have a single character 
representation, eg 5/7.

Is it possible to cancel the conversion on a one-off basis, ie without having 
to alter preferences, conversion tables or whatever?


Yes. Press Ctrl+Z immediately after the conversion happens.

Kind regards
Regina


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

[libreoffice-users] automatic fractions

[Gary Collins]

Hi
Usually its a useful thing to have fractions like 1/2 converted to a single 
character but sometimes its better if the characters are kept separate, eg if 
used along with other fractions that dont have a single character 
representation, eg 5/7.

Is it possible to cancel the conversion on a one-off basis, ie without having 
to alter preferences, conversion tables or whatever?

Thanks
Gary

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

[libreoffice-users] problem spell check dictionaries c/n/b installed.. LO

[fudmier]

ubuntu 16.04  amd 64 LTS Haswell Chip Set
Version: 5.1.6.2  Build ID: 1:5.1.6~rc2-0ubuntu1~xenial2
CPU Threads: 2; OS Version: Linux 4.4; UI Render: default;
Locale: en-CA (en_CA.UTF-8); Calc: group

dictionaries will not attach to the spell checker message in writer.  
Spell checker c/n be activated by checking it in the menu.  When clicked 
on in the menu drop down the checkeer checked the document and found no 
spelling errors, but w/o a directory to check spelling against it found 
no error; and there were many errors to be found.


no matter what I do, I cannot get the add to dictionary to add a 
dictionary  of any kind
each click to add to dictionary.. returns  "spell check complete".. and 
drops me out to the document.


how can that be fixed?  Is this a permissions problem of some kind?


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