My eRes Excel Reports are not aligned how can I fix this?

My eRes Excel Reports are not aligned how can I fix this?

In order to fix the Report alignment the below steps need to be followed:
1. Excel Reports
  1. On Excel versions 2013 and higher the settings used to generate these reports, now look at the user's computer regional settings configuration.
  1. To correct these settings right click on your date and time at the bottom of your screen.
  1. Select "Adjust date/time".
  1. Scroll down and click on "Date, Time & Regional formatting" settings.
  1. Once the regions page is displayed scroll down and select "Additional date, time & regional settings". The clock and region settings will open from the Control Panel.
  1. Select "Change date, time or number formats".
  1. Once the Regions screen displays click on "Additional settings" at the bottom of the screen, then change the Decimal to be a full stop (.)
  1. Next change the List separator to a comma (,)
  1. Click on "Apply" to confirm the changes.
  1. Re-run the report in Excel and it will be aligned correctly.
  1. If the above still did not fix the issue open Excel and go to File -> Options -> Advanced. Please ensure that "Use Systems Separators" is ticked.



    • Related Articles

    • Where can I find Cancellation Reports on eRes/NebulaCRS?

      1. Cancellation Reports Cancellation Reports can be accessed by clicking on Reports-> Management Reports -> Cancellation Reports.  There are a few options to choose from the user can look at the Cancellations by Arrival Date or Cancellations by ...

    • Where can I find Cancellation Reports on eRes/NebulaCRS?

      1. Cancellation Reports Cancellation Reports can be accessed by clicking on Reports-> Management Reports -> Cancellation Reports.  There are a few options to choose from the user can look at the Cancellations by Arrival Date or Cancellations by ...

    • eRes and NebulaCRS V2021.0

      Defects Resolved Zoho Number Module Version Description Zoho Desk Number CRS-I1485 Rates 2021.0.4675 Rate Closeout changes There was a logic issue when a Rate closeout was flagged as an update but no actual changes were made where it was seen as a ...

    • How do I save a report from Apex Repview without it being blank?

      When End of Day is run Apex will save the End Of Day reports in 3 different formats namely PDF, QRP and CSV. When attempting to save the report from Repview, as PDF or in Excel the report will be blank as it has already been saved in the format ...

    • Reports missing from Apex RepView

      Reports may be missing from Apex RepView due to one the following reasons: The incorrect date is selected. Reports have been archived/packed. Incorrect Apex RepView shortcut location has been added to the desktop. Apex End of Day has not been ...