[sc-issues] [Issue 115360] New function for Calc / I ndenting and summing up lines
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115360 User discoleo changed the following: What|Old value |New value CC|''|'discoleo' --- Additional comments from disco...@openoffice.org Mon Nov 22 21:56:33 + 2010 --- Should be combined with special styles. Line indenting should be actually a style: - Style Total - Style Subtotal level 1 - ... - Style Data - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[graphics-issues] [Issue 115387] Support copy paste for the position and size values in the status b ar
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115387 User discoleo changed the following: What|Old value |New value CC|''|'discoleo' --- Additional comments from disco...@openoffice.org Mon Nov 22 22:34:21 + 2010 --- More broadly speaking: when copying an element from the status-bar (when implemented), it should actually copy an object of class corresponding to the displayed element. If pasting in an application that understands that object, then the object should be pasted. Otherwise, the textual representation of that object should be pasted. Beyond Draw, I can imagine this very usefull in Calc: e.g. selecting a column, the count is displayed. Now copying the count would copy an object of type COUNT on the selected range. When pasting in a cell, the corresponding formula would be pasted. Pasting somewhere else, will paste only the textual value of that count. - 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: issues-unsubscr...@graphics.openoffice.org For additional commands, e-mail: issues-h...@graphics.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 113877] Program runs into brief ' not responding' freeze-ups during file input a nd editing input
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113877 User discoleo changed the following: What|Old value |New value CC|''|'discoleo' --- Additional comments from disco...@openoffice.org Sat Aug 14 11:42:58 + 2010 --- This is probably the same as: http://www.openoffice.org/issues/show_bug.cgi?id=103424 I can confirm that on slower systems, Calc becomes unresponsive during the background sava operation. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 113877] Program runs into brief ' not responding' freeze-ups during file input a nd editing input
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113877 --- Additional comments from disco...@openoffice.org Sat Aug 14 11:44:36 + 2010 --- Note: actually the 2 issues are not the same, but probably related as file input and background save probably perform similar operations. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[graphics-issues] [Issue 61613] HTML Slidy/S5 compatbility
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=61613 User discoleo changed the following: What|Old value |New value CC|'davidfraser,gleppert'|'davidfraser,discoleo,glep | |pert' - 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: issues-unsubscr...@graphics.openoffice.org For additional commands, e-mail: issues-h...@graphics.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 20495] Q-PCD EaseOfUse-NN-02 Al low (A:A) as range in functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=20495 User discoleo changed the following: What|Old value |New value CC|'er,fl,kpalagin,swubuntu' |'discoleo,er,fl,kpalagin,s | |wubuntu' - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[framework-issues] [Issue 110102] The user interface langua ge cannot be determined.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110102 --- Additional comments from disco...@openoffice.org Sun Jun 6 10:55:24 + 2010 --- I was able to solve the issue, but only after: 1.) uninstalling OOo 2.) deleting ALL OOo-related directories 3.) reinstalling OOo will start now. It was necessary to delete every old directory. Plain uninstall did not help! I have searched the web for similar cases. One is described on http://ubuntuforums.org/showthread.php?t=586455page=2, although it is Linux-related. My case is a Win2k. However, the common points are that I too uninstalled at some point the OOo to have a clean install. This seems to have resulted in a number of adverse consequences. A newer install on an unintalled version seems to cause a lot of troubles. It is necessary to delete ALL previous directories in order to work again. This is a pain, because I had a number of dictionaries installed, which are now gone. - 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: issues-unsubscr...@framework.openoffice.org For additional commands, e-mail: issues-h...@framework.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[framework-issues] [Issue 110720] Aborting when UI-languag e cannot be determined since DEV300_m76
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110720 --- Additional comments from disco...@openoffice.org Fri Jun 4 11:35:51 + 2010 --- I am installing OOo as always: 1. start OOo installer (dev80 in this case) 2. select Custom install 3. left all settings as is (selected only custom to check that everything is fine, as I do have some unorthodox directories) Everything progresses as expected. [Java v20 was also installed the first time I installed dev80 - it wasn't installed afterward anymore - I hope it is not related to this install.] As mentioned in another issue: App data is on the C drive, while the program is installed on the L drive. If needed, I can send you (in the evening today) various ini files per mail - please specify which ones. Reinstalling did not solve the issue. I did not check if deleting all the previous directories will solve the issue - I only noticed afterward that older directories are still lurking on my computer. I do not have a stable release installed either. Some errors may be related to the fact that I do not have a stable release installed (and therefore NOT reproducible if the stable release is still installed on the computer). I believe this was one issue for the java-errors (I received on previous installs often an error related to java - and I now believe that that error was related to uninstalling the stable release). - 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: issues-unsubscr...@framework.openoffice.org For additional commands, e-mail: issues-h...@framework.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[framework-issues] [Issue 110102] The user interface langua ge cannot be determined.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110102 User discoleo changed the following: What|Old value |New value CC|'hdu,rainerbielefeld' |'discoleo,hdu,rainerbielef | |eld' --- Additional comments from disco...@openoffice.org Thu Jun 3 19:17:49 + 2010 --- I had this problem with m76 on Win2k SP4. I have it again with m80 (I did not install any other version in between). The previous solution does not work anymore (changing bootstrap.ini does not solve the issue). Should be changed to P1 as I am not able to start 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: issues-unsubscr...@framework.openoffice.org For additional commands, e-mail: issues-h...@framework.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[framework-issues] [Issue 110102] The user interface langua ge cannot be determined.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110102 --- Additional comments from disco...@openoffice.org Thu Jun 3 19:20:35 + 2010 --- Just some further information: Win2k SP4 English locale OOo installed in: L:\Programs\Text\OOo-dev Application Data: C:\Documents and Settings\Administrator\Application Data\OOo-dev\3 Contents of bootstrap.ini file: [Bootstrap] BaseInstallation=${OOO_BASE_DIR} InstallMode=installmode ProductKey=OOo-dev 3.3 UserInstallation=$SYSUSERCONFIG/OOo-dev/3 [ErrorReport] ErrorReportPort=80 ErrorReportServer=report.services.openoffice.org - 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: issues-unsubscr...@framework.openoffice.org For additional commands, e-mail: issues-h...@framework.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[framework-issues] [Issue 110102] The user interface langua ge cannot be determined.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110102 --- Additional comments from disco...@openoffice.org Thu Jun 3 19:25:34 + 2010 --- Apologies, OOo install directory is: OOo installed in: L:\Programs\Text\OOo-dev 3 There is a second directory: L:\Programs\Text\OOo-dev (of only a few 100 kb). I believe this is from an older install. - 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: issues-unsubscr...@framework.openoffice.org For additional commands, e-mail: issues-h...@framework.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[framework-issues] [Issue 110720] Aborting when UI-languag e cannot be determined since DEV300_m76
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110720 User discoleo changed the following: What|Old value |New value CC|'rainerbielefeld' |'discoleo,rainerbielefeld' --- Additional comments from disco...@openoffice.org Thu Jun 3 19:42:51 + 2010 --- I have this problem again with m80. The previous solution (with bootstrap.ini) does not work amnymore - see issue 110102 for further comments. That one is a P1 for me. - 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: issues-unsubscr...@framework.openoffice.org For additional commands, e-mail: issues-h...@framework.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[framework-issues] [Issue 110789] Error: The application ca nnot be started. User interface language Error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110789 Issue #|110789 Summary|Error: The application cannot be started. User interfa |ce language Error Component|framework Version|DEV300m76 Platform|PC URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|code Assigned to|tm Reported by|discoleo --- Additional comments from disco...@openoffice.org Sun Apr 11 21:24:23 + 2010 --- I just installed OOo-dev m76, but I am unable to start OOo, instead receiving the following error: The application cannot be started. The user interface language cannot be determined. Unfortunately, this means I cannot open any documents, nor do anything with OOo. I will try to install an older version of OOo in the meantime. - 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: issues-unsubscr...@framework.openoffice.org For additional commands, e-mail: issues-h...@framework.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[framework-issues] [Issue 109410] Fatal Error - cannot star t application
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109410 User discoleo changed the following: What|Old value |New value CC|''|'discoleo' --- Additional comments from disco...@openoffice.org Sun Apr 11 21:30:29 + 2010 --- Please also look at: http://www.openoffice.org/issues/show_bug.cgi?id=110789 It may be the same issue. I always install to a different drive, and up to m72 it worked correctly. I just installed m76 now, and I get this Language error. - 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: issues-unsubscr...@framework.openoffice.org For additional commands, e-mail: issues-h...@framework.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[framework-issues] [Issue 110102] The user interface langua ge cannot be determined.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110102 --- Additional comments from disco...@openoffice.org Sun Apr 11 21:43:05 + 2010 --- Correcting the entry in bootstrap.ini solved my problem as well. However, this error should not happen in the first place. Was introduced somewhere between m72 (is OK) and m76 (broken). - 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: issues-unsubscr...@framework.openoffice.org For additional commands, e-mail: issues-h...@framework.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[framework-issues] [Issue 110789] Error: The application ca nnot be started. User interface language Error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110789 --- Additional comments from disco...@openoffice.org Sun Apr 11 21:45:27 + 2010 --- This is a duplicate of issue 110102, however I am unable to close it as a duplicate. For some reason bugzilla will leave the issue as unconfirmed and not resolved. - 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: issues-unsubscr...@framework.openoffice.org For additional commands, e-mail: issues-h...@framework.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[framework-issues] [Issue 109302] OOO320m12 reports defecti ve jre
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109302 --- Additional comments from disco...@openoffice.org Thu Mar 25 19:32:59 + 2010 --- This issue may be related to issue 109788. http://www.openoffice.org/issues/show_bug.cgi?id=109788 The solution I found for that issue was to delet the file: \Application Data\OOo-dev3\user\config\javasettings_Windows_x86.xml OOo did not display afterwards the error anymore. - 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: issues-unsubscr...@framework.openoffice.org For additional commands, e-mail: issues-h...@framework.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[framework-issues] [Issue 109302] OOO320m12 reports defecti ve jre
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109302 --- Additional comments from disco...@openoffice.org Thu Mar 25 19:36:06 + 2010 --- It may be related to uninstalling a previous version and/or installing a dev-version. - 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: issues-unsubscr...@framework.openoffice.org For additional commands, e-mail: issues-h...@framework.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[framework-issues] [Issue 109788] Defefctive JRE during OOo startup
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109788 Issue #|109788 Summary|Defefctive JRE during OOo startup Component|framework Version|DEV300m72 Platform|PC URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|tm Reported by|discoleo --- Additional comments from disco...@openoffice.org Wed Mar 3 20:14:01 + 2010 --- OOo still returns an error on startup that JRE is defcetive, even after installing OOo-dev300-m72 which is bundled with Java 1.6_v18. This error is older, and I received it with many previous versions of OOo, although it still persists in this latest version of OOo-dev. OOo would start despite this error. After searching the internet, and deleting the file: Application Data\OOo-dev3\user\config\javasettings_Windows_x86.xml OOo does not disply this error anymore. OOo should replace the content of this file with the latest version of the Java-path (or plainly delete this file), when installing a newer Java version. - 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: issues-unsubscr...@framework.openoffice.org For additional commands, e-mail: issues-h...@framework.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 109691] possible bug in MEDIAN() function of OOo Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109691 --- Additional comments from disco...@openoffice.org Wed Mar 3 20:39:45 + 2010 --- Invalid, as when ranking: 179; 199; 202; 229; 249; 263; 263; 263; 227 we get: (1)179; (2)199; (3)202; !! (5)229; (6)249; (7)263; (8)263; (9)263; (4)227 !! And the middle corresponds to rank (5) which corresponds to the number: 229! - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 109365] copy column copies 65536 rows
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109365 User discoleo changed the following: What|Old value |New value CC|''|'discoleo' - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[installation-issues] [Issue 108414] Kernel API GetNativeSyste mInfo only available afer WinXP
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108414 User discoleo changed the following: What|Old value |New value CC|'is' |'discoleo,is' --- Additional comments from disco...@openoffice.org Fri Jan 29 21:33:34 + 2010 --- Is it possible to get an updated install.exe for the m70 build? I would rather not want to wait till m7x comes out and I would be very grateful if I could get simply the install executable. Thank you. - 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: issues-unsubscr...@installation.openoffice.org For additional commands, e-mail: issues-h...@installation.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[installation-issues] [Issue 108745] Error when trying to insa ll on Win2k SP4
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108745 Issue #|108745 Summary|Error when trying to insall on Win2k SP4 Component|Installation Version|DEV300m70 Platform|PC URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|code Assigned to|of Reported by|discoleo --- Additional comments from disco...@openoffice.org Thu Jan 28 17:52:28 + 2010 --- When trying to install on Win2k SP4, the setup program exits with the following code: The procedure entry point GetNativeSystemInfo could not be located in the dynamic link library KERNEL32.dll I am not able to install OOo dev300-m70 (the latest development build). My existing installation is m60, I have not checked other versions between m60 and m70. I hope that support for Win2k is reestablished, otherwise I would be very disappointed by OOo. Thank you. - 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: issues-unsubscr...@installation.openoffice.org For additional commands, e-mail: issues-h...@installation.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 108441] New formula options for C alc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108441 User discoleo changed the following: What|Old value |New value CC|''|'discoleo' --- Additional comments from disco...@openoffice.org Tue Jan 19 17:50:13 + 2010 --- The generic issue is finding the last entry in a list/spreadsheet. Although Calc does not support selecting a whole row or column (it always generates a cellrange with start stop-cells), lets suppose it is possible to select a generic row or column. I will symbolize this as [Row_n] and [Column_n] (this is different from Rows[1:MaxRow]). The issue is then finding the last element in [Row_n] or in [Column_n]. The more generic range: [Row_ri:Row_rj][Column_ci:Column_cj] can be decomposed into: MAX(Column_ci:Column_cj] between the Rows [ri, rj] or MAX(Row_ri:Row_rj] berween the Columns [ci, cj] depending on request to have the last horizontal, or last vertical element. - Actually, the more accurate function is: MAX(1:Column_cj] - MAX(1:(Column_ci-1)) between the Rows [ri, rj] - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 107509] Wrong rank computation of sum values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107509 User discoleo changed the following: What|Old value |New value CC|''|'discoleo' --- Additional comments from disco...@openoffice.org Wed Dec 9 16:31:08 + 2009 --- Weird issue, probably because of rounding in one case, and no rounding in the other case. The 2 sums are probably different using floating point arithmetic, though Clac is likely to round them to the nearest shortest number when displaying the result. This result may however behave oddly in subsequent operations: the rounded value might be used by the IF() function, while the extended result is used by the RANK() function. The handling of floating point results in Calc needs to be confirmed by a someone familiar with the code, though (either Eike or Niklas). - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 84411] Copy while whole column se lected should trim trailing cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84411 User discoleo changed the following: What|Old value |New value CC|'jeongkyu'|'discoleo,jeongkyu' --- Additional comments from disco...@openoffice.org Sun Nov 1 18:13:46 + 2009 --- This is a critical issue. Added myself to the cc-list. There was also a discussion on the OASIS TC list regarding an application dependent Table Grid Size element and my alternative suggestion for the actual spreadsheet size. I believe that the alternative is much more elegant and useful, especially for this particular issue, see: http://lists.oasis-open.org/archives/office-comment/200811/msg6.html - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 106464] Can't enter DB: in a cell
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106464 --- Additional comments from disco...@openoffice.org Fri Oct 30 19:35:02 + 2009 --- @regina: The URL recognition seems to be badly broken. Only :DB: seems to be affected. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103424] Calc: Background AutoReco very freezes Calc, making it unusable
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103424 --- Additional comments from disco...@openoffice.org Sun Oct 25 14:56:11 + 2009 --- Dear Rainer, the problem persists with the version I have currently installed (m60). I had a closer look some time ago, and, while true that OOo becomes again responsive during *brief* moments in time, it is mostly unresponsive. It becomes responsive for short periods of time, but then again becomes unresponsive, then again briefly responsive, then again unresponsive. I have tested this with a smaller spreadsheet on my 1 GHz PC. If I get some time next week, I will try to test it on a faster processor, too (though then I will open simultaneously a couple of realistic spreadsheets). The problem is that, despite Calc becoming responsive again for brief periods of time, it is mostly unresponsive, and so it makes any concurrent work impossible. With unresponsive I mean that the UI interface is unresponsive while Calc saves the document in the background, and this is also true of any other instance of Calc concurrently running. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 105611] If 'search_text' is not f ound, let FIND() and SEARCH() return 0 instead of a #VALUE error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105611 --- Additional comments from disco...@openoffice.org Tue Oct 6 16:28:15 + 2009 --- This is actually a duplicate of issue 66590 (http://www.openoffice.org/issues/show_bug.cgi?id=66590) - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 105612] Provide a RICHTEXT() func tion for dynamic text formatting of formula ou tput in cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105612 --- Additional comments from disco...@openoffice.org Tue Oct 6 16:34:42 + 2009 --- I would probably suggest something like: 1.) HTMLSTYLE(string) Format using html-tags 2.) HTMLENCODE(string) eencode the string as valid html text 3.) HTMLDECODE(string) decode html-encoded string to plain text 4.) ODFSTYLE(string) Format string, interpreting it as an ODF-stream - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 105659] Calc: ODF: Split Conditio nal Formatting Details from Content Stream
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105659 Issue #|105659 Summary|Calc: ODF: Split Conditional Formatting Details from C |ontent Stream Component|Spreadsheet Version|DEV300m60 Platform|PC URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|discoleo --- Additional comments from disco...@openoffice.org Tue Oct 6 18:58:38 + 2009 --- A.) THE PROBLEM Lets suppose we want to do some useful, but more complex Conditional Formatting: 1.) suppose we want to identify every *start* of a new series of records (rows) - suppose row 1 is the header row - we select everything (except row 1), and enter the following conditional formatting, based on the formula: =IF($A1 = $A2; FALSE; TRUE) [as said, A1 was not selected] - IF a number of rows delimit unique items, than we need slightly more complex formulas: =IF(CONCATENATE($A1; $B1; ...) = CONCATENATE($A2; $B2; ...); FALSE; TRUE) 2.) suppose we create a really complex conditional formatting schema [Actually, I think this is not possible yet in OOo, but I often do such work in Excel 2007.] 3.) suppose now that we want to apply this conditional formatting to multiple sheets and spreadsheets. I want to have this conditional formatting schema applied easily to different spreadsheets. B.) SOLUTION From my point of view, I would like something like CSS within HTML: separate the 2 layers: *Content* and *Conditional Formatting*. 1.) This needs ODF-changes, too: add a separate stream for conditional formatting. 2.) Allow exporting/importing the conditional formatting stream. This way, it becomes easy to clone the conditional formatting to different sheets, and to apply minor tweaks to this formatting. This would greatly enhance the conditional formatting experience. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 105659] Calc: ODF: Split Conditio nal Formatting Details from Content Stream
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105659 User discoleo changed the following: What|Old value |New value Issue type|DEFECT|FEATURE - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sw-issues] [Issue 105217] Long outstanding, importa nt Writer issues
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105217 User discoleo changed the following: What|Old value |New value CC|'regina' |'discoleo,regina' --- Additional comments from disco...@openoffice.org Sun Sep 20 16:17:04 + 2009 --- Wrong problem very much resembles the *State of denial* that many people adopt when facing a true problem. Add myself to cc-list. - 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: issues-unsubscr...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 64604] Allow Calc DataProvider to handle named ranges (new chart)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=64604 User discoleo changed the following: What|Old value |New value CC|'pagalmes,regina' |'discoleo,pagalmes,regina' - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sw-issues] [Issue 96713] Sort order not correct in alphabetical index in Romanian language
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96713 --- Additional comments from disco...@openoffice.org Tue Aug 4 10:21:05 + 2009 --- Or is there a way to say that Ș Ş have the same value? Ș=Ş ? I like this suggestion. It would also allow to have one of my suggestions implemented (a=ă=â, b-h, ...) but it is also critical in order to have various Romanian texts sorted appropriately. Indeed, it is common to find both cedillas and comma-below in Romanian texts. Affected characters are: S and T. Comma-below character is official, but I believe that most existing texts use cedillas (due to previous font issues). - 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: issues-unsubscr...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103436] Calc: Improve Collaborati ve Editing of Spreadsheets
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103436 Issue #|103436 Summary|Calc: Improve Collaborative Editing of Spreadsheets Component|Spreadsheet Version|DEV300m49 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|discoleo --- Additional comments from disco...@openoffice.org Thu Jul 9 10:24:37 + 2009 --- Calc: Improve Collaborative Editing of Spreadsheets when collaborations span multiple regions INTRO This feature request is derived from issues witnessed when working with MS Office 2007. It was not tested using OOo (m49 selected to be able to post issue), but, considering that MS Office allows for collaborative editing for quite some time, and is pretty advanced in this field, I do not expect that OOo fares better than the competition. SETTING Multiple users from different regions editing collaboratively a spreadsheet over the web. PROBLEM While editing collaboratively a spreadsheet over a local network works acceptable, when the users are dispersed over a wider region and use connections over the web/internet to access the spreadsheet, any work becomes a nightmare. It takes long even with MS Office 2007 to open a decent sized spreadsheet, it takes long to save the changes, but most notably, it becomes really frustrating, when you are unable to save the changes, because the spreadsheet is locked by someone else. You can't just run across the office and ask the person to close the spreadsheet for a couple of minutes until you saved the changes. COMMENT Considering the global nature of commercial businesses, this is an area that would give the edge over the competition. SOLUTIONS The whole collaborative spreadsheet editing should be rethought. A couple of issues need to be solved: 1. Aggressive locking and de-locking Once a user opens, or performs a change to the spreadsheet, it should post a lock-request. Once it receives the lock, it should rapidly save the changes. Once the changes are saved, it should immediately release the lock. This way, every user is able to save the changes without substantial waiting times. 2. Implement rsid's Recent posts describe the usefulness of rsid's. [see http://gsoc-tzvetelina.blogspot.com/] This feature would allow much better merging capabilities for collaboratively edited spreadsheets. This spreadsheets are likely not as computing-intensive as standalone spreadsheets, so rsid's could be used in these settings without any performance penalty. 3. Implement merging capabilities One of the most disturbing things is managing a comflict: you either have to discard the other users work, or do it all over again. This should not happen. Implementing advanced merging capabilities and conflict resolutions should be implemented. Rsid's would offer additional benefits in these settings. 4. Temporary data-exchange Instead of saving the whole spreadsheet, implement a temporary data exchange container, something similar to the '.lock' file, e.g. a '.lock.data', where only sequential changes are stored. All users working in the spreadsheet will have their spreadsheet updated based on this data, so they always work on the latest version of the spreadsheet. CONCLUSION Collaboratively editing a spreadsheet poses new challenges in this globalised world. It is not uncommon to have offices spread over different countries and continents. Even two distinct regions will introduce various latencies in the network communication, so that classic collaborative editing becomes highly unresponsive. People from 4 countries over 3 continents are involved in a project I am assigned to. But even smaller projects, involving only 2 European countries showed the limitations of the existing collaborative editing model. However, there are plenty of new technologies and software should evolve and solve these issues. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103424] Calc: Background AutoReco very freezes Calc, making it unusable
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103424 Issue #|103424 Summary|Calc: Background AutoRecovery freezes Calc, making it |unusable Component|Spreadsheet Version|DEV300m49 Platform|PC URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|save-export Assigned to|spreadsheet Reported by|discoleo --- Additional comments from disco...@openoffice.org Wed Jul 8 19:43:05 + 2009 --- Summary: The AutoRecovery processes running in the background freezes all instances of Calc, making it unusable SETTING Open 3 real-life spreadsheets simultaneously PROBLEM Calc seuqentially saves the spreadsheets in the background. Every instance of Calc becomes unresponsive during this time, blocking every work. EXPLANATION Each SAVE operation takes 1-2 minutes on a real-life, decent spreadsheet, but even 10 seconds would be highly disruptive. Unfortunately, all instances of Calc are affected, so when the first instance begins the SAVE operation, all instances are unresponsive for 1-2 minutes. The same issue happens 5 minutes later, and again 5 minutes later. In summary, Calc will save every few minutes one of the open spreadsheets. During this time, all Calc instances are unresponsive. Anyone working in a commercial setting with real-life spreadsheets will be completely hindered to work with Calc. SOLUTION [in NO particular order] 1. Make each Calc instance run in a separate process, without inter-process lock 2. Make Calc responsive during background AutoRecovery save operations 3. Make the SAVE operation much faster, virtually save data instantly [from a user perspective] PERSONAL Unfortunately, this error is a critical one. I wasn't as much aware of this problem when working at home on insignificant tasks. MS Office 2007 is used in the commercial setting and has completely replaced any other Office suite. Trying to do the same work using OOo revealed this critical error. basically, OOo is unsuitable in a commercial setting, unless this error is fixed. PRIORITY I struggled to set the correct priority. While some may argue that this should be less than priority one (but at least P2), I considered that P2 is too weak to accurately describe the relevance of this issue. Actually, this issue completely removes OOo from the list of applications suitable for a large segment of commercial uses. I would suggest, this is a very severe issue. Maybe no one complained, because MS Office is the norm in these settings, and this is likely to stay like this as long as OOo doesn't become competitive in this setting. All potential advantages (mathematical accuracy, standardization, advanced features) are completely useless, if you cannot work. And you cannot work, believe me, I have tried, because I am still a staunch supporter of 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 102121] New Feature: Introduction of duplicate cell/record finder
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102121 User discoleo changed the following: What|Old value |New value CC|''|'discoleo' --- Additional comments from disco...@openoffice.org Thu May 21 16:01:58 + 2009 --- Even more, Excel 2007 has extended the Formatting with a Highlight duplicates feature. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sw-issues] [Issue 16877] New Page Style always appl ies to page 1
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=16877 User discoleo changed the following: What|Old value |New value CC|'asrail,kschmir,tuharsky' |'asrail,discoleo,kschmir,t | |uharsky' - 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: issues-unsubscr...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[graphics-issues] [Issue 101936] Line Plot broken - Select ing first Row as Label breaks plot
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101936 Issue #|101936 Summary|Line Plot broken - Selecting first Row as Label breaks | plot Component|Chart Version|DEV300m47 Platform|PC URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|kla Reported by|discoleo --- Additional comments from disco...@openoffice.org Thu May 14 19:30:17 + 2009 --- This error is reproducible, though not always. I do not know a definite method to reproduce it, though I will attach a spreadsheet that shows the error. Generate a Line Plot (Points and Lines): - first row is a numerical label (e.g. years) - NO Label for the rows [i.e. first column is not a label, but data, too] Select the data, draw a Line plot (Points and Lines) with data series in rows. By default, first row is NOT ticked as column label, BUT de facto is used as a column label (this would be correct). However, manually ticking the option First Row as Label, breaks completely the plot. I could reproduce this error, but unfortunately it is hard to track and might fail to show up even with the same data set. I am using OOo-dev m47 on Win2k. - 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: issues-unsubscr...@graphics.openoffice.org For additional commands, e-mail: issues-h...@graphics.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[graphics-issues] [Issue 101936] Line Plot broken - Select ing first Row as Label breaks plot
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101936 --- Additional comments from disco...@openoffice.org Thu May 14 19:31:44 + 2009 --- Created an attachment (id=62274) Spreadsheet showing broken PLOT - 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: issues-unsubscr...@graphics.openoffice.org For additional commands, e-mail: issues-h...@graphics.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[graphics-issues] [Issue 101936] Scatter Plot broken - Sel ecting first Row as Label breaks plot
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101936 User discoleo changed the following: What|Old value |New value Summary|Line Plot broken - Selecti|Scatter Plot broken - Sele |ng first Row as Label brea|cting first Row as Label b |ks plot |reaks plot --- Additional comments from disco...@openoffice.org Thu May 14 19:38:38 + 2009 --- I noticed now, that I mis-clicked on Scatter Plot (XY), instead of Line Plot. It is still broken though, with the first row being dropped instead of set as label, and the second row being used instead as label, yielding a very strange plot. - 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: issues-unsubscr...@graphics.openoffice.org For additional commands, e-mail: issues-h...@graphics.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[graphics-issues] [Issue 101936] Scatter Plot broken - Sel ecting first Row as Label breaks plot
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101936 User discoleo changed the following: What|Old value |New value Status|RESOLVED |UNCONFIRMED Resolution|WORKSFORME| --- Additional comments from disco...@openoffice.org Thu May 14 22:15:39 + 2009 --- It doesn't work for me at all. Actually, the first row contains various years. However, this row has disappeared from the plot. Instead of using this row as a label, Calc uses the second row as label when the Label option is ticked. This is the actual error. It should have ticked by default the Label option, and use the Years-row as a label, NOT the second row. - 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: issues-unsubscr...@graphics.openoffice.org For additional commands, e-mail: issues-h...@graphics.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sw-issues] [Issue 3959] Outline View (aka MS Word)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=3959 --- Additional comments from disco...@openoffice.org Sat Apr 18 16:10:17 + 2009 --- ... perhaps we should be considering integration with a good mind mapping tool. I fully agree. Various techniques have been developed and have evolved over the past years, warranting novel approaches to the writing model. - 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: issues-unsubscr...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 100444] A function to remove hyph ens would be nice
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=100444 User discoleo changed the following: What|Old value |New value CC|''|'discoleo' - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 17995] up standard autofilter fie lds from 3 to 4
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=17995 --- Additional comments from disco...@openoffice.org Wed Dec 17 18:04:52 + 2008 --- Slightly reworking my previous comment: IF it is still desired to extend it, then a more comprehensive solution that permits an unlimited amount of rows is warranted: [FIELD] [CONDITION] [VALUE] [-] [OPERATOR] [FIELD] [CONDITION] [VALUE] [-] [OPERATOR] [FIELD] [CONDITION] [VALUE] [-] [MORE OPTIONS] [DELETE CONDITION] [UNDO] [HELP] Where: A new row of conditions is automatically added once ALL rows are filled with conditions. [CHANGED from my previous post.] [-] Deletes the corresponding filter condition. If there are less than 3 conditions, the remaining rows up to 3 are displayed empty. [DELETE CONDITION] Similar to [-], deletes the condition that has the focus [UNDO] Undo last action (e.g. restores a deleted condition) [MORE OPTIONS] Display the advanced options [HELP] Display the Help - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 17995] up standard autofilter fie lds from 3 to 4
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=17995 --- Additional comments from disco...@openoffice.org Wed Dec 17 18:07:11 + 2008 --- And forgot the OK/Cancel buttons :-) [MORE OPTIONS] [DELETE] [UNDO] [OK] [CANCEL] [HELP] - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 96967] Calc makes incomplete part of URL a link
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96967 --- Additional comments from [EMAIL PROTECTED] Sun Dec 7 13:07:29 + 2008 --- Can confirm this with OOo dev300-m35, Win2k SP4. If you write in one cell: openoffice.org HIT ENTER go back and edit the cell: http://www.openoffice.org HIT ENTER Only: http://www.openoffice/ becomes a link, missing the last part! Do NOT try with www.opneoffice.org during the first step, because this becomes directly a link. BUT if you do not start with 'www.' within the first step, then OOo will format only the first part of the URL as a link in the subsequent step. Another example: who.is ENTER Go back and edit: http://who.is ENTER only http://who becomes a link, missing the '.is' part. - 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 83767] Spreadhseet Header Contain ing Company Logo
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83767 --- Additional comments from [EMAIL PROTECTED] Sun Dec 7 13:38:22 + 2008 --- discoleo - pgan How is this different than creating the spreadsheet table inside a Writer document? Writer is NOT a spreadsheet, so IF the user needs to work inside a spreadsheet, then he CAN NOT work within Writer. Anyone who has worked professionally with a spreadsheet will understand these requirements. REASONS === - Important functionality is MISSING - REDUCED screen-size [a lot of unhelpful margins] - 2-dimensional flow outside the page [both right-side and bottom of the page] There are many more, including that I can NOT embed a spreadsheet currently in OOo-dev300 m35. Will have to check this more thoroughly if it is a different error. For a real life example, see also the xls-based Exception Report available from the following NHS-site (Britain's National Health Service): [shortened url: http://tinyurl.com/68tnvm] http://www.ic.nhs.uk/cmsincludes/_process_document.asp?sPublicationID=1225147131677sDocID=4318 http://www.ic.nhs.uk/statistics-and-data-collections/audits-and-performance/the-quality-and-outcomes-framework/the-quality-and-outcomes-2007-08-exception-report I will add also a screenshot. - 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 83767] Spreadhseet Header Contain ing Company Logo
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83767 --- Additional comments from [EMAIL PROTECTED] Sun Dec 7 13:42:53 + 2008 --- Created an attachment (id=58597) Real Life Example (NHS Spreasdsheet) showing a Spreadsheet Header covering most of the upper half of the screen. - 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]
[lingucomponent-issues] [Issue 96410] Deleting Australian Englis h Dictionary disables other english spelling c heckers.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96410 --- Additional comments from [EMAIL PROTECTED] Sun Dec 7 15:43:03 + 2008 --- I do not know if this is a related problem: My English spellchecking does NOT work at all since the latest versions of OOo. I am currently using OOo-dev 3.1 (m37). However, I think that the English spellchecking was broken since at least m35, and probably since m29 as far as I can remember. I have installed the English version of OOo. Running Win2k SP4 English version. I have uninstalled a long way back the stable release of OOo and I am installing since then only the dev builds, which caused some problems back then. The English spellchecking problem could be related to this fact as well. However, installing even the dev-build should install all the necessary files. I do not think that I have removed the Australian dictionary [though I am unsure IF my previous uninstall could have triggered that behaviour]. If this issue is unrelated, I will open a new bug report. However, please understand that I switched back to MSO at home after more than 2 years of using exclusively OOo. Not only that the spellchecking is broken, but this is compounded by the irritable red-lining which refuses to disappear. I can confirm: selecting some text and selecting Thesaurus will crash OOo (as stated in a previous post). So probably my issue is indeed related to this issue. - 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]
[lingucomponent-issues] [Issue 94420] Crash on two similar spell ing extensions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94420 User discoleo changed the following: What|Old value |New value CC|'sba,tl' |'discoleo,sba,tl' - 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]
[lingucomponent-issues] [Issue 94420] Crash on two similar spell ing extensions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94420 User discoleo changed the following: What|Old value |New value CC|'discoleo,sba,tl' |'sba,tl' --- Additional comments from [EMAIL PROTECTED] Sun Dec 7 15:44:31 + 2008 --- [Wrong issue.] - 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]
[lingucomponent-issues] [Issue 96410] Deleting Australian Englis h Dictionary disables other english spelling c heckers.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96410 User discoleo changed the following: What|Old value |New value CC|''|'discoleo' - 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]
[lingucomponent-issues] [Issue 96410] Deleting Australian Englis h Dictionary disables other english spelling c heckers.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96410 --- Additional comments from [EMAIL PROTECTED] Sun Dec 7 15:56:43 + 2008 --- Yes, the action mentioned on the forum corrected the problem. http://user.services.openoffice.org/en/forum/viewtopic.php?f=6t=12340p=57999#p57999 It is possible that the error was triggered when I updated some/all extensions, though I do not remember exactly when I made a full update (it could be after installing m35). Though, correcting this bug in the main branch of OOo seems highly desirable. - 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]
[framework-issues] [Issue 96738] UNDO Autoformat should rem ember this action
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96738 --- Additional comments from [EMAIL PROTECTED] Sun Dec 7 19:57:00 + 2008 --- To give another example: - type in Writer: 1. We do NOT want this to be a bullet HIT ENTER This becomes a bullet: 1. We do NOT ... Now select UNDO. The bullet is undone: 1. We do NOT ... - CURSOR IS HERE. HIT AGAIN ENTER ON THE BLANK LINE. The first line gets again a bullet. 1. We do NOT ... The second time the line is bulleted should NOT happen, because OOo knows now that this is NOT a bullet. - 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]
[framework-issues] [Issue 96738] UNDO Autoformat should rem ember this action and avoid Autoformatting tha t portion again
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96738 User discoleo changed the following: What|Old value |New value Summary|UNDO Autoformat should rem|UNDO Autoformat should rem |ember this action |ember this action and avoi | |d Autoformatting that port | |ion again - 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]
[lingucomponent-issues] [Issue 96996] Missing words: lyophilizat ion, lyophilize, ...
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96996 Issue #|96996 Summary|Missing words: lyophilization, lyophilize, ... Component|lingucomponent Version|DEV300m37 Platform|PC URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|thesaurus Assigned to|[EMAIL PROTECTED] Reported by|discoleo --- Additional comments from [EMAIL PROTECTED] Sun Dec 7 20:07:44 + 2008 --- The following technical words are missing from the English-US dictionary and probably from all other English-dictionaries: lyophilization lyophilize = To freeze-dry lyophilized lyophilizer see e.g. http://www.medterms.com/script/main/art.asp?articlekey=39250 - 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]
[sw-issues] [Issue 96713] Sort order not correct in Romanian language
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96713 User discoleo changed the following: What|Old value |New value CC|''|'discoleo' --- Additional comments from [EMAIL PROTECTED] Sun Nov 30 18:07:38 + 2008 --- Just to avoid confusion, the correct alphabetical order is: a, ă, â, ..., i, î, ..., s, ş, t, ţ, ... (And this is what miksar refered to. Please note, this order is different in the attached document, with plain letters first, followed then by the diacritis, i.e.: a, b, c, ..., y, z, ă, â, î, ş, ţ - and this is wrong.) I would like to add that I sometimes prefer to treat diacritics as the simple plain letters, e.g. I would like to have this sort order, as if /a/ and /â/ are the same: rac NOT rac rând raport raport rând This is particularly important, because documents are written often with a mixture of diacritics and NO diacritics, so it doesn't make sense to sort in such detail. (The order: a, i, s, t, then diacritics is nevertheless wrong.) - 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]
[framework-issues] [Issue 96738] UNDO Autoformat should rem ember this action
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96738 Issue #|96738 Summary|UNDO Autoformat should remember this action Component|framework Version|DEV300m35 Platform|PC URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P3 Subcomponent|code Assigned to|tm Reported by|discoleo --- Additional comments from [EMAIL PROTECTED] Sun Nov 30 18:40:48 + 2008 --- Often OOo programs wrongly apply some autofrmatting, e.g. they create a bullet when hitting enter after a line that starts with a number or with '*'. When the user UNDO's this auto-formatting, OOo shall remember this action and should NOT attempt to auto-format the next time the user hits enter. A classic example is: * ...some...text ENTER = will be auto-formatted to BULLET = UNDO = again ENTER, to leave an empty-line = OOo auto-formats AGAIN to bullet The second auto-format is superfluous, because OOo knows now that the user does NOT want to auto-format this entry. [This is unknown during the first instance.] Desired action: OOo shall invisibly mark the specific text as NON-Autoformattable. When the user repeats the action, the auto-formatting shall be disabled. - 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]
[framework-issues] [Issue 96738] UNDO Autoformat should rem ember this action
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96738 User discoleo changed the following: What|Old value |New value Keywords| |usability - 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]
[sw-issues] [Issue 96612] Easier page style assignat ion
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96612 User discoleo changed the following: What|Old value |New value CC|''|'discoleo' --- Additional comments from [EMAIL PROTECTED] Wed Nov 26 17:49:27 + 2008 --- A far better solution would look like this: PREREQUISITES: 1. various parent-elements inherit styles from child-elements In this example, the page style inherits attributes from a paragraph on the specific page. When the user drops a page-style on a specific page, the first paragraph that starts on that page will receive the new page-style attributes. [This is because in OOo and ODF more broadly there is NO physical concept of page, but the user does NOT need to know this detail.] Then, the page on which this paragraph is displayed automatically inherits the page style. There is NO need for page break. [It is still wise to have a page break, because the previous paragraph may flow on this page, or there is even NO paragraph starting on this page - if the previous paragraph is very long and starts on the previous page and goes up to the next page. BUT, per se this method does NOT need any page-break, and would work even IF the paragraph from the previous page flows on the current page! This latter thing is currently not doable, even with low-level page styles - only IF knowing exactly how many pages are in the document and this number is fixed - a very messy procedure.] Similarly, the style may include a page-break property, so the paragraph will automatically insert a page-break when necessary, so no need for the user to do it automatically. The user just drops a page style on a page, and the first paragraph automatically grabs the page-style properties. This is it. - 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 5658] Spreadsheet thinks a number is a string (text)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Mon Nov 24 21:58:16 + 2008 --- discoleo-cornouws For all needing 100% Excel compatability: make sure you have all the same version of Excel as well as the same CPU. Both are known sources for differences in more complex spreadsheets ... This is the kind of comment that doesn't bring anything useful to this issue. By the way, if you really want absolutely identical spreadsheet results, be also warned that different versions of OOo Calc, and gnumeric and probably any other major spreadsheet beyond MS Excel will yield different results, so you NEED to stick to exactly the same version of the same spreadsheet on the same processor. [Yes, a SPARC will handle floating point very different than most MIPS processors.] The problem however is very different than EXCEL compatibility: it is really the broken philosophy in Calc, that allows to compute WRONG results, without notifying the user. So, in the end, the user might well be unsuspecting that his calculations are utterly wrong, and might be so catastrophically wrong. To paraphrase a different user: The question, also, is not “does OOo behaviour really cause more real problems than incompatibility to Excel.” The incompatibility already exists as Issue 5658 shows. Both spreadsheets do illegal operations, *they just do them differently*. The real question is, “Do we want to have a spreadsheet that we know is faulty, where the faults may be very serious and potentially life threatening. So, the real issue is that Calc allows me to do: = 1 + '1,000,000 and get a 1 and have NO feedback that the result is probably utterly nonsense. The unsuspecting user will likely miss this wrong calculations. How often did you look into a 10,000 rows spreadsheet if some numbers are actual text? Be warned that Calc often imports csv as text. You end sometimes even with a number transformed to text. Format e.g. a column as text and enter now numbers. They end up as *strings*, and any mathematical operation is broken. You may well miss this on a foreign spreadsheet, and even inspecting the cells will devoid you of any useful information, because the apostrophe in front of the text is missing (for cells formatted as text - how often did you check that the cell was previously formatted as text?). And have you thought of a 50,000 rows spreadsheet. I already work with 100,000 rows (well, obviously not in Calc). What chance do I have to find the faulty string in this spreadsheet? [see e.g. http://www.openoffice.org/issues/show_bug.cgi?id=85328 - I was well unaware that various cells were text - and this was a happy example that I noticed is wrong. !4! different users beyond me did NOT recognize that the cell was actually text.] I would bet, NONE. And on a different note: THERE IS NO SUCH STRING AS 1 If you mean the string 'one' than this is different from the number '1'. There is only one number '1' and NO string '1'. This is purely a programmers distinction with NO real backup in linguistics. '1' is a number. Basta. Not to confuse the issue with '1 is not a number'. This is indeed a composite string, but simple numerical symbols are always numbers. I already described more advanced ways to handle string-input in a previous post: http://www.openoffice.org/issues/show_bug.cgi?id=5658#desc123 Hope this clarifies some issues. - 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 5658] Spreadsheet thinks a number is a string (text)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Thu Nov 20 18:27:20 + 2008 --- It seems to me that there is a consensus developing here that it is more important to behave correctly than to be compatible with Excel. YES, BUT: Treating 'text' as zero is definitely a BUG. Consider a company doing $1 + '1,000,000' = $1 and going bankrupt afterwards. You don't want that, do you? - 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 85328] Formula in spreadsheet int erpreted as text
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85328 User discoleo changed the following: What|Old value |New value Status|CLOSED|UNCONFIRMED Resolution|WONTFIX | --- Additional comments from [EMAIL PROTECTED] Fri Nov 7 21:25:39 + 2008 --- Reopening Issue. Please do not close if you do not understand the issue. Also do not send WONTFIX if you do NOT understand the issue and you are not a developer. The putative explanations are wrong and could be readily defeated. Write: =sum(A49:A62) into cell A63, and it ends up as *TEXT*, not as a formula. It also does NOT contain the apostrophe before the = sign, so it really should NOT be text. BUT it is. Write the same formula in column C63, and the SUM is computed. So, for some reason, Calc set the range A1:A78 into a strange state, which does NOT allow any formula, even though it is NOT transformed to/marked as text either. This might be an xls-import problem, but please note that the current file is in ods-format, so the problem persists. This might indicate a DEEPER Calc problem, so avoid closing this issue till a DEVELOPER takes a look at it. It might be a flaw somwhere in Calc's inner workings. This flaw might appear later as a serious problem. Therefore, IF after debugging the error is deemed WONTFIX, then I will accept that (because it is not very likel to get often into this trouble). BUT because this might hint to a hidden flaw which might appear under various circumstances, the error should be first debugged. Please note - and I repeat - only the range A1:A78 is affected, NOT the other columns!!! [Actually the whole column A] I will attach a new document describing the above behaviour. Tested with OOo Calc dev300-m29 on Win2k SP4. - 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 85328] Formula in spreadsheet int erpreted as text
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85328 --- Additional comments from [EMAIL PROTECTED] Fri Nov 7 21:27:42 + 2008 --- Created an attachment (id=57776) BUG persists with SUM() function written in Column A - 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 85328] Formula in spreadsheet int erpreted as text
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85328 --- Additional comments from [EMAIL PROTECTED] Fri Nov 7 23:30:28 + 2008 --- Indeed. The cells were probably formatted as text (and therefore would warrant INVALID), but... if it weren't for some inconsistencies I noted below: 1.) I was sure that Auto-number recognition and Auto-formula recognition has always precedence. Strange. Also, the formula autocompletion is activated, although the resulting entry is a text string. Even entering a function using the fx button keeps the resulting entry as a text string, and doesn't evaluate to a function. I would say that this last feature is definitely a bug. 2.) Also, the missing apostrophe at the beginning of the text did mislead me. Changing the cell to a different type, does NOT evaluate the formula. It will still display the content as =..., without the apostrophe in the beginning (see cell A78). This clearly misleads one. 3.) And this makes Calc very inconsistent: SUM() will evaluate these text-numbers!!! But it doesn't evaluate numbers entered as '1. Therefore, is the 1 entered as text now or as number? I would say, it is a number, but then why does Calc NOT also evaluate the formula? A lot of inconsistencies. - 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 95754] Calc for tree calculus too
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95754 User discoleo changed the following: What|Old value |New value CC|''|'discoleo' --- Additional comments from [EMAIL PROTECTED] Wed Nov 5 17:39:04 + 2008 --- What you are referring to are probably multidimensional spreadsheets. These are for some 20 years around, and more and more companies use such custom solutions, but it seems open source projects are not yet open to these ideas. Another concept are hierarchical databases. These are indeed extensively used e.g. in clinical trials, and it would fit well in your description of the organization of a department: HEAD |- DEPT 1 | |_ SUBDEPT 1: actual sheet | |- DEPT 2 | |- SUBDEPT 1: actual sheet | |- SUBDEPT 2: actual sheet | |- SUBDEPT 3: actual sheet | |_ SUBDEPT 4: actual sheet | |_ DEPT 1 |- SUBDEPT 1: actual sheet |- SUBDEPT 2: actual sheet |_ SUBDEPT 3: actual sheet I think that this tree structure can be solved with a multidimensional spreadsheet. - 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 95823] can't enter negative expon ents in formula
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95823 --- Additional comments from [EMAIL PROTECTED] Tue Nov 4 17:19:51 + 2008 --- Could not confirm issue in OOo-dev300-m29. Therefore, this issue should be probably closed as worksforme. - 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]
[framework-issues] [Issue 11393] Add File | Export... funct ionality for _all_ supported formats
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=11393 User discoleo changed the following: What|Old value |New value CC|'ace_dent,fs,murb,pulsifer|'ace_dent,discoleo,fs,murb |,smsm1,thing' |,pulsifer,smsm1,thing' --- Additional comments from [EMAIL PROTECTED] Thu Oct 30 19:50:28 + 2008 --- Issue 32684 depends on this one. I strongly favour adding some other formats to the EXPORT-dialog, at least csv. The reasoning behind a separate export for formats that cannot be imported back is wrong, as OOo already can import some pdf, and hopefully will be able to import any format sometime in the future. - 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 32684] Export to CSV
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=32684 User discoleo changed the following: What|Old value |New value CC|''|'discoleo' --- Additional comments from [EMAIL PROTECTED] Wed Oct 29 23:12:05 + 2008 --- As the csv is really an intermediary transport file used to transfer one sheet of data from the spreadsheet to another program, I strongly support adding the CSV-format to the EXPORT-possibilities. The csv can't support formatting nor formulas, BUT most importantly, only the *active sheet* is exported, so it is really ONLY an export, NOT a SAVE AS-functionality. I therefore strongly suggest to add this option to the EXPORT-dialog. This has some practical consequences. Basically, it is impossible to perform any sound statistics in Calc. At the same time, the ODF-format has become too complex to implement accurate readers (that mimic all its bugs and limitations) in professional statistic packages. It is therefore imperative to use a simple format for data-transfer, and csv is simply the best suited one (tab-delimited data is another one). I therefore strongly hope that this enhancement gets implemented in Calc. Basically, the export-dialog should have both PDF and CSV as options. Selecting CSV should export the active sheet, using the sheet-name as default name. The status of the ods-file should not change (i.e. do not set changed status). That's it. - 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 49978] Choosing decimal point c haracter when importing .csv files
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49978 User discoleo changed the following: What|Old value |New value CC|'cs_support,ft,thing' |'cs_support,discoleo,ft,th | |ing' --- Additional comments from [EMAIL PROTECTED] Wed Oct 29 23:17:22 + 2008 --- Added myself to cc. As I started over the last month to do again more advanced statistics, after basically an absence of more than 2 years, I got into the trouble of localisations. The problem is more weird, because setting , as the decimal separator, basically invalidates the csv-file, while MS chooses to delimit the csv with ; generating a lot of additional trouble because of this. - 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 68636] Checkbox Save cell conten ts as shown should be unchecked as standard
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68636 User discoleo changed the following: What|Old value |New value CC|'muthusuba,rainerbielefeld|'discoleo,muthusuba,rainer |' |bielefeld' --- Additional comments from [EMAIL PROTECTED] Wed Oct 29 23:37:29 + 2008 --- It seems that issue 4925 was more about formatting as money and as date, which are separate data types by the way. It was a tragic decision that ordinary numbers got chopped as well. Calc basically lost with one move all the scientific community. - 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 94419] lost formating when using IF stmt in formula
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94419 --- Additional comments from [EMAIL PROTECTED] Mon Sep 29 19:53:32 + 2008 --- Can confirm that: = some cell with currency + IF(1; some cell with currency ;0) = currency, BUT = some cell with currency + IF(1; 0 ;0) = NO CURRENCY The currency is not inherited IF adding a non-currency using IF()! Please note, IF adding non-currency directly, currency IS still inherited! Though, avoiding the inheritance is in my opinion desirable, allowing to implement *type checking* later on. However, the situation should be consistent, and: = some cell with currency + non-currency should NOT inherit the currency, as opposed to the current implementation! Having a type _0_currency_ is warranted in these situations, to ease the use of IF() clauses. discoleo - chuv In order to make the formula work, you should rewrite the 0 inside the IF() clause as: 0 * any cell with currency. The result will be still 0, BUT will inherit the currency. Tested on OOo-dev3 m29 - 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 85328] Formula in spreadsheet int erpreted as text
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85328 --- Additional comments from [EMAIL PROTECTED] Thu Sep 18 10:00:29 + 2008 --- I don't know how you enter the AVERAGE() formula in lower case Type: = average() everything in lower case ;-) Now, joking aside, I do not have the original Excel file anymore. However, I may think that the following went wrong: for some reason, Excel did mark the column as text and did not evaluate the string entered. Can somebody check, IF the ODS-file does contain indeed a text entry? Even then, a text entry should start with a ('), which it doesn't. I wonder also, why Calc does not test IF the new entry is something different. Now, let's go to row 79 and type: = su auto-completion suggests SUM, but when we enter SUM(...), nothing gets computed. The entry is still interpreted as plain text. Even entering a number, will make it text: try with 123 Enter in A80: 123 It gets formatted to the left, like text. Then write in cell D80: = A80 + 1 You get 1, strange! This is because text '123' is interpreted as 0 in Calc. The funny thing is, 123 is really 123 and NOT '123 !!! - 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 94024] inserting row or column in between merged cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94024 --- Additional comments from [EMAIL PROTECTED] Thu Sep 18 18:43:17 + 2008 --- This is a duplicate of issue 8302: http://www.openoffice.org/issues/show_bug.cgi?id=8302 Please vote for that issue. Please also note that I started a discussion on writing the specification for that issue, but almost nobody replied to my post. At the same time, it seems that people do not even fully test the competitive programs to detect what the competition actually does. Inserting an empty row (a new row) should be pretty trivial, but inserting/moving another row is slightly more complex. I would like to do it better than Excel in these situations. - 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 5550] auto-fill can't increment l ast octet of ip addresses.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5550 User discoleo changed the following: What|Old value |New value CC|'kamataki,kami_,kohei,masa|'discoleo,kamataki,kami_,k |yan' |ohei,masayan' --- Additional comments from [EMAIL PROTECTED] Wed Sep 17 21:16:58 + 2008 --- discoleo-kohei I would appreciate a short description of the feature the patch brings in. ;) How are the following situation handled: '12.34 '12.34 '12.34 '12.34.45 '12abc34 '12.35 '13.34 '13.44 '12.34.46 '12abc44 Maybe others. - 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 8302] want to be able to insert i nto the middle of merged cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=8302 --- Additional comments from [EMAIL PROTECTED] Tue Sep 9 15:39:50 + 2008 --- TO everyone: This is the 2nd call. Please have a look at my previous post. In order to get a feature implemented into OOo, we need to write a specification. That is why I brought into discussion the way this feature should work. I started also a discussion on the UX-list, see: http://ux.openoffice.org/servlets/ReadMsg?list=discussmsgNo=2336 [But NO responses either.] To explain some of my rationale: When we have merged cells, we may want to insert some cells or delete some cells. Because inserting/deleting a limited selection creates a lot of ambiguity (by allowing different options to shift cells up/right/...), I decided to start with inserting/deleting whole rows or columns. This is more easily handled and behaves predictably. A number of scenarios are possible even when inserting or deleting a whole row/column, see my previous message. When inserting: new cell would be added to the merged complex. Should the new content replace or be appended to the existing content? When deleting: Delete content from merged cells, or leave content untouched? Some further options are discussed in the other posts. Feel free to add any other opinion/option. I actually favour both options in both instances, so a dialog is warranted. For inserting/deleting only a limited selection of cells, the shift-options could be disabled, allowing only insert/delete whole row/column (and of course a CANCEL button). - 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 8302] want to be able to insert i nto the middle of merged cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=8302 --- Additional comments from [EMAIL PROTECTED] Tue Sep 9 19:06:17 + 2008 --- The evil alternative, IF you are referring to MS Office, doesn't do it at all under some circumstances. I do have access only to Office XP at home, and cannot test it today on Office Vista, but these are my findings: 1.) merge some cells, e.g. A1:D2 2.) enter some text 3.) enter some text into F1:F2 A.) MOVING 4.) select column F 5.) move over merged area = ERROR: Cannot change part of a merged cell. B.) COPY/PASTE 4.) select column F 5.) COPY 6.) PASTE over column B 7.) content is pasted outside of merged cells BUT NOT inside the merged cells = NOT necessarily what the user wants [Also, NO notification to the user that something went wrong.] C.) CUT/PASTE 4.) select column F 5.) CUT 6.) PASTE over column B 7.) This operation will cause some of the merged cells to unmerge I would like to do it better in Calc than in Excel. That is why I started the discussion. I do not want i.) to unmerge cells, or ii.) to loose content. I hope everyone agrees. - 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 8302] want to be able to insert i nto the middle of merged cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=8302 User discoleo changed the following: What|Old value |New value CC|'andreschnabel,davidfraser|'andreschnabel,davidfraser |,fl,gercokees,jondo,jrahem|,discoleo,fl,gercokees,jon |ipour,kohei,maoyg,mloisele|do,jrahemipour,kohei,maoyg |ur,pagalmes,rail,sgauti,ta|,mloiseleur,pagalmes,rail, |nstaafl,tora' |sgauti,tanstaafl,tora' --- Additional comments from [EMAIL PROTECTED] Sat Sep 6 15:07:21 + 2008 --- Lets start devising a specification. I will offer a starting point for the features I feel need to be implemented within this request (but feel free to express a different opinion): A.) Insert into Merged Cells - A1-D1 is merged - we want to insert a column between column B C This should be possible. Columns A B remain unmodified. Columns C D get shifted to the right. Though, what should happen with the merged A1-D1 cell and the newly inserted newC1 cell? There are 2 options: i.) merge C1-D1 with the newC1 cell the 2 contents should be appended OR the old content should be overwritten ii.) the new cell (newC1) acts as a splitter, i.e. A1-D1 gets split into: A1-B1 and C1-D1 which gets shifted to D1-E1 the new, unmerged cell gets inserted between A1-B1 and D1-E1 I strongly support both options presented at i.). Because cell A1 would inherit all the content anyway, I do not see any strong indication for ii.). [A possible utility arises when more cells are merged, like IF A1:D2, then after inserting we have: A1:B2 and D1:E2 and the unmerged cells C1 and C2. All the initial content would be in A1:B2, while C1 c2 would preserve their own content.] A dialog should pop up for choosing the appropriate option from point i.), BUT if the merged cells are empty, then NO dialog is needed. B.) Delete Merged Cells Similarly, suppose cells A1-D1 are merged, and we want to delete column B. What should happen with the cell A1-D1? i.) Cell A1-D1 becomes A1-C1 - content is deleted from this cell - content is preserved ii.) Whole cell A1-D1 is deleted - cells E1-... are shifted left iii.)A1-D1 is split into: A1 and C1:D1 which gets shifted to B1:C1 A1 inherits the content Again, I do not see a strong case for ii.)-iii.), while option i.) seems sensible and needs a dialog to ask for the proper action (delete/preserve content). IF the whole merged cell is selected and deleted, then NO dialog is needed (and is already working in Calc). - 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]
[graphics-issues] [Issue 79882] Impress: Highlight Row Poi nted by Mouse Pointer
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79882 User discoleo changed the following: What|Old value |New value Summary|Highlight Current Row |Impress: Highlight Row Poi | |nted by Mouse Pointer - 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 17995] up standard autofilter fie lds from 3 to 4
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=17995 --- Additional comments from [EMAIL PROTECTED] Sat Aug 30 16:50:57 + 2008 --- Extending the filter offers only a limited functionality. A far more flexible way to extend the functionality is described in issue 66588. http://www.openoffice.org/issues/show_bug.cgi?id=66588 Having the ability to perform SQL-statements natively in Calc (without external data sources) is a way more flexible feature without any artificial limitations. The existing filter has 3 major limitations: 1.) limited categories (currently 3) 2.) limited string functionality 3.) no possibility to save and load filter settings Also, comparisons between 2 fields cannot be done and need to be pre-computed. Extending the filter to cover 4 fields is at most a minor enhancement. IF it is still desired to extend it, then a more comprehensive solution that permits an unlimited amount of rows is warranted: [FIELD] [CONDITION] [VALUE] [-] [OPERATOR] [FIELD] [CONDITION] [VALUE] [-] [ADD CONDITION] [DELETE CONDITION] [UNDO] Where: [-] Deletes the corresponding filter condition [ADD CONDITION] Adds another row to the filter [DELETE CONDITION] Similar to [-], deletes the condition that has the focus [UNDO] Undo last action (e.g. restores a deleted condition) IF less than 2 conditions remain, then 2 rows will be displayed, with one or both rows empty (as appropriate). - 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]
[sw-issues] [Issue 67500] WILDCARDS in Writer Replac ement List
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67500 User discoleo changed the following: What|Old value |New value Summary|WILDCARDS in Replacement L|WILDCARDS in Writer Replac |ist |ement List - 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 93277] wrong automatically calcul ated sum of marked cells for times 24h in st atus bar
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93277 --- Additional comments from [EMAIL PROTECTED] Sat Aug 30 22:03:07 + 2008 --- Can confirm this on OOo-dev300m29: 12:30:42 06:12:22 20:15:20 The sum as displayed in the status bar is: 14:58:24, instead of '1 Day 14:58:24'. - 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 93277] wrong automatically calcul ated sum of marked cells for times 24h in st atus bar
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93277 --- Additional comments from [EMAIL PROTECTED] Sat Aug 30 22:07:23 + 2008 --- Even more peculiar, IF I select the cell just below the data-cells, the sum becomes 1.62 which makes absolutely NO sense. OOo-dev300m29 en-locale Win2k SP4 en-locale See attached screen capture. - 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 93277] wrong automatically calcul ated sum of marked cells for times 24h in st atus bar
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93277 --- Additional comments from [EMAIL PROTECTED] Sat Aug 30 22:08:25 + 2008 --- Created an attachment (id=56108) Erroneous Sum Calculation when including an empty cell below the data-cells - 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]
[sw-issues] [Issue 17203] Ease the way to format eac h page individually (apply style to current pa ge)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=17203 User discoleo changed the following: What|Old value |New value CC|'cornouws,kpalagin,mba,pag|'cornouws,discoleo,kpalagi |almes,rainerbielefeld,regi|n,mba,pagalmes,rainerbiele |na' |feld,regina' --- Additional comments from [EMAIL PROTECTED] Fri Aug 29 08:08:44 + 2008 --- Inserting a page-break to change the page-style is one option but it is very limiting. I proposed a better solution to solve the page-numbering issue, and the same solution can be applied for any other page-style: A.) the page-style shall inherit style properties from the text/objects displayed on the specific page B.) Resolving conflicting styles: - declared page styles have precedence [this is just to avoid any confusion ;) ] - one options is: first come, first served (apply first-encountered style, aka style of first object) - another option: highlight conflicting styles and ask user to specify which one has precedence The usefulness of this approach is its great flexibility: Lets say the user want to draw a very wide table on a landscape page. BUT some text flows over from the previous page. We therefore do NOT want to insert a page-break, but let the text freely flow. We would assign a landscape-style to the table-object, which will be inherited by the page proper on which this table is displayed. Similarly, assigning a page-break to a specific text/object/and/or style should be possible and would make advanced layouts more structured: e.g. every 'Heading 1' will force a new page start with a particular page style (going beyond the already discussed page-numbering styles). - 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 92677] ODFF: Calc needs to implem ent IFERROR
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92677 User discoleo changed the following: What|Old value |New value CC|'er' |'discoleo,er' - 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 92677] ODFF: Calc needs to implem ent IFERROR
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92677 --- Additional comments from [EMAIL PROTECTED] Tue Aug 12 18:01:27 + 2008 --- I have seen some discussions on the MS forums to improve the IFERROR() function to catch only a specified type of error. I can imagine that this is useful, as some errors (like #REF!) are undesirable to catch. I can imagine to expand the function with a 3rd argument specifying which error/errors should be caught: =IFERROR( _expression_ , _alt_expression_ , *ERROR_TYPE* ) - 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]
[framework-issues] [Issue 90214] GUI: Move Measurement Uni t to General preferences
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90214 User discoleo changed the following: What|Old value |New value Summary|GUI: Measuremnt Unit-Set|GUI: Move Measurement Uni |ting: Move from Writer/Gen|t to General preferences |eral to General/General | - 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 85825] Multidimensional Spreadshe ets and OLAP Functionality
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85825 --- Additional comments from [EMAIL PROTECTED] Tue Aug 12 20:55:43 + 2008 --- This is a quote from the MS-forums and it highlights another use case for the proposed functionality. The post might better explain what I tried to accomplish with multidimensional spreadsheets (although the concept of multidimensionality goes far beyond this simple case): [I have corrected some misspellings] Why not a HEADER FORMULA. When I bring data through queries, I typically end up adding calculated columns on the excel side. Each column has the same formula, I just copy the formula up to the last record. At every refresh, the number of records may change and I could need to copy further down. When I am tired to repeat the process, I copy the formula for more rows than enough and typically, I end up having unnecessary calculated rows. Usually, I keep a copy of the formula over the header line. In this case, since we can treat the data as a table, we could prevent this copy process by defining the calculated columns from the top line, the HEADER FORMULA. The calculated rows would adjust automatically the same way the filters does. Jean - 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 66590] Calc: String Functions: Ex tended FIND() Function
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66590 User discoleo changed the following: What|Old value |New value Summary|Calc: String Functions: FI|Calc: String Functions: Ex |ND() |tended FIND() Function --- Additional comments from [EMAIL PROTECTED] Tue Aug 12 21:17:16 + 2008 --- Searching on the MS forums I saw some other requests that could well be handled by this extended function. FINDEX() Function Syntax: FINDEX(string, string, START, END) Initially, when I wrote the code for the FindEx() function, I did NOT interpret specifically a negative END position, BUT returned 0 IF START END. I did played with the idea to interpret negative values as pointing to the _end_ of the original string, though the code would have become to complex and I abandoned the idea. The requests to search the end of the string (and even a reverse search) did pop up on the MS forums, so I think it is time to get into such an extended FINDEX() function, too. The idea: - IF (START 0) = begin to search at string position: strlen() + START /* REMEMBER: START is negative */ - IF (END 0) = end search at string position: strlen() + END /* REMEMBER: END is negative */ So, it would be possible to specify relative positions from the beginnineg or from the end of the original string. This function would not cover a reverse-search, however, one could similarly define an RSearchEx() 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]
[sw-issues] [Issue 91562] Specify what happens to th e meta data of text document entities when the document is edited
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91562 --- Additional comments from [EMAIL PROTECTED] Fri Aug 8 08:58:24 + 2008 --- Having read briefly the specification, there are some things that worry me. I might have misunderstood the specification. How does CUT/COPY/PASTE behave? More precisely, is the META-data lost? This would be bad. Although the meta-data content will be often accessed/extracted by external applications (scripts, other programs), user actions like CUT/COPY/PASTE need to preserve this meta-data, too. I hope this is kept in mind when implementing this issue. The point is, the major use of meta-data is in *reusing content*, so there is really no difference between manual reuse (cut/copy/paste) and automatised reuse (meta-data extraction by external applications). If the text-object looses its meta-data during cut/copy/paste than the most useful feature gets lost. The meta-data was a single use issue. Sometimes it might be necessary to strip away all/some meta-data, BUT this is a completely different issue (and needs to be addressed within the security framework). This is not an issue of meta-data per se. So, I would keep these 2 issues separate and always preserve the meta-data. - 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]
[sw-issues] [Issue 91562] Specify what happens to th e meta data of text document entities when the document is edited
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91562 --- Additional comments from [EMAIL PROTECTED] Fri Aug 8 10:40:26 + 2008 --- *Reusing Content* One of the main use-cases of meta-data is for re-using content. Lets explain this a little bit and I will take a dictionary-style example where we define the meaning of a new word using meta-data. [Actual use cases are likely to be well beyond this very simple/trivial example.] Now, we have the first document where we have this new word and the meta-data. However, I might i.) copy this new word to a new document or ii.) within the same document, and I wish that it's meta-data is preserved: i.) the meta-data should be copied to the new document ii.) the 2nd copy should point to the existing meta-data Lets take a more realistic example: we may have a diagnostic study performed, and the lab reports the results. These results may contain a lot of meta-data (like Lab-specific parameters, machine type, test conditions, ...). Now, I receive these results and wish to write a new document which contains these results. I will copy/paste the desired data and I would welcome that the meta-data is copied as well. Basically, copying the meta-data, too, has 2 roles: i.) it will flank, and therefore identify the specific data in the 2nd document (so it can be automatically detected in this document, too) ii.) it conveys additional information, not present in the visible text Now, lets go back to the Actions in the previous e-mail. I still might misunderstand this feature (or meta-data more globally), but this is *my meaning* of meta-data (or the way I find it most useful). Action 1: CUT Nothing points to the meta-data, but after paste, the text-object should point again at this meta-data (either left in place, or copied to the new document IF it was pasted to a new document) Action 2: COPY and PASTE as new paragraph As we can't predict which paragraph is important (will be re-used for its content/meta-data), both paragraphs should continue to point to the same meta-data. Especially, because manually copying data won't ensure that the right paragraph is copied. [IF the data was handled automatically, the parser could detect the paragraph that still has the meta-data attached to it, but this is not true for manual copy/paste.] Action 3: CUT and PASTE (meta-data is preserved) Action 4: COPY and PASTE in new document The meta-data stream should be copied to the new document and the paragraph shall point to this new copy. As I said, the content might traverse different documents: PROVIDER 1 = generates meta-data [document 1] = COPIED to document 2 [rather then CUT/PASTE, the COPY/PASTE is more likely] = COPIED to document 3 = ... All users will benefit from the meta-data, so all objects originating from the original object should reference the meta-data (or a copy of the meta-data). As I said, my expertise in meta-data is very limited, but this is what I understand from meta-data and how I imagine it being most useful. When nothing points to the meta-data anymore, then the best way to handle this is to delete the meta-data (should be undoable as long as the Undo is allowed; should be deleted completely after the undo is not possible anymore). - 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]
[sw-issues] [Issue 91562] Specify what happens to th e meta data of text document entities when the document is edited
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91562 --- Additional comments from [EMAIL PROTECTED] Fri Aug 8 12:49:05 + 2008 --- Hello all, my view of the real-life scenario is like this: a simple content gets rarely passed by to another document as it is. More often, a new document is assmebled from various existing documents. Consider this: _ LAB 1 = generate document + meta-data | | LAB 2 = generate document + meta-data | | = LAB 1 = new data + meta-data | | RECEIVER = generate other content + meta-data | - RECEIVER will combine his own generated content with contents from the various LABS and will generate a new document containing this data and hopefully all the relevant meta-data along. This is a more realistic use-case. Then he passes this document along to a new RECEIVER who again will corroborate various sources to generate a new document with combined meta-data and passes it along to a new receiver (maybe back to the first one or another one, e.g. a hospital). With regard to pasting within the same document: I do not have a strong opinion about this, as in the field I work it won't occur that often. But copying the meta-data to a new document is something that in my opinion is very important and the main utility of meta-data. - 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 92153] spurious div/0 error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92153 --- Additional comments from [EMAIL PROTECTED] Fri Aug 8 17:31:18 + 2008 --- The problem with the proposed approach is: 1. variable names have to be typed 2. cells can be selected with the mouse I mention this, because it is easy to mistype something like AB_6 or AB6v and still end with cell [AB6] instead of the variable name. IF the user names something PI2, or to give an example that I often use APACHE2, then I still believe that the chance of an error will be dim and the chance of a calculation with a cell PI2 (and APACHE2 - when spreadsheets will support as many columns) is rather small. But as you said, it is not zero. Instead of forbidding valid names (and highly desirable names), I would adopt an overall better solution: - Calc could detect such conflicts and mark the respective cell -- mark only IF the cell is non-empty -- it is unlikely that the user would reference an empty cell - the user is then warned that a similar name and cell do exist I still believe that the liberal use of names greatly outweighs the negative consequences. If people were using more often names, then they would start both to organise better their spreadsheet and also reduce a great number of other errors. This would by far offset the rare occurrence of the mentioned naming conflict. - 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 5658] Spreadsheet thinks a number is a string (text)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Fri Aug 8 21:39:01 + 2008 --- What I don't understand is, why refering to a cell containing (empty string) in formulas evaluates to Err:529 This is definitely an error. Empty cells should not be evaluated as either text or number. They are just empty. Silly, but this is how it should have been handled. Actually, empty has a special value, it is called Not Available, or NaN, or NA. Calc should implement such a special type, as described in one of my previous posts. R does it (the S+ language) and all professional statistical applications. Also, R has a very powerful way to handle NA values. Default is to ignore these values, but the user can specify a different action, e.g. remove or fail. This is also the sensible way how to handle string-numbers: default would be *fail*, while other options are: *ignore* (Current Calc implementation) and *convert* to number (Excel's way). These option parameters should be passed to every function/formula/cell. - 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 92153] spurious div/0 error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92153 --- Additional comments from [EMAIL PROTECTED] Thu Aug 7 08:46:08 + 2008 --- A user might forget (3 months later) that she has defined VARIABLE AB6, refer to CELL AB6, and get (without warning) a wrong result using variable AB6 --not what she meant! I do not quite understand this statement. In general named ranges should be preferred whenever feasible (and I strongly prefer them), because they make the sheet much more structured, and indeed the user can easily remember 3 months later what he was doing. I especially point here to some of my feature requests to extend the concept of named ranges/variables: - issue 66886 (to restrict names to a particular sheet) and - issue 67499 (which, besides other things, would allow organising these definitions and adding sensible comments to every definition) http://www.openoffice.org/issues/show_bug.cgi?id=66886 http://www.openoffice.org/issues/show_bug.cgi?id=67499 As I said, at some time point every 'string'-name will be a valid column (even this 'VeryVeryLongVariableName') and so would preclude the use of any sensible name. Also, I expect variable names to be as short as possible, therefore I strongly oppose artificial 'X_6v or' the like. They only increase error rates and mistakes. At the same time, it is unlikely that a particular user, which has defined PI2 will actually use column PI2. Still, most people use less than 100 columns. Why wasting so many resources for just the rare use of more columns. - 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 92292] automatic filling of cells doesnt work as expected
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92292 User discoleo changed the following: What|Old value |New value CC|'sweigel' |'discoleo,sweigel' --- Additional comments from [EMAIL PROTECTED] Thu Aug 7 17:17:29 + 2008 --- I did some testing in OOo-dev m28 I entered in the first 2 cells a string and examined what happens when autofilling (using the drag method): Text entered in first 2 rows: A B C -- 1 text1.1 text1.1 text 2 text2.1 text2.2 text == after autofilling = 1 text1.1 text1.1 text 2 text2.1 text !2.1 text! == HAS CHANGED !!! 3 text3.1 text3.1 text 4 text4.1 text4.1 text Cell C2 should have never changed: at a minimum, it should not change, even IF the other cells are undefined. The optimal solution would be to detect the common string parts in the first 2 cells, remove them, and use the remaining numbers to increment. Alternatively, one could extract the whole number sequence. IF(cell_content == string) { ITERATOR = first_pos(cell_content) while(ITERATOR end) { IF( *ITERATOR++ == number ) next IF( *ITERATOR++ == locale_dependent(.) ) { decimal_separator++ # we can also have dates or date-like strings IF( decimal_separator 3) next ITERATOR-- # this is a decimal separator too much # will break after this } break } # we found our number-sequence } The alternative is to compare the 2 strings and extract ALL identical strings. Try to interpret as a number everything else that remains (that is different between the 2 strings). - 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 92292] automatic filling of cells doesnt work as expected
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92292 --- Additional comments from [EMAIL PROTECTED] Thu Aug 7 17:41:52 + 2008 --- Just to slightly update the described algorithm: - IF NO number sequence is found at the beginning of the string then the iterator should start backwards [left should have precedence over right] - this algorithm will fail with discontinues numbers, e.g. 1 text 1 2 text 2 The identical string algorithm would be slightly more stable, but would fail IF the true string part is different, e.g. 1 abc 1 2 axx 2 The behaviour would be undefined in this latter instance. Also, this latter algorithm would then have to increment every number sequence encountered (with possibly different steps). Though, this needs not be implemented immediately. Fixing the overwrite behaviour should however be fixed in a timely manner. Detecting a whole number sequence should probably follow closely. - 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]