Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

Download or installation problems? Try these steps
Problems after upgrading to NeoOffice 2022? Try these steps


Support
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


RSS Feeds
· Announcements Only
· All Posts


  
NeoOffice :: View topic - problems with find and replace in calc
problems with find and replace in calc
 
Post new topic   Reply to topic    NeoOffice Forum Index -> NeoOffice Releases
View previous topic :: View next topic  
Author Message
MartinK
Blue Pill


Joined: Mar 09, 2007
Posts: 1

PostPosted: Fri Mar 09, 2007 9:55 am    Post subject: problems with find and replace in calc Reply with quote

Good morning,

I'm new user of neooffice, from the very first moments quite impressed by overall functionality of your open software. therefore I have decided to be an early access subscriber.

Can you pls. help me with following?


I have problem with conversion of text to numbers in calc. For your explanation I have soma tables which were converted from .pdf, therefore all figures appear there with sign '1234, which is not reckognized as number but as text, therefore I tried to use some tipical MC Office hint, select area of text-numbers, find symbol *'* and replace it by nothing, which should result into deletion of all text symbols and conversion of text to numbers

In neooffice call this approach does not work. can you help me to find some alternative solution?



Kind rgds


Martin
Back to top
View user's profile Send private message
Lorinda
Captain Mifune


Joined: Jun 20, 2006
Posts: 2051
Location: Midwest, USA

PostPosted: Fri Mar 09, 2007 10:21 am    Post subject: Reply with quote

Find and Replace works somewhat differently in NeoOffice than in Microsoft Word.

Try reading through this page of our wiki.

I particularly reccomend the link there to the OpenOffice.org Migration guide section on the same topic.
Back to top
View user's profile Send private message
Lorinda
Captain Mifune


Joined: Jun 20, 2006
Posts: 2051
Location: Midwest, USA

PostPosted: Fri Mar 09, 2007 10:22 am    Post subject: Reply with quote

I forgot to say:

Welcome to NeoOffice and the forums at Trinity.

If the wiki article doesn't answer your question, or you have other questions, please let us know.
Back to top
View user's profile Send private message
jgd
Agent Smith


Joined: Feb 27, 2005
Posts: 1531
Location: France

PostPosted: Fri Mar 09, 2007 11:43 am    Post subject: Reply with quote

Welcome Martin,

You can use the "Value" function to replace a text with a number.
Example: Let's suppose that cell A1 contains a text '23
Select an empty cell B1 on the right of the cell A1.
Click on the icon of the Function Wizard on the left of the formula bar, choose Value in the category Text. Then click Next and click the cell A1 containing the text '23, and click OK.
The number 23 appears in B1.
If you want to convert a cell range, you can use the Fill function as described in the wiki

Hope that helps

Jacqueline
Back to top
View user's profile Send private message AIM Address
Samwise
Captain Naiobi


Joined: Apr 25, 2006
Posts: 2315
Location: Montpellier, France

PostPosted: Fri Mar 09, 2007 12:24 pm    Post subject: Reply with quote

Oops ... I was about to reply to this topic but a sudden build problem surfaced, and I completely forgot this thread.

It's probably just as well : I didn't know the answer Embarassed
Back to top
View user's profile Send private message
jgd
Agent Smith


Joined: Feb 27, 2005
Posts: 1531
Location: France

PostPosted: Fri Mar 09, 2007 1:18 pm    Post subject: Reply with quote

Samwise wrote:
Oops ... I was about to reply to this topic but a sudden build problem surfaced, and I completely forgot this thread.

It's probably just as well : I didn't know the answer Embarassed

Is your problem solved ?

Jacqueline
Back to top
View user's profile Send private message AIM Address
Samwise
Captain Naiobi


Joined: Apr 25, 2006
Posts: 2315
Location: Montpellier, France

PostPosted: Sat Mar 10, 2007 8:45 am    Post subject: Reply with quote

Yes. NeoOffice wouldn't build ("Permission denied"). I suspect that MacDrive has changed some permissions on my HD (see my thread in Random Whatnot), but I changed them back and now it works Smile
Back to top
View user's profile Send private message
jgd
Agent Smith


Joined: Feb 27, 2005
Posts: 1531
Location: France

PostPosted: Sat Mar 10, 2007 1:59 pm    Post subject: Reply with quote

Nice Very Happy
Back to top
View user's profile Send private message AIM Address
Display posts from previous:   
Post new topic   Reply to topic    NeoOffice Forum Index -> NeoOffice Releases All times are GMT - 7 Hours
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.03 Seconds