Desktop version

Main > Forum > 1C:Enterprise Platform > 1C:Enterprise – Business applications platform > Export catalog list - problem with date format in Excel

Forum

Search UsersRules
Export catalog list - problem with date format in Excel
#1
Active user
Points:: 0
Joined:: Sep 16, 2013

Hello,

When I save catalog list to Excel format the date fields are saving into Excel as Text format.
I have changed format these fields as date and ater that when I start filterring by any date field in Excel I do not see in Excel options to filteriing by year, month or day. Next I have entered into edit mode (F2 button) Excel cell and after break edit mode the filtering options are completly for this cell. Is there any way to save catalog list into Excel format with completly date format in cell?

Profile
#2
Guest
Points::
Joined::

Hello, kris s!

Try selecting all sheet and copy/pasting it as only data.

Also, you can use rich reporting features of Data composition schema. This will let you making more advanced filters than Excel allows.

Hope, this helps.

Profile
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.