Announcement

Collapse
No announcement yet.

Navicat v12 xlsx export. Null dates and numbers stored as text

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Navicat v12 xlsx export. Null dates and numbers stored as text

    I have what I consider an issue with the new v12. When I export the results of a query or table into xlsx format I have the following undesired issues.

    1. Null dates in the database output as 0000-00-00 rather than leaving them blank as previous version
    2. All Int columns appear in excel as "Number stored as text"

    If I export a large amount of data, I get an error in excel to recover data as it is corrupt and this message

    "Removed Feature: Format from /xl/styles.xml part (Styles)
    Repaired Records: Cell information from /xl/worksheets/sheet1.xml part"

    These issues are preventing me using V12 as I use export and import quite a lot.

    Am I missing something as it all worked fine in previous version.

  • #2
    Would you please provide us the following information? You can send to our support center - https://help.navicat.com/hc/en-us/requests/new

    1. Your Navicat version, e.g. Navicat for MySQL (Windows) 12.0.9 64-bit
    2. The query.
    3. The sql file of the tables used to build the query. In main window, right-click your table and choose Dump SQL File.
    4. Screenshots showing all export steps.
    5. The excel file which has recover data error message.

    Comment

    Working...
    X