[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

Jacques Guilleron  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

--- Comment #18 from Jacques Guilleron  ---
Works fine now with 
LO 5.0.2.2 Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe 
Locale : fr-FR (fr_FR)
& Windows 7 Home Premium

Have a fine day

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

Jacques Guilleron  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

--- Comment #19 from Rpnpif  ---
It works fine also with Debian Linux 8 (Jessie).

Thanks.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

--- Comment #16 from Jacques Guilleron  ---
Created attachment 118523
  --> https://bugs.documentfoundation.org/attachment.cgi?id=118523=edit
Formula differ from Tips

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

--- Comment #17 from Jacques Guilleron  ---
Hi Rpnpif,

To confirm what you said:
Since LO 4.3, in the french UI, due to the fact that two functions have the
same name, when using SERIE.JOUR.OUVRE, formula displayed (Workday) and formula
registered (Workday.intl) in the file differ, as shows it the screen shot.
A double semicolon can be used for the third argument to get the correct
displaying, but this will be to correct when the fix will be applied.

Jacques

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

Jacques Guilleron  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||guillero...@aol.com
 Ever confirmed|0   |1

--- Comment #13 from Jacques Guilleron  ---
Hi,

* So I think that the French version of LO 5.0.1.2 has errors that are not in
the * English version.

Right. In french UI, function wizard, Functions tab, Date category,
there's two different functions named SERIE.JOUR.OUVRE. INTL is missing to the
end of the second one. I reported that on the french qa list. This is corrected
now and will be available in master, next LO 4.4 and 5.0.
With Windows 7 Home Prmeium, only the first function is available. Selecting
the second one send back to the first one, so only three arguments. Error 502
comes from the fact you are adding a fourth argument.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

--- Comment #14 from Rpnpif  ---
(In reply to Jacques Guilleron from comment #13)
Thank you for this good news.
Error 502 does not come from the fact I am adding a fourth argument because I
used only three arguments to SERIE.JOUR.OUVRE. Look well in the attached file.

Cordialement,

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

Joel Madero  changed:

   What|Removed |Added

 Status|NEW |UNCONFIRMED
 Ever confirmed|1   |0

--- Comment #15 from Joel Madero  ---
With Comment 14 it seems like Comment 13 is describing a separate issue. Moving
this back to UNCONFIRMED.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

Rpnpif  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

--- Comment #12 from Rpnpif  ---
(In reply to Robinson Tryon (qubit) from comment #11)
> It's not quite clear to me how I should go about reproducing this issue.
> Could you please provide an enumerated list of steps that one can follow?

I agree with you, my explanation was not clear because this issue seems to have
changed with LO5.0.1 after 5.0.0. WORKDAY that was replaced by WORKDAYINTL
seems to be come back.

So, I use LO 5.0.1 on Debian Wheezy Linux. My locale are LANG=fr_FR.UTF-8. Note
that LO on MS Windows has a similar issue but not exactly the same (see below).

1. Open the file in attachment in a terminal :
/opt/libreoffice5.0/program/soffice Plan\ d_annee_2.ods
2. Select B6.
3. Click on the icon Fx (Assistant Fonctions, the function wizard).
4. Click in the zone Formule, on the name SERIE.JOUR.OUVRE. Above the argument
are : Date initiale, Jours, nombre de chaînes, matrice. Note that is the type
of the argument, not their names and there are four arguments.
5. Click on OK without modifying nothing. Now an error 502 appear.in the cells
that contain SERIE.JOUR.OUVRE. No good reason for this error.

Now with the English version of LO 5.0.1 on Debian Linux.
1. Open the file in attachment in a terminal :
LANG=C /opt/libreoffice5.0/program/soffice Plan\ d_annee_2.ods
2. Select B6.
3. Click on the icon Fx (the function wizard).
4. Click in the zone Formula, on the name WORKDAY, the arguments are Start
date, Days, Holidays as in LO 4.4.
5. Click on OK. All works fine, no error.

So I think that the French version of LO 5.0.1.2 has errors that are not in the
English version.

On MS Windows, with the French version, the arguments are translated as : date
initiale, jours and Congés et fêtes (should be the same as on Linux). So, with
three arguments but clicking on OK get the same error 502.

I hope that my explanation is more clear.

Regards.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

--- Comment #8 from Rpnpif  ---
This issue seems to be more complicated.

I see that both WORKDAY and WORKDAY.INTL exist in Excel. But in LO 5,
WORKDAYINTL replaces WORKDAY. So I think that the compatibility with Excel is
not fixed. Am I right ?

My source :
http://excelunplugged.com/2015/01/27/workday-and-workday-intl-in-excel/

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

--- Comment #7 from Rpnpif  ---
(In reply to MM from comment #6)
> I think WORKDAYINTL got fixed, now with 4 arguments instead of 3, to be
> better compatible with excel.

I understand but this make WORKDAYINTL now incompatible with the files created
with LO 4.4 or older.

As in Excel, why not keep both WORKDAY with the old schema (3 arguments) and
WORKDAY.INTL (not WORKDAYINTL) for new schema (4 arguments) ? Today,
WORKDAYINTL replaces WORKDAY for the international (and English?) language.

Another alternative more versatile should be to detect the old schema or the
new schema, basing on the type of the arguments to assure compatibility with
earlier LO. I do not known if this is possible.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

Rpnpif  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |WORKSFORME

--- Comment #9 from Rpnpif  ---
Oh! This issue is fixed for me in LO 5.0.1.1 that I found only few minutes
before.

I tried LO5.0.1 RC1 but without success.

Thank you!

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

Robinson Tryon (qubit)  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||qu...@runcibility.com
 Ever confirmed|0   |1

--- Comment #11 from Robinson Tryon (qubit)  ---
(In reply to Rpnpif from comment #0)
> So old spreadsheet have errors because Holidays are arrays and number or
> strings are required with another meaning.
> 
> To  assure compatibility, the 4th parameter should be in the 3th position.

Sounds quite problematic.

(In reply to Rpnpif from comment #4)
> My normal locale is fr_FR.UTF-8.
> When I run :
> LANG=C libreoffice4.4 Plan\ d_annee_2.ods
> the function is named WORKDAY.
> 
> But if I run :
> LANG=C libreoffice5.0 Plan\ d_annee_2.ods
> the function is named WORKDAYINTL.

It's not quite clear to me how I should go about reproducing this issue. Could
you please provide an enumerated list of steps that one can follow?

Status -> NEEDINFO

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

Rpnpif  changed:

   What|Removed |Added

 Status|RESOLVED|UNCONFIRMED
 Resolution|WORKSFORME  |---

--- Comment #10 from Rpnpif  ---
Sorry, but this issue was not fixed. After removing LO, and install another
time, this bug is still present. I do not understand why.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

--- Comment #6 from MM  ---
I think WORKDAYINTL got fixed, now with 4 arguments instead of 3, to be better
compatible with excel.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

--- Comment #3 from Rpnpif rpn...@free.fr ---
Created attachment 118222
  -- https://bugs.documentfoundation.org/attachment.cgi?id=118222action=edit
A calc file with WORKDAY function from LO 4.4

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

Rpnpif rpn...@free.fr changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

--- Comment #4 from Rpnpif rpn...@free.fr ---
My normal locale is fr_FR.UTF-8.
When I run :
LANG=C libreoffice4.4 Plan\ d_annee_2.ods
the function is named WORKDAY.

But if I run :
LANG=C libreoffice5.0 Plan\ d_annee_2.ods
the function is named WORKDAYINTL.

Is it normal ?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

--- Comment #5 from Rpnpif rpn...@free.fr ---
 LANG=C libreoffice4.4 Plan\ d_annee_2.ods

I think you have understand that I use Debian Linux and this command is typed
in a X terminal. But this issue probably exists on another OS.

Regards.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

Eike Rathke er...@redhat.com changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 Ever confirmed|0   |1

--- Comment #2 from Eike Rathke er...@redhat.com ---
@Rpnpif:
Could you attach such a failing document, NOT saved with 5.0 but last saved
with 4.x?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

Joel Madero jmadero@gmail.com changed:

   What|Removed |Added

   Keywords||regression
 CC||jmadero@gmail.com

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

Rpnpif rpn...@free.fr changed:

   What|Removed |Added

Version|5.0.1.1 rc  |5.0.0.5 release

--- Comment #1 from Rpnpif rpn...@free.fr ---
Exist in 5.0.0.5.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 93685] WORKDAYINTL function has a new parameter that make old spreadsheet in error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=93685

Rpnpif rpn...@free.fr changed:

   What|Removed |Added

 CC||rpn...@free.fr
   Severity|normal  |major

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs