Page 1 of 1

Pasting form Excel with Blank Cells

Posted: Wed May 08, 2019 12:54 am
by marksluser
I have a table in Microsoft excel with blank lines:

Code: Select all

ID  Name_F   Name_M     Name_L
P1  John                Lighton
P2  Steve    Robert	Ruddy
P3  Vince               Sims
When I paste into OxygenXMl Editor, it ignores the blank cells.
It comes out as:

Code: Select all

ID  Name_F   Name_M     Name_L
P1  John     Lighton
P2  Steve    Robert	Ruddy
P3  Vince    Sims
What can I do so OxygenXML will include the blank cells?

-Mark

Re: Pasting form Excel with Blank Cells

Posted: Wed May 08, 2019 10:32 am
by sorin_carbunaru
Hello,

I just tried copying a table with blank cells from Excel to the Author page of both a DITA topic and a DocBook article, and the blank cells were kept... I did this on the latest oXygen version, i.e. 21.0. How did you reproduce the problem?

Regards,
Sorin Carbunaru
oXygen XML

Re: Pasting form Excel with Blank Cells

Posted: Wed May 08, 2019 5:27 pm
by marksluser
Using the latest OxygenXML editor (21.0), I get this problem when pasting into an XML file in grid view.
Note: pasting into an HTML, docbook file there is no problem and it works fine.

Re: Pasting form Excel with Blank Cells

Posted: Thu May 09, 2019 10:07 am
by sorin_carbunaru
I understand. We already have an issue for this, and I added your vote.

Is pasting in the Author page an option for you?

Re: Pasting form Excel with Blank Cells

Posted: Thu May 09, 2019 5:04 pm
by marksluser
Pasting in author is not an option because I am editing an xml file.
I look forward to your fixing of this issue.
Any timeframe of when this is to be resolved?

-M

Re: Pasting form Excel with Blank Cells

Posted: Mon May 13, 2019 10:15 am
by sorin_carbunaru
Now that you mentioned this bug again, we rescheduled it for version 22 (probably February 2020), as we are too close to releasing 21.1. We will have to further discuss this issue during our meetings with the product architects and the upper management.

As a side note, we receive very, very little feedback on the Grid page. We are trying to focus on what is more requested.

Re: Pasting form Excel with Blank Cells

Posted: Mon May 13, 2019 4:04 pm
by marksluser
While Iā€™m not exactly sure the details to fix this bug, proper pasting from excel seems like a fairly basic feature.
My expectation is that such a bug fix would be in your next maintenance release, not major release and I am surprised that this bug fix needs upper management to reschedule.

I hope you can fix this in the next maintenance release as proper from excel is one of the major reasons I bought oxygen because i have lots of data in excel and Csv files and I am moving to an xml based system.

Re: Pasting form Excel with Blank Cells

Posted: Tue May 14, 2019 11:33 am
by sorin_carbunaru
Indeed, I do agree this is a faulty behavior and the copying and pasting should have worked as expected, but I wanted to state that I personally cannot guarantee that it will be fixed in a certain kit or version. However, my team lead agreed for me to take a look at the problem and see what a fix would involve. We will definitely update this thread when we have that fix.

There would also be a couple of workarounds, if you were interested in trying them...
1. You could first paste into DITA, which creates a table as expected, and then invoke a custom DITA action created over "XSLTOperation" (see https://www.oxygenxml.com/doc/versions/ ... ialog.html for how to create a new Author action) that transforms the DITA table into your custom table, using an XSLT script that you would need to write, because you know the exact syntax you want to obtain.
2. You could also create a minimal framework (https://www.oxygenxml.com/doc/versions/ ... ialog.html), with a minimal CSS to render your custom XML files in the Author page, and then write an XSLT script that takes care of the pasting inside the Author page (see https://www.oxygenxml.com/doc/versions/ ... paste.html). Just in case you didn't know, the Author page is just like looking at your raw XML through a lens. This "lens" is CSS.

As a side note, I find the Author page more user-friendly and easy to use than the Grid one.

Re: Pasting form Excel with Blank Cells

Posted: Thu May 23, 2019 2:23 pm
by Radu
Hi,

We released Oxygen 21.1 and it should have a fix for the problem you reported.

Regards,
Radu

Re: Pasting form Excel with Blank Cells

Posted: Thu May 23, 2019 6:08 pm
by marksluser
Thank you very much !
That helps me a lot with my workflow.
You just made oxygen even better for mešŸ˜ŠšŸ˜Š

-Mark