Unsupported error when trying to view the excel files in excel

[huguesfcadets]

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

[kirvanp]

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.

[kirvanp]

This file. PK

…

On Jan 15, 2020, at 1313, Hugues Ferland ***@***.***> 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 <#53?email_source=notifications&email_token=AMAFZXOWJC57IQ2SPTYV6TDQ55VAPA5CNFSM4KHJIOW2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4IGOQXYQ>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AMAFZXLDNQS4BHPHTVULDCDQ55VAPANCNFSM4KHJIOWQ>.

[huguesfcadets]

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

[kirvanp]

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 ***@***.***> 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]

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]

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 ***@***.***> 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]

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.ca<mailto: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.ca<mailto: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 ***@***.******@***.***>> 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 GitHub<#53?email_source=notifications&email_token=AOITXIBULKTMU775PSK3WL3Q6XIM7A5CNFSM4KHJIOW2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJNHQJY#issuecomment-576354343>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AOITXIDNSF7OCUQH3DSUWATQ6XIM7ANCNFSM4KHJIOWQ>.

[kirvanp]

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

…

On Jan 20, 2020, at 0954, Hugues Ferland ***@***.***> 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 ***@***.******@***.***> / 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 ***@***.******@***.***> / Tel: 450-358-7099 X 7105 / CSN: 668-7105 De : kirvanp ***@***.*** Envoyé : 20 janvier 2020 11:46 À : cadets-ca/ets ***@***.***> Cc : Ferland civ H ***@***.***>; Author ***@***.***> 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 ***@***.******@***.***>> 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 GitHub<#53?email_source=notifications&email_token=AOITXIBULKTMU775PSK3WL3Q6XIM7A5CNFSM4KHJIOW2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJNHQJY#issuecomment-576354343>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AOITXIDNSF7OCUQH3DSUWATQ6XIM7ANCNFSM4KHJIOWQ>. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#53?email_source=notifications&email_token=AMAFZXNGVFD7SFVAKP3RWF3Q6XJNPA5CNFSM4KHJIOW2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJNIKJA#issuecomment-576357668>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AMAFZXLWANQISUU7L6GD7ATQ6XJNPANCNFSM4KHJIOWQ>.