[libreoffice-users] Re: Calc 3.6.0 takes a lot of time editing any cell o a file
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
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
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
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
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