Re: [libreoffice-users] Problem with formulas between Excel and LO

On 2014-03-17 21:19, Ernest Karlsson wrote:
> Hi,
>
> We run Ubuntu at our school, Mellansels Folk High School, but our principal
> creates lots of excel files that need to work in both environments. Our
> time reporting file stopped working in the 4.0> LO update. We were unable
> to figure out were the problem was. The problem arises after the first date
> is inserted and it seems as if the formula that checks for date repetitions
> and long hours disappears in the column that handles this. I am no
> spreadsheet guru and have no idea how to find the fault. The thing that
> surprised me was that the error was err:508 which, as far as I can see,
> means that a bracket is missing but as this file worked on version 3
> without error I don't think that is where the problem lies.
>
> The file is in Swedish but I believe that the formulas will be in English
> on a English system. To unlock the hidden columns and rows use the
> password: Mellansel (I have permission to pass this on)
>
> I hope you can assist me.
>
> /ernie
>
>   
> Manadsrapport-1760.xlt<https://docs.google.com/file/d/0B4qz_rnI8G9jVG5qeDM5Wmc5Qkk/edit?usp=drive_web>
Hi.
This opens in my LO 3 without an error, but I have no idea where to 
start to enter some data to get the sheet to the condition you obtain an 
error.
The sheet seems to need some values in A16 and C16 which are empty (both 
0) by default.
steve

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted