search

PopovGP / Export-MS-Project-to-MS-Excel

Export tasks, Gantt chart and resources from MS Project to MS Excel. No additional software or installation required. Using build-in MS Project features (VBA).
GNU General Public License v3.0
30 stars 10 forks source link

Broken for nested subprojects #10

Open joelgroves opened 2 months ago

joelgroves commented 2 months ago

When subprojects are present the order of the outputted lines is messed up.

PopovGP commented 2 months ago

Hello! Can you provide some sample file or screenshots?

joelgroves commented 2 months ago

Hi,

I think I may have reported too soon, there is a problem but the definition I provided doesn't quite match the behaviour.

I have a large MS Project with multiple Subprojects. Initially when I ran the export module some lines from subprojects were seemingly randomly interspersed with each other. Having run the export a few times since then, this seems to have stopped (really odd!).

The remaining issue is with task grouping. When exported to Excel I'm seeing row groupings that don't match the original MS Project content, and this isn't a case of exceeding the 8-level Excel limit). What happens is that summary tasks at the same indent on MS Project get bundled into the same Excel group.

Sadly I can't recreate this issue with a smaller (and non-confidential) project.

I'll keep trying to recreate...

B.R.

Joel

From: Popov Grigorii @.> Sent: 07 June 2024 12:01 To: PopovGP/Export-MS-Project-to-MS-Excel @.> Cc: joelgroves @.>; Author @.> Subject: Re: [PopovGP/Export-MS-Project-to-MS-Excel] Broken for nested subprojects (Issue #10)

Hello! Can you provide some sample file or screenshots?

— Reply to this email directly, view it on GitHubhttps://github.com/PopovGP/Export-MS-Project-to-MS-Excel/issues/10#issuecomment-2154604183, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AFQVIRXPUEUWDRGKYF3WL7DZGGHKHAVCNFSM6AAAAABI6ODIO2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNJUGYYDIMJYGM. You are receiving this because you authored the thread.Message ID: @.***>

PopovGP commented 1 month ago

I've tried to repeat this error, but it's all ok. Here is the screenshot:

  1. MS Project: image

  2. Excel output: image

Seems like everything is ok. Test files attached. Multiple_projects.zip