[sc-issues] [Issue 63452] Err: 522 if "Save Autoreco very information" occurs during recalculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63452 User fst changed the following: What|Old value |New value Assigned to|spreadsheet |nn Status|REOPENED |NEW Target milestone|--- |OOo Later --- Additional comments from [EMAIL PROTECTED] Thu Apr 12 10:14:01 + 2007 --- Hi Niklas, I'm not sure if it's yours, but if not please re-assign. Frank - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 63452] Err: 522 if "Save Autoreco very information" occurs during recalculation
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=63452
User gercokees changed the following:
What|Old value |New value
Attachment data| |Created an attachment (id=
| |44052)
set autosave on 1 m
| |inute, then, press {ctrl}+
| |{shift}+{f9} until error o
| |ccurs
--- Additional comments from [EMAIL PROTECTED] Fri Mar 30 09:14:49 +
2007 ---
Created an attachment (id=44052)
set autosave on 1 minute, then, press {ctrl}+{shift}+{f9} until error occurs
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 63452] Err: 522 if "Save Autoreco very information" occurs during recalculation
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=63452
User gercokees changed the following:
What|Old value |New value
Status|CLOSED|REOPENED
Resolution|WORKSFORME|
--- Additional comments from [EMAIL PROTECTED] Fri Mar 30 09:13:14 +
2007 ---
I reopen this issue, because in my opinion the problem still persists in OOo 2.2
i think it has to do something with vb-functions calling other functions.
I submit an attachment where the error occurs.
use the vb-functions below, and be sure to use {ctrl}+{shift}+{f9}. Then, when a
"save autorecovery information" occurs during the recalculation, on cell gets an
error "Err:522"
greetz...
Function Test(one, two, three)
Test = one * (1 + int(two / 0.4 / test2(three) + 0.999))
End Function
Function test2(three)
velocities = Array(-1, 3000, 1200, 3000, 3000, 240, 120, 1250, 240,
1250, 1250,
240, 600, 170, 25, 999, 999, 999, 999, 999, 999)
test2=velocities(three)
End Function
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 63452] Err: 522 if "Save Autoreco very information" occurs during recalculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63452 --- Additional comments from [EMAIL PROTECTED] Tue Mar 27 12:28:40 + 2007 --- i give this one a try as soon as version 2.2 is available. (I need a stable version of OOo because of production). I will then post my conclusions here... - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 63452] Err: 522 if "Save Autoreco very information" occurs during recalculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63452 User fst changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Tue Mar 27 12:26:38 + 2007 --- closed wfm - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 63452] Err: 522 if "Save Autoreco very information" occurs during recalculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63452 User fst changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |WORKSFORME --- Additional comments from [EMAIL PROTECTED] Tue Mar 27 12:25:26 + 2007 --- could not reproduce using OOo2.2rc4 therefore closed wfm - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 63452] Err: 522 if "Save Autoreco very information" occurs during recalculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63452 --- Additional comments from [EMAIL PROTECTED] Tue Mar 20 10:05:55 + 2007 --- Hi, have tried the operations outlined by gercokees with OOo2.2rc3 and was not able to reproduce. Gercokees have you tried it with the latest rc too ? Frank - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 63452] Err: 522 if "Save Autoreco very information" occurs during recalculation
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=63452
User gercokees changed the following:
What|Old value |New value
Ever confirmed| |1
Status|UNCONFIRMED |NEW
--- Additional comments from [EMAIL PROTECTED] Tue Mar 20 08:15:52 +
2007 ---
Hi,
I can confirm this behavour. To reproduce follow the following procedure (force
frequent autorecovery saving, toggle a simple basic function, use the function a
lot in the sheet and recalculate, so that an autorecovery-saving is done in the
end of the calculation...)
0) Start a worksheet, save it somewhere
1) Goto: Tools > Options > Load/Save > General > Check autorecoveryinformation
and choose: 1 minute.
2) Goto: Tools > Macros > Organize macros > OpenOfice.Org Basic > New and enter
the following function:
Function test(one, two)
tmp = iif(one <> 0, 1, 2)
test = 0 + tmp * two
End Function
3) In your sheet, in cell a3 enter: =test(0;1)
4) Copy cell a3 down until cell 1003
5) In cell a1 enter: sum(a3:a1003)
Now, force a recalculation a few times (use {ctrl}+{f9}
when an autosave is performed during a recalculation, one of the 1000 cells
contains an error: Err522. You can see that in cell a1 ofcourse.
The workaround for this is to save the sheet, just before recalculating it, so
that no autosaving is performed during the calculatingproces (ofcourse set
autosaving to 15 minutes then...)
Greetz,
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 63452] Err: 522 if "Save Autoreco very information" occurs during recalculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63452 User gercokees changed the following: What|Old value |New value CC|''|'gercokees' --- Additional comments from [EMAIL PROTECTED] Mon Mar 19 10:55:55 + 2007 --- hi, im busy with this one... - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 63452] Err: 522 if "Save Autoreco very information" occurs during recalculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63452 User gfim changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |41029) please ignore previ | |ous attachment and use thi | |s one instead!!! --- Additional comments from [EMAIL PROTECTED] Thu Nov 30 14:10:26 -0800 2006 --- Created an attachment (id=41029) please ignore previous attachment and use this one instead!!! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 63452] Err: 522 if "Save Autoreco very information" occurs during recalculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63452 User gfim changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |41028) Basic function defi | |nitions as a text file (fo | |r pasting into OOo) --- Additional comments from [EMAIL PROTECTED] Thu Nov 30 14:06:26 -0800 2006 --- Created an attachment (id=41028) Basic function definitions as a text file (for pasting into OOo) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 63452] Err: 522 if "Save Autoreco very information" occurs during recalculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63452 --- Additional comments from [EMAIL PROTECTED] Thu Nov 30 14:04:18 -0800 2006 --- I don't know how to add function definitions to the ODS file. If OOo is crashing your computer, then that sounds like something you should report as a bug!! The copy/paste method seems like the easiest to me. The functions definitions should start with "Function SlideDisp(slides, volume, profile)" and end with "PM_CONFIRM_REAGENT_VOLUME = 0" follwed on the next line by "end function". I'll upload the contents of the function definitions to the issue as a text file. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 63452] Err: 522 if "Save Autoreco very information" occurs during recalculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63452 --- Additional comments from [EMAIL PROTECTED] Thu Nov 30 00:16:18 -0800 2006 --- hmm, I tried both your solutions to the .xba file, but could not get the job done. I had to restart my computer three times now :-( Is it possible to add the functions to your .ods-file? When i do it myself there is always a missing "<" or "then" statement wich causes ooo to freeze my computer... (Tools menu -> Macros -> Organize macros -> OpenOffice.org Basic then Edit) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 63452] Err: 522 if "Save Autoreco very information" occurs during recalculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63452 --- Additional comments from [EMAIL PROTECTED] Wed Nov 29 13:52:33 -0800 2006 --- I don't think you should "open" the file using OOo. You either: - put it in the right place (in my case, it came from "C:\Documents and Settings\zgm\Application Data\OpenOffice.org2\user\basic\Standard" (on Windows obviously, and my login name is "zgm"), or - paste most of it (everything except the XML header and footer) into the OOo Basic macro window (Tools menu -> Macros -> Organize macros -> OpenOffice.org Basic then Edit). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 63452] Err: 522 if "Save Autoreco very information" occurs during recalculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63452 --- Additional comments from [EMAIL PROTECTED] Wed Nov 29 02:18:19 -0800 2006 --- Hi, I Tried to open your xba-file, but i could not get it to work. Can you please explain the steps for me (sometimes i feel like a novice...) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
