[libreoffice-users] Re: Calc 3.6.0 takes a lot of time editing any cell o a file

2012-08-13 Thread Juan Antonio
In Calc 3.6, the conditional formatting with a condition of type * 'Formula
is'* doesn't work well. In my sheet I have logic formulas, for example *
'Sheet1'.A1'Sheet1'.A2*, and they don't work.

If the file was created with a previous version, in Calc 3.6 the conditon
appears as* 'Sheet1'.#REF!1'Sheet1'.#REF!1*.

And, if I create a file with Calc 3.6 and open it with 3.5, surprisingly the
conditon appears as * 'Sheet1'.B1'Sheet1'.B2* (has changed the references
to cells)

It looks like Calc 3.6 changes the references of the cells in the
conditional formatting with conditions of type* 'Formula is'*



--
View this message in context: 
http://nabble.documentfoundation.org/Calc-3-6-0-takes-a-lot-of-time-editing-any-cell-of-a-file-tp4000339p4001010.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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: Calc 3.6.0 takes a lot of time editing any cell o a file

2012-08-11 Thread Juan Antonio
This problem doesn't occur in all files but in one file with calculations.
The option 'Autocalculate' is activated. 

There are simple calculations and conditional formatting. There are not
large matrix formulas.

This is in all cells, including empty cells, with any change. For example,
if I enter a word in an empty cell, Calc stops and, if I click the mouse
anywhere it hangs. After  some minutes it becames ready again.

With Calc 3.5 and previous this problem didn't exist with the same file.



--
View this message in context: 
http://nabble.documentfoundation.org/Calc-3-6-0-takes-a-lot-of-time-editing-any-cell-of-a-file-tp4000339p4000582.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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: Calc 3.6.0 takes a lot of time editing any cell o a file

2012-08-11 Thread MiguelAngel

El 11/08/12 11:04, Juan Antonio escribió:

This problem doesn't occur in all files but in one file with calculations.
The option 'Autocalculate' is activated.

There are simple calculations and conditional formatting. There are not
large matrix formulas.

This is in all cells, including empty cells, with any change. For example,
if I enter a word in an empty cell, Calc stops and, if I click the mouse
anywhere it hangs. After  some minutes it becames ready again.

With Calc 3.5 and previous this problem didn't exist with the same file.



--
View this message in context: 
http://nabble.documentfoundation.org/Calc-3-6-0-takes-a-lot-of-time-editing-any-cell-of-a-file-tp4000339p4000582.html
Sent from the Users mailing list archive at Nabble.com.


Take a look to this bug:
https://bugs.freedesktop.org/show_bug.cgi?id=49764

--
For unsubscribe instructions e-mail to: users+h...@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: Calc 3.6.0 takes a lot of time editing any cell o a file

2012-08-10 Thread Juan Antonio
This problem occurs in both Windows XP and 7



--
View this message in context: 
http://nabble.documentfoundation.org/Calc-3-6-0-takes-a-lot-of-time-editing-any-cell-of-a-file-tp4000339p4000481.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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: Calc 3.6.0 takes a lot of time editing any cell o a file

2012-08-10 Thread MiguelAngel

El 10/08/12 17:41, Juan Antonio escribió:

This problem occurs in both Windows XP and 7



--
View this message in context: 
http://nabble.documentfoundation.org/Calc-3-6-0-takes-a-lot-of-time-editing-any-cell-of-a-file-tp4000339p4000481.html
Sent from the Users mailing list archive at Nabble.com.

Have you intensive calculations?, Try modifying Menu/Tools/Cell 
contents/Autocalculate.

Is this in all cells or only cell with conditional formatting?
Are there large matrix formulas?


--
For unsubscribe instructions e-mail to: users+h...@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