Pasting form Excel with Blank Cells

<oXygen/> general issues.
marksluser
Posts: 5
Joined: Wed May 08, 2019 12:40 am

Pasting form Excel with Blank Cells

Post by marksluser » Wed May 08, 2019 12:54 am

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

sorin_carbunaru
Site Admin
Posts: 228
Joined: Mon May 09, 2016 9:37 am

Re: Pasting form Excel with Blank Cells

Post by sorin_carbunaru » Wed May 08, 2019 10:32 am

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

marksluser
Posts: 5
Joined: Wed May 08, 2019 12:40 am

Re: Pasting form Excel with Blank Cells

Post by marksluser » Wed May 08, 2019 5:27 pm

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.

sorin_carbunaru
Site Admin
Posts: 228
Joined: Mon May 09, 2016 9:37 am

Re: Pasting form Excel with Blank Cells

Post by sorin_carbunaru » Thu May 09, 2019 10:07 am

I understand. We already have an issue for this, and I added your vote.

Is pasting in the Author page an option for you?

marksluser
Posts: 5
Joined: Wed May 08, 2019 12:40 am

Re: Pasting form Excel with Blank Cells

Post by marksluser » Thu May 09, 2019 5:04 pm

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

sorin_carbunaru
Site Admin
Posts: 228
Joined: Mon May 09, 2016 9:37 am

Re: Pasting form Excel with Blank Cells

Post by sorin_carbunaru » Mon May 13, 2019 10:15 am

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.

marksluser
Posts: 5
Joined: Wed May 08, 2019 12:40 am

Re: Pasting form Excel with Blank Cells

Post by marksluser » Mon May 13, 2019 4:04 pm

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.

sorin_carbunaru
Site Admin
Posts: 228
Joined: Mon May 09, 2016 9:37 am

Re: Pasting form Excel with Blank Cells

Post by sorin_carbunaru » Tue May 14, 2019 11:33 am

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.

Radu
Posts: 6325
Joined: Fri Jul 09, 2004 5:18 pm

Re: Pasting form Excel with Blank Cells

Post by Radu » Thu May 23, 2019 2:23 pm

Hi,

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

Regards,
Radu
Radu Coravu
<oXygen/> XML Editor
http://www.oxygenxml.com

marksluser
Posts: 5
Joined: Wed May 08, 2019 12:40 am

Re: Pasting form Excel with Blank Cells

Post by marksluser » Thu May 23, 2019 6:08 pm

Thank you very much !
That helps me a lot with my workflow.
You just made oxygen even better for me😊😊

-Mark

Post Reply