Comments (12)
I must had that the FormControl "reader" seems not to work properly.
In debugging I see that the read properties don't correspond to the form.
Best regards.
from vbasync.
Could you please make a small file that displays this behavior? It's probably some odd combination of settings you're using on your form that causes this. My test files all generate the same .frx
file each time.
from vbasync.
Modèles Office personnalisés.zip
from vbasync.
The issue seems to be that Office can change the order in which it stores controls in a form, even if you make no changes to that form. Please try this v2.2.0 release candidate.
Portable VBA Sync Tool 2.2.0.zip
from vbasync.
Hi,
Still not working.
Maybe Office jumbles sites order but still I don't think that's the reason I had to open this ticket. As I explained in the initial post, the problem is that extracting twice in a row (without using Office between the two extractions) the generated frx is different. There must be something in VBASync that is not repeatable or time/random dependant to generate this issue.
Thx
from vbasync.
In fact I noticed that there's an issue on frm files also. Maybe that's the starting point.
There's some special french char in the frm: é.
When I "open" (from scratch) VBASync and then I extract the dot file the é char is correctly extracted. But at the same time VBASync display some differences although it just did itself the extraction! So then (without closing/reopening VBASync) I extract again. And the second time the é char is lost/misinterpreted.
After applying, the frm is kinda correct:
VERSION 5.00
Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} Designations
OleObjectBlob = "Designations.frx":0000
Caption = "Intégration"
but VBASync stil detects some differences although it just extracted!
So then I apply. And so there's no more differences but the frm file is now incorect:
VERSION 5.00
Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} Designations
OleObjectBlob = "Designations.frx":0000
Caption = "Int�gration"
from vbasync.
Hm, I thought the fix for that was included in the last set of binaries I posted here. Could you try replacing VBASync.exe
and VBASync.WPF.dll
in your VBASync folder with these, to see if they make a difference?
from vbasync.
The frm file problem is gone. But the frx one is still here.
The problem is always at the same place in the frx, "last line" between character 523 and 539 (with winmerge).
You can reproduce the problem using the doc2.dot document in the zip file:
Modèles Office personnalisés.zip
from vbasync.
Okay, I see what you mean now, and it may be due to the CLSID of the .frx
root storage not being set to the proper value of c62a69f0-16dc-11ce-9e98-00aa00574a4f
. Try this latest set of binaries and see if they help:
VBASync binaries with CLSID fix.zip
Sorry for mistakenly editing your bug title earlier!
from vbasync.
Ok, It work better/fine now.
Nonetheless I noticed something else during some roudtripping tests. When you suppress the ThisDocument.cls and publish to the office document you kinda corrupt the office file. That is to says that when opening the document with office, you don't find anymore the project in the VBA Editor.
Is it intentionnal?
I found this feature kinda dangerous. I can envision the case where someone would want this case. But for most of the time I think the root project should remain intact. Maybe there should be an additional option for when the user intentionaly wants to crush the root project.
from vbasync.
When I tested a similar scenario with Excel, Excel automatically repaired the file, so I assumed Word would behave the same. I guess not!
To prevent future users from stumbling upon this and corrupting their file, I've made it so that if you delete any document file in the repository and then publish, VBA Sync will act as if you had truncated all of the code in that file, leaving the metadata intact.
Note there is an option that “expert users” can apply to override this and delete document modules to their hearts' content, even though I can see no legitimate uses of this behavior…
from vbasync.
By the way, have you had a chance to look at my responses to #28 and #29?
from vbasync.
Related Issues (20)
- Allow drag and drop of folder and file HOT 4
- Recent files are ignore if spécifier as relative path HOT 1
- Recent files are ignored if specified as relative path HOT 5
- When you load a session, if file or folder doesn't exist, alert user and disable some functions HOT 1
- Prevent publishing code to worksheets that don't exist HOT 2
- Option: ignore worksheets and modules with no VBA Code
- Language selected on first launch not taken into account HOT 2
- GistThat integration HOT 7
- Support subdirectories HOT 11
- Differentiate extract/publish Office document HOT 4
- Input string was not in a correct format HOT 5
- Splitting VS Project HOT 4
- OLE error at "next" extraction HOT 1
- Paths in VBASync UI with national characters are restored incorrectly on session auto-restore HOT 4
- "Error reading 'o' stream in .frx data" after the first export HOT 5
- New maintainers and new versions of VBA Sync HOT 9
- Issue while extracting from Office file
- Chinese garbled HOT 1
- debug is error
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from vbasync.