Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

date/time format in xlsx export

User_BLLH6May 27 2021 — edited May 27 2021

Using "Version 20.2.0.175/Build 175.1842".
I use nls_date_format = 'DD.MM.YYYY HH24:MI:SS'.
When exporting to xlsx, the time information in MS-Excel is gone and the date-format shown is "MM.DD.YY" (the time information is not hidden by the cell-format, but is really missing!)
e.g. SQLDeveloper: "31.01.2021 13:41:59" => MS-Excel: "01.31.2021"

As I was not able to solve this issue, I copied " Version 20.4.1.407/Build 407.0006" in parallel without migrating the config from my 10.2 version.
I use the same nls_date_format = 'DD.MM.YYYY HH24:MI:SS'.
When exporting "31.01.2021 13:41:59" to xlsx, I see "1.31.2021 1:41 PM" in MS-Excel (seconds are there, but only hidden by the cell-format).
=> is the date/time-format used in xlsx-export a configuration/setting in SQLDeveloper or fixed in the respective SQLDeveloper version?

Comments

USER1211

Do it your Data Form Design.

Have column with the entity,scenario and the year members then have another column with the other entity,scenario and the other year members.

Once you got the clarity you needed remember to mark the thread as answered so members can focus on unanswered questions.

Did Your Question Get Answered in My Oracle Support Community (Doc ID 1180503.1)

3235756

I want that the column of "entity" dimension (1101, 1218) shows only once like this example:

pastedImage_3.png

If I create some columns, the entity repeats. For my example, the column 1101, I want that shows once and now Entity shows 3 times:

pastedImage_0.png

pastedImage_1.png

Further, I don't want to view all years and all scenarios. There are these situations:

  • FY16 and FY15 for "Presupuesto" Scenario
  • Only FY15 for "Real" Scenario
  • Only FY14 for "Presupuesto" Scenario
JohnGoodwin
Answer

You may not get it exactly how you want it but here is an example similar to yours.

pastedImage_1.png

pastedImage_0.png

Marked as Answer by 3235756 · Sep 27 2020
3235756

Thanks, this option tried, but the problem is that I have a lot of members entity (sales east, international sales).

I wanted to know if PBCS had a option to avoid: add entity by entity in the form, and not repeat the member in the view (for example, "sales east" displays in two columns).

At the moment, I will use this option

AL.

Hello,

From my point of view, it seems like you need a report instead of a webform.

Finnancial reporting studio gives you many more posiblities regarding the design and display options. You can merge cells, asign colours or even change the writing font...

Best Regards,

1 person found this helpful
3235756

Thanks, I going to explorer "Finnancial reporting studio" option.

JohnGoodwin

You can only customise the form with the options that are available, as I said it may not always be exactly the format you are looking for.

There are many different ways of doing things you could have entity in the page and then with security the user will just enter data for the entity they have access permissions against.

Also it depends if this is a data entry form or a report which as suggested could be done through FR if it is.

1 person found this helpful
1 - 7

Post Details

Added on May 27 2021
#excel, #export, #sql-developer
4 comments
1,505 views