Skip to main content
On the backlog

Export function to excel should follow date visualisation of user

Related products:Indicium Service Tier
Geurt
eurban
Kasper Reijnders
+15
  • Edwin Saan
  • Geurt
    Geurt
  • eurban
    eurban
  • Erwin Ekkel
  • Kasper Reijnders
    Kasper Reijnders
  • Savienne Sanches
  • Anne Vries
  • Christian Schmidtchen
    Christian Schmidtchen
  • Marius Korff
    Marius Korff
  • rbiram
    rbiram
  • Wouter Vos
  • Johann Loewen
  • R. Leismann
  • Eric
    Eric
  • avandervelden
  • Raymond Maas
  • martijngaasbeek
  • Ionut
    Ionut
  • j.mart
  • pietervasbinder

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