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

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - Can't import large Excel applications
Can't import large Excel applications
 
   NeoOffice Forum Index -> NeoOffice Releases
View previous topic :: View next topic  
Author Message
Leif_Ivan
Red Pill


Joined: Apr 30, 2005
Posts: 5

PostPosted: Sat Apr 30, 2005 5:59 am    Post subject: Can't import large Excel applications

I would really like to leave MS office as quick as possible. Unfortunately I still haven't found a way to transfer the large (a budget-/project-management tool) Excel-models. What happens is that the functions are not transferred correctly. Now I use Swedish as my language and this problem seem to have something to do with this specific function "Förskjuta" . This is one example:
Excel:
=OM(E39>0;SUMMA(FÖRSKJUTNING(Personal!$B$26;0;4):FÖRSKJUTNING(Personal!$B$26;0;6))/4,1;"")

is translated as:

=OM(E39>0;SUMMA(#NAMN!(FÖRSKJUTA($Personal.$B$26;0;4);FÖRSKJUTA($Personal.$B$26;0;6)))/4,1;"")

As you can see it is not a question of just taking away "#NAMN!" because then I don't get a ":" is now a ";" and the calculation actually fails

To explain:
Om = the function "IF)
Förskjutning = a function that I think is "OFFSET" in english
Personal = another sheet in the application


A workaround would be to rewrite the formula in a simpler way. But then I would I be sure other functions are translated properly? And also - it is really a long and tiresome work. Then I must continue with Excel.

Any one has an idea?
Question
Back to top
Display posts from previous:   
   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.