[sw-issues] [Issue 8938] import/export filters for M icrosoft Works (.wdb, .wps and .wks)

2009-08-04 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=8938





--- Additional comments from na...@openoffice.org Tue Aug  4 17:33:50 + 
2009 ---
Looks like the simple solution for Works users trying to move up to the real 
world may be to use http://go-oo.org/ and not the normal OpenOffice.  I haven't 
tried it yet - downloading it now.

I have two friends who are still using Works, and unfortunately they never 
spotted that Works can be set to default to saving in Word6 or RTF formats.

For people who want to continue using Works, the rest of us need OpenOffice to 
be able to read their Works files without fuss.  This also applies to people 
who 
accidentally open Works and create documents without realising their mistake.

For people who want to move up, there is a need for a batch converter that will 
convert all the old files.

-
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



[sw-issues] [Issue 85193] Pictures moved after save and reopen

2008-01-12 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=85193
 Issue #|85193
 Summary|Pictures moved after save and reopen
   Component|Word processor
 Version|OOo 2.3.1
Platform|All
 URL|
  OS/Version|Windows XP
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P3
Subcomponent|editing
 Assigned to|mru
 Reported by|navvy





--- Additional comments from [EMAIL PROTECTED] Sat Jan 12 17:33:52 + 
2008 ---
I'm using a Word 2003 document with several photos on the page.  I've opened it 
in Writer and saved as .ODT then closed.  When I reopen the .ODT file, the 
photos are in the wrong places.  First large picture is correct, but other 
three pictures have moved to centre of first picture.

If I pick up and drag any one picture to a different location, then hit Ctrl-Z, 
all pictures are then displayed in the correct original locations.

If I save and reopen again, the fault repeats.

-
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 76463] defective java error

2007-07-03 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=76463





--- Additional comments from [EMAIL PROTECTED] Tue Jul  3 23:18:40 + 
2007 ---
I've just upgraded from OOo 2.2.0 to 2.2.1 and now I'm getting the defective 
java message when I try to use the web page wizard in Writer.  This wizard has 
worked OK in the past.  Java is build 1.6.0_01-b06.

I looked in Tools/Options/OpenOffice.org/Java and saw 2 versions of Java (1.6.0 
and 1.6.0_01) listed but both had empty radio buttons.  I selected one radio 
button and that seemed to fix the fault.

It may be coincidence, but I had recently use Add/Remove Programs to get rid of 
several old versions of Java (1.5.x) which seemed to be cluttering up my hard 
drive (130MB each!)  I would have expected the OOo upgrade to have fixed any 
potential problems with Java.

Seems to me that the OpenOffice installer is not automatically selecting the 
most recent Java version - possibly it is expecting an old version to work, but 
not bothering to check whether it still exists?

Looking through the forum, it appears that this bug has been present through 
several versions of OOo and Java.


-
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 76463] defective java error

2007-07-03 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=76463


User navvy changed the following:

What|Old value |New value

  CC|'kpalagin'|'kpalagin,navvy'





-
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 79185] Import for Microsoft Works documents

2007-07-03 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=79185
 Issue #|79185
 Summary|Import for Microsoft Works documents
   Component|Word processor
 Version|OOo 2.2
Platform|All
 URL|
  OS/Version|All
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|ENHANCEMENT
Priority|P3
Subcomponent|open-import
 Assigned to|mru
 Reported by|navvy





--- Additional comments from [EMAIL PROTECTED] Tue Jul  3 23:38:07 + 
2007 ---
OpenOffice does not easily open Microsoft Works documents.  (Nor does MS Word.)

Novices who buy a new computer and start using the built-in wordprocessor, 
which is MS Works, should be able to upgrade easily to OpenOffice.  Currently 
the Works file format is not recognised by OpenOffice.

-
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 32344] Simple wildcards * and ? as opposed to regular expressions

2005-08-02 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=32344





--- Additional comments from [EMAIL PROTECTED] Tue Aug  2 08:35:00 -0700 
2005 ---
I agree with drensink.  Automatic translation is what the user needs and 
expects.  

Changing options that affect all workbooks, will cause more problems than it 
solves.

If the user sees a warning that a regular expression could not be translated 
to Excel format, they will learn that Open Office is more powerful than 
Excel.  Currently the inadequate translation gives the opposite impression, if 
the user has never heard of 'regular expressions'.


-
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 51068] Count should ignore error s

2005-07-05 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=51068





--- Additional comments from [EMAIL PROTECTED] Tue Jul  5 06:26:41 -0700 
2005 ---
I'm sure this won't be the only case where fixing a bug causes spreadsheets to 
give different results in oo1.4 and oo2.0.  In this case it's perhaps more of 
a difference of interpretation over what should be counted.  Both 
interpretations might be correct if they match what is described in the 
program documentation, but the important thing for Open Office to be accepted 
by former Excel users is that OO should give the same results as Excel without 
the user having to fiddle with any settings.

Having several modes, where formulas either follow Excel rules or oo1.0 or 
oo2.0 rules, would not be sensible.  The journalists who write magazine 
reviews would have a field day!

Excel 2003 has started putting green blobs on any cells that it thinks look 
odd, such as numbers that are text, or formulas that are different from the 
adjacent formulas.  A text message like a tooltip is displayed to show what 
might be wrong.  This technique might be a possible way for Open Office to 
warn the user about ambiguous functions.

In this particular case, I can see that Open Office has a safer approach in 
that an error will be propagated, whereas Excel may hide the error from the 
user.  In my case the error was unimportant so I preferred Excel's approach, 
but that might not always be the case.

-
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 51076] WW8: Drawing Callouts in groups appear in the wrong place

2005-06-23 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=51076





--- Additional comments from [EMAIL PROTECTED] Thu Jun 23 03:09:33 -0700 
2005 ---
My bug report was about inaccuracies in the conversion from a Word document.  
Obvioiusly there needs to be compatibility here, regardless of whether the 
original error is casued by Microsoft or Open Office.

However, the simple solution would have been for me to move the callouts to 
the correct locations using Open Office.  I found this impossible.  I couldn't 
create new callouts as easily in Open Office Writer as in Microsoft Word.

In Word I can choose a callout style, click at location A and drag to location 
B.  I get an arrowhead at A and a box at B.  I can then resize the box and it 
remains linked to the arrow.  Open Office doesn't work this way - A and B 
become the diagonals of a box, and an arrow appears nearby but not joined on.  
The arrow seems to have no relationship to the location that I was pointing 
to.  The box also does not seem to work as a text box - text spills out of it 
and does not word wrap inside it.  Text, box and line appear to be unrelated - 
not really a callout object.

Maybe I've misunderstood how to use it?  Is there an alternative way to put 
arrowed labels on maps?


-
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 51149] New - Resize graphics usin g corner changes shape

2005-06-23 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=51149
  Issue #:|51149
  Summary:|Resize graphics using corner changes shape
Component:|Word processor
  Version:|OOo 2.0 Beta
 Platform:|All
  URL:|
   OS/Version:|All
   Status:|UNCONFIRMED
Status whiteboard:|
 Keywords:|
   Resolution:|
   Issue type:|DEFECT
 Priority:|P3
 Subcomponent:|editing
  Assigned to:|mru
  Reported by:|navvy





--- Additional comments from [EMAIL PROTECTED] Thu Jun 23 03:20:23 -0700 
2005 ---
When I resize a graphic, I usually don't want the aspect ratio to change.  In 
Word I can drag the corner and the size changes but shape remains fixed.  If I 
want to change the aspect ratio, I drag the middle of a side.

Open Office Writer doesn't lock the aspect ratio when I drag the corner.

-
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 51149] Resize graphics using cor ner changes shape

2005-06-23 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=51149


User navvy changed the following:

  What|Old value |New value

Status|CLOSED|UNCONFIRMED

Resolution|WORKSFORME|





--- Additional comments from [EMAIL PROTECTED] Thu Jun 23 08:49:27 -0700 
2005 ---
Thanks, I thought it must be possible somehow.  I still can't find it in the 
Help file.  Could we please have that on a Tool Tip.  Maybe when hovering over 
a corner, it could say press Shift to Keep Ratio.

I'd much prefer the default to be reversed - Keep Ratio unless Shift is 
pressed.  

I can't think why anyone would need to unlock the ratio - it's generally 
easier to drag one side to fit the column width, then drag bottom to give the 
required height.  It's annoying to find you have accidentally changed the 
shape.

In the right-click Position and Size window, there is a box for Keep Ratio 
but it won't stay ticked when the window is closed.  Maybe this window would 
be an appropriate place to display a note To keep ratio while dragging 
corner, hold the left Shift key.

Note that holding the right Shift key for 8 seconds will activate Filterkeys.


-
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 51168] New - How do I move a row up or down?

2005-06-23 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=51168
  Issue #:|51168
  Summary:|How do I move a row up or down?
Component:|Spreadsheet
  Version:|OOo 2.0 Beta
 Platform:|All
  URL:|
   OS/Version:|Windows XP
   Status:|UNCONFIRMED
Status whiteboard:|
 Keywords:|
   Resolution:|
   Issue type:|ENHANCEMENT
 Priority:|P3
 Subcomponent:|editing
  Assigned to:|spreadsheet
  Reported by:|navvy





--- Additional comments from [EMAIL PROTECTED] Thu Jun 23 14:02:36 -0700 
2005 ---
I want to manually rearrange the rows in a spreadsheet.  Sorting manually.  
How do I move a row and insert it between two other rows?

In Excel, I select the entire row, then hover just to the right of the row 
label, and then drag while holding the Shift key.

How do I do this in Calc?

I can't find it in the help file.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sw-issues] [Issue 51076] Drawing Callouts appear i n the wrong place

2005-06-22 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=51076


User navvy changed the following:

  What|Old value |New value

   Attachment data|  |Created an attachment
  |  |(id=27428) Sample maps
  |  |with callouts





--- Additional comments from [EMAIL PROTECTED] Wed Jun 22 14:52:13 -0700 
2005 ---
Created an attachment (id=27428)
Sample maps with callouts


-
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 51076] Drawing Callouts appear i n the wrong place

2005-06-22 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=51076


User navvy changed the following:

  What|Old value |New value

Status|RESOLVED  |UNCONFIRMED

Resolution|INVALID   |





--- Additional comments from [EMAIL PROTECTED] Wed Jun 22 15:03:08 -0700 
2005 ---
I've just attached a sample file with two maps.  It's about 224KB.  The first 
map (Brookwood) has the callouts appearing in the wrong place when opened with 
Open Office Writer 1.9.109 but should appear correctly in Microsoft Word 
2003.  The callout for the Pub should point to the railway station (red blob 
on the black railway line).  All three callouts get moved, and the map seems 
to have moved up too.

The second map (Foxham) works OK.  There is only one callout, and it points to 
a building marked P on the map.


-
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 51068] New - Count should ignore errors

2005-06-21 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=51068
  Issue #:|51068
  Summary:|Count should ignore errors
Component:|Spreadsheet
  Version:|OOo 2.0 Beta
 Platform:|All
  URL:|
   OS/Version:|Windows XP
   Status:|UNCONFIRMED
Status whiteboard:|
 Keywords:|
   Resolution:|
   Issue type:|DEFECT
 Priority:|P3
 Subcomponent:|code
  Assigned to:|spreadsheet
  Reported by:|navvy





--- Additional comments from [EMAIL PROTECTED] Tue Jun 21 12:48:13 -0700 
2005 ---
When Excel counts a range using =COUNT(D4:D191) the result is the number of 
valid numbers only.  Any cells that contain calculation errors, and display 
#N/A are ignored.  The result is a number.

Open Office Calc recognises the errors and shows an error in its own result.  
Count is supposed to show the number of valid numbers.  Errors are not valid 
numbers, and therefore should be ignored.

-
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 51072] New - COUNTIF should allow wildcards

2005-06-21 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=51072
  Issue #:|51072
  Summary:|COUNTIF should allow wildcards
Component:|Spreadsheet
  Version:|OOo 2.0 Beta
 Platform:|All
  URL:|
   OS/Version:|Windows XP
   Status:|UNCONFIRMED
Status whiteboard:|
 Keywords:|
   Resolution:|
   Issue type:|DEFECT
 Priority:|P3
 Subcomponent:|code
  Assigned to:|spreadsheet
  Reported by:|navvy





--- Additional comments from [EMAIL PROTECTED] Tue Jun 21 13:20:24 -0700 
2005 ---
Excel's version of COUNTIF supports wildcards * and ? in the criteria, but 
Calc doesn't. 

These wildcards have been in use since CP/M (before Microsoft!) and I can't 
see any reason for Open Office not to use them.

I use the criteria ??* to count both Op and Ins because my instructors 
are also operators and I want a total of everyone who can operate.  I just 
want to count all the 2 and 3 letter words.  I don't want to use regular 
expressions.

-
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 51076] New - Drawing Callouts app ear in the wrong place

2005-06-21 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=51076
  Issue #:|51076
  Summary:|Drawing Callouts appear in the wrong place
Component:|Word processor
  Version:|OOo 2.0 Beta
 Platform:|All
  URL:|
   OS/Version:|Windows XP
   Status:|UNCONFIRMED
Status whiteboard:|
 Keywords:|
   Resolution:|
   Issue type:|DEFECT
 Priority:|P3
 Subcomponent:|code
  Assigned to:|mru
  Reported by:|navvy





--- Additional comments from [EMAIL PROTECTED] Tue Jun 21 14:32:39 -0700 
2005 ---
I use callouts in Microsoft Word to put labels on maps, using the arrowhead to 
point to the location.  The map is a GIF image saved from multimap.

Grouping the callouts and the map together works within Word, but when I open 
the document in Open Office I find the callouts and arrows have moved, and are 
now pointing to the wrong locations!

I tried ungrouping in Writer, and moving one of the callouts, but it didn't 
seem possible to move individual parts of the callout.  I tried to pick up the 
arrowhead and move it to the correct location, but the whole callout jumped to 
a completely different location.

Problem may be that the Writer callout is created as diagonal corners of a box 
with a line somewhere near it, while the Word callout is created as a line 
with a box attached at the second point of the line.  The most important 
anchor point of the callout should be the first point of the line (ie the 
arrowhead.)

-
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 48020] COUNTIF criteria wildcards do not work

2005-04-25 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=48020





--- Additional comments from [EMAIL PROTECTED] Mon Apr 25 02:25:32 -0700 
2005 ---
Issue 32344 seems more appropriate.  The problem is Excel formulas that do not 
give the correct result in Open Office.  

When I open an Excel spreadsheet in Open Office, I need to either get the 
correct results or to get a message warning that some cells contain formulas 
that cannot be handled correctly.  Open Office does neither.


-
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 32344] Simple wildcards * and ? as opposed to regular expressions

2005-04-25 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=32344





--- Additional comments from [EMAIL PROTECTED] Mon Apr 25 02:38:21 -0700 
2005 ---
The problem is Excel formulas that do not give the correct result in Open 
Office.  

When I open an Excel spreadsheet in Open Office, I need to either get the 
correct results or to get a message warning that some cells contain formulas 
that cannot be handled correctly.  Open Office does neither.

As an Excel user, I don't want to know about regular expressions - I just want 
Open Office to give the same answers as Excel.

I also don't want to accidentally create Open Office formulas that will give 
the wrong results in Excel.

If there is a radio button in Tools/Options to change the formula-handling 
method, I would expect that to be automatically set correctly to match the way 
that Excel works, whenever an Excel file is opened.  Alternatively, when the 
troublesome formulas are detected, a warning box should open when the file is 
opened, preferably giving a quick way to make the necessary changes.



-
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 48020] New - COUNTIF criteria wildcards do not work

2005-04-23 Thread navvy
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=48020
  Issue #:|48020
  Summary:|COUNTIF criteria wildcards do not work
Component:|Spreadsheet
  Version:|OOo 2.0 Beta
 Platform:|All
  URL:|
   OS/Version:|All
   Status:|UNCONFIRMED
Status whiteboard:|
 Keywords:|
   Resolution:|
   Issue type:|DEFECT
 Priority:|P3
 Subcomponent:|code
  Assigned to:|spreadsheet
  Reported by:|navvy





--- Additional comments from [EMAIL PROTECTED] Sat Apr 23 08:06:58 -0700 
2005 ---
Excel allows wildcards to be used as criteria in COUNTIF function.  For 
example, ??* will count any cell with two or more letters.

Open Office gives a zero result, while Excel works correctly.

Fault is still present on version 1.9.93

I need to share files with an Excel user, so I can't just change the formula.

-
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]