[sc-issues] [Issue 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from paulwolstenho...@openoffice.org Wed Dec 15 10:37:32 + 2010 --- I haven't yet seen any way of specifying 1000's grouping in scientific format in OOo with 'Minimum number of integer digits' = 3. I should have pointed out that, as far as I can determine, OOo and excel are the same in this respect. If this combination of attributes is indeed impossible to set at present, there can be no OOo users making use of it. Reassigning it to mean engineering format is a promising option. We could maintain the existing support for any users that are using 1000's grouping in scientific format with 'Minimum number of integer digits' 3 (which is an OOo feature or trait that does not exist in excel). To do this we would turn off the engineering interpretation during 'Minimum number of integer digits' 3. Finally, to look at the problem and solution from all angles, it is worthwhile considering how existing software handles spreadsheet files that a future version of OOo has coded as engineering format. I would hope some sort of value is shown and that the format can be changed - all without crashing or hanging or deeming the file to be corrupt. - 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 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from paulwolstenho...@openoffice.org Wed Dec 15 19:53:47 + 2010 --- Let's not confuse the idea of encoding engineering format in a calc file (using 1000's grouping) with the issue of expressing engineering format in OOo's equivalent to what excel describes as a 'custom code' string. It would be confusing to make the user enter a comma in the format string just because we have a (temporary?) situation that encodes his intention in a similar manner to 1000's grouping. It is consistent with the existing symbol definitions to express standard engineering format as ##0.00E+00 since the # indicates the possible presence of a digit with leading 0 supression. Do we need to support leading zeros with engineering format? I do not think so. Excel allows #00.00E+00 and 000.00E+00 to express engineering notation (i.e. the exponent a multiple of 3) with a minimum of 2 or 3 digits before the decimal point (i.e. leading zeros) and it does implement it. Not wishing to be sexist, I might suggest that a user of this format could be an extremely strange girl or guy ;) Perhaps a reasonable compromise here is to accept the code #00.00E+00 and show 1234 as 001.23E+03 (because I can't imagine a need to supress the first leading zero but not the second). - 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 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from paulwolstenho...@openoffice.org Tue Dec 14 21:09:51 + 2010 --- I disagree with irneb who said: E.g. 0,000.00E+00 would get translated to .00E+00. Excel actually interprets .00E+00 as meaning that exponents must be a multiple of 4. Excel custom codes do not seem to support 1000's grouping in scientific format without also forcing the exponent to be a multiple of 4 or more, such as excel custom codes 0,000.00E+00 or #,###.00E+00. My tests on excel 2002 indicate that excel counts the total number of integer digits in the custom code (the number of '#' or '0' characters before the '.') and makes the exponent a multiple of that number. I believe there is no existing excel custom code that can simultaneously specify scientific format, 1000's grouping and 'Minimum number of integer digits' = 1, 2 or 3. This combination of attributes is actually not required because there is no value that would ever use 1000's grouping. We can safely use this combination of attributes to represent engineering format. I'm not sure why we would want engineering format with leading 0's but the codes do support it - and so does excel. So I'm suggesting we interpret a combination of ODF file attributes of: * 1000's grouping, * scientific format, and * 'Minimum number of integer digits' = 3 as denoting engineering notation. - 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 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from paulwolstenho...@openoffice.org Tue Nov 30 21:11:05 + 2010 --- Great to see some progress at last... 1) File storage of format specification: When considering how the format is encoded in spreadsheet files, please bear in mind that OOo also supports some excel formats. It would be great to see values an excel user formatted as 'engineering' shown as engineering. At present if OOo reads an excel97/200/xp file that has values that were formatted as ##0.0E+0 in excel, they are shown in 000.0E+0 format. 2) Excel 'engineering' format vs. true engineering format Excel's 'engineering' format has a variable number of significant digits - not a fixed number of significant digits as traditionally used as engineering format. Excel got it wrong. A little bit less than 1.00E+0 should be 990.E-3, not 990.00E-3 which pretends to be more accurate than it should. Offering true engineering format would be a real bonus for OOo although I expect many will say compatibility with excel is also important. For true engineering format we would need to specify the number of mantissa digits and accept that the decimal point will be inserted after the first, second or third digit according to the value being displayed. How to express that intention in a custom format would be an interesting question ( perhaps 0?00E+0 0?000E+0 0?E+0 ) I have no wish to see progress on this issue halted. I believe it is more important to provide any form of engineering notation than it is to fine-tune that format. If only one engineering format is possible, my vote would be for what I describe here as true engineering format. Keep up the good work! - 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 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from paulwolstenho...@openoffice.org Sun Aug 1 21:04:09 + 2010 --- I agree with Lars' comment that the problem as originally described (displaying the exponent as a multiple of 3) is 'low hanging fruit' and ought to be easy to implement. Lars did NOT say that the problem was already solved so I do not think there is any evidence to suggest that he 'missed the point' at all. As far as I am concerned he is right onto it! I do not believe thomasb12's recent statement starting with Secondly... is a useful posting in this issue as it is totally contrary to the detailed posting of alastair_paton on Tue Sep 8 22:55:17 that clearly placed that additional feature under issue 24373 which could be entitled 'nicer fruit that is higher up the tree and harder to get to'. - 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 108423] Form Controls are flicker ing in documents
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108423 --- Additional comments from paulwolstenho...@openoffice.org Mon Feb 1 22:35:00 + 2010 --- The symptoms I reported are completely fixed in RC4. - 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 108423] Form Controls are flicker ing in documents
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108423 --- Additional comments from paulwolstenho...@openoffice.org Mon Jan 25 22:47:50 + 2010 --- Similar issues seen with 3.2.0 RC3 (OOo320m10 build 9477) on win2k SP4: Opening an existing database form (from 3.0.1 using hsqldb) causes soffice.exe process to run at 60 - 90%. In the case of one form, a text box, some formatted fields and some label fields are all shifted left in a big jumble on top of each other. The other form I tried didn't show this trait despite having been constructed in a similar manner. Is this related? - 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 101782] Can't open calc spreadshe et - OOo hangs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101782 --- Additional comments from paulwolstenho...@openoffice.org Wed Nov 4 20:29:27 + 2009 --- This issue has resulted in OOo 3.0.1 and 3.1 both failing to support formulae produced according to published techniques. Furthermore, these formulae were supported correctly by earlier versions. In my opinion, software that fails in this way will either be unable to convince users that it is a tool that can be relied upon to get the job done, or alternatively it will lose any credibility that it already has - and it will lose it FAST. Fixing old features that got broken while implementing something else isn't glamourous - and I wouldn't expect it to win popularity contests (such as voting). Faced with a feature that doesn't work, most users would get frustrated and switch to another product rather than fight through an issues reporting system to have it put right (and rightly so given the lack of result I have seen so far). Surely keeping things working reliably should automatically come above implementing new features, regardless of voting? I thought that my posting of Fri Jul 3 04:19:33 would have allowed someone to realise that this bug is a symptom of linked file updates happening at the wrong time and then being able to reproduce that. I'm surprised that it keeps getting put in everyone's 'too hard' basket. Please increase the priority so OOo's reputation doesn't suffer! - 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 101782] Can't open calc spreadshe et - OOo hangs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101782 --- Additional comments from paulwolstenho...@openoffice.org Mon Jul 6 21:34:48 + 2009 --- I'm glad to see this bug can now be reproduced. I have submitted issue 103331 regarding the problem I mentioned with OFFSET() as it could well be unrelated. - 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 103331] OFFSET returns Err:504 on reference to another calc file
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103331 Issue #|103331 Summary|OFFSET returns Err:504 on reference to another calc fi |le Component|Spreadsheet Version|OOo 3.1 Platform|PC URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|code Assigned to|spreadsheet Reported by|paulwolstenholme --- Additional comments from paulwolstenho...@openoffice.org Sun Jul 5 08:13:25 + 2009 --- The offset function used to work up to 3.0.1 but in OOo 3.1.0 it returns Err:504 whenever the reference field refers to another calc document. To replicate: 1) Create a new calc document and save it as the default name (Untitled 1.ods) on the desktop. 2) Create a second calc document. (There is no need to save it.) 3) In the second document, select cell A1 of sheet1. Use the function wizard to enter function OFFSET. Set the 'rows' field to 0 and the 'columns' field to 0. With the cursor in the 'reference' field, click the first spreadsheet and a cell (e.g. A1) within that spreadsheet. Click OK on the function wizard to enter the formula. The formula will be similar to: =OFFSET( 'file:///C:/Documents%20and%20Settings/PaulW/Desktop/Untitled%201.ods'#$Sheet1.A1; 0; 0 ) Note that the formula result is Err:504 rather than the value of the cell in the first calc document. Same result on WinXP. - 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 101782] Can't open calc spreadshe et - OOo hangs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101782 --- Additional comments from paulwolstenho...@openoffice.org Thu Jul 2 23:29:18 + 2009 --- In my environment, the 2 examples of cianoz DO open correctly under 3.1.0. My problematic .ods file does NOT open under 3.1.0 until I do the following: 1. Remove the drive mapping that leads to the linked files, AND 2. Move the offending file to a higher or lower folder level. Neither action on its own will stop OOo 3.1.0 from hanging during file open. Most oddly, after doing the above, I have found a situation where, after opening the file, windows 'computer management' showed a file was being accessed using file sharing that was not a linked file but rather a previous version of the file I was opening that happened to be in the same folder. At the time, I had no mapped drive so it is unclear to me why the file would have been accessed via sharing when the file I was opening was accessed via the local C: drive and not via sharing. I was able to repeat the situation a few times until I opened and closed one or two other files. Now I am unable to repeat this observation. I'm not sure how relevant it is, but my .ods file, when opened under 3.0.1 contains: * 18 links shown under edit - links * 26 hidden sheets with names starting with file:///P:/ (should there be more than 18?) * 11 hidden sheets with names Table through to Table_11 that would appear to contain copies of tables that once were linked but no longer are. * 3 normal sheets that I created. (The other 37 must have been created automatically by various release versions of OOo.) * Note that the 40 sheets exist in a random order. * Some file:/// sheets displayed information like: The link could not be updated. File: file:///P:/Projects/Design/PCBs/RMU/BMS-R13/bms_r13Parts.sxc Sheet: PCB_Assy * One such file:/// sheet had column B hidden so the file name and sheet were not visible. I hope this information gives some clues on what I could usefully try next to further pin the issue down. - 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 101782] Can't open calc spreadshe et - OOo hangs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101782 --- Additional comments from paulwolstenho...@openoffice.org Thu Jul 2 23:35:06 + 2009 --- Correction to previous posting: Please change tables to sheets * 11 hidden sheets with names Table through to Table_11 that would appear to contain copies of SHEETS that once were linked but no longer are. - 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 101782] Can't open calc spreadshe et - OOo hangs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101782 --- Additional comments from paulwolstenho...@openoffice.org Fri Jul 3 02:28:13 + 2009 --- In 3.1.0 OFFSET to a cell in another spreadsheet file always gives Err:504. The links in my spreadsheets mostly use this feature. This means that even if I could stop OOo from crashing when opening, my old linked spreadsheets (and I have found many sheets that do crash) would not work on OOo 3.1.0 anyway. The failure of OFFSET can be demonstrated by creating 2 calc files and entering a formula into file SpreadsheetB such as: =OFFSET('file:SpreadsheetA.ods'#$Sheet1.C5;0;0) Note that OOo will add the full path after you enter it. The function wizard even lets you specify the link by clicking in the other spreadsheet if you have both open. So far I haven't been able to prove that this has anything to do with OOo hanging. What I do know is that after OOo does hang, memory usage increases until something happens (such as: visual C++ runtime library - runtime error... application requested the runtime to terminate in an unusual way). While hanging I've also seen the linked files on the share drive being accessed (reported by windows 'computer management') and the file original spreadsheet file being opened a second time (read instead of read-write access). As I knowing nothing of OOo internals, interpretation of the symptoms and a possible link of these issues is beyond 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...@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 101782] Can't open calc spreadshe et - OOo hangs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101782 --- Additional comments from paulwolstenho...@openoffice.org Fri Jul 3 04:19:33 + 2009 --- The following sequence causes OOo 3.1.0 to hang for me: 1. Using Win XP pro SP3 and OOo 3.1.0 create a new calc document and place the following into one line on cell A2: =MATCH( some text; 'file:///P:/some path/test target.ods'#$Part_Source.$A$1:$Z$1; 0 ) The result will be #NAME? because test target.ods does not exist. Save the new file (any name in the same folder will do) 2. Re-open the file. OOo opens and asks if you want to update the link. If you do nothing changes. Save and close again. (Maybe I didn't really need step 2.) 3. Create file P:/some path/test target.ods Whether OOo 3.1.0 is going to hang in step 4 or not DOES depend upon the content and OOo version of this file - in weird and wonderful ways that I do not yet understand. 4. Repeat step 2. This time OOo hangs before displaying the spreadsheet and before asking about updating links. BUT this should not happen because OOo should not have been checking the link yet so the presence or absence of a linked file should not be an issue. You might not experience OOo hanging because you might have other content in test target.ods. Nevertheless a suitable debugging system should be able to prove that the file system was accessed at a time that I understand it should not have been accessed. - 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 101782] Can't open calc spreadshe et - OOo hangs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101782 --- Additional comments from paulwolstenho...@openoffice.org Thu Jul 2 05:16:42 + 2009 --- This issue seems the same as the problem I am experiencing - as cianoz states it is a difficult issue to quantify: My calc spreadsheet has been working fine for years and links to a number of other calc spreadsheets - all an a shared drive on a peer-peer W2k + Wxp workgroup. I was shocked to see (after reading this issue) that it has accumulated 37 hidden sheets over the years - possibly due to changed links. Following the 3.0.1 - 3.1.0 upgrade, OOo hangs when opening the file. The status line shows Load document then calculating then Adapt row height but the progress bar stops at about 30% with my only recovery option being to kill the soffice.bin process via windows task manager. I have found that various combinations of resaving (without any real change) under OOo 3.0.1 or 3.0.0 combined with copying the file to another computer do result in 3.1.0 being able to open the amended file. In doing so I have created one version of the file that will open or not according to which shared drive I have saved the file on. In both cases OOo 3.1.0 running on WinXP pro on the same machine is trying to open the file. In one case the file is located on a mapped drive that happens to be a share from the same pc - and OOo hangs. In the other case the file is located on an unmapped share on a W2k pc - and the spreadsheet opens. To date I have been unable to reduce my spreadsheet to a useful example. I also have little knowledge of how to diagnose this further. Presumably it has something to do with links and hidden sheets but I'm not sure what I should fiddle with in those areas. It would appear that file rights or path completion on a network are a factor in this OOo hang. I hope this assists the diagnosis process! - 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 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from [EMAIL PROTECTED] Tue Aug 22 15:07:30 -0700 2006 --- 1) I've used this feature in ms excel 95 and probably even earlier versions. OOo is really deficient in letting this one slip to such low priority. Please raise the urgency! 2) The competing product suppresses leading digits when rounding to scientific notation and this isn't always the nicest way to show things. What excel will NOT let you do is ask for engineering notation with a specified number of significant digits. For example, instead of seeing 1.2E3, 12.3E3, 123.4E3, 1.2E6 it is usually better to see 1.23E3, 12.3E3, 123.E3, 1.23E6 since this maintains the same accuracy throughout, i.e. 3 significant digits in this example - which is what we engineers really need. 3) The competing product does not allow suppression of the redundant trailing E+0 or E00 or whatever. This would be really nice. 4) It would be great to have a 'general engineering' format, similar to the excel's general format but which switches to engineering format for numbers between -1.0 and +1.0, numbers -1E3 and under and numbers 1E3 and greater. Note that excel's general format already shows small numbers (below about 1E-5) in scientific format instead of just 0 as in OOo 2.02. - 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 60236] Offset when pasting dates
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=60236 User paulwolstenholme changed the following: What|Old value |New value Status|CLOSED|REOPENED Resolution|INVALID | --- Additional comments from [EMAIL PROTECTED] Tue Feb 7 12:21:38 -0800 2006 --- If this is intended behaviour, then I think the help system should make some attempt to explain it. The user does not expect dates to be changed when pasting between sheets so a tip or warning explaining the need for the same 'base' date would be appropriate. Related existing help index entries are: Date Time Functions dates;default copying;spreadsheets The text might read something like: Tip: When copying cells that contain dates between spreadsheets, both spreadsheets should have the same 'base' date defined under 'tools - options - openoffice.org calc - calculate - date'. In particular, StarCalc 1.0 spreadsheets differ from the OpenOffice.org default 'base' date. - 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]
[dba-issues] [Issue 42358] MySQL/ODBC: dynamic max-t ext-length on text fields works improperly
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=42358 --- Additional comments from [EMAIL PROTECTED] Thu Sep 1 15:04:37 -0700 2005 --- The default settings of MyODBC-3.51.11-2-win caused my text fields to be truncated because Don't Optimize Column Widths wasn't ticked. This was a MyODBC advanced option with the only help stating The client can't handle that MYODBC returns the real width of a column. I only realised that this was my problem because upgrading from an earlier version of MyODBC resulted in this being set (on one computer) while a new DSN on a newly installed MyODBC 3.5.11- 2 resulted in the option cleared (on another computer). As a simple user I didn't want to be involved in these issues. I don't care which product it is fixed in; OOo or MySQL, I'll leave that to experts. - 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]