Bug 100316 - FORMULAEDITOR: Error en resultado formula suma fechas
Summary: FORMULAEDITOR: Error en resultado formula suma fechas
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.1.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-06-10 20:40 UTC by segovia1040@gmail.com
Modified: 2016-06-11 02:57 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Hoja de muestra con el posible error indicado, marcando en rojo las celdas significativas (67.94 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-06-10 20:40 UTC, segovia1040@gmail.com 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description segovia1040@gmail.com 2016-06-10 20:40:12 UTC 
Created attachment 125594 [details]
Hoja de muestra con el posible error indicado, marcando en rojo las celdas significativas

la expresión =TEXTO(J12+7;"DD/MM") me devuelve una fecha equivocada para el salto de Febrero a Marzo cuando el año NO ES BISIESTO. Los trata todos como bisiestos.

Se han marcado en fondo rojo las celdas que producen el resultado erroneo.
Comment 1 m_a_riosv 2016-06-10 22:59:33 UTC 
Hi @segovia1040.

IMO you are using the wrong formula, with your formula the actual year it's took by default.
Use a formula like: =TEXT(CONCATENATE(J28;"/";$B28)+7;"DD/MM"), so you take the year of the row ($B28).
Why not simply manage dates in the cells not as text and format the cell how you like.

Resolved as not a bug, please if you are not agree, reopen it.

If you have questions about how to use dates and cell format, there is:
ask.libreoffice.org and the mailing list for users in a lot of different languages http://nabble.documentfoundation.org/

Libreoffice documentation: https://wiki.documentfoundation.org/Documentation/Publications