Forums Home / ComponentOne / WinForms Edition
Posted by: olivier941 on 1 March 2018, 10:59 pm EST
olivier941
Posted 1 March 2018, 10:59 pm EST
Hello
I have some old application in VB5 that use the old method vsFlexGrid.SaveGrid
I have some files coming from this method
How can I Load then into the new C1.Win.C1FlexGrid.4 ?
I cant see any LoadGrid method in this new grid !
thanks
Ruchir.Agarwal
Posted 3 March 2018, 1:38 am EST
Hi,
We do offer LoadGrid method, with various overloads in C1FlexGrid. However, to use this method you need to add reference to C1.Win.C1FlexGrid.ImportExport.4.dll.
Here’s the history URL informing about the migration of C1FlexGrid’s import/export methods to a different assembly named C1.Win.C1FlexGrid.ImportExport.4 (can be found at C:\Program Files (x86)\ComponentOne\WinForms Edition\bin\v4.0): http://help.grapecity.com/componentone/NetHelp/WinForms_ReleaseHistory/webframe.html#2017v3.html
Also, you might to refer to following Documentation link for information about various import/export features in C1FlexGrid: http://help.grapecity.com/componentone/NetHelp/c1flexgrid/webframe.html#savingloadingandprinting.html
Let me know, if you need anything else.
Regards,
Ruchir Agarwal
jong
Posted 16 May 2018, 7:10 am EST
Should the C1.Win.C1FlexGrid.ImportExport.4 be included in licenses.licx? If so, what would be the format?
Ruchir.Agarwal
Posted 16 May 2018, 3:23 pm EST
Hello,
You need not add any entry for C1.Win.C1FlexGrid.ImportExport.4.dll in licenses.licx file. To use this dll methods, you just need to add reference of this dll in your project and add the Using/Imports statement for the namespace C1.Win.C1FlexGrid in your form.cs file.
Thanks,
Ruchir
olivier941
Posted 26 November 2018, 4:32 am EST
Hello
Sorry but it doesn’t work 
Here’s in attachment, my old VB5 file create with VsFlexgrid7.SaveGrid method
VsFlexgrid1.SaveGrid “c:\expor.TXT”, flexFileAll, True
How can i Load this file in the New C1.Win.C1FlexGrid.4
any sample code ?
thanks
meenakshi.singh
Posted 26 November 2018, 4:36 pm EST
Hello Olivier!
I could not see any attachment in your post. However, I’m attaching a sample application for your reference. This should help you.
Prj_LoadGrid.zip
Regards,
Meenakshi
olivier941
Posted 26 November 2018, 8:38 pm EST
olivier941
Posted 26 November 2018, 8:43 pm EST
[quote]However, I’m attaching a sample application for your reference. This should help you.
[/quote]
your sample use the FileFormatEnum.TextComma format
but in my sample, i use the old flexFileAll format from VsFlexGrid
see my attachment
thanks
meenakshi.singh
Posted 28 November 2018, 5:31 pm EST
Olivier!
I would like to inform you, in WinForms C1FlexGrid control, only text values are saved in/loaded from text file and not formatting information. In case you want to save/load values along with formatting, I suggest you to work with XML or Excel files.
Please follow the given help pages, for detailed information on the same:
Regards,
Meenakshi
olivier941
Posted 29 November 2018, 7:10 pm EST
Hello
It meens that all my files saved with the old method (VB6) : VsFlexGrid.SaveGrid with the format flexFileAll
http://helpcentral.componentone.com/docs/vsflexgrid8/savegridmethod.htm
are unusable.
what a pity
thanks
meenakshi.singh
Posted 3 December 2018, 7:32 pm EST
Hello!
I’m sorry, but please note that both the grids (C1FlexGrid and VSFlexGrid) are different in their architectural-designs. And hence, C1FlexGrid allows to save/load formatting information using Excel and XML files only, and not with text files.
Best regards,
Meenakshi
daniel.franke
Posted 4 December 2018, 8:22 pm EST
Hello, we have the same problem with VB6 (VSflexGrid8) to .NET
I’m testing C1 V4 Vsflexgrid. Why is there no possibilty to open old Files (Format “flexFileAll”) ?? In our saved files are very important data. You are the manufactor of this software and this should not a problem to implement?
Regards
Daniel
olivier941
Posted 4 December 2018, 11:21 pm EST
I confirm that this is really very annoying.
I hope they can find an issue !
thanks
olivier
meenakshi.singh
Posted 5 December 2018, 11:02 pm EST
HI Daniel/Olivier!
Currently, due to different architectural designs of both the grids, this is not possible to load older text files. However, I’ve asked the development team to look into this issue if anything can be done.
You’ll be notified once there is any update from them.
Regards,
Meenakshi
olivier941
Posted 28 December 2018, 10:27 pm EST
Hello
any news from the development team ?
thanks
Pragati.Kaushik
Posted 1 January 2019, 8:36 pm EST
Hi Olivier,
The developers are discussing this case internally. I will update the thread once there is any conclusion from them.
Thanks,
Pragati
olivier941
Posted 18 February 2019, 11:18 pm EST
Hello.
Have they had time to discuss?
Some ideas :
Take the code of the VsFlexGrid8.LoadGrid () method and redo it in a C1FlexGrid.LoadOldVsFlexgrid method
Thank you
olivier
Ruchir.Agarwal
Posted 20 February 2019, 6:29 pm EST
Hello Olivier,
I have your feedback forwarded to the developers and they are still discussing about the feasibility of this feature in the control.
Thanks,
Ruchir
olivier941
Posted 2 July 2019, 12:33 am EST
Hello.
I imagine that adding a function can take time, but now, it’s a lot of time
can you give me news?
does it seem possible to do this function?
thank you
Olivier
Ruchir.Agarwal
Posted 7 August 2019, 9:10 pm EST
Hello Olivier,
Apologies for the delay.
As per the discussion with the developer, there is a way: You can load the VSFlexGrid data files into a VSFlexGrid, then save them back as Excel files. These excel files can then be read by the C1FlexGrid.
In addition to this, what I can try is request the developers to create a utility that shall expose a method for reading the files and loading them in C1FlexGrid. If that’s okay, I would request you to kindly confirm so I can request the developers for it.
Regards,
Ruchir
olivier941
Posted 10 October 2019, 7:39 pm EST
Hello
Yes please.
Thanks
Olivier
olivier941
Posted 23 January 2020, 2:14 am EST
Hello
and ?
thanks
Ruchir.Agarwal
Posted 26 January 2020, 5:01 pm EST
Thanks Olivier for confirming. I have requested the developers for the same [ID:356551].
We will keep you updated with the progress over this.
Best wishes,
Ruchir
Ruchir.Agarwal
Posted 26 January 2020, 5:03 pm EST
Hello,
I have asked for an ETA for the utility and will share with you as soon as the developers share it.
Regards,
Ruchir
Ruchir.Agarwal
Posted 28 January 2020, 10:20 pm EST
Hi Oliver,
Would it be possible for you to share with us some of the older text files that includes the formatting information? The team would want to test the utility being prepared on these files.
Thanks,
Ruchir
julius
Posted 21 April 2020, 12:03 am EST
Hello,
I have same problem just migrating from olf flexgrid to C1(but 2010 year version). In old grid we have in first column Tree with nodes with few levels and everything is saved “flexFileAll” so I tried to save to Excel format and Load with C1 as excel, but seems Loading method not reading everything cause I’m lacking a lot of rows. I tried:
flexOld1.LoadGrid(file, VSFlex8L.SaveLoadSettings.flexFileAll);
flexOld1.SaveGrid(file, VSFlex8L.SaveLoadSettings.flexFileExcel);
flexC1.LoadGrid(file, FileFormatEnum.Excel);
If I open new file with Excel I see a lot of hidden rows, and those rows not loaded into grid. Maybe I’m missing something?
I’m new to flexgrid and C1. And i know we have an old 2 versions, but before we can update to newest version we need to rewrite everything from old flexgrid.
olivier941
Posted 21 April 2020, 2:59 am EST
Hello
Here’s one file simple file
thanks
Olivier
Ruchir.Agarwal
Posted 21 April 2020, 3:35 pm EST
Hello Julius,
So, the problem you’re facing is that C1FlexGrid does not load the hidden rows from Excel?
I tested this using C1FlexGrid version: 2.6.20101.545 and invoking either the LoadGrid or LoadExcel method, both works properly. See attached file.
Do you see the issue running this application? If no, please modify it making it structurally similar to your application and share back so that I can have a look.
Ruchir.Agarwal
Posted 21 April 2020, 3:36 pm EST
Hello Olivier,
I do not see any file attached with your reply. Could you please re-upload?
Thanks,
olivier941
Posted 21 April 2020, 7:05 pm EST - Updated 3 October 2022, 2:06 pm EST
here’s the file
testFile.zip
julius
Posted 21 April 2020, 8:48 pm EST
Ty for reply.
Because .SaveGrid saved collapsed rows in Excel as Hidden rows, .LoadExcel(and probably LoadGrid) cant see them. We save user grid, so next time he opens he will same window. Your workaround seems good. Thank you
Ruchir.Agarwal
Posted 22 April 2020, 9:24 pm EST
So, as it seems the solution we provided works for you and the issue is now resolved. If you face any other problem, do create a post.
Regards.
Ruchir
Ruchir.Agarwal
Posted 22 April 2020, 9:25 pm EST
[quote=“olivier941”]
here’s the file
testFile.zip
[/quote]Thank you, Olivier. I have passed it to the developer for testing the utility.
Thanks,
Ruchir
olivier941
Posted 22 April 2020, 10:39 pm EST
To be precise, I used the old version :
component One VsFlexGrid Light 7.1
thanks
julius
Posted 22 April 2020, 10:48 pm EST
For future who will read this to make it clear:
Workaround for me “how to read old FlexGrid8L file with new C1Flexgrid” is in old flexgrid expand whole tree or make all rows visible and save(oldFlexGrid.SaveGrid(YourXlsFile, VSFlex8L.SaveLoadSettings.flexFileExcel) it in excel format(.xls), expand tree needed to make sure rows wont be hidden cause new grid wont see those rows, then the last thing need to use C1Flexgrid.LoadExcel and C1Flexgrid.SaveGrid to new format.
olivier941
Posted 26 May 2021, 3:53 am EST
Hello
I’m very disapointed
2 years and style not have any issues for that
can your developper can’t add a simple method ?
do they have the old source code from vsFlexGrid7 ?
here’s an attached file for sample
it’s a file create with the .SaveGrid method from an old * "vsflexgrid7 "
component and with * "arcAdd "
option
http://helpcentral.componentone.com/docs/vsflexgrid8/archivemethod.htm
it’s vsFlexGrid 7 and * "NOT "
8
for your purpose, it has : 32 columns and 445 rows
thanks for any help
[quote=“olivier941”]
To be precise, I used the old version :
component One VsFlexGrid Light 7.1
thanks
[/quote]tablesnew2.zip
prabhat.sharma
Posted 26 May 2021, 11:17 pm EST
Hello,
Sorry for the inconvenience.
The developers have tried creating the utility but did not get any breakthrough, and after that, they did not get time to look and work on it again due to other releases in hand.
But it is on their to-do list, and they would definitely work on it again.
We have asked the developers to take this as a priority, and we will let you know as soon as we get the update from their side.
Regards,
Prabhat Sharma.
olivier941
Posted 26 May 2021, 11:49 pm EST
Hello
If you manage to do this function, I say a big thank you.
I have a lot of files that are in the same configuration.
thank you so much
olivier941
Posted 28 April 2023, 8:30 pm EST
04-29-2023
hello
*still nothing in my inbox ?
thanks
prabhat.sharma
Posted 1 May 2023, 7:24 pm EST
Hello Oliver,
Apologies for the inconvenience.
We are getting in touch with the developers to take an update on this and will get back to you on this soon.
Regards,
Prabhat Sharma.
prabhat.sharma
Posted 1 May 2023, 7:25 pm EST
Hello Oliver,
Apologies for the inconvenience.
We are getting in touch with the developers to take an update on this and will get back to you on this soon.
Regards,
Prabhat Sharma.
levanduyet
Posted 20 May 2023, 7:43 pm EST
Hi Ruchir,
I could not find this file in folder: C:\Program Files (x86)\ComponentOne\WinForms Edition\bin\v4.0
How can I get this file.
Thanks,
Duyet Le
