View Issue Details

IDProjectCategoryView StatusLast Update
0013046Tine 2.0Addressbookpublic2017-05-10 09:41
ReportermiwiAssigned To 
PrioritynormalSeverityminorReproducibilityalways
Status newResolutionopen 
PlatformApacheOSDebianOS VersionWheezy
Product Version2017.02.3 Community Edition 
Target VersionFixed in Version 
Summary0013046: timezone error in export to xls
DescriptionExporting to xls with datafield type date leeds to a wrong date due to timezone correction in Export filter.
For example bday=10.1.1980 -> Excel: 9.1.1980 23.00
Steps To ReproduceExport filter Definition:

<?xml version="1.0" encoding="UTF-8"?>
<config>
    <model>Addressbook_Model_Contact</model>
    <name>Custom</name>
    <type>export</type>
    <plugin>Addressbook_Export_Xls</plugin>
    <label>Custom export</label>
    <description>Export nach Excel</description>
    <header>1</header>
    <columns>
        <column>
            <identifier>bday</identifier>
            <header>Geburtstag</header>
            <type>date</type>
        </column>
    </columns>
</config>
Additional Informationit seems the error occurs in Tinebase\Export\Xls.php Line 223
$result = PHPExcel_Shared_Date::($_record->{$_field->identifier}->getTimestamp());

this is fine for calendar but not for fixed Dates like birthday.
TagsNo tags attached.
mwticket

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2017-05-10 09:41 miwi New Issue