[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=81711

--- Comment #11 from Stéphane Guillou (stragu) 
 ---
(In reply to Stéphane Guillou (stragu) from comment #10)
> ... it seems Andreas...
(Sorry: Andras, not Andreas.)

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=81711

Stéphane Guillou (stragu)  changed:

   What|Removed |Added

 Resolution|--- |DUPLICATE
   See Also|https://bugs.documentfounda |
   |tion.org/show_bug.cgi?id=66 |
   |377,|
   |https://bugs.documentfounda |
   |tion.org/show_bug.cgi?id=13 |
   |6541|
 Status|NEW |RESOLVED
 Blocks|108897, 108917, 137805  |

--- Comment #10 from Stéphane Guillou (stragu) 
 ---
As stated before, Err:508 because of range names has been fixed for a while,
see bug 85063.

Regarding the remaining issue:
(In reply to Andras Timar from comment #0)
> Opening this file in Calc or creating a table in
> Calc will not display any colors.
... it seems Andreas talks about both adding the feature to Calc (bug 132780)
and supporting the formatting that was set by Excel (bug 66377).

Because we have to pick one, I'm marking as duplicate of bug 66377.

*** This bug has been marked as a duplicate of bug 66377 ***


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
https://bugs.documentfoundation.org/show_bug.cgi?id=108917
[Bug 108917] [META] Cell references bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=137805
[Bug 137805] [META] XLSX (OOXML) Data range / Format as Table issues
-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=81711

Stéphane Guillou (stragu)  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=80
   ||956

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=81711

NISZ LibreOffice Team  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=13
   ||6541

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=81711

Aron Budea  changed:

   What|Removed |Added

 Attachment #103394|application/vnd.ms-excel|application/vnd.openxmlform
  mime type||ats-officedocument.spreadsh
   ||eetml.sheet

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=81711

NISZ LibreOffice Team  changed:

   What|Removed |Added

 Blocks||137805


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=137805
[Bug 137805] [META] XLSX (OOXML) Data range / Format as Table issues
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=81711

Xisco Faulí  changed:

   What|Removed |Added

   Priority|high|medium

--- Comment #9 from Xisco Faulí  ---
Changing priority back to 'medium' since the number of duplicates is lower than
5

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=81711

Aron Budea  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=66
   ||377

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=81711

Luke  changed:

   What|Removed |Added

 CC||er...@redhat.com

--- Comment #8 from Luke  ---
Table formatting still not implemented in 5.2.0.0.alpha1+
Build ID: a5a71cea62ac3041006c5e9815ae2317999639ac

Eike Rathke has already laid the basic foundation allowing formulas that use
reference by table to be imported and exported.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=81711

--- Comment #7 from Luke  ---
jpd8752,
If you didn't mean to pay for the entire project yourself, you could always
start a crowd funded project at:
https://www.bountysource.com/teams/libreoffice/issues?tracker_ids=207487
or
https://freedomsponsors.org/project/149/LibreOffice#/LibreOffice

Please post it here if you do.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=81711

--- Comment #5 from jpd8...@gmail.com ---
This one function is really the only reason that I (and i suspect many others)
are still using MsExcel. It is a function that most excel users dont use b/c
they dont know the benefits. Those that use it have more confidence in their
results b/c of the softwares' managing of the named ranges (no cells are
accidentally left out).

I am willing to pay for this functionality to be built into Calc if someone
will do the coding (i dont know how). I know others will benefit greatly.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=81711

jpd8...@gmail.com changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
Version|unspecified |5.0.2.2 release
 Resolution|DUPLICATE   |---

--- Comment #4 from jpd8...@gmail.com ---
-There seemed to be two functions that Andras Timar requested on 20140724.
-One was the removal of the Err:508, which seems to have been completed.
-The second request was to build the 'table' functionality into Calc, modeled
after Excel.
-The 'Table' function in excel manages many things easier including (but not
limited to) named ranges, enhanced formatting and pivot table function, column
names in formulas, expands said named range when new columns or rows are added,
and generally better preps the data (normalizes) for use in a database
environment more so than just using regular cells and named ranges.

-see thread here:
https://ask.libreoffice.org/en/question/4767/creating-tables-in-calc/
-also microsoft's explanation here:
https://support.office.com/en-us/article/Overview-of-Excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=81711

Joel Madero  changed:

   What|Removed |Added

 Status|REOPENED|NEW

--- Comment #6 from Joel Madero  ---
REOPENED is incorrect status - moving back to NEW.

As for paying - are you willing to pay hundreds if not thousands of dollars?
That's likely how much it'll cost if you're going to hire a company. If you are
willing to - I suggest contacting one of our certified developers to get a
quote. Millions of lines of code, just tracking down the code can take several
hours...at $100/hr (reasonable rate for consulting/coding), you're looking at a
few hundreds to just track the code down.

As for "many users sticking with Excel" - so be it. That's now how we run the
program - if there are features that our competitors have that we don't, we're
not going to demand that volunteers implement those features just to appease
users (who aren't the ones doing the work). 

https://www.documentfoundation.org/certification/developers/

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=81711

Luke lukebe...@hotmail.com changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |DUPLICATE

--- Comment #3 from Luke lukebe...@hotmail.com ---
Dupe of Bug 66377 - Feature request: Format As Table

Eike Rathke recently added support to recognize the tags, so the  Err:508
should be gone now in LO 5.0.

*** This bug has been marked as a duplicate of bug 66377 ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81711

Owen Genat owen.ge...@gmail.com changed:

   What|Removed |Added

 Attachment #103394|text/plain  |application/vnd.ms-excel
  mime type||

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81711

Joel Madero jmadero@gmail.com changed:

   What|Removed |Added

 CC||camilleri@gmail.com

--- Comment #2 from Joel Madero jmadero@gmail.com ---
*** Bug 80956 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81711

Joel Madero jmadero@gmail.com changed:

   What|Removed |Added

   Hardware|Other   |All
 Status|UNCONFIRMED |NEW
   Priority|medium  |high
 CC||jmadero@gmail.com
 Ever confirmed|0   |1

--- Comment #1 from Joel Madero jmadero@gmail.com ---
Confirmed:

New
Enhancement
High - I think that this will be needed and cause headaches for certain users
because to them it looks like data loss


@Andras - seems like these are two separate bugs but I figure it's on your
radar

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 81711] XLSX: Import tables with alternating colors for rows and handle references to their names

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81711

Andras Timar tima...@gmail.com changed:

   What|Removed |Added

Summary|In Calc provide alternating |XLSX: Import tables with
   |colors for rows in a table  |alternating colors for rows
   ||and handle references to
   ||their names

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs