iDoceo 7 for macOS and iPadOS now available!

You will find all the details explained here
Welcome, Guest
Username: Password: Remember me

TOPIC: Report export XLS options

Report export XLS not working fully 5 years 5 months ago #6306

Hi Bert,
I'm trying to export my text annotations as an XLS file but none of the text comes up on the Excel spreadsheet. I've ticked include annotations and also tried the save cell as text.
Is there something else I should be doing?
James
The administrator has disabled public write access.

Report export XLS not working fully 5 years 5 months ago #6307

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3368
  • Thank you received: 652
Hi James,
I've just recorded this, give it a look and let me know if you spot the difference.
The video shows both Numbers and Excel


Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
The administrator has disabled public write access.

Report export XLS not working fully 5 years 5 months ago #6308

Hi Bert,
It seems to be the XLSX option that means the comments don't come up on the spreadsheet, but it works when this option isn't ticked.

Is there a way to get these annotations exporting as text so that I can mail merge into a printable format? I want to be able to get the whole class' annotations into a table so that I can cut them out and stick into books rather than having a separate page per student.
The administrator has disabled public write access.

Report export XLS not working fully 5 years 5 months ago #6309

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3368
  • Thank you received: 652
Use the CSV export instead. It will create an additional column with the annotations next to each actual column in the gradebook
Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
The administrator has disabled public write access.
The following user(s) said Thank You: james.me.robinson

Report export XLS not working fully 5 years 5 months ago #6310

Thanks Bert,
Will try this now.
The administrator has disabled public write access.

Report export XLS not working fully 5 years 5 months ago #6336

Hi Bert,

The CSV file thing does exactly what I need it to, apart from the formatting (such as bullet points or line breaks) doesn't come out on the CSV. Is there a setting that would mean the formatting would be transferred?

What is the difference between CSV1, SCV2 and CSV3 on the options?
The administrator has disabled public write access.
Time to create page: 0.235 seconds
21 AUG

iDoceo 7 for iPad and Mac now available!

A huge update with tons of new features and a new interface

Read more

6 JUN

Create Multiple-choice tests with iDoceo Connect!

In addition to self-evaluation rubrics, your students can now fill exams online. Supports text and images - in answers and questions - and can easily be imported from an XLS template

Read more

Cookies policy

This website uses cookies to make it easier for you to use the forum. We do not track you for any kind of advertising or statistics. Cookies are only used to keep you logged in the forum in case you would like to post and to keep your language selection in case you use the automatic translation offered by Google. If you continue to use our offer and have activated this technology in your browser, you consent to the use of cookies.