search

cadets-ca / ets

MIT License
5 stars 3 forks source link

Unsupported error when trying to view the excel files in excel #53

Open huguesfcadets opened 4 years ago

huguesfcadets commented 4 years ago

Asked to @kirvanp the file and version of Excel and OS.

kirvanp commented 4 years ago

So, on the iOS version of Excel the file just doesn't open. On the Mac, it says the file may be corrupt, but if you click past that everything is fine. I will send you the file directly since gitHub doesn't want it.

Screen Shot 2020-01-15 at 22 07 54
kirvanp commented 4 years ago

This file.

PK

On Jan 15, 2020, at 1313, Hugues Ferland notifications@github.com wrote:

Asked to @kirvanp https://github.com/kirvanp the file and version of Excel and OS.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/cadets-ca/ets/issues/53?email_source=notifications&email_token=AMAFZXOWJC57IQ2SPTYV6TDQ55VAPA5CNFSM4KHJIOW2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4IGOQXYQ, or unsubscribe https://github.com/notifications/unsubscribe-auth/AMAFZXLDNQS4BHPHTVULDCDQ55VAPANCNFSM4KHJIOWQ.

huguesfcadets commented 4 years ago

Is opening the Excel report from an iPad/iPhone a regular usecase?

kirvanp commented 4 years ago

Not sure. Another issue with the excel files is that the numbers are stored as text so you can’t Apple formulas to them. For example, if you click an empty cell and try to sum some of the flights, you cannot. This can be bypassed by cutting the numbers and pasting them back in.

PK

On Jan 20, 2020, at 07:52, Hugues Ferland notifications@github.com wrote:

 Is opening the Excel report from an iPad/iPhone a regular usecase?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or unsubscribe.

huguesfcadets commented 4 years ago

Number as Text is another issue. It can be fixed if we want to do it now. In fact the code exit to create number cells, not used yet as this would require change to the code the generate the HTML/PDF report. Just need prioritization.

kirvanp commented 4 years ago

Sounds good. Were you able to take a look at the error I was getting trying to build and run on my iPad?

On Jan 20, 2020, at 09:03, Hugues Ferland notifications@github.com wrote:

 Number as Text is another issue. It can be fixed if we want to do it now. In fact the code exit to create number cells, not used yet as this would require change to the code the generate the HTML/PDF report. Just need prioritization.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or unsubscribe.

huguesfcadets commented 4 years ago

No. I don't see what is missing. Could you create a new issue for that and give more details.

Hugues Ferland

Gestionnaire – Soutien des applications, Centre de gestion des services TI (CGS TI), Groupe de soutien national aux cadets et aux Rangers juniors canadiens. Défense nationale / Gouvernement du Canada hugues.ferland@cadets.gc.camailto:hugues.ferland@cadets.gc.ca / Tél. : 450-358-7099 X 7105 / RCCC: 668-7105

Manager – Application Support, IT Service Management Centre (IT SMC), National Cadet and Junior Canadian Rangers Support Group National Defence / Government of Canada hugues.ferland@cadets.gc.camailto:hugues.ferland@cadets.gc.ca / Tel: 450-358-7099 X 7105 / CSN: 668-7105

De : kirvanp [mailto:notifications@github.com] Envoyé : 20 janvier 2020 11:46 À : cadets-ca/ets ets@noreply.github.com Cc : Ferland civ H Hugues.Ferland@cadets.gc.ca; Author author@noreply.github.com Objet : Re: [cadets-ca/ets] Unsupported error when trying to view the excel files in excel (#53)

Sounds good. Were you able to take a look at the error I was getting trying to build and run on my iPad?

On Jan 20, 2020, at 09:03, Hugues Ferland notifications@github.com<mailto:notifications@github.com> wrote:

 Number as Text is another issue. It can be fixed if we want to do it now. In fact the code exit to create number cells, not used yet as this would require change to the code the generate the HTML/PDF report. Just need prioritization.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or unsubscribe.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/cadets-ca/ets/issues/53?email_source=notifications&email_token=AOITXIBULKTMU775PSK3WL3Q6XIM7A5CNFSM4KHJIOW2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJNHQJY#issuecomment-576354343, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOITXIDNSF7OCUQH3DSUWATQ6XIM7ANCNFSM4KHJIOWQ.

kirvanp commented 4 years ago

Nevermind, I forgot that you fixed that already. My iPad works fine.

PK

On Jan 20, 2020, at 0954, Hugues Ferland notifications@github.com wrote:

No. I don't see what is missing. Could you create a new issue for that and give more details.

Hugues Ferland

Gestionnaire – Soutien des applications, Centre de gestion des services TI (CGS TI), Groupe de soutien national aux cadets et aux Rangers juniors canadiens. Défense nationale / Gouvernement du Canada hugues.ferland@cadets.gc.camailto:hugues.ferland@cadets.gc.ca / Tél. : 450-358-7099 X 7105 / RCCC: 668-7105

Manager – Application Support, IT Service Management Centre (IT SMC), National Cadet and Junior Canadian Rangers Support Group National Defence / Government of Canada hugues.ferland@cadets.gc.camailto:hugues.ferland@cadets.gc.ca / Tel: 450-358-7099 X 7105 / CSN: 668-7105

De : kirvanp [mailto:notifications@github.com] Envoyé : 20 janvier 2020 11:46 À : cadets-ca/ets ets@noreply.github.com Cc : Ferland civ H Hugues.Ferland@cadets.gc.ca; Author author@noreply.github.com Objet : Re: [cadets-ca/ets] Unsupported error when trying to view the excel files in excel (#53)

Sounds good. Were you able to take a look at the error I was getting trying to build and run on my iPad?

On Jan 20, 2020, at 09:03, Hugues Ferland notifications@github.com<mailto:notifications@github.com> wrote:

 Number as Text is another issue. It can be fixed if we want to do it now. In fact the code exit to create number cells, not used yet as this would require change to the code the generate the HTML/PDF report. Just need prioritization.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or unsubscribe.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/cadets-ca/ets/issues/53?email_source=notifications&email_token=AOITXIBULKTMU775PSK3WL3Q6XIM7A5CNFSM4KHJIOW2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJNHQJY#issuecomment-576354343, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOITXIDNSF7OCUQH3DSUWATQ6XIM7ANCNFSM4KHJIOWQ. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/cadets-ca/ets/issues/53?email_source=notifications&email_token=AMAFZXNGVFD7SFVAKP3RWF3Q6XJNPA5CNFSM4KHJIOW2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJNIKJA#issuecomment-576357668, or unsubscribe https://github.com/notifications/unsubscribe-auth/AMAFZXLWANQISUU7L6GD7ATQ6XJNPANCNFSM4KHJIOWQ.