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

2014-03-17 Thread Steve Edmonds 


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



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+unsubscr...@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

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

2014-03-17 Thread e-letter 
On 17/03/2014, 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.
>

Before update to LO40, the spreadsheet was accessible?

Has the principal changed m$ software or the file format of the spreadsheet?

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

The document appears to be a template file (suffix .xlt). No password
was requested to open the file.

-- 
To unsubscribe e-mail to: users+unsubscr...@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

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

2014-03-17 Thread Ernest Karlsson 
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


-- 
To unsubscribe e-mail to: users+unsubscr...@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