Skip to main content
On the backlog

Export function to excel should follow date visualisation of user

Related products:Indicium Service Tier
  • HJ van Dalfsen
  • pvleeuwen

Kasper Reijnders

We have some tables with start and end dates per row. When we do an export we see that all dates are no longer in the format that we used in the app. In Universal we use dd-MM-yyyy and the downloaded file uses MM-dd-yyyy.

We would like the export function to follow the date representation that the user within the application has.

Did this topic help you find an answer to your question?

6 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23
NewOpen

  • Rookie
  • 1 reply
  • March 29, 2023
Kasper Reijnders wrote:

We have some tables with start and end dates per row. When we do an export we see that all dates are no longer in the format that we used in the app. In Universal we use dd-MM-yyyy and the downloaded file uses MM-dd-yyyy.

We would like the export function to follow the date representation that the user within the application has.

Especially when adding rows (and re-importing) the file this is an issue. The date shown in the cell is different then the one shown in the "formula bar”. So when adding new rows and typing the date (following the cell above) you get the dd-MM part wrong and import the wrong date.


Forum|alt.badge.img+2
  • Partner
  • 14 replies
  • July 27, 2023

Are there any updates on this?


Mark Jongeling
Administrator
Forum|alt.badge.img+23

Hey @Anne Vries,

We also have a ticket in TCP with the same wish which has already been placed on the backlog, so I'll update the status of this idea. Indicium will be working on some more Date related stuff which may relate to this idea. We'll make sure to link them together. Once the ticket, and thus this idea is worked on, we'll be sure to update the status.


Mark Jongeling
Administrator
Forum|alt.badge.img+23
OpenOn the backlog

Forum|alt.badge.img+4

Hi Mark, we experience the same problem as mentioned above. Export of dates with format dd-mm-jjjj from UGUI 2025.1.14.0.0 gives in Excel a visual of mm-dd-jjjj although the value of the cell is correct. So it seems to be a display issue. 
Do you have an update of the last status ON THE BACKLOG ?

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings