Export catalog list - problem with date format in Excel

The 1C:Enterprise developers forum

#1
People who like this:0Yes/0No
Active user
Rating: 2
Joined: Sep 16, 2013
Company:

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?

 
#2
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

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.

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.